Re: [JDBC] No Suitable Driver

[Dave Cramer]

You need to load the driver first and then get the connection, also the
url for the connection s/b

jdbc:postgresql://hostname/testuser=testpassword=test

Assuming your database name is test


So your code needs to execute 
Class.forName(org.postgresql.Driver)

And then
Connection db =
DriverManager.getConnection(jdbc:postgresql://hostname/testtest,test
);

Dave

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Guy McArthur
Sent: October 24, 2001 7:13 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] No Suitable Driver



Hi, I'm trying to get a small test program going. I have built
PostgreSQL 7.1.3 on RedHat 6.2 with --java, installed and created
databases, verified with psql. The postgresql.jar is on my classpath.

My pg_hba.conf has:
localall   password
host all 127.0.0.1 255.255.255.255 password

Here is my code:

import java.sql.*;

public class PostgresTest {
   public static void main(String[] args) {
 try {
  Connection db =
DriverManager.getConnection(jdbc.postgresql:testuser=testpassword=tes
t);
// I've also tried all the permutations of getConnection() and urls. //
db, user, and password names have been changed to protect the innocent
// I've also tried Class.forName(org.postgresql.Driver) and //
Class.forName(org.postgresql.Driver).newInstance() instead of the arg.
  db.close();
 } catch(Throwable t) {
 t.printStackTrace(System.out);
 }
   }
}

--
Running it with:

java -Djdbc.drivers=org.postgresql.Driver PostgresTest
where the db has been started by user postgres with:
/usr/local/pgsql/bin/postmaster -i -D /data/pgsql /data/pgsql/pgsql.log
21 

And the error is:

java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:199)
at PostgresTest.main(PostgresTest.java:6)


What is wrong?

--
Guy McArthur * email{[EMAIL PROTECTED]} http{guymcarthur.com}





---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [JDBC] no suitable driver

[Michael Stephenson]

 Then I changed the dbUrl string to:

   private static final String dbUrl =
 jdbc:postgresql//wetwang.ontko.com/demo;

 Any thoughts about what I've done wrong here?

This might not be the only problem, but your URL is missing a colon,
should be:

jdbc:postgresql://wetwang.ontko.com/demo

Michael xxx


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

RE: [JDBC] No suitable driver

[Skidmore, Walt]

Title: RE: [JDBC] No suitable driver





Try passing the driver in the command line, like this: java -Djdbc.drivers=org.postgresql.Driver ...


-Original Message-
From: Peter Mezzina [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 15, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] No suitable driver



I have Tomcat 3.2.1 and Postgres 7.0.3 running well in Solaris and I 
have installed the JDBC driver, jdbc7.0-1.2.jar, in both the 
TOMCAT_HOME/lib and a second directory off of the tomcat tree. With 
the jar file in the classpath the driver works fine from an application 
but produces the error No suitable driver when called from within a 
servlet. Having combed through the jdbc mailing list I have tried 
placing the jar file in the TOMCAT_HOME/lib (a restart of tomcat 
references the existence of the jar file in its output) and I have set 
the driver's path for wrapper.classpath in tomcat.properties for the 
parameter wrapper.classpath and set the driver name for 
wrapper.bin.parameters.


Is there anyone who might have some advise about whatelse needs to be 
done for this?



-Peter Mezzina
[EMAIL PROTECTED]



---(end of broadcast)---
TIP 6: Have you searched our list archives?


http://www.postgresql.org/search.mpl