java - JPA Hibernate HSQLDB - VARBINARY() field and error attempting to select -

-

i found similar question @ hsqldb: duplicate column name, unsupported internal operation: type, invalid character cast, there no intelligible answer. looked @ http://old.nabble.com/unsupported-internal-operation%3a-statementdmql-td27427172.html reports issue bug in hsqldb, should fixed in version using (2.2). so, here's details of problem:

i have entity stores byte[] data in varbinary(128) field inside of hsqldb. table created successfully, when try select table, following stack trace:

java.sql.sqlexception: java.lang.runtimeexception: unsupported internal operation: type java.lang.runtimeexception: unsupported internal operation: type     @ org.hsqldb.jdbc.util.sqlexception(unknown source)     @ org.hsqldb.jdbc.util.sqlexception(unknown source)     @ org.hsqldb.jdbc.jdbcpreparedstatement.fetchresult(unknown source)     @ org.hsqldb.jdbc.jdbcpreparedstatement.executequery(unknown source)     @ com.mchange.v2.c3p0.impl.newproxypreparedstatement.executequery(newproxypreparedstatement.java:76)     @ org.hibernate.jdbc.abstractbatcher.getresultset(abstractbatcher.java:208)     @ org.hibernate.loader.loader.getresultset(loader.java:1953)     @ org.hibernate.loader.loader.doquery(loader.java:802)     @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:274)     @ org.hibernate.loader.loader.dolist(loader.java:2533)     @ org.hibernate.loader.loader.listignorequerycache(loader.java:2276)     @ org.hibernate.loader.loader.list(loader.java:2271)     @ org.hibernate.loader.hql.queryloader.list(queryloader.java:452)     @ org.hibernate.hql.ast.querytranslatorimpl.list(querytranslatorimpl.java:363)     @ org.hibernate.engine.query.hqlqueryplan.performlist(hqlqueryplan.java:196)     @ org.hibernate.impl.sessionimpl.list(sessionimpl.java:1268)     @ org.hibernate.impl.queryimpl.list(queryimpl.java:102)     @ org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:274)     @ com.dns.recursive.ipcache.data.cachewrapper.findentry(cachewrapper.java:206)     @ com.dns.recursive.ipcache.net.tcpworker.run(tcpworker.java:114)     @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1110)     @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:603)     @ java.lang.thread.run(thread.java:636) caused by: org.hsqldb.hsqlexception: java.lang.runtimeexception: unsupported internal operation: type     @ org.hsqldb.error.error.error(unknown source)     @ org.hsqldb.result.result.newerrorresult(unknown source)     @ org.hsqldb.statementdmql.execute(unknown source)     @ org.hsqldb.session.executecompiledstatement(unknown source)     @ org.hsqldb.session.execute(unknown source)     ... 21 more caused by: java.lang.runtimeexception: unsupported internal operation: type     @ org.hsqldb.error.error.runtimeerror(unknown source)     @ org.hsqldb.types.type.subtract(unknown source)     @ org.hsqldb.expressionarithmetic.getvalue(unknown source)     @ org.hsqldb.expressionorderby.getvalue(unknown source)     @ org.hsqldb.queryspecification.buildresult(unknown source)     @ org.hsqldb.queryspecification.getsingleresult(unknown source)     @ org.hsqldb.queryspecification.getresult(unknown source)     @ org.hsqldb.statementquery.getresult(unknown source)     ... 24 more

i use in figuring out cause of this. in advance!!

unsupported internal operation generic error reports class in error occured. low-level line of defence against errors. sql error caught , reported before type of error occurs. in case not caught. other exception reports same error string may totally unrelated.

you need report create table statement , select statement runs against it.

the stack trace indicates there order clause includes order - b or b not numbers.


Comments

Post a Comment

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

-
my group , running server based upon django , uses mod_wsgi run apache server. not working on project after over, attempting set cronjob similar functionality check if apache server has shut down(system restart or power failure), , if has, restart server me. i've found documentation on how check if apache server down , restart server if is, our server uses https , our start command pretty verbose. can use functionality provided in these examples: https://askubuntu.com/questions/277389/cron-job-to-restart-apache https://www.digitalocean.com/community/tutorials/how-to-use-a-simple-bash-script-to-restart-server-programs or need more complicated process make happen? the command use start server is python manage.py runmodwsgi --host 0.0.0.0 --port 8001 --https-port 8000 --ssl-certificate (certificate location) --server-name (domain name) i'm pretty new linux , using both mod-wsgi apache appreciated. you better off using --setup-only option mod_wsgi-expres...
Read more

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines. ...
Read more

jQuery Ajax Render Fragments OR Whole Page -

-
i'm in throes of building application wraps mess of legacy code. page working on, need substitute fragment divs constructed on back-end -- or else need replace entire page altogether. idea there dynamically controlled flow needs satisfied before can forward legacy product. substituting fragments works fine, seen in below my_body_content swap. trouble comes when i'm trying render not fragment, whole page, in "body" swap. @ point page goes blank. i want similar errors returned server. want nice rest 404 error messages displayed on screen, legacy-product 404s show in legacy-product 404 page. yes, requirements project weird. that's not problem can fix. here's jquery invocation, names changed protect guilty: $.ajax({ url: "places/things", type: "post", data: json.stringify(somebadassobject), datatype: "text", accepts: "text/html", contenttype: "application/json; charset=...
Read more