Already having installed on my PC the database (Firebird 2.5 Alpha1) and a client tool (Flamerobin 0.8.6) I went for the server, downloading and installing the free developer version of ColdFusion 8 from Adobe's site.
Install went smooth and I just confirmed every default option but the drive D: in my case instead of the standard C:
After the install finished I logged into the admin console at the default address and opened the Server Setting Summary:
The important things are highlighted:
- ColdFusion server version: 8,0,1,195765
- Edition: Developer
- Java VM Version: 1.6.0_04
I chose the lates driver available, JayBird 2.1.6, for my JVM which is 1.6:
The driver downloads as a zip file, unzip it, extract the driver:
And place it along the other JDBC drivers in the ColdFusion server (the server config can tell you where they are), in my case D:\ColdFusion8\lib and restarted the server:
A quick check confirmed that the driver is in the server classpath:
Now I set up an alias for my Firebird database, just to have a simpler connectionstring, open up the file aliases.conf and add a row for your db, from now on you'll be able to refer to the alias instead of the full path to the db:
Don't forget to restart the Firebird server.
Ok, time to go back to ColdFusion and set up a Data Source:
Name it "LocalFirebird" and chose driver "other" from the drop down list, the click "Add".
After clicking "Add" a new form opens, asking for some other details:
- JDBC URL: jdbc:firebirdsql:127.0.0.1/3050:pippo (note the alias, no need for the full path)
- Driver Class: org.firebirdsql.jdbc.FBDriver
- Driver Name: JayBird
- Username: your user, standard admin name is SYSDBA
- Password: your password, standard password for SYSDBA is masterkey
After confirming the datasource is OK you can go on and put up a quick test page.
A Devshed forum use has put up a quick tutorial some time ago, kudos to him but it looks like it's a bit old (2003) and "poor in graphics" ;), you can find it here, I added some notes there which correspond to the content of this post.