Re: Exception: com.informix.asf.IfxASFException

Posted in 2005

Doug Lawry — Tue, 25 Jan 2005 11:50:19 -0000 — source: Usenet: comp.databases.informix

I don't know whether this will help, but I recently had some trouble connecting to SE 7 with the latest JDBC driver until I realised that there was no way of passing DBPATH to the back end. The only solution was to create symbolic links of the "*.dbs" directories in the user's home directory (probably "/home/rdtest" in your case). Before we can diagnose this further, you need to change your code so that the exact and full Informix error condition is captured and displayed: the listing below show the exception class name and context but not the contents. -- Regards, Doug Lawry www.douglawry.webhop.org "Leo" <francis.leonard@logonsi.fr> wrote in message news:321e3c40.0501210256.2d2e22d3@posting.google.com... > Hi, > I'm newbie with informix and I have to develop a java application that > will have to connect to Informix. > It will be running with Informix 5 SE ( with Informix NET ) on AIX > 4.3.3 > > Ihave set the environement variable > INFORMIXDIR,INFORMIXSERVER,SQLEXEC... > I'v launched $INFORMIXDIR/lib/sqlexecd -l logfile > > When I try to connect to Informix with the following url > I've a problem with the url > "jdbc:informix-sqli://myhost:1533/testDB:INFORMIXSERVER=myserver;user=rdtest;password=test" > I have the following error > MESSAGE:com.informix.asf.IfxASFException > java.sql.SQLException: com.informix.asf.IfxASFException > at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:950) > at java.lang.reflect.Constructor.newInstance(Native Method) > at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243) > at java.sql.DriverManager.getConnection(DriverManager.java:543) > at java.sql.DriverManager.getConnection(DriverManager.java:216) > at DBConnection.main(DBConnection.java:102) > In the log file, I have : ^A\\^A< myhost M-^@A > > > When I use the url > "jdbc:informix-sqli://myhost:1533/testDB:INFORMIXSERVER=myserver;USEV5SERVER=1;user=rdtest;password=test" > Exception in thread "main" java.lang.ClassCastException: > java.lang.NoSuchMethodError > at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:247) > at java.sql.DriverManager.getConnection(DriverManager.java:543) > at java.sql.DriverManager.getConnection(DriverManager.java:216) > at DBConnection.main(DBConnection.java:102) > In the log file, I have :sqlexec myhost rdtest -p > > Any idea? > Thanks.