Unable to prepare a statement when the object names contain more than one $ symbol

From: Altaf Malik <mmalik_altaf(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Unable to prepare a statement when the object names contain more than one $ symbol
Date: 2007-07-09 11:58:27
Message-ID: 540504.87872.qm@web39103.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi All,
I have a table with two columns of type varchar and the table name contains two dollars. I am unable to prepare a statement for this table. Here is the code:

con.createStatement().executeUpdate("create table a$b$c(a varchar, b varchar)");
PreparedStatement pstmt = con.prepareStatement("insert into a$b$c values( ? , ?)");
pstmt.setString(1,"Hello");
pstmt.setString(2,"Welcome");
pstmt.execute();

This code throws the following exception.
Exception in thread "main" org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:52)
at org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:117)
at org.postgresql.jdbc2.AbstractJdbc2Statement.bindString(AbstractJdbc2Statement.java:2118)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1241)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1227)
at Main.main(Main.java:33)

How can i insert values in this table using PreparedStatement?

--Altaf Malik


---------------------------------
Shape Yahoo! in your own image. Join our Network Research Panel today!

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message student23 2007-07-09 12:29:41 stddev_pop, stddev_samp strange behaviour
Previous Message Marek Lewczuk 2007-07-09 09:00:24 Re: patch - support for multi-dimensional arrays and NULL values