From: | "McCaffity, Ray (Contractor)" <McCaffityR(at)epg(dot)lewis(dot)army(dot)mil> |
---|---|
To: | 'zze-Synchro ball001 exterieur FTRD' <synchro(dot)ball001(at)rd(dot)francetelecom(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Connexion with jdbc |
Date: | 2002-06-05 14:57:08 |
Message-ID: | 9669B05099E9D411B6E400B0D0AA476C5C3872@epg.lewis.army.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm using jdbc with 7.2.1 and it works great. (j2sdk 1.4.0 on Solaris and
Linux 2.4.18)
I've also used this pre-compiled one with no problems.
http://jxdbcon.sourceforge.net/download
<http://jxdbcon.sourceforge.net/download>
my connect string is jdbc:postgresql://serverName/dbName Perhaps leaving
out the port number would shorten it.
But then it might not know how to find it?
-----Original Message-----
From: zze-Synchro ball001 exterieur FTRD
[mailto:synchro(dot)ball001(at)rd(dot)francetelecom(dot)com]
Sent: Tuesday, June 04, 2002 6:32 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Connexion with jdbc
Hello,
I have try to connect to my database using the org.postgresql.Driver (the
last stable release) but it does not work. The logfile on postgresql server
says that the function pg_encoding_to_char does not exist.
From what I have read, this is due to a problem of version (I'm using the
6.5.3).
I wanted to use the sun.jdbc.odbc.JdbcOdbcDriver to connect instead.
However, I have the following error:
* If I try to connect to "jdbc:odbc://myServerUrl/myDatabaseName" : The
datasource cannot be found and pilote name is not specified
* If I try to connect to "jdbc:odbc://myServerUrl:5432/myDatabaseName": Data
source name too long! ( it's 29 characters)
Note:
* I'm using jdk1.3.1_03
* My postmaster is running with the -i option.
* I have added the client ip address to the pg_hba.conf file.
* I can connect without problem on a mySql database on the same server
Could anyone help me?
Thanks a lot
Tanguy
ps: I have another server running postgresql on another network. From a
computer on the same network the one I'm using, I can connect to a db on
this server with "jdbc:odbc:databasename", but not from the computer i'm
using. I found strange that I do not have to give a url for the database. If
anyone could give me a reason... Thanks a lot.
From | Date | Subject | |
---|---|---|---|
Next Message | tony | 2002-06-05 15:14:10 | need magic formula for euro conversion |
Previous Message | Oleg Bartunov | 2002-06-05 14:53:29 | Re: Insight into indexes? (or inverting then externally) |