?
Solved

Connecting JDBC to interbase database file

Posted on 2011-03-12
9
Medium Priority
?
331 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

752 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