SQL Anywhere jdbc3 v jdbc4

Dieter Schmerlaib shared this question ago

Answered

I am experimenting with my first transformation and if I covnect with this jdbc driver com.sybase.jdbc3.jdbc.SybDriver there is no problems if I connect with this com.sybase.jdbc4.jdbc.SybDriver I can only insert 1 row. I get no errors using either just different amount of rows updated in the same database using the same data and transfation just a different driver

I would have thought the more recent driver would be preferred is there a recommendation ?

The same question

Best Answer

Guest ●

Hi Dieter,

if my memory serves me correctly, that's why we kept both jconn3 and jconn4 in the installation. See the following SAP forum article and you'll see that issue:

https://sqlanywhere-forum.sap.com/questions/9852/ase-issue-with-jdbc-driver-jconn3-vs-jconn4

So definitely use jconn3 if jconn4 is playing up for you.

regards,

David

Replies (1)

Guest ● ●

Hi Dieter,

if my memory serves me correctly, that's why we kept both jconn3 and jconn4 in the installation. See the following SAP forum article and you'll see that issue:

https://sqlanywhere-forum.sap.com/questions/9852/ase-issue-with-jdbc-driver-jconn3-vs-jconn4

So definitely use jconn3 if jconn4 is playing up for you.

regards,

David

Reply URL

Dieter Schmerlaib ●

The article referes to ASE and I am using SQL Anywhere but I guess the suggestion is the same use jconn3 I just wonder if I hae not setup 4 properly but for the moment I will use jconn3

URL

Guest ●

Yes Dieter, I would do the same. The description of the issue is exactly the same as that which you described. And also, we are talking about JDBC drivers here - they work independently of the DBMS.

regards,

David

URL