pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem with driver
2+ messages / 2 participants
[nested] [flat]
* problem with driver
@ 2000-10-16 07:47 Davis <davis@elixirtech.com>
0 siblings, 0 replies; 2+ messages in thread
From: Davis @ 2000-10-16 07:47 UTC (permalink / raw)
To: pgsql-interfaces
Hi all,
I am very new to postgresql. I am working in linux machine and I have
builtin postgres server version 6.5.2. I am able to play around with sql
through command line. But When I tried to connect through my java
application it thowing SQLexception saying no suitable driver. I tested
with both "org.postgresql.Driver" and "postgresql.Driver" including
"postgresql.jar "driver file and "jdbc6.5-1.2.jar" driver files.
somebody please help me saying which Driver we need to use to connect to
the above server. Or please let me know how to solve this particular
problem. Any commands in this issue is welcome. Your interest in this
regard is hihgly appreciated.
Thanks in advance
Davis
^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: problem with driver
@ 2000-10-17 09:53 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Mount @ 2000-10-17 09:53 UTC (permalink / raw)
To: 'Davis' <davis@elixirtech.com>; pgsql-interfaces
Ok, no such driver means that either you are not loading the driver, or
theres a syntax error in the jdbc url you are providing.
1: Load the driver. For pre 7.0 backends, the driver class is
postgresql.Driver whereas for 7.0 and later its org.postgresql.Driver
You have several methods of loading it. For java applications you can use
the
-Djdbc.drivers=postgresql.Driver
parameter to java, or the line:
Class.forName("postgresql.Driver");
2: The JDBC url MUST begin with jdbc:postgresql:
ie: jdbc:postgresql:test for local db's
jdbc:postgresql://host/database for remote databases
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council
-----Original Message-----
From: Davis [mailto:davis@elixirtech.com]
Sent: Monday, October 16, 2000 8:47 AM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] problem with driver
Hi all,
I am very new to postgresql. I am working in linux machine and I have
builtin postgres server version 6.5.2. I am able to play around with sql
through command line. But When I tried to connect through my java
application it thowing SQLexception saying no suitable driver. I tested
with both "org.postgresql.Driver" and "postgresql.Driver" including
"postgresql.jar "driver file and "jdbc6.5-1.2.jar" driver files.
somebody please help me saying which Driver we need to use to connect to
the above server. Or please let me know how to solve this particular
problem. Any commands in this issue is welcome. Your interest in this
regard is hihgly appreciated.
Thanks in advance
Davis
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-10-17 09:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-16 07:47 problem with driver Davis <davis@elixirtech.com>
2000-10-17 09:53 RE: problem with driver Peter Mount <petermount@maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox