Sybase DB adapter service

, ,
1

Hi,
There is a sybase DB adapter service that i am working on. The service is already existing in production. Also, the adapter service has the production DB catalogue hardcoded in it.
To test this service in TEST, i have repointed the connection to the test instance, however, i am unable to change the catalogue in the adapter service. If i try to expand the tree for , nothing opens up.

The user is having read and write access to the required schemas, the connection itself is not giving any errors while getting enabled.

Any suggestions?

PS: I am using jt400.jat and the driver that i am using is com.sybase.jdbc2.jdbc.SybDataSource . WM version is 7.1.3

Thanks.

2

Hi All, i am still facing this issue with the adapter service. Even when i create a new adapter and an adapter service, in the ‘tables’ tab, i see a list in this form:
[HTML]
+
+catalogue1
+catalogue2
.
.
.
.
[/HTML]
Ideally, it should be something like this:
[HTML]
-
+catalogue1
+catalogue2
.
.
.
.
[/HTML]
I have checked with the DBA team and the user that i am using is having DBO privileges. However, still i am facing this issue.
Also, when i try to validate the adapter service, i get this error:

com.wm.driver.comm.b2b.WmCommException: [[[ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.1.321] Cannot get the list of schemas. "
B JZ0SA: Prepared Statement: Input parameter not set, index: 0."[/b]
JZ0SA: Prepared Statement: Input parameter not set, index: 0.] [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.1.321] Cannot get the list of schemas. "
B JZ0SA: Prepared Statement: Input parameter not set, index: 0."[/b]
JZ0SA: Prepared Statement: Input parameter not set, index: 0.] [[ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.1.321] Cannot get the list of schemas. "
B JZ0SA: Prepared Statement: Input parameter not set, index: 0."[/b]
JZ0SA: Prepared Statement: Input parameter not set, index: 0.] [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.1.321] Cannot get the list of schemas. "
B JZ0SA: Prepared Statement: Input parameter not set, index: 0."[/b]
JZ0SA: Prepared Statement: Input parameter not set, index: 0.
on tables.schemaName [Ljava.lang.String;@15dcdeb
java.lang.Exception: Adapter values are not available.

I have also updated my jar file and am using jconn3.jar and the driver is com.sybase.jdbc3.jdbc.SybDataSource

Thanks.

3

Hi there,
we had the same problem and a few minutes ago we managed to resolve the issue, so hope this will work for you as well:

Recently the ASE was upgraded to 15.0.3/EBF 17772 ESD#4. On top of it our DBAs installed SDK 19 (because of some connectivity problems), which installed SP for JConnect 7 onto the DB. WM JDBC Adapter was using jconn2.jar and jconn3.jar, which both correspond to the JConnect 6 … so:

log onto your sybase server and run the following sp:
sp_version

this will display a few lines, one of them will relate to the jConnect
I suspect it will be something like this:
jConnect ™ for JDBC™/7.00(… blah, blah …

So you have 2 options here:

  1. Roll back the SP so the version corresponds to your jConnect, when you run sp_version you get:
    jConnect ™ for JDBC™/6.05(… blah, blah …
    and your WM JDBC adapter should start working again

  2. Download jConnect 7 from Sybase. Get the jconn4.jar file from the tgz file (you might need to run setup and then get it from the installation folders). Put the jconn4.jar to the IntegrationServer/lib/jars/ folder, restart the IS. Change the JDBC connection to use class: com.sybase.jdbc4.jdbc.SybDataSource. Please note that this requires also your IS to run Java 1.6!

Again, hope this helps!

Stefan

ps, we went for the option 1

4

Hi Stefan,

Any one had luck with configuring this sybase class on IS 8.2.2?

com.sybase.jdbc4.jdbc.SybDataSource

We had jconn4.jar updated in the class path and restarted IS but still no luck:

Error we are getting while enabling the JDBC connection is:

[ADA.1.204] Cannot connect to the database with DataSource class “com.sybase.jdbc4.jdbc.SybDataSource”. JZ0D5: Error loading protocol com.sybase.jdbc4.tcp/ip.TCP/IP.

Please advise.

TIA,
RMG

5

Hi RMG,

I am sorry, but since we rolled back the SP I’ve not looked into this issue. We still run version IS 7.1.3.

6

Thanks for your quick response!

We are getting this error now and trying to resolve:

[ADA.1.205] Cannot retrieve the metadata. " (JZ0SJ/0) JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation." JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation.
TIA,
RMG

7

Folks/Gurus,

Any one else faced this issue and resolution please?..

We had tried with all jconn3d,jconn4,netforge jtds jars but no luck with WmJDBCAdapter6.5 for SYBASE SQL Anywhere:

P.S.with WmDB for jtds driver works though.

TIA,
RMG