Getting started with ColdFusion and Firebird

Firebird With CFMX

ColdFusion MX doesn't directly support Firebird/Interbase, but it's still easy to get them working together (assuming you have enough control over the server enviroment). Currently Firebird is about the only option when it comes to free/open-source RDBMS for Windows. Of course, in the Linux world there's plenty of alternatives, one of which you're probably already using. With this in mind the following steps focus mainly on CF under Windows, but it's a simple process so you should be able to adapt it to other platforms easily enough.

Assumming you have applied the latest CFMX updater and have Firebird installed and running, here's how:

Firstly, download the latest version of the Firebird JDBC drivers. The recommended install location is \wwwroot\WEB-INF\classes, under your CFusionMX root (usually C:\CFusionMX). Personally I like to create a firebird sub-directory under classes and extract it there. You don't need everything in the archive; see the documentation for what each particular file is for.

Now log into ColdFusion Administrator. Under server settings, choose Java & JVM. You need to add the location you just extracted the JDBC drivers to your class path, something like this:
C:/CFusionMX/wwwroot/WEB-INF/classes/firebirdsql.jar

or if you made a firebird sub-directory:
C:/CFusionMX/wwwroot/WEB-INF/classes/firebird/firebirdsql.jar

Now save the changes, then restart the CF service.

Next we can try to create a Firebird datasource. Add a new datasource, choosing 'Other' in the driver select box. The JDBC URL is probably the trickiest part of the whole process. From the documentation:


I've never had any problems using the "new format," which willl be something that looks like this:
jdbc:firebirdsql://localhost:3050/C:\\www\\data\\TEST.GDB
or
jdbc:firebirdsql://192.168.1.1:3050/C:\\www\\data\\TEST.GDB
are both valid. Note the double backslashes in the path.

For the same database on the same machine, the "old format" would look like this:
jdbc:firebirdsql:localhost/3050:C:\\www\\data\\TEST.GDB
or
jdbc:firebirdsql:192.168.1.1/3050:C:\\www\\data\\TEST.GDB

The next thing you need to add is the driver class. It's simply: org.firebirdsql.jdbc.FBDriver

You also need to enter the DB username and password; the Interbase/Firebird default is sysdba:password

That's more or less it. Submit your new datasource and hopefully it should verify okay. If not, check your JDBC URL.

I hope I got everything. Feel free to post corrections/problems below!

Hi,

I have a problem; occuring following error when I click Submit button in the "Data Source Add" page. Error message:

"Connection verification failed for data source: firebirdsql101
[]java.sql.SQLException: Resource Exception. Your user name and password are not defined. Ask your database administrator to set up a Firebird login. Reason: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
The root cause was that: java.sql.SQLException: Resource Exception. Your user name and password are not defined. Ask your database administrator to set up a Firebird login. Reason: Your user name and password are not defined. Ask your database administrator to set up a Firebird login."


Fields in the form;
CF Data Source Name : firebirdsql101
JDBC URL : jdbc:firebirdsql://localhost:3050/C:\\Program Files\\Firebird10\\examples\\employee.gdb
Driver Class : org.firebirdsql.jdbc.FBDriver
Username : SYSDBA
Password : masterkey


I installed FB now (full). not change default settings of FB.

please help me


Firebird 1.0.1
CF 6.1 (JRun)

Hi,

resolved my problem.

thank everyone

when I click Submit button in the "Data Source Add" page. Error message:
" Connection verification failed for data source: firebirdx
[]java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection"


url: jdbc:firebirdsql://localhost:3050/C:\\Program Files\\Firebird\\Firebird_1_5\\bin\\EMPLOYEE.FDB

What should I do to test to see if the database is working and what tests should do to make sure connections can be made from port 3050 and should I change to GDB from FDB and what is the difference between the two. thanks Dan

hi,

my Data Source properties:

----

CF Data Source Name : ibbgovtr_icerik
JDBC URL : jdbc:firebirdsql://localhost:3050/C:\\Program Files\\Firebird\\FirebirdSQL15\\examples\\EMPLOYEE.FDB
Driver Class : org.firebirdsql.jdbc.FBDriver
Driver Name : FirebirdSQL -1.5.0.4027-RC7-Win32 - firebirdsql.jar
Username : SYSDBA
Password : ****************
Description :

----

my JDBC driver located: C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\lib\firebirdsql.jar

this JDBC driver contain :

09.03.2004 09:42 <DIR> EDU
30.12.2003 17:02 8.013 isc_encodings.properties
30.12.2003 17:02 1.696 isc_encoding_size.properties
30.12.2003 17:02 36.864 isc_error_msg.properties
30.12.2003 17:02 247 isc_tpb_mapping.properties
09.03.2004 09:42 <DIR> javax
09.03.2004 09:42 <DIR> META-INF
09.03.2004 09:42 <DIR> org

there is this JDBC driver at :

http://sourceforge.net/project/show...p?group_id=9028

also my this driver located :

http://esrefatak.sitemynet.com/fb-jdbc.htm


---

CF Administrator web interface -> "Java VM Settings"'s "Classpaths" list contain (also):

{application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/lib/firebirdsql.jar

important: require restart when modified this list

---


my softwares:

ColdFusion MX 6.1
Firebird 1.5




regards,
esref atak
"close the window open the source!" ©

ei...
I have a problem equal...
I'm brazilian and don't speak english...
So.. Exists the probability of I don't understand everyThings...

I make like it[ exemplo]

I get the firebird Driver firebird.jar on net..
and Your location now is "c:\cfusionMX\verifity\collection\firebird.jar"

I using the IIS, ColdFusion MX 6, Win XP, FireBird 1.5 runing as classical server...

In Java e JVM I Write:
class path :"c:\cfusionMX\verifity\collection\firebird.jar"

After it, I make a DataSource.... TypeDatabase other..

||>Name: FireIni
||>Jdbc Url: jdbc:firebirdsql://localhost/c:\\dados\\ini
[ I hide the port number because I using the IIS{i think}, and my FireBird Database has not a extension... and is locate in c:\dados\ and your name is only ini]
||>Drive Classrg.firebirdsql.jdbc.FBDriver
||>Drive name: FirebirdSQL -1.5.0.4027-RC7-Win32 - firebirdsql.jar
||>userName: SysDba
||>*********
||>Description: FireBird test

and whem I save..

Give me this message
Connection verification failed for data source: Fireini
[]java.sql.SQLException: No suitable driver available for Fireini, please check the driver setting in jrun-resources.xml, error: org.firebirdsql.jdbc.FBDriver
The root cause was that: java.sql.SQLException: No suitable driver available for Fireini, please check the driver setting in jrun-resources.xml, error: org.firebirdsql.jdbc.FBDriver

Whats the mather??
Whats Error??


Please..
Help-me...

hi,

is valid the your username?: SysDba
default username is SYSDBA
default password is masterkey

hi!

I change the username and the password...
now..
I has a new error message

Connection verification failed for data source: Fireini
[]java.lang.NoClassDefFoundError: java/sql/Savepoint
The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint

Can you say me what is this??

"Class not found"
is the configuration o JVM ??
or is the configuration in ClassName ??
the classname is rg.firebirdsql.jdbc.FBDriver correct ??
and the jvm Class is my driver firebirdsql.jar correct ??

wow...
is very dificult config it...

Where are every body??
Why I haven't the reply??

is my problem the language now??

I know nothing about Firebird, I use Oracle and SQL Server. You may what to go ask this question in a Firebird forum as it is really a Firebird configuration question that has nothing to do with ColdFusion.

I use oracle and SqlServer too..
But now I Wont use the firebirb.. because is a great open source database..
The mysql is free too... but the Firebird is the best...
Becouse it I wont use the firebird...
Here in Brasil I Don't find nothing about it...[ cold and fire]
so, I see the MySql the last solution...
It's shy!!!!
If anypeople find the solution, It will be very Welcome...
But... the MySql is gonna be my solution.... now...
Thanks everybody...

did you copy the jar file to the jar directory of the application server?

yet!!!
I gonna try redo one more time..
ReInstall the ColdFusion Server...
ReDo my data base and
ReDownload the firebirdsql.jar in other place...

After it .. if don't work well I make a now post.. posting the new errors....

can you send me the "Settings Summary" of the application server.

I don't can compile a java class too...
I have a message equal!!! in a native clas.. java.lang....

I bet I need format the machine to make it runing..
I unistal the cold.. and I gonna instal the cold 6.1... after it I send to you the error...
Fist I gonna try one more time..