java - Why is Hibernate adding schema name to Hsql functions? -


we have legacy app uses hibernate 3.0.3. unit testing hsqldb. 1 of queries generated hibernate looks this:

select  transactio0_.reason_id reason1_0_,  transactio0_.description descript2_93_0_,  transactio0_.reason_name reason3_93_0_  apps.mtl_transaction_reasons transactio0_  transactio0_.reason_id=54  , transactio0_.nvl (transactio0_.disable_date, now() + 1 day) > now()

note schema name "transactio0_" prepended nvl function. why? how can configure hibernate not that?

the next question deals version of hsqldb using. we're using hsqldb 2.2.8 , move hsqldb 2.3.2. above query works fine hsqldb 2.2.8 fails in hsqldb 2.3.2 "invalid schema name" error. there way can configure hsqldb 2.3.2 can execute query hsqldb 2.2.8 does?

the generated sql looks strange , incorrect sql. transactio0_ table alias , shouldn't prepended function name.

perhaps selected hibernate dialect not hsqldb dialect.

in case, old version of hibernate , needs used version of hsqldb closer time of release.

regarding configuring hsqldb accept malformed name, shouldn't possible original behavior fixed because lax , accepted incorrect sql.


-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

python 3.x - PyQt5 - Signal : pyqtSignal no method connect -

following example in doc found on sourceforge faced error. from pyqt5.qtcore import pyqtsignal, pyqtslot def setsignal(): signal = pyqtsignal() signal.connect(self.myaction) @qtcore.pyqtslot() def myaction(): print("signal triggered") results in attributeerror: 'pyqt5.qtcore.pyqtsignal' object has no attribute 'connect' as mentioned in docs linked, signal needs defined on class level: class foo(qobject): signal = pyqtsignal() def connectsignal(): self.signal.connect(self.myaction) @qtcore.pyqtslot() def myaction(): print("signal triggered")
Read more