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: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
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


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-2017 The PostgreSQL Global Development Group