Reg : Exception ( Postgresql with Java -JDBC) - Mailing list pgsql-jdbc

From smitha
Subject Reg : Exception ( Postgresql with Java -JDBC)
Date
Msg-id 20051123082744.40705.qmail@web60224.mail.yahoo.com
Whole thread Raw
Responses Re: Reg : Exception ( Postgresql with Java -JDBC)  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
 This is my Java Program.  I get connected with the Postgresql Database and the query get executed and it affects in the Database.....A new user is created in the Database.. But i am getting the Exception "No result were returned by the query"  what could be the reason.....Plz tell me


// .java - example connection to a Postgresql (Database)

import java.io.*;
import java.sql.*;

public class connect
{
    public static String villageName = null;
    public static final boolean DEBUG = false;

    public static void main (String[] args)
    {
        //Get a Connection to Postgres
        try
        {
            Class.forName("org.postgresql.Driver");
        }
        catch (ClassNotFoundException e)
        {
            System.err.println( "Driver not found: " + e + "\n" + e.getMessage() );
        }
        try
        {
            String url="jdbc:postgresql://10.163.2.95:5432/collabland";
            Connection con=DriverManager.getConnection(url,"postgres","postgres");
            Statement st=con.createStatement();
 
    String logName = "kala";
    String passwd = "kala";
   
  &nb sp; String  query1 = "CREATE user " + logName + " with password '" + passwd + "' createuser";
            ResultSet rs= st.executeQuery(query1);
       System.out.println(query1);
       System.out.println("user created");
        }
        catch (SQLException sqlex)
            {
                if (DEBUG) sqlex.printStackTrace();
               System.out.println(sqlex.getMessage());
             //  return false;
            }
               System.out.println("after catch block");

           }
}


Yahoo! FareChase - Search multiple travel sites in one click.

pgsql-jdbc by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Reg : Exception in Postgresql with Java
Next
From: Rob Kirkbride
Date:
Subject: Switching user within connection.