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 retu
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
Sent: Tuesday, January 17, 2017 12:08 P
Hi Selva
I came across this to and believe that setArray is to support SQL Array type
that we don't support anyway.
Eric
From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
Sent: Tuesday, January 17, 2017 2:46 PM
To: user@trafodion.incubator.apache.org
Subject: Re: question on using Ba
Trying this workaround but hitting a timeout exception at prepare time:
final static String missingVal1 = "select x.a, d.a from (values ";
final static String missingValVar = "(?,?,?,?)";
final static String missingIVal2 = ") as x(a,b,c,d) join d on x.b = d.b and x.c
= d.c and x.d = d.d where x.a
Hi Eric,
I don't there is a generic CQD here. If there was a core file and we
analyzed it we might be able to find something specific to this situation.
Can we please try with say 1000 values and 4000 parameters?
Thanks
Suresh
On Tue, Jan 17, 2017 at 4:53 PM, Eric Owhadi wrote:
> Trying this w
Hi Suresh,
Good thought, I actually did exactly what you said:
1000 -> 1.8 sec compile
2000: 6.8 sec
4000: 28.3 sec.
All plan generate tuple list, and not unpack nodes. Suspecting some recursive
call, non linear scalable linked with tuple list handling, and associated stack
overflow common probl