JDBC/ODBC Eway java.lang.NoClassDefFoundError 1

[atshah]

I tried to implment the expample of ODBC/jdbc from provided PDF.
here is the error i got after running the schem

please advise what is the problem.

DBSelect (Information): (setConnectionManagementExpiration_C) WorkItem in ThreadInfo not null.
DBSelect (Information): (setConnectionManagementExpiration_C) going to see if WorkITem is valid
DBSelect (Information): (setConnectionManagementExpiration_C) going to set Timer
DBSelect (Information): SessionFactory.createSession(): Using JDBC URL for connection
DBSelect (Information): SessionFactory.createSession(): Login timeout is set to 300 secs
DBSelect (Information): Session.open(): Opening database session...
DBSelect (Information): JCS: Java collaboration translate threw a java.lang.Exception!
DBSelect (Information): *************** Exception occurred **************
DBSelect (Information): toString: java.lang.NoClassDefFoundError: com/merant/SlExtensionInterface
DBSelect (Information):
DBSelect (Information): getMessage: com/merant/SlExtensionInterface
DBSelect (Information):
DBSelect (Information): StackTrace:
a.lang.NoClassDefFoundError: com/merant/SlExtensionInterface
at com.stc.eways.jdbcx.Session.connect(Session.java:327)
at com.stc.eways.jdbcx.Session._open(Session.java:415)
at com.stc.eways.jdbcx.DbConnector.open(DbConnector.java:120)
at com.stc.common.collabService.JConnectionManagerImpl.openConnectorConnection(JConnectionManagerImpl.java:504)
at com.stc.common.collabService.JConnectionManagerImpl.manageAutomatic(JConnectionManagerImpl.java:429)
at com.stc.common.collabService.JConnectionManagerImpl.registerConnector(JConnectionManagerImpl.java:269)
at com.stc.eways.jdbcx.SqlObjectGroupExt.initialize(SqlObjectGroupExt.java:87)
at com.stc.jcsre.JCollaboration.newInstance(JCollaboration.java:78)
at DBSelectBase.createInstances(DBSelect.java:48)
at com.stc.jcsre.JCollaboration.initialize(JCollaboration.java:45)
at com.stc.common.collabService.JCCollabControllerImpl.initializeJCollaboratorExt(JCCollabControllerImpl.java:1154)
at com.stc.common.collabService.JCCollabControllerImpl.firstTimeInTranslate(JCCollabControllerImpl.java:1139)
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java:423)

 

[STCNAG]

You have to install the ThirdParty drivers from Mernat and add them inot you classpath.

Thanks
Nag

 

[atshah]

I already did that.. but no use.

Here its what is set in my Class path.

G:\eGate4.\client\ThirdParty\merant\classes\spy.jar;
G:\eGate4.5\client\ThirdParty\sun\classes\jdbc2_0stdext.jar;
G:\eGate4.5\client\classes\egate.jar;
G:\eGate\client\classes;
G:\eGate\client\classes\egate.jar;
G:\eGate\client\JRE\1.1.7B\lib\rt.jar;


Please Advise i m waiting..

Regards
~at

 

[grmah]

try this:
In your collab editor go to tool>options and tools/java imports

double check if the class/package is there.

recompile and promote to run time.

 

[atshah]

thanks grmah,
I tried that and it worked BUT ..

Now i am Constantly getting these messages
- WorkItem in ThreadInfo not Null
- Gooing to see if workITem is valid
- Going to set Timer DBSelect

above is the log block.

<LOG>
DBSelect (Information): (setConnectionManagementExpiration_C) WorkItem in ThreadInfo not null.
DBSelect (Information): (setConnectionManagementExpiration_C) going to see if WorkITem is valid
DBSelect (Information): (setConnectionManagementExpiration_C) going to set Timer
DBSelect (Information): SessionFactory.createSession(): Using JDBC URL for connection
DBSelect (Information): SessionFactory.createSession(): Login timeout is set to 300 secs
DBSelect (Information): Session.open(): Opening database session...
DBSelect (Warning): Session.setDBMS(): Oracle recommends using JDBC 9.0.1 with Java 1.3. Pleas
DBSelect (Information): Session.setDBMS(): Driver name is JDBC-ODBC Bridge (SQORA32.DLL) (ver:
DBSelect (Information): Session.open(): Successfully opened database session
DBSelect (Information): DbConnector.open(): Successfully opened Database connector
DBSelect (Information): (setConnectionManagementExpiration_C) WorkItem in ThreadInfo not null.
DBSelect (Information): (setConnectionManagementExpiration_C) going to see if WorkITem is valid
DBSelect (Information): (setConnectionManagementExpiration_C) going to set Timer
DBSelect (Information):
<log>

Thanks for helping me ...
Please Advise what is wrong ... I AM waiting.... for responses.

Regards

~at

 

[grmah]

hey,

sorry for the late reply, it looks like a configuration information.

Is it an acutal error?

check your config files and connection params

 

[kodumuri]

Yes, you need to install Merant Drivers which comes with seebeyond installation kit

 

[atshah]

Hi grmah,
Thanks a lot for you post.
It seems liked JDBC/ODBC sample worked.
becuase i m getting query result in out put file.

I have another question
Let say I have two Application SERVER and CLIENT
SERVER takes request in its defined tagged form. (XML form)
and client send request to Server in xml form.

how can i integrate Server and client applications.
how can i define XML request data structure which will be recived by client and send it to server.

Any suggestion and comments would help.

regards
~at