aspose file tools*
The moose likes JDBC 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
Bookmark "jdbc driver loading" Watch "jdbc driver loading" New topic
Author

jdbc driver loading

vangelis valasakis
Greenhorn

Joined: Aug 27, 2004
Posts: 1
Hi,
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://192.168.131.2:ii7/atl4356::testdb (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.

Jules
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc driver loading