Thread: Unable to make a connention through jdbc

Unable to make a connention through jdbc

From
Vernon
Date:
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/

Re: Unable to make a connention through jdbc

From
Dave Cramer
Date:
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


Re: Unable to make a connention through jdbc

From
Vernon
Date:
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/

Re: Unable to make a connention through jdbc

From
Kris Jurka
Date:

On Thu, 24 Mar 2005, Vernon wrote:

> 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.

Directly on the download page, it's all about the JVM version:

http://jdbc.postgresql.org/download.html#jdbcselection

Kris Jurka