KB#01039-Sample JDBC configuration for Informix JDBC

Title:

Sample JDBC configuration for Informix JDBC

Description:

1) Before you install check that the correct JVM is referenced for Java, or modify your BBj.properties to reference the correct version of Java. 

/install/opt/bbj/cfg/BBj.properties 

2) Check your environment variable $CLASSPATH. Does it include both the BBj JDBC jar file and your Informix JDBC jar file? 

3) Try the quick test from within BBj. From the Ready prompt, type the following: 
java.lang.Class.forName("com.informix.jdbc.IfxDriver") 

If this doesn't return an error, try your sqlopen() again. 

4) Confirm that your sql.ini is properly configured. From your previous emails on your SQL.ini file: 

[JDBC Drivers] 
com.informix.jdbc.IfxDriver 

[intradec] 
url=jdbc:informix-sqli://xavier:1551:informixserver=xavier;user=informix;pas 
sword=Informix 

Last Modified: 02/24/2004 Product: BBj Operating System: UNIX

BASIS structures five components of their technology into the BBx Generations.