Re: JDBCR4 service program question

I usually see this error when using an older Java Virtual Machine (JVM). SQL Server requires version 1.4 or later of the JVM.

Please make sure that you are using version 1.4 or later. If you have multiple JVMs installed on the system, make sure you've told it to use 1.4 or higher (it won't do it automatically.)


Nick Arndt wrote:

Hi all,
I am trying to connect to a MS SQL Server data base using Scott's JDBCR4
Service Program. I am getting a Java error when I try to connect :

java.lang.NoClassDefFoundError:
java/util/logging/Logger

java/lang/Throwable.<init>(Ljava/lang/String;)V+4
(Throwable.java:85)

java/lang/Error.<init>(Ljava/lang/String;)V+1 (Error.java:41)

java/lang/NoClassDefFoundError.<init>(Ljava/lang/String;)V+1 (
NoClassDefFoundError.java:38)
com/microsoft/sqlserver/jdbc/Util.<clinit>()V+99
(:??)

com/microsoft/sqlserver/jdbc/SQLServerDriver.parseAndMergeProperties(Ljava/lang/String;Ljava/util/Properties;)Ljava/util/Prope

com/microsoft/sqlserver/jdbc/SQLServerDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+5
(:??)


Here is the RPG code I am trying to execute
p CrtConnection b
d CrtConnection pi n
/free

// prepare the connection proporties
prop = JDBC_Properties();
JDBC_setProp(prop: 'userName' : 'fradmin');
JDBC_setProp(prop: 'password' : 'freitrater');
JDBC_setProp(prop: 'databaseName' : 'FreitRater');

conn = JDBC_ConnProp('com.microsoft.sqlserver.jdbc.SQLServerDriver'
:'http://192.168.90.216'
: prop );
JDBC_freeProp(prop);

if (conn = *NULL);
return error;
endif;

return success;
/end-free
p CrtConnection e

Any help would be greatly appreciated.

Thanks