Firebird embedded and JBuilderx java applicatiomn

Thread View: borland.public.jbuilder.database

5 messages

[T] Back to Threads [V] Tree View [G] Group Articles

5 total messages Started by cts Wed, 02 Aug 2006 07:36

#226

Author: cts
Date: Wed, 02 Aug 2006 07:36

10 lines
1113 bytes

 
 I am very close to getting Firebird embedded working with JBuilder
 the DataModule wizard can see data
 the setconnection throws no exceptions
 But when I try to open a table in my program it throws a
 com.borland.dx.dataset.DataSetException
 
 Can anyone comment on JBuilderX & FirebirdEmbedded?

Re: Firebird embedded and JBuilderx java applicatiomn

#227

Author: Kevin Dean [TeamB]
Date: Wed, 02 Aug 2006 13:15

26 lines
1960 bytes

cts wrote:

>  I am very close to getting Firebird embedded working with JBuilder
>  the DataModule wizard can see data
>  the setconnection throws no exceptions
>  But when I try to open a table in my program it throws a
>  com.borland.dx.dataset.DataSetException
>
>  Can anyone comment on JBuilderX & FirebirdEmbedded?

Run the console version of JBuilder (jbuilder.exe instead of 
jbuilderw.exe).  The exception will be printed to the console window; that 
should give you some idea as to the cause of the error.

-- 
Kevin Dean [TeamB]
Dolphin Data Development Ltd.
http://www.datadevelopment.com/

NEW WHITEPAPERS
Team Development with JBuilder and Borland Enterprise Server
Securing Borland Enterprise Server
http://www.datadevelopment.com/papers/index.html

Please see Borland's newsgroup guidelines at
http://info.borland.com/newsgroups/guide.html

Re: Firebird embedded and JBuilderx java applicatiomn

#228

Author: ctskinner
Date: Thu, 03 Aug 2006 04:34

45 lines
2423 bytes

Firebird embedded and JBuilderx java application
 
 I am very close to getting Firebird embedded working with JBuilder
 the DataModule wizard can see data
 the setconnection throws no exceptions
 But when I try to open a table [QueryDataSet in my program it throws a
 com.borland.dx.dataset.DataSetException



      dDriver = "org.firebirdsql.jdbc.FBDriver";
      durl = "jdbc:firebirdsql:embedded:C:\\a\\emFirebird\\T21";
      database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(durl, dUname, dpass, false,  dDriver));
   

      
===========================================      
com.borland.dx.dataset.DataSetException: Resource Exception. I/O error for file CreateFile (open) ""
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) ""
Error while trying to open file
null
============================================
[nb its a QueryDataSet, not a 'file' that I am trying to open]

If I omit the "embedded"  ie:
              durl = "jdbc:firebirdsql:C:\\a\\emFirebird\\T21";
              
              
I get:
============================================
              

com.borland.dx.dataset.DataSetException: Resource Exception. Unable to complete network request to host "C".
Reason: Unable to complete network request to host "C".

============================================




Note: the setconnection throws no exception even when the url points to a directory  which does _not_ contain my fdb database
The exceptions arise when I try to open a QueryDataSet

Re: Firebird embedded and JBuilderx The ANSWER

#229

Author: ctskinner ctskinnerATyahoo.com
Date: Thu, 03 Aug 2006 05:12

20 lines
1264 bytes

the answer is:

jdbc:firebirdsql:embedded:C:\\a\\emFirebird\\T21.fdb

NOT

jdbc:firebirdsql:embedded:C:\\a\\emFirebird\\T21

Obvious (in hindsight)

thanks to a prompt reply on:
http://groups.yahoo.com/group/Firebird-Java/
from:
"Roman Rokytskyy" <rrokytskyy@...>
rrokytskyy



JBuilderX and FireBird, a good combo....

Re: Firebird embedded and JBuilderx The ANSWER

#230

Author: Kevin Dean [TeamB]
Date: Thu, 03 Aug 2006 11:51

18 lines
1630 bytes

"ctskinner" ctskinnerATyahoo.com wrote:

>the answer is:

Thanks for posting the solution.

-- 
Kevin Dean [TeamB]
Dolphin Data Development Ltd.
http://www.datadevelopment.com/

NEW WHITEPAPERS
Team Development with JBuilder and Borland Enterprise Server
Securing Borland Enterprise Server
http://www.datadevelopment.com/papers/index.html

Please see Borland's newsgroup guidelines at
http://info.borland.com/newsgroups/guide.html

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads