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

.

Relevant Pages

  • How to include a file with connection parameters in JSP
    ... I have a series of JSP pages wich connect to an Oracle DB using JDBC. ... Several of these pages use the same connection string for JDBC, ... now that the connection parameters change, I have to uådate every one ...
    (comp.lang.java.programmer)
  • RE: Setting Up Training Domain
    ... The connection string that you have posted is not a valid JDBC connection ... This newsgroup is concerned with issues surrounding the JDBC ... If you are not using the JDBC driver to connect to SQL Server then you may ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: jdbc connection problem
    ... I don't believe the 2.6 version of the JDBC driver supports the VNODE ... I'm struggeling with a JDBC connection string and could use some ... The java client is running on the same host as a JDBC server. ...
    (comp.databases.ingres)
  • Re: strange problem using DATE fields from coldfusion/MX (jdbc)
    ... jdbc this problem went away. ... I will ask coldFusion, but its an uphill battle to talk to these guys ... I tried to add the parameters to the connection string, ... all the parameters to the JDBC driver. ...
    (comp.databases.oracle.server)
  • Re: [Info-Ingres] jdbc caches prepared statements?
    ... [Info-Ingres] jdbc caches prepared statements? ... the JDBC driver needs to follow the DBMS here. ... For the DBMS, in theory I would agree, but it turned out that changing ...
    (comp.databases.ingres)