JDBC Adaptor Connection - Cannot Locate Schemas from the Dat

, ,
1

Hello
We have configured JDBC Adaptor connection, and when we are trying to create the adaptor service it has done but not showing the schemas of database under that user.
The username and password is valid.
Previously it was giving error on creation of JDBC Connection, i copied the classes12.zip file in <server.root>/lib/jars directory. now it has created Connection but not listing the schemas available in that user. giving following error.

com.wm.app.b2b.server.ServiceException: [ART.114.205] Adapter Runtime (Metadata):
Unable to lookup the resource domain values.
[ADA.1.321] Cannot get the list of schemas. "
(60000/600) ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], , , , , ,
"
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], , , , , ,

on tables.schemaName [Ljava.lang.String;@10dd09
java.lang.Exception: Adapter values are not available.

What could be the reason, please help me this …
Thanks and Best Regards,
Rizwan

2

Hi Rizwan,

please provide us the following informations:

  • IS Version
  • JDBC Adapter Version
  • Oracle DB Version
  • Driver Version
  • Java Version used by IS.

Probably your db user does not have the rights to show the schemas.
Verify this with your DBA.

Regards,
Holger

3

We initially had a similar problem.
It was indeed schema rights for the userid as Holger has indicated.
Try using a external tool such as TOAD against say an Oracle instance you are
attempting and it will give you some more indication as to your problem.
We needed to have the userid be able to create schema triggers, etc.
HTHs !