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

Problem with Running Query

From: Bellur Ashwin <bell_ashwin(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem with Running Query
Date: 2007-04-06 16:57:12
Message-ID: 195732.49845.qm@web50604.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,
I have modified my postgres code to accept queries starting with a word "My" followed by the query followed by the 1000 #separated values,
inside postgres, i check for the word "My" at the beginning of the query if found, i will generate 1000 inserts into a table (these 1000 values are those i have sent after the query with the delimiter #), then execute the query which is in between "My" and #values,

Example: My query would look like this

My select * from xyz1 a, xyz2 b where a.a1=b.a1 #1#2#3...........

Now my problem is when i try to send the new (appended) query to the JDBC, i get
ArrayIndexOutOfBoundException: Index: 1 Size: 1 
from the executeQuery function, here my query is reaching the postgres and is executing, but i am getting the exception in my JAVA Program 

Any Idea of why i am getting the exception.



With Regards,
Bellur Ashwin




		
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/

Responses

pgsql-jdbc by date

Next:From: Thor-Michael StøreDate: 2007-04-09 15:52:18
Subject: Pg JDBC 3 driver, JDK 1.6, Glassfish v2 incompatability
Previous:From: Albe LaurenzDate: 2007-04-06 07:39:04
Subject: Re: Encoding issue (utf8): different strings received from java than from PGAdmin

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