Reg : Exception ( Postgresql with Java -JDBC)

From: smitha <smitha_alice_c(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Reg : Exception ( Postgresql with Java -JDBC)
Date: 2005-11-23 08:27:44
Message-ID: 20051123082744.40705.qmail@web60224.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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";

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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Achilleus Mantzios 2005-11-23 09:16:37 Re: Reg : Exception in Postgresql with Java
Previous Message smitha 2005-11-23 08:08:45 Reg : Exception in Postgresql with Java