Skip site navigation (1) Skip section navigation (2)

Re: Unable to make a connention through jdbc

From: Vernon <vwu725(at)yahoo(dot)com>
To: pg(at)fastcrypt(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Unable to make a connention through jdbc
Date: 2005-03-24 23:06:59
Message-ID: 20050324230700.31981.qmail@web40525.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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(at)fastcrypt(dot)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(at)fastcrypt(dot)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/ 

Responses

pgsql-jdbc by date

Next:From: David GagnonDate: 2005-03-24 23:30:17
Subject: plpgsql function with RETURNS SETOF refcursor AS. How to get it work via JDBC
Previous:From: Vadim NasardinovDate: 2005-03-24 21:40:15
Subject: CLOB encoding (was: Re: [Patch] JDBC3 Blob support)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group