Re: Unable to make a connention through jdbc - Mailing list pgsql-jdbc

From Vernon
Subject Re: Unable to make a connention through jdbc
Date
Msg-id 20050324230700.31981.qmail@web40525.mail.yahoo.com
Whole thread Raw
In response to Unable to make a connention through jdbc  (Vernon <vwu725@yahoo.com>)
Responses Re: Unable to make a connention through jdbc
List pgsql-jdbc
Hi, Dave,

I already tried all the three drivers under the
8.0/jdbc directry and get the same error message. Can
you provide a URL of the documentation in regarding of
the difference among the three drivers.

I will change the server character configuration to
overcome this problem. I had a typo in my email of the
IP address.

Thanks a lot for your promptly helps.

Vernon

--- Dave Cramer <pg@fastcrypt.com> wrote:
> Try your other one again, and fix the ip address.
>
> these are two different errors.
>
> dave
>
> Vernon wrote:
>
> >I find out that problem is about the driver
> >configuration. I install another Java DB client
> >DbVisualizer 4.2.2 and configure the driver by
> >selecting one of three drivers (why three? anyone
> >would be fine?), I get the error which I only get a
> >warming in a comman prompt:
> >
> >org.postgresql.util.PSQLException: Backend start-up
> >failed: FATAL: conversion between UNICODE and
> >MULE_INTERNAL is not supported.
> >    at
>
>org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:443)
> >    at
>
>org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:98)
> >    at
>
>org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
> >    at
>
>org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:117)
> >    at
>
>org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.java:24)
> >    at org.postgresql.Driver.connect(Driver.java:195)
> >    at
>
>java.sql.DriverManager.getConnection(DriverManager.java:525)
> >    at
>
>java.sql.DriverManager.getConnection(DriverManager.java:140)
> >    at
>
>com.onseven.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:40)
> >    at
> com.onseven.dbvis.sql.Database.doConnect(Unknown
> >Source)
> >    at
> com.onseven.dbvis.sql.Database.access$000(Unknown
> >Source)
> >    at
>
>com.onseven.dbvis.sql.Database$ConnectionCommand.execute(Unknown
> >Source)
> >    at
>
>se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:163)
> >    at
>
>se.pureit.util.ThreadCommand.run(ThreadCommand.java:143)
> >    at java.lang.Thread.run(Thread.java:595)
> >
> >--- Dave Cramer <pg@fastcrypt.com> wrote:
> >
> >
> >>Ya have to give us more than that, stack trace ?
> My
> >>obi-wan-kanobi wand
> >>seems not to be working
> >>
> >>--dc--
> >>
> >>Vernon wrote:
> >>
> >>
> >>
> >>>After installed the Window version of PG 8.0.1, I
> >>>
> >>>
> >>am
> >>
> >>
> >>>able to access the server through both the
> command
> >>>prompt and the pgAdmin III. I, however, am not
> able
> >>>
> >>>
> >>to
> >>
> >>
> >>>get the access through either Eclipse and Aqua
> Data
> >>>Studio with jdbc. In the Eclipse, I have
> >>>
> >>>Database type - jdbc
> >>>Data source URL -
> >>>jdbc:postgresql://127.0.0.1:5432/template1
> >>>
> >>>The error message says that the settings are not
> >>>right.
> >>>
> >>>I check a few times and can't see any wrong with
> my
> >>>connection setting.
> >>>
> >>>Any idea?
> >>>
> >>>Thanks,
> >>>
> >>>Vernon
> >>>
> >>>
> >>>
> >>>__________________________________
> >>>Do you Yahoo!?
> >>>Yahoo! Small Business - Try our new resources
> site!
> >>>http://smallbusiness.yahoo.com/resources/
> >>>
> >>>---------------------------(end of
> >>>
> >>>
> >>broadcast)---------------------------
> >>
> >>
> >>>TIP 5: Have you checked our extensive FAQ?
> >>>
> >>>              http://www.postgresql.org/docs/faq
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>--
> >>Dave Cramer
> >>http://www.postgresintl.com
> >>519 939 0336
> >>ICQ#14675561
> >>
> >>
> >>
> >>
> >
> >
> >
> >__________________________________
> >Do you Yahoo!?
> >Yahoo! Small Business - Try our new resources site!
> >http://smallbusiness.yahoo.com/resources/
> >
> >
> >
> >
>
> --
> Dave Cramer
> http://www.postgresintl.com
> 519 939 0336
> ICQ#14675561
>
>



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

pgsql-jdbc by date:

Previous
From: Vadim Nasardinov
Date:
Subject: CLOB encoding (was: Re: [Patch] JDBC3 Blob support)
Next
From: David Gagnon
Date:
Subject: plpgsql function with RETURNS SETOF refcursor AS. How to get it work via JDBC