Firebird Driver

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

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

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.> On 2 Jan 2016, at 19:13, John Hastings <@John_Hastings> wrote:

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

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+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@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.

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.

Look at this post in Railo google group.

https://groups.google.com/forum/#!searchin/railo/firebird/railo/ttiNHySRz7U/_BlY5syLe4MJOn Saturday, January 2, 2016 at 2:40:48 PM UTC-6, John Hastings wrote:

Thanks for any help.

John

Hi Derrick,

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

GXOn Friday, 1 January 2016 22:18:23 UTC+2, Derrick Stone wrote:

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

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,

JohnOn Sat, Jan 2, 2016 at 3:14 PM, Mark Drew <@Mark_Drew> wrote:

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.

On 2 Jan 2016, at 19:13, John Hastings <@John_Hastings> wrote:

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


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+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/f73d8d97-5a6b-4d61-a5c3-fdca0e6e0f78%40googlegroups.com
https://groups.google.com/d/msgid/lucee/f73d8d97-5a6b-4d61-a5c3-fdca0e6e0f78%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.


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 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+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/C88A7EB4-A618-469A-9B2F-9F4658906EA2%40gmail.com
https://groups.google.com/d/msgid/lucee/C88A7EB4-A618-469A-9B2F-9F4658906EA2%40gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

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.On Saturday, January 2, 2016 at 8:42:28 PM UTC-5, John Hastings wrote:

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

On Sat, Jan 2, 2016 at 3:14 PM, Mark Drew <mark...@gmail.com <javascript:> wrote:

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.

On 2 Jan 2016, at 19:13, John Hastings <hhou...@gmail.com <javascript:>> wrote:

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


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 <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/f73d8d97-5a6b-4d61-a5c3-fdca0e6e0f78%40googlegroups.com
https://groups.google.com/d/msgid/lucee/f73d8d97-5a6b-4d61-a5c3-fdca0e6e0f78%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.


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 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 <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/C88A7EB4-A618-469A-9B2F-9F4658906EA2%40gmail.com
https://groups.google.com/d/msgid/lucee/C88A7EB4-A618-469A-9B2F-9F4658906EA2%40gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

Is there a full file you need to access?

Mark Drew

  • Sent by typing with my thumbs.> On 3 Jan 2016, at 04:58, Derrick Stone <@Derrick_Stone> wrote:

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.

On Saturday, January 2, 2016 at 8:42:28 PM UTC-5, John Hastings wrote:
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

On Sat, Jan 2, 2016 at 3:14 PM, Mark Drew mark...@gmail.com wrote:
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.

On 2 Jan 2016, at 19:13, John Hastings hhou...@gmail.com wrote:

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

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.


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 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.

For more options, visit https://groups.google.com/d/optout.


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+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/5a60210b-2074-4e86-9afe-2c212c4e1f6e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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.*On Sunday, January 3, 2016 at 12:07:12 PM UTC-6, Derrick Stone wrote:

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.

On Saturday, January 2, 2016 at 8:42:28 PM UTC-5, John Hastings wrote:

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

On Sat, Jan 2, 2016 at 3:14 PM, Mark Drew mark...@gmail.com wrote:

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.

On 2 Jan 2016, at 19:13, John Hastings hhou...@gmail.com wrote:

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


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
https://groups.google.com/d/msgid/lucee/f73d8d97-5a6b-4d61-a5c3-fdca0e6e0f78%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.


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 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
https://groups.google.com/d/msgid/lucee/C88A7EB4-A618-469A-9B2F-9F4658906EA2%40gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

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!On Sunday, January 3, 2016 at 1:53:21 PM UTC-5, mark wrote:

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.*
    On Sunday, January 3, 2016 at 12:07:12 PM UTC-6, Derrick Stone wrote:

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.

On Saturday, January 2, 2016 at 8:42:28 PM UTC-5, John Hastings wrote:

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

On Sat, Jan 2, 2016 at 3:14 PM, Mark Drew mark...@gmail.com wrote:

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.

On 2 Jan 2016, at 19:13, John Hastings hhou...@gmail.com wrote:

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


Love Lucee? Become a supporter and be part of the Lucee project today!


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
https://groups.google.com/d/msgid/lucee/f73d8d97-5a6b-4d61-a5c3-fdca0e6e0f78%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.


Love Lucee? Become a supporter and be part of the Lucee project today!


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
https://groups.google.com/d/msgid/lucee/C88A7EB4-A618-469A-9B2F-9F4658906EA2%40gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.