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