Re: [GENERAL] Problem using PostgreSQL 9.0.4 with Java

2011-09-07 Thread David Johnston
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Arun Nadar Sent: Wednesday, September 07, 2011 4:45 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Problem using PostgreSQL 9.0.4 with Java Hi but it work by putting " ",

Re: [GENERAL] Problem using PostgreSQL 9.0.4 with Java

2011-09-07 Thread John R Pierce
On 09/07/11 1:45 PM, Arun Nadar wrote: 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. String sql="SELECT \"Id\", \"Name\" FROM \"Student\" ORDER BY \"Id\""; Alternate

Re: [GENERAL] Problem using PostgreSQL 9.0.4 with Java

2011-09-07 Thread Tomas Vondra
On 7 Září 2011, 22:45, Arun Nadar wrote: > 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 =

[GENERAL] Problem using PostgreSQL 9.0.4 with Java

2011-09-07 Thread 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://localhos