Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Ingres Topics / June 2008

Tip: Looking for answers? Try searching our database.

How to conect ingres with Java in windows XP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
koli1980 - 20 Jun 2008 08:15 GMT
Hello, I want to use Java to perform queries in my ingres database. Currently
there is an ODBC driver installed in the server but I would like to use JDBC
driver to connect directly with the database without using a JDBC/ODBC bridge.

Please can somebody tell me what do I need to install and how? Also would you
know if this drivers are available for free which I am interested in?

Many thanks
Nikolla
Roy Hann - 20 Jun 2008 08:40 GMT
> Hello, I want to use Java to perform queries in my ingres database.
> Currently
[quoted text clipped - 6 lines]
> you
> know if this drivers are available for free which I am interested in?

JDBC support is included with when you install Ingres 2006.  Just make sure
you have a Data Access Server configured to start, although it probably
starts automatically.

Take a look at
http://docs.ingres.com/connectivity/UnderstandingJDBCConnectivity.

Roy
Paul Mason - 20 Jun 2008 10:14 GMT
2008/6/20 koli1980 <u44357@uwe>:

> Hello, I want to use Java to perform queries in my ingres database.
> Currently
[quoted text clipped - 9 lines]
> Many thanks
> Nikolla

Hi Nikolla,

You can download the driver itself from here
http://www.ingres.com/downloads/connectivity-resources.php (you'll need to
register but it's free)

The driver itself is pure Java and is just a jar file that you need to put
on your client PC and make sure your CLASSPATH picks it up. On the Ingres
installation you're trying to connect to you'll need to have the Data Access
Server (DAS) running. Check CBF and make sure the startup count is 1. Also
the DAS server has a "listen address" which you need to specify as part of
the connection URL. By default it's whatever your installation id is with a
7 on the end e.g. if your installation id is II then your DAS listen address
will be II7 and you connection URL might be something like
jdbc:ingres://servername:II7/mydatabase

That's just a very brief overview, for more information follow the link Roy
gave and read the documentation.

HTH
Paul

Signature

Paul Mason

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.