Re: [Info-Ingres] jdbc connection problem

Hi Martin,
I'm pretty sure you could automate it with the installation scripting right
down to vnode creation.
Paul

-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx
[mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx]On Behalf Of
Martin Bowes
Sent: Tuesday, 11 September 2007 5:27 PM
To: John Dennis
Cc: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] jdbc connection problem


Hi John,

Your absolutely right.

I'm currently contemplating the thought of upgarding a lot of PCs from
II2.6 to Ingres2006 Client installations. Not a pretty thought!

Marty

-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx
[mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of John
Dennis
Sent: 11 September 2007 03:53
To: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] jdbc connection problem

Marty,

I don't believe the 2.6 version of the JDBC driver supports the VNODE
property/attribute in the connection string. It's certainly not listed
in the somewhat sparse JDBC doco for 2.6

John

Martin Bowes wrote:
Hi Everyone,

I'm struggeling with a JDBC connection string and could use some
ideas...

The java client is running on the same host as a JDBC server (II2.6).
It
wishes to use a vnode (called spam) to access a database on a remote
host. The vnode is a global vnode, and it uses user account
authentication on the remote host and it works perfectly well in SQL.

The connection string we chose was:
jdbc:ingres://localhost.II7/spam::bethan_dev;VNODE=login

Sadly this fails to connect.

_______________________________________________
Info-Ingres mailing list
Info-Ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

_______________________________________________
Info-Ingres mailing list
Info-Ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

.