• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

jdbc driver loading

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
reply
    Bookmark Topic Watch Topic
  • New Topic