[Info-Ingres] JDBC driver for Ingres 2.5

[Grant Croker]

Hi Mohan,

Try changing the port part of the URL from 117 to II7, an easy mistake
to make when using the default installation id. From there make sure you
have a database called "local" (Ingres is case-insensitive with database
names unless SQL-92 has been switched on).

Regards,

grant

> -----Original Message-----
> From: info-ingres-bounces at kettleriverconsulting.com
[mailto:info-ingres-
> bounces at kettleriverconsulting.com] On Behalf Of kodaliece at gmail.com
> Sent: 20 March 2007 11:38
> To: info-ingres at kettleriverconsulting.com
> 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... at gmail.com" <jpzu... at gmail.com> wrote:
> > On 20 mar, 10:33, kodali... at gmail.com 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 at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres