File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes jdbc driver loading Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc driver loading" Watch "jdbc driver loading" New topic

jdbc driver loading

vangelis valasakis

Joined: Aug 27, 2004
Posts: 1
We have ingres database on UNIX platform and our front end is java-jsp on windows platform.

The problem that i have is that i can not load the driver of jdbc for ingres and connect to the database.

I am trying to connect through code or through connection wizards of JBuilder DataPilot and WebSphere connection DB Server configuration, using the following parameters:

class = ca.edbc.jdbc.EdbcDriver

url = jdbc:edbc:// (atl4356 is our vnode)

the documentation says that i must copy edbc.jar but it doesn't say where to put it. I put it in the client ingres installation in the lib directory and i declared it on the CLASSPATH. Where i should put this file?
i have tried also to put it in the java installation path in the lib directory and declare it again there.

the port that I use is ii7, because i saw it somewhere written on the documentation as an example. I don't know what port should i use.
Can someone tell me if this is the right port anyway?

I saw on another forum that the problem was solved by starting the ingres jdbc server. How can i do this? The documentation doesn't refer to it.
Ingres server has already started on UNIX and ingres client on my pc has started too through ingstart. Is there something that i miss?

Vangelis Valasakis

Vangelis Valasakis
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
I've never used Ingres through JDBC (nor do I ever plan to! ) but I may be able to offer some help.

Firstly, when you deploy a JAR file for a web application it typically needs to go in the <app context>/WEB-INF/lib directory where <app context> is the root context of your web app. The servlet container should pick it up from there.

Secondly, Ingres ... yuk. When I used Ingres years ago (even then it was outdated! ) you had to configure connections through ingmenu. I suspect that you'll need to set up the logical port ii7 (unless it's already there) in the same place that your vnode is defined, perhaps you can see what's already set up and use that instead.

Hope that helps.

I agree. Here's the link:
subject: jdbc driver loading
jQuery in Action, 3rd edition