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