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!
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 |