Solved

Connecting JDBC to interbase database file

Posted on 2011-03-12
9
329 Views
Last Modified: 2012-05-11
Hello
Question relates to using java to access an interbase file.
When I was using Interbase 2009 developer edition, I was able to connect with a local database with the path

interbase.path: jdbc:interbase://localhost/C:/Program Files/Ron/Rad/Rile.GDB

This worked fine.
When I changed to desktop edition Interbase XE using the same path, the connection is refused.

I feel it has to do with the localhost. In delphi, I had the sam problem, and was able to fix this by removing the word local host from the path. Is there a way to remove the localhost from this path in Java? what is the syntax?
Thansk in advance
0
Comment
Question by:dkeene
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 92

Expert Comment

by:objects
ID: 35118725
what driver are you using?
0
 

Author Comment

by:dkeene
ID: 35118959
The same driver in each case. I don't know. It worked in 2009 Developer edition, which might emulate the server edition, and it does not work in the Desktop edition.
0
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 35119035

For desktop editions you dont use server name, have you tried

 jdbc:interbase:C:\Program Files\Ron\Rad\Rile.GDB
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 92

Expert Comment

by:objects
ID: 35119055
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 35121904
Does Interbase have a listening socket? You can establish that with the server running with the following command at the command line:
netstat -a -n

Open in new window

0
 

Author Comment

by:dkeene
ID: 35122609
Thank you all; it has something to do with the difference between Developer Edition license and Desktop Edition license, as the same JDBC code worked in Developer and NOT in Desktop.

0
 
LVL 86

Expert Comment

by:CEHJ
ID: 35122616
What was the result of the netstat command?
0
 

Accepted Solution

by:
dkeene earned 0 total points
ID: 35159041
This was answered by embarcadero. To connect to interbase via Java, the Server edition is required. It has only to do with Interbase Licensing. Thank you all for your help.
0
 

Author Closing Comment

by:dkeene
ID: 35187399
The question was answered by embarcadero.
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This video teaches viewers about errors in exception handling.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question