This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes SQLJ in Visual Age for Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLJ in Visual Age for Java" Watch "SQLJ in Visual Age for Java" New topic
Author

SQLJ in Visual Age for Java

Gary Marten
Greenhorn

Joined: Sep 19, 2003
Posts: 2
Hi all,
When I try to run my java application in VA Java it fails in execution of the SQLJ (I am not getting any data from DB2, it fails in the first statement of the following group:
synchronized (__sJT_execCtx) {
sqlj.runtime.profile.RTStatement __sJT_stmt = __sJT_execCtx.registerStatement(__sJT_connCtx, MdApplicationDataAccessDeptDiv_SJProfileKeys.getKey(0), 0);
try
{
sqlj.runtime.profile.RTResultSet __sJT_result = __sJT_execCtx.executeQuery();
aMdDepartmentDivisionCursor = new MdDepartmentDivisionInfo_Cursor(__sJT_result);
}
finally
{
__sJT_execCtx.releaseStatement();
}
}
When I export the project as jar file (classes and resources) and run it using JRE it is working fine.
I was thinking that it was related to Workspace classpath in VA Java, but I have the following in my Windows-Options-Resources:
C:\Program Files\SQLLIB\;
C:\Program Files\SQLLIB\bin\;
C:\Program Files\SQLLIB\java\db2java.zip;
C:\Program Files\SQLLIB\java\runtime.zip;
C:\Program Files\SQLLIB\java\sqlj.zip;
Thank you very much in advance for any ideas.
Garry
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SQLJ in Visual Age for Java
 
Similar Threads
troube starting 4.0.2 WAS admin server
precompiling problems
PATH and CLASSPATH
Please Help!. Having problem starting Server in WSAD5.0
package oracle.jdbc.driver does not exist