Setting up JDBC in Railo 4.2

[Joe Genshlea]

Hello - Sort of NB with RAILO so please bear with me.

We have some old legacy Informix databases where I work that I'd like to wrap some CFML forms around 

I have the requisite JDBC drivers installed on my workstation (same workstation that hosts RAILO). The jdbc drivers are used by Aqua Studio and Talend, so I'm pretty sure they support what I need to do.

I'm running 

Tomcat7 and the most recent release of Railo (4.2 I think) .

Anyway, these are all part of IBMs jdbc download:

ifxjdbc.jar

ifxjdbcx.jar

ifxlang.jar

ifxlsupp.jar

ifxslqj.jar

ifxtools.jar

So, long question short, what steps do I take to get RAILO wired up with our informix host?

This is the connect string I tried with no luck.

jdbc:informix-sqli://server.somewhere.com:5050:INFORMIXSERVER=acme;user=NONEOFYOURBEEZWAX;password=NONEOFYOURBEEZWAX

[mmm mmm]

 Try this,

make sure the ifxjdbc.jar file is in the railo lib folder,
in Railo admin datasource = other jdbc,
driver class = com.informix.jdbc.IfxDriver,
jdbc url = dbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>,
user = NONEOFYOURBEEZWAX,
password = NONEOFYOURBEEZWAX.

good luck.

[Joe Genshlea]

Thank  you

still getting this:

can't find class [com.informix.jdbc.IfxDrive] for jdbc driver, check if driver (jar file) is inside lib folder (cannot load class through its string name, because no definition for the class with the specified name [com.informix.jdbc.IfxDrive] could be found)

I confirmed that the jar file(s) are in  Tomcat7/webapps/WEB-INF/railo/lib 

Also did you mean to say the connect string is 

dbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>,

or

jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>,

?

Thanks again.

[Joe Genshlea]

Hello

Success.

I restarted both Tomcat and Railo which didn't seem to fix the problem.  Then I bounced my workstation which did fix the problem.  One of the services apparently didn't restart when I thought it did.

[mmm mmm]

Sorry about the typo, good to hear you got it figured out.