Re: JDBCR4 service program question

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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