cancel
Showing results for 
Search instead for 
Did you mean: 

jConnect 5.5 (jconn2.jar) with ASE 15.7 or ASA 16?

0 Kudos

We have a Java1.3 application and wanted to know if it can work with ASE 15.7 and/or ASA 16.

I have tested it with ASE 15.7, so far so good. After all, we are not using any Sybase-specific feature.

However, I would like to know, if there is any document or reference, talking about the compatibility of jConnect 5.5 (jconn2.jar)?

Something like this page?

http://www.sybase.com/detail?id=1065550

And I read in this page that, ASE 15.7 has a compatibility mode for 12.5 user. Does it help in my case (compatibility with jConnect 5.5)?

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00967.1550/html/Migration...

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello Henry,

I'm not sure if you use an SAP application, if not then the following area is much better to ask ASE questions:

SAP Sybase ASE for Custom Applications

or for Anywhere go to here:

SAP Sybase SQL Anywhere

This area of SCN should be only for SAP applications running on ASE.

And finally an answer to your question:

JConnect 5.5 wasn't not tested with ASE 15.7 and ASA 16, cause it's end of life.

http://www.sybase.com/detail?id=1061561

Check the Interoperiablitly matrix of ASE 15.7:

Adaptive Server Interoperability

For ASA 16 you can take a look to the documentation what JDBC Drivers you need:

SAP Sybase SQL Anywhere Documentation

The compatibilty mode is not for 12.5 users, but it will try to use the 12.5 optimizer. See here for a more details what compatiblity mode is:

SAP Sybase ASE compatibilty mode

With kind regards

Stefan

0 Kudos

Sorry, my mistake, didn't notice the meaning of "on" in the name of this area.

Answers (1)

Answers (1)

0 Kudos

Henry,

Just for a clarifying point regarding the JDBC driver (in this case the jConnect 5.5 driver), the driver is expected to work properly against ASE versions moving forward as long as they support/use TDS for communications, which of course they do.

Please keep in mind that new features/capabilities of the ASE may not be available to the older driver.  You do not need to worry about your JDBC metadata on the ASE as the MeataData information on the ASE has backward compatible stored information as part fo the sp_mda execution.

As Stefan pointed out, the 5.5 driver is End-Of-Life and has been for quite some time, as is the 6.05 driver.  The current driver is the 7.07 driver.  But older versions of the jConnect driver are expected to function normally against the newer ASEs, although no testing or certifications were or will be performed due to the status of the driver.

Cheers,

-Ken

0 Kudos

Thank you for answering this old thread.

Your clarification is useful to us.