> My problem is using JDBC(ODBC) in POSTGRESQL. My machine has Red Hat
>Linux 5.2. In the Howto Postgres document it is written that JDBC driver
>is supplied with this CD. I created Database and tabels using psql
>interactive prompt. Then I wrote one java program to access the tabels
>created before.
> The statements in the java program are:
> String url ="jdbc:postgres95:mydb?user=postgres&passwd=pass";
> String query="select * from emp;
>
Seems like you're using a very old Postgres distribution?
Normally I use this url:
jdbc:postgresql://host:5432/database
where 'host' is your postgres-database-server's name or ip-address and
'database' is your database name. On the server you have to have a running
postmaster listening on port 5432. Best thing to do is to download the
latest postgresql from www.postgresql.org in stead of using the very old
postgres95. For more information on the latest JDBC driver see
http://www.retep.org.uk/postgres/
You'll also find all the documentation you want there.
>(I have created emp tabel and it has also some rows inserted.)
>
>To load the driver the statement is
> Class.forName("postgress95.PGDriver");
Should be: postgresql.Driver
Regards
Wim Ceulemans - [EMAIL PROTECTED]
Nice Software Solutions - http://www.nice.be
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 412953 - Fax +32(0)15 412954
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
