Re: Using JDBC

Hi Fernando,

I have already read this documents, because it came with PostgreSQL
documentation.

I would like to see a simple source code (and compile line) that open a
conection to the database, run a query and close the database.

I'm new with JDBC and examples are welcome.

These is the versions of the softwares I'm using:

Java: j2sdk-1.4.1
Ant: jakarta-ant-1.5.1
PostgreSQL: 7.3.1

This morning I tried to compile the following code (test.java):

// -- begin
/*
** pgdbping.java - programa para testar uma conexo jdbc com PostGRES
**
** Elielson - 24.07.2002
*/

   import java.sql.*;

    class pgdbping {
       public static void main(String args[]) {
         try {
            Class.forName("org.postgresql.Driver");
            Connection con;

            if ( args.length != 3 )
            {
               String
               url =
"jdbc:postgresql://192.168.1.5:5432/test", user = "postgres", password =
"123";

               System.out.println("Uso: java dbping URL user password");
               System.out.println("URL jdbc:postgresql://host:port/dbname");
               System.out.println("Vou usar conexao interna: " + url
                  + ", " + user + ", " + "*******");

               con = DriverManager.getConnection(url, user, password);
            }
            else
            {
               con = DriverManager.getConnection(args[0], args[1], args[2]);
            }
            System.out.println("Sucesso na conexo!!");
            con.close();
         }
             catch(Exception e) {
               System.out.println("Falha na conexao");
               e.printStackTrace();
            }
      }
   }
// -- end

$ java test.java
$ javac test.class
Exception in thread "main" java.lang.NoClassDefFoundError: test/class

Is this the right way to compile/run the source codes?
Any ideas??

Thanks in advance,
Regards,

Marcelo Pereira

-- Remember that only God and ^[:w saves.
        __
       (_.\           © Marcelo Pereira     |
        / / ___       marcelo@pereira.com   |
       / (_/ _ \__    [Math|99]-IMECC       |
_______\____/_\___)___Unicamp_______________/

--- Fernando Nasser, with his fast fingers, wrote:

:> Try:
:>
:> http://www.redhat.com/docs/manuals/database/RHDB-2.1-Manual/prog/jdbc.html
:>
:> Um abraco,
:> Fernando
:>
:> Marcelo Pereira wrote:> Hi All,
:> >
:> > I have been working to make PostgreSQL acessible from java. I have
:> > downloaded and instaled the following:
:> >
:> > - j2sdk-1_4_1_01-linux-i586.bin
:> > - jakarta-ant-1.5.1-src.tar.gz
:> >
:> > and compiled PostgreSQL as:
:> >
:> > # ./configure --with-java
:> > # make
:> > # make install
:> >
:> > The driver (postgresql.jar) was compiled properly, and I have configured
:> > some variables:
:> >
:> > # export CLASSPATH=/usr/local/pgsql/share/java/postgresql.jar:.
:> > # export ANT_HOME=/usr/local/ant
:> > # export JAVA_HOME=/usr/local/j2sdk1.4.1
:> > # export PATH=${JAVA_HOME}:${PATH}:${ANT_HOME}/bin
:> >
:> > So I think the environment is almost good, but I can't compile a source
:> > that use jdbc.
:> >
:> > Would you send to me a really simple example java source code using jdbc,
:> > acessing a simple table at PostgreSQL? I'm really having problem with
:> > this.
:> >
:> > Thanks in advance and
:> > Best Regards,
:> >
:> > Marcelo Pereira
:> >
:> > -- Remember that only God and ^[:w saves.
:> >         __
:> >        (_.\           © Marcelo Pereira     |
:> >         / / ___       marcelo@pereira.com   |
:> >        / (_/ _ \__    [Math|99]-IMECC       |
:> > _______\____/_\___)___Unicamp_______________/
:> >
:> >
:> > ---------------------------(end of broadcast)---------------------------
:> > TIP 2: you can get off all lists at once with the unregister command
:> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
:> >
:>
:>
:>
:> --
:> Fernando Nasser
:> Red Hat - Toronto                       E-Mail:  fnasser@redhat.com
:> 2323 Yonge Street, Suite #300
:> Toronto, Ontario   M4P 2C9
:>