ASE issue with jdbc driver jconn3 vs jconn4

[Former Member]

Hi,

I am facing a strange issue, not sure if it has something to do with Sybase or the jdbc connector. We are working on a software upgrade at a client. The earlier version of software used com.sybase.jdbc3.jdbc.SybDriver jdbc driver to connect to Sybase DB. The latest version of the software uses com.sybase.jdbc4.jdbc.SybDriver to connect to Sybase.

The application sends a batch of insert queries of which only the last one gets executed. I fail to understand why is this so? I replaced jdbc4 with jdbc3 and I was not able to replicate the issue.

Any idea if there is some difference in working of the two jars? or is there any property that needs to be set in that case?

Regards,
Rahul

[jeff_albion]

Which version of jconn3.jar / jconn4.jar are you using? (e.g. java -jar jconn3.jar)

The application sends a batch of insert queries of which only the last one gets executed. I fail to understand why is this so?

Is your Java application a JDBC 3 or JDBC 4 application? How specifically does your Java program send batched inserts (what JDBC API calls does it make)?

Which "Sybase DB" are you referring to in your question - SQL Anywhere? Adaptive Server Enterprise (ASE)? Sybase IQ? Which version of the database software are you using?

[Former Member]

JCONN3.jar: jConnect (TM) for JDBC(TM)/6.05(Build 26021)/P/EBF13862/JDK14/Tue Oct 3 19:26:12 2006

JCONN4.jar: jConnect (TM) for JDBC(TM)/7.00(Build 26544)/P/EBF18588/JDK16/Mon Mar 7 23:17:31 2011

Sybase Version:
Adaptive Server Enterprise/15.5/EBF 18379 SMP ESD#3/P/Solaris AMD64/OS 5.10/asear155/2531/64-bit/FBO/Fri Jan 14 10:08:51 2011

The application vendor suggests use of jconn4 with the latest version of the application.

Here are some details on the Sybase Database
ODBC MDA Scripts 15.5.0.1012.1000/Tue 04-06-2010 20:23:52.35
OLEDB MDA Scripts 15.5.0.1012.1000/Tue 04-06-2010 20:23:52.35
installcommit 15.0.2/EBF 15686 ESD#5/P/Solaris AMD64/OS 5.10/ase1502/2528/64-bit/OPT/Tue Jun 17 10:36:50 2008
installjdbc jConnect (TM) for JDBC(TM)/7.00(Build 26544)/P/EBF18588/JDK16/Mon Mar 7 23:17:31 2011
installmaster 15.5/EBF 18379 SMP ESD#3/P/Solaris AMD64/OS 5.10/asear155/2531/64-bit/OPT/Fri Jan 14 04:43:53 2011
installmodel 15.0.2/EBF 15686 ESD#5/P/Solaris AMD64/OS 5.10/ase1502/2528/64-bit/OPT/Tue Jun 17 10:36:50 2008
installsecurity 15.5/EBF 18379 SMP ESD#3/P/Solaris AMD64/OS 5.10/asear155/2531/64-bit/OPT/Fri Jan 14 04:43:53 2011
montables 15.5/18379/P/Solaris AMD64/OS 5.10/asear155/2531/64-bit/OPT/Fri Jan 14 01:25:16 2011

The application uses batch mode in prepared statement of java.
preparedStatement.addBatch();
preparedStatement.executeBatch();

Please let me know in case you need more details on this.

[VolkerBarth]

Rahul, this is a forum about Sybase SQL Anyhwere, not about ASE. Therefore I would recommend to have a look in the FAQ page - see the last question to find hints for further support on ASE...