This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes accessing database ingres 6.4 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "accessing database ingres 6.4 " Watch "accessing database ingres 6.4 " New topic

accessing database ingres 6.4

Pinto K Geevarghese

Joined: Dec 18, 2003
Posts: 1
Hi ,
Can I take data from ingres 6.4 database with java ?
What is the driver ? How can I connect to ingres 6.4 from java servlet ?
please reply asap ...

David O'Meara

Joined: Mar 06, 2001
Posts: 13459

I'll move this to the JDBC forum for you.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

You can find a driver by checking the Driver Search Page here.
It lists 13 companies that provide Ingres drivers.
If you've never used JDBC before, it's probably best to begin by writing a couple of stand-alone applications that access the database before trying to write it in to a servlet.
Likewise, if you've never written a servlet, start by configuring the server and writing a couple of simple non-JDBC servlets to start with.
JDBC in Servlets is very similar except for a couple of minor differences. Firstly the driver libraries need to be configured in the web-application classpath, not the system classpath. Most people fall over this.
Secondly, if you're using a J2EE app server and not just a simple servlet container, you should get Connections via a server-provided DataSource rather than getting them from the DriverManager. This is much the same as using the DriverManager, but the Driver gets configured in the application server and is given a name where it can be found using JNDI. When you connect to the database, you get the DataSource from JNDI by this name and get a Connection from it. This allows the server to manage Connection resources and reduce problems like the time it takes to create a new Connection and applications that try to choke the database, stopping anyone else from getting in.
Hope this helps,
I agree. Here's the link:
subject: accessing database ingres 6.4
It's not a secret anymore!