[GENERAL] Problem using PostgreSQL 9.0.4 with Java

[Arun Nadar]

Hi


I am currently using 'PostgreSQL 
9.0.4' database with JDBC driver 'postgresql-9.0-801.jdbc4'. In my Java 
program normal SELECT query didn't work.
ie,  

try {
            Class.forName("org.postgresql.Driver");
            connection = 
DriverManager.getConnection("jdbc:postgresql://localhost/Student","postgres","postgres");
            statement = connection.createStatement();
            String sql="SELECT Id, Name FROM Student ORDER BY Id";     // 
problem

            resultSet = statement.executeQuery(sql);
            if(resultSet.next()) {
                String id=resultSet.getString(1);
                String name=resultSet.getString(2);
            }    
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
   
             connection.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }


I directly write a query via pgAdmin III the above SELECT query didn't work
{ SELECT Id, Name FROM Student ORDER BY Id; }


but it work by putting " ",  like this  SELECT "Id", "Name" FROM "Student" 
ORDER BY "Id";

in java String,  inside of double inverted commas another is does not possible. 


how this code is implement through java program. please kindly send me the 
solution for this.
 
Thanks & Regards
Arun.R.T