Re: [Info-Ingres] JDBC driver for Ingres 2.5

Good morning all,
Do you not need to talk to the port of the DAS server(iigcd) on the server
side ?
This is available r3/2006 so you probably need a comms only install of 2006
then vnode out from there to your target database.

Geoff

-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx
[mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx]On Behalf Of
kodaliece@xxxxxxxxx
Sent: Tuesday, March 20, 2007 10:38 AM
To: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] JDBC driver for Ingres 2.5


Hi
We are using the following code to connect:

private String connectString = "jdbc:edbc://10.118.131.214:117/";
private String vnode = "LOCAL";
private String user = "";
private String password = "";
private Connection con = null;
Class.forName("ca.edbc.jdbc.EdbcDriver");
con = DriverManager.getConnection(connectString + vnode, user,
password);

But this is throwing the error: Exception in thread "main"
java.sql.SQLException: Unable to establish connection
due to communications error.

Could you please tell what can be the problem?

On Mar 20, 2:45 pm, "jpzu...@xxxxxxxxx" <jpzu...@xxxxxxxxx> wrote:
On 20 mar, 10:33, kodali...@xxxxxxxxx wrote:

Hi,
Do we have any JDBC driver available for Ingres 2.5. If yes, can
anybody please post me the sample code for connecting to Ingres
database using this driver.

Thanks
Mohan

Hello,

Yes the JDBC driver is available for Ingres 2.5, and must be installed
and started from server side.

See in the documentation for 2.5 details but for Ingres2006 the URL
look like this : jdbc:ingres://host:port/[dbname|vnode::dbname/
server_class];attr=value

Hope this help,
Jean-Pierre


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


**********************************************************************

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.

If you have any queries, please contact the IT Service Desk on 1870
(01384-275454).

postmaster@xxxxxxxxxx

**********************************************************************
.

Relevant Pages

  • iigcn cpu usage / iilticket file growth
    ... Ingres issues and problems to resolve. ... stability and performance on a critical production server. ... in a nutshell: the gcn lticket queue file on ... Connection time become very slow, ...
    (comp.databases.ingres)
  • JDBC for sql server: delays experienced when using Connection.prepareCall()
    ... I have been doing some performance tests of the MS jdbc driver for sql ... sql server instance). ... prepareCall(on the same Connection) to generate a different ...
    (comp.lang.java.databases)
  • Re: JDBC driver doesnt close socket event after connection.close()
    ... It turns out the problem is with the initialization of the JDBC driver: ... This line was being executed each time a connection was made (every 10 ... This would account for so many open sockets to the ... MS/SQL server. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: [Info-Ingres] JDBC driver for Ingres 2.5
    ... have a database called "local" (Ingres is case-insensitive with database ... [Info-Ingres] JDBC driver for Ingres 2.5 ... java.sql.SQLException: Unable to establish connection ... Do we have any JDBC driver available for Ingres 2.5. ...
    (comp.databases.ingres)
  • RE: Class Not Found Exception
    ... in the sqlserver connection variable? ... If you are using the SQL Server 2005 version, ... I've downloaded and installed Microsoft's JDBC driver (it appeared to ... install okay). ...
    (microsoft.public.sqlserver.jdbcdriver)