Problem using PostgreSQL 9.0.4 with Java

[Arun Nadar <arun_rt@xxxxxxxxxxxxxx>]

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