> 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/ _______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
