Firebird Driver

[Derrick Stone]

Hello,

I am exploring new technologies for software development. I recently came across Lucee, and was intrigued because our company has tens of thousands of lines of CF code running on CF10. I downloaded first the Express and then the Installer versions. I am trying to connect a Firebird database, but I am getting confusing errors.

I start to define the connection, then get an error on the Path attribute:
Missing value for field Path

Path where the database is or should be located

When I supply a path to the database file, I get a create folder error. Does anyone have a suggestion for me?

Thank you,
Derrick

[mail...@gmail.com]

Hi Derrick,

are you supplying relative or absolute path? are you using windows or linux?

GX

[John Hastings]

I have a similar issue with Win 10 and migrating from Railo on Win 7.

I can access the Firebird database with other software but I get this message when trying to setup a Datasource in Lucee:

can't find class [org.firebirdsql.jdbc.FBDriver] for jdbc driver ...

I have verified the database name, user name, password, path, etc.

I have reinstalled Lucee with the same result.

Thanks for any help.

John

[Mark Drew]

The JDBC driver might be missing it seems. Download it and add it to the jars dir?

Mark Drew

- Sent by typing with my thumbs. 

--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/f73d8d97-5a6b-4d61-a5c3-fdca0e6e0f78%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mark]

Look at this post in Railo google group.

 https://groups.google.com/forum/#!searchin/railo/firebird/railo/ttiNHySRz7U/_BlY5syLe4MJ

[Hastings House]

That worked!  Downloaded the Firebird-2.5.5.26952-0_x64.zip file and put the 4 jar files in the C:\lucee\lib directory.

Thanks for the help,

John

You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/zu6aqTxW6X0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/C88A7EB4-A618-469A-9B2F-9F4658906EA2%40gmail.com.

[Derrick Stone]

Well, I'm a bit confused as to why Lucee is trying to access the database through the file system.

I had first gotten a missing driver error, and placing the Firebird driver jar file within the path cleared up that error and brought me to the errors about being unable to open the directory. I can get past the error by including a trailing slash in the path statement (e.g. E:\dev\data\) , however, I still get an error when I attempt to access that datasource in code.:

GDS Exception. 335544344. I/O error during "CreateFile (open)" operation for file "E:\DEV\DATA\MYDB"
Error while trying to open file
null

Shouldn't the server be connecting over a tcp/ip socket? Glad for your thoughts.

[Mark Drew]

Is there a full file you need to access?

Mark Drew

- Sent by typing with my thumbs. 

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/5a60210b-2074-4e86-9afe-2c212c4e1f6e%40googlegroups.com.

[mark]

Did you read my post in railo google groups?

Did you use jaybird-full.jar? Railo-Jetty folder =  railo\lib\ext\ is where you want to drop jaybird-full in with the other jdbc drivers, railo admin also asks for the path to where the database file is located, one more thing to remember is add the extension to the database name, database = mydatabase.fdb or gdb.

[Derrick Stone]

Thank you for replying and attempting to help me! I was a bit dense. I had no problems adding the jaybird-full file in an accessible location.

The part that did not appear to work is that the database I named mydb, and the database file was named mydb.db. So I entered the path e:\dev\data, then entered the database name, mydb, but it would fail to validate the datasource. I eventually figured out that I needed to supply the FILE NAME ( mydb.db ) in the database name field, and the complete folder name including the trailing slash (e:\dev\data\)  in the path. One of those things that just wasn't obvious until I understood what the fields were looking for. Now, it makes sense.

Thank you, I seem to be working!