Hi,
I just altered my setup:
JdbcDriver=ca.ingres.jdbc.IngresDriver
DbUrl=jdbc:ingres://serval:RJ7/sdmsdb2;
and of course $II_SYSTEM/ingres/lib/iijdbc.jar is in my classpath.
This combination runs perfectly.
(my ingres version on this machine is:
Ingres Linux Version II 3.0.1 (int.lnx/106) login
)
The ingres "port" RJ7 is hashed to a non privileged portnumber. It serves
as some sort of abstraction to make configuration easier. The hashing is
done somewhere in the ingres libs.
Regards,
Ronald
On Sun, 3 Dec 2006 19:50:59 -0800 (PST)
Richard Troy <[EMAIL PROTECTED]> wrote:
>
>
> > just a summary of my setup, it might help with getting JDBC running.
>
> Thank you very much, Ronald...
>
> > 1. $II_SYSTEM/ingres/files/config.dat
> >
> > you can edit this file with plain vi (or any other editor) and adjust your
> > configuration. As long as you know what you are doing, you can circumvent
> > cbf.
>
> Perfect. Glad to know there's no problem with just editing the file.
>
> > For using JDBC I have:
> >
> > ii.serval.ingstart.*.jdbc: 1
> > ii.serval.jdbc.*.client_max: 10
> > ii.serval.jdbc.*.client_timeout: 0
> > ii.serval.jdbc.*.connect_pool_expire: 0
> > ii.serval.jdbc.*.connect_pool_size: 0
> > ii.serval.jdbc.*.connect_pool_status: off
> > ii.serval.jdbc.*.port: RJ7
> > ii.serval.jdbc.*.protocol: tcp_ip
>
> Looks like you're using the "JDBC Server", which I understand is
> deprecated, yes? I was trying to use DAS....
>
> Your port is set to RJ7 - where does this get translated into an integer?
> Other systems will need to know the port number and I'll have to either
> hard-code the port or put it in /etc/services, right?
>
> I also note several servers use client_max; when the value is -1 does this
> mean unlimited as one might expect?
>
> >
> > My db server is called serval, my installation code is RJ (for
> > apparent reasons)
> >
> >
> > 2. connect URL
> >
> > I use a configuration file with following contents:
> >
> > JdbcDriver=ca.edbc.jdbc.EdbcDriver
> > DbUrl=jdbc:edbc://serval:RJ7/sdmsdb;
> > DbUser=ronald
> > DbPasswd=somepassword
>
> Right. I'm using com.ingres.IngresDriver, and I've been trying two
> versions of the url: jdbc:ingres://<host>:<port>/<database>, passing the
> username and password as you have below, and I've also tried
> jdbc:ingres://<host>:<port>/<database>;user=<user>;password=<pwd>
>
> >
> > This all might not entirely fit your needs, on the other hand it may serve
> > as a starting point.
>
> Thanks for replying, Ronald.
>
> Regards,
> Richard
>
> --
> Richard Troy, Chief Scientist
> Science Tools Corporation
> 510-924-1363 or 202-747-1263
> [EMAIL PROTECTED], http://ScienceTools.com/
>
>
--
independIT Integrative Technologies GmbH
Sitz der Gesellschaft: Schrobenhausen
HRB Neuburg B 1.521
Geschäftsführer:
Dieter Stubler, Dipl. Inform. (FH)
Ronald Jeninga, Diplom Mathematiker
_______________________________________________
Users mailing list
Users@lists.ingres.com
http://lists.ingres.com/mailman/listinfo/users
