Connection to another database using jdbc - Informix

wings · Post by **wings** » Tue Apr 28, 2009 11:01 am

I want to connect to another database (Informix) and link the table to aware.

I have followed the manual but get the following error after selecting discover attributes:

'Aware IM Server encountered the following error .Unable to initialise the JDBC driver ifxjdbc.jar. Naek sure that the driver's class name is correctlyspecified .ifxjdbc.jar'

I have:

1. configured setenv.bat to include:

set INFORMIX_JDBC=..\InformixJDBC

SET CLASSPATH=%INFORMIX_JDBC%\ifxjdbc.jar;......

and this is correctly set in the CLASSPATH in the console window when aware starts up

2. Entered ifxjdbc.jar as the driver class name

3. jdbc:informix-sqli://servername:1541/database:INFORMIXSERVER=dbservername;user=username;password=password

What have I done wrong??

wings · Post by **wings** » Tue Apr 28, 2009 11:21 am

Ok, the classname was wrong, are googleing it should be:

com.informix.jdbc.IfxDriver

But I still get the same error:

Aware IM Server encountered the following error .Unable to initialise the JDBC driver com.informix.jdbc.IfxDriver. Naek sure that the driver's class name is correctlyspecified .com.informix.jdbc.IfxDriver

pixerp · Post by **pixerp** » Tue Apr 28, 2009 2:18 pm

I'm using a DB2 jdbc driver included in

c:\awareim\tomcat\shared\lib\jt400.jar

In setenv.bat :
......
set classpath=........;%AWARE_HOME%\jt400.jar;

When defining the external DB connection in the configuration tool (running from the Control panel !), the driver class name and connection URL need double check. In fact, I've used another tool to find out the correct values.

Good luck

wings · Post by **wings** » Wed Apr 29, 2009 9:01 am

Thanks, I moved the jar's to the location you used but still no luck.

Get the same error. I wouldn't had thought this was rocket science to get a connection going.

aware_support · Post by **aware_support** » Wed Apr 29, 2009 9:48 am

1. Make sure you re-start Aware IM after you change the batch file
2. Open your jar file with the zip utility and verify that the class you are specifying is indeed inside the jar file

wings · Post by **wings** » Thu Apr 30, 2009 8:55 am

I have restarted the server and unzipped the .jar confirming the classname as

com\informix\jdbc\IfxDriver.class and use com.informix.jdbc.IfxDriver in aware

Still no luck, I get the same error.

aware_support · Post by **aware_support** » Tue May 05, 2009 8:17 am

Aware IM was running as Windows service. In this case different files need to be modified - awareim.conf and wrapper.conf located in the AwareIM/BIN directory rather than setenv.bat