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.
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 |