Hi Eric,
Looking at the JDBC specification, I am guessing preparedStatement.setArray and using Array interface can do the trick. But, setArray is unsupported feature in Trafodion jdbc drivers. Selva ________________________________ From: Eric Owhadi <eric.owh...@esgyn.com> Sent: Tuesday, January 17, 2017 12:08 PM To: user@trafodion.incubator.apache.org Subject: question on using Batch for a select statement with jdbc Hi Trafodioneers, Have following jdbc question: select x.a, d.a from (values (?,?,?,?)) as x(a,b,c,d) join directories d on x.b = d.b and x.c= d.c and x.d = d.d; I was thinking of using Batch to fill the list of values, but then I struggle with how to invoke the query. executeBatch does not return a resultSet, as I guess it is used for upsert or inserts? Can I use executeQuery(), and that will do the trick as long as I use addBacth()? Or it is not possible to use addBatch for this use model? Thanks in advance for the help, Eric
