Hiwe are developing a Java application with Hibernate as ORM provider on a SQL Anywhere 17 database. This has worked well so far. However, Hibernate 6 has changed so much that our SQL Anywhere Hibernate dialect no longer works.Does anyone know a dial...
Hi
we are developing a Java application with Hibernate as ORM provider on a SQL Anywhere 17 database. This has worked well so far. However, Hibernate 6 has changed so much that our SQL Anywhere Hibernate dialect no longer works.
Does anyone know a di...
HI
is there a simple way to find out in the client database if a row was sent to the server by MobiLink?
One option would be to add a column that's set on the server and sent back to client. However this would leaves a gap of a couple of seconds bet...
I have a Select from 3 tables with a subselect in the result set and in the where condition. Tables contain between 30 and 90'000 rows.
I run the select from ISQL a 1st time and it takes about 3 seconds.I run the select from ISQL a 2nd time and it t...
Hi
when I run a quite simple query (select a couple of columns, 3 simple sub selects, 1 with max) I have very different behavior on different VMs.
SQL Anyhwere 12.0.1Same Startup Parameter for DB Server
-nDBNAME -ec simple -xtcpip -gd all -c5G -g...
I think I should go with a combination of the "ready flag" and the automatic lock based on ISYSSYNC. I haver ordes and order lines to synchronize. As the synchronization is running in the background every x minutes and the users saves orders while wo...
I tried to upload the PDFs but the the dialog just states "No file chosen". Any limitation of file sizte? My question is more basically about why this can happen (gives quite troubles when trying to solve performance issues on customer installations)...
Cache hits are quite good. Recreating the statistics solves the problem but it will appear after a couple of days. I might have to disable automatic statistics for some tables and force the creation manually.
Mikel, 3rd time is as bad as 2nd time and it's not a cached plan issues as the problem persists whether I set them to 0 or try it with a 2nd connection. Problem are the bad table statistics