On Sun, 3 Dec 2006, Gerhard Hofmann wrote: > > Richard Troy wrote: > > > > ... > > So, the time came to do something "real" with it, which in my case starts > > with loading a schema. For that, I've already got a Java application that > > works great with Postgres, Oracle, Sybase, DB2 and Informix. Should be a > > snap with Ingres, I figured! (ouch!) I considered creating a vnode, but I > > really don't want to in the first place, and in the second place, the > > keyboard mapping problem won't let me run (do anything with) netutil > > anyway, so, I can't create a vnode even if I wanted to. > > > > There is a workaround to use netutil and other Ingres tools in case your > keyboard layout is broken: > Hit ESC key, then keep SHIFT key pressed and hit O key, then P key -> > cursor will jump to netutil's command prompt.
Thanks much - I'd forgotten TERM_INGRES; setting it to the same value as TERM worked fine. (SHOULD be the default!) ... <esc><shift>0P, got it! > > When I try to connect using my app (updated to use the Ingres version of > > the URL - chose NOT to put a password in the URL but rather pass it > > through the method that takes the username/password separately. I get the > > exception: > > > > DriverManager.getConnectio() exception: com.ingres.gcf.util.SqlEx: > > Communications error while establishing connection. > > > > I thought I'd do a port scan check but there's nothing listening on port > > 117 - or any other port other than ssh and Postgres. Utility ingstatus > > says everythng is up and running and I can get into my database with > > isql/ingres/sql tools. So... > > If your using edbc.jar driver, check that JDBC server is turned on. For > use of iijdbc.jar, turn Data Access Server on. Use cbf tool to check this. > > HTH Gerhard Thanks Gerhard. I'm using the iijdbc.jar as I gather from what I've read that the edbc.jar is deprecated. Also, FWIW, I'm only using the com.ingres tree and not the ca.<whatever> tree (ie. unzipped into the installations CLASSPATH); could that be the problem? (Will try adding back the ca.<crap> but, frankly, it revulses my stomach to even "touch" _anything_ that has CA's lable on it!) When I run ingstat, I get: Ingres d0 name server (iigcn) - running Ingres d0 recovery server (dmfrcp) - running Ingres d0 DBMS server (iidbms) - 1 running Ingres d0 Star server (iistar) - 1 running Ingres d0 Net server (iigcc) - 1 running Ingres d0 Data Access server (iigcd) - 1 running Ingres d0 JDBC server (iijdbc) - not active Ingres d0 RMCMD process (rmcmd) - running Ingres d0 archiver process (dmfacp) - running but when I run cbf, I get: Name Server 1 DBMS Server 1 ICE Server 0 Star Server 1 Locking System 1 Logging System 1 Transaction Log II_LOG_FILE 1 Transaction Log II_DUAL_LOG 0 Recovery Server 1 Archiver Process 1 Remote Command 1 ...Still working on it! Thanks for the insights so far, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ _______________________________________________ Users mailing list Users@lists.ingres.com http://lists.ingres.com/mailman/listinfo/users
