Re: Switching user within connection.

smitha wrote:

> Hi Rob !!
>
>          Just now I got ur Query.  I will check it. I have doubt. If
> You know the answer for this Please reply to me. I am breaking my head
> to solve this.
>
> 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)
>     {
>         //Ge t 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");
>
>            }
> }
>
> *

(Correct top post - also please don't email off list)

I use the following syntax :

create user 'username' encrypted password 'password'

It works ok for me providing I don't try and use a prepared statement -
it doesn't seem to translate the $1 correctly in the username.

Rob