Calling SyncObjectGenerator.jar. leads to SQLException: The sajdbc.jar build does not match the shared object build

[Former Member]

I am trying to generate synchronization logic between Oracle, Mobilink and a SQL Anywhere reference database. For that I am running a build.xml with Ant that calls SyncObjectGenerator.jar. Getting the following exception block:

[java] MakeConnection - SQL Exception
     [java] java.sql.SQLException: The sajdbc.jar build does not match the shared object build
     [java]     at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method)
     [java]     at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:811)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:664)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:270)
     [java]     at ianywhere.ml.tools.SyncObjectGenerator.makeConnection(Unknown Source)
     [java]     at ianywhere.ml.tools.SyncObjectGenerator.execute(Unknown Source)
     [java]     at ianywhere.ml.tools.SyncObjectGenerator.main(Unknown Source)
     [java] **java.sql.SQLException: The sajdbc.jar build does not match the shared object build**
     [java]     at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method)
     [java]     at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:811)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:664)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:270)
     [java]     at ianywhere.ml.tools.SyncObjectGenerator.makeConnection(Unknown Source)
     [java]     at ianywhere.ml.tools.SyncObjectGenerator.execute(Unknown Source)
     [java]     at ianywhere.ml.tools.SyncObjectGenerator.main(Unknown Source)

I ran java -cp sajdbc4.jar sybase.jdbc.sqlanywhere.IBuildNum. I am getting the version 16.0.0.2193

What is the workaround here? Please suggest.

Note: 1. Oracle, mobilink and sql anywhere reference db - all are running in my consolidated server 2. I am using SQL Anywhere 16.0.0.2043. The required version for the application was 16.0.0.1823 or higher.

[chris_keating]

You are getting the exception sybase.jdbc4.sqlanywhere.IDriver which indicates that the jar being used is sajdbc4.jar not sajdbc.jar. The version check should then be:

java -cp sajdbc4.jar sybase.jdbc4.sqlanywhere.IBuildNum

[Former Member]

Thanks, I am getting the version 16.0.0.2193

[chris_keating]

So you have addressed the issues as described by the original post for this thread? Can you please provide more details?

[Former Member]

When I am trying to generate Synchronization logic between Oracle, SQL Anywhere and Mobilink by running a build.xml file from ant, I am getting this issue.

Note: 1. Oracle, SQL Anywhere and mobilink are residing on the same server. 2. My application required SQL Anywhere 16.0.0.1823 or higher. I am using SQL Anywhere 16.0 developer's edition i.e 16.0.0.2043 (SELECT version from SYSHISTORY)

[java] get List of: table.name.too.long [java] java.sql.SQLException: The sajdbc.jar build does not match the shared object buildget List of: mapping.table.client [java] [java] at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method)get List of: mapping.table.server [java] [java] get List of: mapping.column.client at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:811) [java] get List of: mapping.column.server [java] [java] at java.sql.DriverManager.getConnection(DriverManager.java:664) [java] get List of: mapping.variable.client at java.sql.DriverManager.getConnection(DriverManager.java:270) [java] [java] get List of: mapping.variable.server [java] get List of: mapping.package.from at ianywhere.ml.tools.SyncObjectGenerator.makeConnection(Unknown Source) [java] [java] get List of: mapping.package.to at ianywhere.ml.tools.SyncObjectGenerator.execute(Unknown Source) [java] [java] get List of: special.blob [java] get List of: excluded.column.table [java] get List of: excluded.column.column at ianywhere.ml.tools.SyncObjectGenerator.main(Unknown Source) [java] get List of: table.name.too.long [java] [java] java.sql.SQLException: The sajdbc.jar build does not match the shared object buildget List of: table.name.shorten [java] at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method) [java] get List of: namedParameter.extraVersions [java] [java] get List of: publications [java] at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:811) [java] at java.sql.DriverManager.getConnection(DriverManager.java:664) [java] MakeConnection - SQL Exception [java] at java.sql.DriverManager.getConnection(DriverManager.java:270) [java] at ianywhere.ml.tools.SyncObjectGenerator.makeConnection(Unknown Source) [java] at ianywhere.ml.tools.SyncObjectGenerator.execute(Unknown Source) [java] at ianywhere.ml.tools.SyncObjectGenerator.main(Unknown Source)

[VolkerBarth]

Note: This question was originally posted as an answer to that FAQ...

I converted it to a question (as it is one, obviously), but unfortunately, it seems the nested comments from Chris Keating and rohinibasuu have not been converted (so far?) but are nevertheless no more available with the previous thread, either...

Sorry for messing things up... - Graeme, can you fix that...

[VolkerBarth]

Hm, according to that meta-FAQ on converting answers into questions, I'm sure it should have worked as expected - there was one answer with some nested comments, and in my understanding that should be converted as a nested entity, as Mark has stated...

Once all of the text that you want to keep together is in one 'bundle' (i.e. under one answer) then you can convert the answer to a question and all of the comments attached to it will be carried along with it.

[Former Member]

Many thanks for converting it to a question. 🙂

I have edited my question itself on the basis of the nested conversations with Chris Keating.

[chris_keating]

There is a hard requirement that the version of the SQL Anywhere JDBC driver jar be the same version as the native libraries that it uses. The "workaround" is really a requirement. You must use the same version of files for both the JAVA and native libraries that make up the SQL Anywhere JDBC driver files.

You indicate that you are using SQL Anywhere 16.0.0.2043. The sajbdc*.jars should all be that version (or vice versa).

If on Windows, I would likely do the following:

1) Make a backup of the following files

[VolkerBarth]

@Chris, that list seems somewhat incomplete...:)

@Rohini: You state you are using 16.0.0.2193 (the sajdbc4.jar) and 16.0.0.2043 (as database server?). So that's the mismatch.

[Former Member]

Thanks Chris and Volker. I am trying to find SQL Anywhere 16.0.0.2193 version (if it exists). The sajdb4.jar of version 16.0.0.2193 was provided with the application bundle itself.

[VolkerBarth]

if it exists

It does: That's 16.0 SP43 Build 2193 for Windows, released 22.10.2015.

(You might as well try to replace 16.0.0.2193 sajdbc4.jar with that of the .2043 version...)

And of course, if you are doing new development, I'd recommend to use the freshest EBF, currently (on Windows) 16.0.2344 (SP65), released 01.11.2016.

[Former Member]

So after replacing 16.0.0.2193 sajdbc4.jar with 16.0.0.2043 sajdbc4.jar, the build is successful.

Thanks all 🙂

FYI, I am yet to find that 2193 build of SQL Anywhere. Looking in this page: http://sqlanywhere.blogspot.ca/search/label/latest%20EBFs

[Breck_Carter]

> somewhat incomplete

There are two kinds of people in the world.

1) Those who can extrapolate from incomplete data.

[VolkerBarth]

You will have to go to the SAP Support Portal to get current EBFs, which requires a support contract, AFAIK...

The list you cited is maintained by Breck himself - and shows the following date:

Sunday, October 18, 2015

So it's no surprise you'll not find newer EBFs there.

(In my understanding, Breck has stopped updating that list as EBFs are no more publically available, and there's no way to add links to the according downloads in the SAP Support Portal...)

[VolkerBarth]

Wow, that really made my day:)

Although, the new SCN community is good for fun, as well:)