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