Hope yr all having more fun than me.
Im working with Hibernate and Ingres, have had no trouble 'saving' my
objects, but am having endless trouble getting them back again. I have
implemented a 'table per class' strategy, which when retreiving involves a
couple of inner joins. This creates a (what im told is anyways) rather
large sql statement, some 670 characters long. Which Ingres won't seem to
accept because its to long, at least thats the current theory.
So my question is.....
Does Ingres have an upper limit for the size of a single SQL statement?
and if so...
Can this limit be changed?
Heres the sql in question
select earlywarni0_.EarlyWarningID as UID0_, earlywarni0_2_.critical as
critical0_, earlywarni0_2_.corePoolSize as corePool3_0_,
earlywarni0_2_.keepAliveTime as keepAliv4_0_,
earlywarni0_2_.maximumPoolSize as maximumP5_0_, earlywarni0_2_.queueSize
as queueSize0_, earlywarni0_2_.jndiName as jndiName0_, earlywarni0_1_.host
as host5_, earlywarni0_1_.interval as interval5_, earlywarni0_1_.port as
port5_, earlywarni0_1_.reciever as reciever5_ from EarlyWarning
earlywarni0_ inner join WebBasedProcessors earlywarni0_1_ on
earlywarni0_.EarlyWarningID=earlywarni0_1_.WebBased_ID inner join
ProcessingService earlywarni0_2_ on
Any answers/critque or funny jokes wld be welcome at this stage.
Archived post - originally posted at 2005-12-19 10:43:49