Solved

Connecting JDBC to interbase database file

Posted on 2011-03-12
9
325 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

In this post we will learn different types of Android Layout and some basics of an Android App.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

740 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