java - Create table with native SQL works for Hibernate/HSQLDB, insert fails. Why? -

-

i use hsqldb , hibernate. have implement functionality on database level (trigger ...) , because of have execute native sql. create new table (works) , try insert data (fails). sa such there should no access right violation. can guess why user lacks privilege or object not found: a492interface thrown?

this code (simplified):

session.createsqlquery("create table entity_table_map (entity_name varchar(50) not null primary key,table_name varchar(50) not null)").executeupdate(); session.createsqlquery("insert entity_table_map (entity_name,table_name) values (\"a429interface\",\"interface\")").executeupdate();

here relevant log:

[server@19616c7]: 0:sqlcli:sqlprepare create table entity_table_map (entity_name varchar(50) not null primary key,table_name varchar(50) not null) [server@19616c7]: 0:sqlcli:sqlexecute:5 [server@19616c7]: 0:sqlcli:sqlfreestmt:5 [server@19616c7]: 0:hsqlcli:getsessionattr [server@19616c7]: 0:sqlcli:sqlprepare insert entity_table_map (entity_name,table_name) values ("a492interface","interface") [server@19616c7]: [thread[hsqldb connection @13adc56,5,hsqldb connections @19616c7]]: 0:disconnected sa

and here exception:

exception in thread "main" org.hibernate.exception.sqlgrammarexception: not execute native bulk manipulation query     @ org.hibernate.exception.sqlstateconverter.convert(sqlstateconverter.java:92)     @ org.hibernate.exception.jdbcexceptionhelper.convert(jdbcexceptionhelper.java:66)     @ org.hibernate.engine.query.nativesqlqueryplan.performexecuteupdate(nativesqlqueryplan.java:219)     @ org.hibernate.impl.sessionimpl.executenativeupdate(sessionimpl.java:1310)     @ org.hibernate.impl.sqlqueryimpl.executeupdate(sqlqueryimpl.java:396)     @ version.api.versionapi.setupdatabase(versionapi.java:38)     @ test.ui.versionui.setupdatabase(versionui.java:107)     @ test.setupdatabase.main(setupdatabase.java:9) caused by: java.sql.sqlsyntaxerrorexception: user lacks privilege or object not found: a492interface     @ org.hsqldb.jdbc.util.sqlexception(unknown source)     @ org.hsqldb.jdbc.util.sqlexception(unknown source)     @ org.hsqldb.jdbc.jdbcpreparedstatement.<init>(unknown source)     @ org.hsqldb.jdbc.jdbcconnection.preparestatement(unknown source)     @ org.hibernate.jdbc.abstractbatcher.getpreparedstatement(abstractbatcher.java:534)     @ org.hibernate.jdbc.abstractbatcher.preparestatement(abstractbatcher.java:116)     @ org.hibernate.jdbc.abstractbatcher.preparestatement(abstractbatcher.java:109)     @ org.hibernate.engine.query.nativesqlqueryplan.performexecuteupdate(nativesqlqueryplan.java:202)     ... 5 more

update: seems can't execute insert statement. if try insert data other table fails, too. must doing realy dumb ... didn't see ...

details of error mentioned op.

session.createsqlquery("insert entity_table_map (entity_name,table_name)  values (\"a429interface\",\"interface\")").executeupdate();

in sql statement above, 2 inserted values strings, therefore single quote (sql quote character strings) must used.

when double quote (sql quote character variable, column , table names) used, engine expects find variables named "a429interface", "interface" insert table. no such variables exist, reports user lacks privilege or object not found: a492interface


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