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

asked 13 Feb '12, 01:20

Rahul%20Dixit's gravatar image

Rahul Dixit
1111
accept rate: 0%

closed 19 Feb '13, 10:42

Mark%20Culp's gravatar image

Mark Culp
24.9k10139297

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?

(14 Feb '12, 14:42) Jeff Albion

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.

(15 Feb '12, 08:38) Rahul Dixit
Replies hidden
2

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...

(15 Feb '12, 08:44) Volker Barth

The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 19 Feb '13, 10:42

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×53
×39

question asked: 13 Feb '12, 01:20

question was seen: 8,711 times

last updated: 19 Feb '13, 10:42