Hello All,
I've got a new Ingres installation and am trying to connect using JDBC and a "dynamic vnode specification". It's a new installation, never worked before. I'm not entirely new with Ingres, but haven't used it since CA bought the company in 1994, so I'm trying to sweep out the ole cobwebs and reactivate some of those dormant neurons... So, I appreciate the help. The server in question is on a Red Hat Linux system with no X-windows, and no web-server, and it's got the same old problem with key mapping that has been the bane of the ABF-type applications since 1989 and earlier. (Can somebody remind me, please, how to get the damned key mapping correct?) ...I got the installation up and running just fine, authorized a user and created a database. Checked out that I can create tables and add data without a problem. 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. 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... A little digging and I tried: ingstop -iigcc and then ingstart -iigcc and it spat out a port for GCC, 32993, and a "TCP-IP" port, 18816. (Neither is apparently open from another system in the network.) So, I tried: $ java JdbcInfo jdbc:ingres:/<host>:<gcc port>/<dbname> and it hung! Ran ingstatus and IT HUNG when it got to iigcc! I ^ced my way out of java and then the ingstatus completed. After a stop and restart of iigcc, I got a DIFFERENT gcc port!! (How do I know which one to use?) ...I've tried port 117 (which SEEMS like it would be the right port, from the literature) and the TCP-IP port as reported by starting IIGCC, but nothing other than the hang on the GCC port does anything interesting. I then got the idea that I have to include the password in the URL because I haven't a clue what JdbcInfo is doing and surely it can't know the password, and besides, what's in the errlog.log? Tried this format: $ java JdbcInfo jdbc:ingres:/<host>:<gcc_port>/<dbname>;user=<user>;password=<pwd> Still hung. Tried it agail while examining the errlog.log and found it gave this when the ^c came: <snip> Sat Dec 2 12:51:00 2006 E_GC0001_ASSOC_FAIL Association failure: partner abruptly released association I also found on one occasion that the iigcc server was down even though I didn't shut it down - restarted, of course... But I found the following that _might_ be related to that in the errlog.log: <host> ::[32993 IIGCC, 00000001]: Sat Dec 2 12:13:14 2006 E_GC100A_AUTH_EXPIRED Authentication certificate has expired. Advice appreciated. Richard P.S. sending an email reply is also appreciated - I'm having some technical difficulty with the comp.databases.ingres newsgroup. -shrug- RT -- 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
