Solved

Connecting JDBC to interbase database file

Posted on 2011-03-12
9
328 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Read about achieving the basic levels of HRIS security in the workplace.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…

734 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