Re: simple insert operation - Mailing list pgsql-jdbc

Hi,

The problem is that you never catch exceptions, specifically
SQLException. It is more a Java problem that a PostgreSQL problem. Maybe
you should read a little more about Java.

http://java.sun.com/docs/books/tutorial/essential/exceptions/index.html

Look at the modified code below.

Besides, it doesn't make sense to use PreparedStatement if don't use any
variable inside.

Regards,
Diego.

El jue, 08-09-2005 a las 10:58 +0300, Aydın Toprak escribió:
> Hii guys,
>
> I am very newbie about postgresql and I am making practice,
> however I couldnt been able to insert a simple item to my DB via jdbc...
>
>
> here is my code  for insertion...
>
try {
>         Class.forName("org.postgresql.Driver");
} catch (java.lang.ClassNotFoundException nfe) {
    nfe.printStackTrace();
}

try {
>         String connectionStr = "jdbc:postgresql://localhost:5432/XXXX";
>         Connection connection =
> java.sql.DriverManager.getConnection(connectionStr, "XXXX", "XXXX");
>         String sqlQuery = "INSERT INTO passTable (idCol , pass) VALUES
> (3, 5)";
>         PreparedStatement query = connection.prepareStatement(sqlQuery);
>         query.executeUpdate();
>         connection.close();

} catch (java.sql.SQLException se) {
    se.printStackTrace();
}

>
> but I cant compile it
>
> the errors
>
> -------------------------------------------------------------------------------------------
> form.java:26: unreported exception java.lang.ClassNotFoundException;
> must be caught or declared to be thrown
>                 Class.forName("org.postgresql.Driver");
>                              ^
> form.java:28: unreported exception java.sql.SQLException; must be caught
> or decl
> ared to be thrown
>                 Connection connection =
> java.sql.DriverManager.getConnection(con
> nectionStr, "XXXX", "XXXX");
>
> ^
> form.java:30: unreported exception java.sql.SQLException; must be caught
> or decl
> ared to be thrown
>                 PreparedStatement query =
> connection.prepareStatement(sqlQuery);
>
>                                                                      ^
> form.java:31: unreported exception java.sql.SQLException; must be caught
> or decl
> ared to be thrown
>                 query.executeUpdate();
>                                    ^
> form.java:32: unreported exception java.sql.SQLException; must be caught
> or decl
> ared to be thrown
>                 connection.close();
>                                 ^
> 5 errors
> -------------------------------------------------------------------------------------------
>
> what is the problem I am stuck with it..
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>