Problem using PostgreSQL 9.0.4 with Java

Поиск
Список
Период
Сортировка
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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: checkpoint logs
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Problem using PostgreSQL 9.0.4 with Java