Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group