Two Laptop Bag*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "accessing database ingres 6.4 " Watch "accessing database ingres 6.4 " New topic
Author

accessing database ingres 6.4

Pinto K Geevarghese
Greenhorn

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 ...


erdc
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

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

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,
Dave.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: accessing database ingres 6.4
 
Similar Threads
Problem with database connection to ingres
ATG migration
Problem of JDBC request is not supported
jdbc driver loading
free database