Connection to another database using jdbc - Informix

wings

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:

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

Entered ifxjdbc.jar as the driver class name
jdbc:informix-sqli://servername:1541/database:INFORMIXSERVER=dbservername;user=username;password=password

What have I done wrong??

wings

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

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

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

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

wings

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

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