Solved

Connecting JDBC to interbase database file

Posted on 2011-03-12
9
322 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
  • 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:ewangoya
ID: 35119035

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

 jdbc:interbase:C:\Program Files\Ron\Rad\Rile.GDB
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
web application structure 18 77
pagenation logic how it is working in my code 1 32
ejb on wildfly 5 20
Java syntax, or is it Selenium 6 16
Read about achieving the basic levels of HRIS security in the workplace.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
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…

832 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