Re: simple insert operation - Mailing list pgsql-jdbc

Aydin,

You're obviously beginner at Java too :-)

The problem has nothing to do with JDBC, you must catch the Java
exceptions which are declared to be thrown by the methods you use (the
compilation error message is quite explicit about which ones), or
declare them to be thrown by your code. Look up some Java tutorial,
and/or use an intelligent IDE which highlights you the errors and
possibly fixes them too automatically... IntelliJ is a good one (not
free).

Other than that, from a superficial check, I guess your code is Ok.

Cheers,
Csaba.

On Thu, 2005-09-08 at 09:58, Aydın Toprak wrote:
> 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...
>
>         Class.forName("org.postgresql.Driver");
>         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();
>
> but I cant compile it
>
> the errors
>
> -------------------------------------------------------------------------------------------
> form.java:26: unreported exception java.lang.ClassNotFoundException;
> must be cau
> ght 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