PostgreSQL JDBC - Reg : Exception ( Postgresql with Java -JDBC)

Author

Reg : Exception ( Postgresql with Java -JDBC)

smitha

2005-11-23, 7:24 am

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 (ClassNotFoundExcept
ion 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.

Oliver Jowett

2005-11-23, 7:24 am

smitha wrote:

> &nb sp; String query1 = "CREATE user " + logName + " with password '"
> + passwd + "' createuser";
> ResultSet rs= st. executeQuery(query1)
;

CREATE USER does not return a resultset, so you should use
executeUpdate() or execute(), not executeQuery(). See the JDBC javadoc.

-O

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links