SQL Anywhere jdbc3 v jdbc4

Dieter Schmerlaib shared this question 1 month ago
Answered

Hi

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 ?

Best Answer
photo

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

Comments (3)

photo
1

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

photo
1

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

photo
1

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

photo