Re: Help + Postgresql 7.22

Pierre,

The problem is the url

it should be "jdbc:postgresql://localhost/MUSICS"

Dave
On Sun, 2002-12-29 at 14:21, Pierre Routens wrote:
> Please take my join piece.
>
>
> Pierre.
>
> ___________________________________________________________
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
>
> ______________________________________________________________________
>
> Hello, I have a problem with my connection jdbc.
>
> My conf is :
>
> PC Linux Mandrake 9.0 - 256 Ram - Video GForce 200Mx etc..
>
> Installed: j2sdk1.4.1.01,postgresql 7.2.2 and driver jdbc : pg72jdbc2.jar
>
> **********************************************************************************************
> My error message : The error msg generated at getConnect is No suitable driver
> Erreur durant la creation de la table : java.lang.NullPointerException
> java.lang.NullPointerException
> at Connecting.creerTable(Connecting.java:33)
> at Connecting.<init>(Connecting.java:23)
> at MP3.main(MP3.java:10)
> ***********************************************************************************************
>
> My compilation :
>
> javac -classpath /home/xarius/tmp/bd/pg72jdbc2.jar /home/xarius/tmp/bd/*.java
>
> My Executable :
>
> java -cp /home/xarius/tmp/bd/pg72jdbc2.jar:/home/xarius/tmp/bd MP3
>
>
> My code :
>
> //! Class Connecting
> import java.sql.*;
> import java.io.*;
> import java.io.BufferedInputStream;
>
> class Connecting
> {
> protected Connection connectionBD;
> public Connection getConnectionBD()
> {
> return this.connectionBD;
> }
>
> public void setConnectionBD(Connection connection)
> {
> this.connectionBD = connection;
> }
>
> public Connecting()
> {
> ConnecterBaseDeDonnees cbdd = new ConnecterBaseDeDonnees();
> setConnectionBD(cbdd.connection());
>
> creerTable();
> //insererImage();
> //insererBLOB();
> //readGetBLOB() ;
> }
>
> public void creerTable()
> {
> try
> {
> Statement stmnt = getConnectionBD().createStatement();
> stmnt.executeUpdate( "CREATE TABLE test (ident int)" );
>
> }
> catch(Exception ex)
> {
> System.out.println("Erreur durant la creation de la table : " + ex);
> ex.printStackTrace(System.out);
> }
> }
> }
>
> /********************************************************************************/
> /********************************************************************************/
>
> //! Class ConnecterBaseDeDonnees
>
> import java.sql.*;
>
> class ConnecterBaseDeDonnees
> {
> public ConnecterBaseDeDonnees()
> {
> }
>
> public Connection connection()
> {
> Connection con = null;
> try
> //! Pour PostgreSQL
> Class.forName("org.postgresql.Driver");
> String url = "jdbc:postgresql://localhost:127.0.0.1/MUSICS";
> con = DriverManager.getConnection( url,"","" );
> }
> catch ( SQLException ex)
> {
> System.err.println(" Message genere " + ex.getMessage());
> }
> catch ( ClassNotFoundException es)
> {
> System.err.println("Class non trouvee " + es.getMessage());
> }
> return con;
> }
> }
>
> /********************************************************************************/
> /********************************************************************************/
>
> //! Class MP3
>
> import java.sql.*;
> import java.io.*;
>
> class MP3
> {
> public static void main(String[] args) throws SQLException
> {
> try
> {
> Connecting connect = new Connecting();
> }
> catch(Exception ex)
> {
> System.out.println("Main erreur :"+ex);
> }
> }
> }
>
>
> Even with the documention and the forum , I have always the same problem. Please can you help me.
>
> Excuse me for my bad english, I am French.
>
> Thank you for yor help.
>
> Pierre.
>
>
>
>
> ______________________________________________________________________
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Dave Cramer <davec(at)fastcrypt(dot)com>
Cramer Consulting
--
Dave Cramer <Dave(at)micro-automation(dot)net>