CF8 - GDSFactory class error when connecting to Firebird DB
Hello,
I am trying to get started in learning CF but I can't seem to get past the starting gate. The problem is in connecting to the Firebird DB.
I followed the instructions from many blogs and forums (including this one which is most helpful: http://pabloj.blogspot.com/2008/07/setting-up-coldfusion-and-firebird.html). I downloaded the Jaybird 2.1.6 driver from the www.firebirdsql.org site and placed jaybird-full-2.1.6.jar in c:\coldfusion8\lib folder. I also tried putting it in the c:\coldfusion\runtime\lib, c:\coldfusion\wwwroot\WEB-INF\lib -- all to no avail.
The error I'm getting (from the exception.log file) is:
"Error","web-0","10/12/09","10:18:03","cfadmin","Could not initialize class org.firebirdsql.gds.impl.GDSFactory The specific sequence of files included or processed is: C:\ColdFusion8\wwwroot\CFIDE\administrator\logging\index.cfm, line: 142 "
java.lang.NoClassDefFoundError: Could not initialize class org.firebirdsql.gds.impl.GDSFactory
at org.firebirdsql.jdbc.FBDriver.acceptsURL(FBDriver.java:190)
at java.sql.DriverManager.getDriver(DriverManager.java:253)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:79)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:59)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:297)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
Any suggestions on where to go next would be most appreciated. I've been trying different things for almost 2 weeks now and have reached a dead end. Thanks in advance,
vince
pittsburgh, pa
