mysql - HSQLDB: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found -


i have found error has arised many times throughout internet haven't found solution case @ all. have hsql database - have connected 1 table in database successfully. went on create table in database - same java code modified appropriate brings error: java.sql.sqlsyntaxerrorexception: user lacks privilege or object not found: user.

i found in file store script code product table create there have created user table same way did product table - using hsql database manager.

this error code:

java.sql.sqlsyntaxerrorexception: user lacks privilege or object not found: user @ org.hsqldb.jdbc.jdbcutil.sqlexception(unknown source)     @ org.hsqldb.jdbc.jdbcutil.sqlexception(unknown source)     @ org.hsqldb.jdbc.jdbcpreparedstatement.<init>(unknown source)     @ org.hsqldb.jdbc.jdbcconnection.preparestatement(unknown source)     @ hb00294_ecommerce_com1028.data.loginwindow.validateuserdetails(loginwindow.java:129)     @ hb00294_ecommerce_com1028.data.loginwindow.access$4(loginwindow.java:121)     @ hb00294_ecommerce_com1028.data.loginwindow$2.mouseclicked(loginwindow.java:113)     @ java.awt.awteventmulticaster.mouseclicked(unknown source)     @ java.awt.component.processmouseevent(unknown source)     @ javax.swing.jcomponent.processmouseevent(unknown source)     @ java.awt.component.processevent(unknown source)     @ java.awt.container.processevent(unknown source)     @ java.awt.component.dispatcheventimpl(unknown source)     @ java.awt.container.dispatcheventimpl(unknown source)     @ java.awt.component.dispatchevent(unknown source)     @ java.awt.lightweightdispatcher.retargetmouseevent(unknown source)     @ java.awt.lightweightdispatcher.processmouseevent(unknown source)     @ java.awt.lightweightdispatcher.dispatchevent(unknown source)     @ java.awt.container.dispatcheventimpl(unknown source)     @ java.awt.window.dispatcheventimpl(unknown source)     @ java.awt.component.dispatchevent(unknown source)     @ java.awt.eventqueue.dispatcheventimpl(unknown source)     @ java.awt.eventqueue.access$500(unknown source)     @ java.awt.eventqueue$3.run(unknown source)     @ java.awt.eventqueue$3.run(unknown source)     @ java.security.accesscontroller.doprivileged(native method)     @ java.security.protectiondomain$1.dointersectionprivilege(unknown source)     @ java.security.protectiondomain$1.dointersectionprivilege(unknown source)     @ java.awt.eventqueue$4.run(unknown source)     @ java.awt.eventqueue$4.run(unknown source)     @ java.security.accesscontroller.doprivileged(native method)     @ java.security.protectiondomain$1.dointersectionprivilege(unknown source)     @ java.awt.eventqueue.dispatchevent(unknown source)     @ java.awt.eventdispatchthread.pumponeeventforfilters(unknown source)     @ java.awt.eventdispatchthread.pumpeventsforfilter(unknown source)     @ java.awt.eventdispatchthread.pumpeventsforhierarchy(unknown source)     @ java.awt.eventdispatchthread.pumpevents(unknown source)     @ java.awt.eventdispatchthread.pumpevents(unknown source)     @ java.awt.eventdispatchthread.run(unknown source) caused by: org.hsqldb.hsqlexception: user lacks privilege or object not found: user     @ org.hsqldb.error.error.error(unknown source)     @ org.hsqldb.error.error.error(unknown source)     @ org.hsqldb.schemamanager.gettable(unknown source)     @ org.hsqldb.parserdql.readtablename(unknown source)     @ org.hsqldb.parserdql.readtableorsubquery(unknown source)     @ org.hsqldb.parserdql.xreadtablereference(unknown source)     @ org.hsqldb.parserdql.xreadfromclause(unknown source)     @ org.hsqldb.parserdql.xreadtableexpression(unknown source)     @ org.hsqldb.parserdql.xreadqueryspecification(unknown source)     @ org.hsqldb.parserdql.xreadsimpletable(unknown source)     @ org.hsqldb.parserdql.xreadqueryprimary(unknown source)     @ org.hsqldb.parserdql.xreadqueryterm(unknown source)     @ org.hsqldb.parserdql.xreadqueryexpressionbody(unknown source)     @ org.hsqldb.parserdql.xreadqueryexpression(unknown source)     @ org.hsqldb.parserdql.compilecursorspecification(unknown source)     @ org.hsqldb.parsercommand.compilepart(unknown source)     @ org.hsqldb.parsercommand.compilestatement(unknown source)     @ org.hsqldb.session.compilestatement(unknown source)     @ org.hsqldb.statementmanager.compile(unknown source)     @ org.hsqldb.session.execute(unknown source)     ... 37 more

this file store script:

set database unique name hsqldb4d9b227d23 set database gc 0 set database default result memory rows 0 set database event log level 0 set database transaction control locks set database default isolation level read committed set database transaction rollback on conflict true set database text table defaults '' set database sql names false set database sql references false set database sql size true set database sql types false set database sql tdc delete true set database sql tdc update true set database sql translate tti types true set database sql concat nulls true set database sql unique nulls true set database sql convert truncate true set database sql avg scale 0 set database sql double nan true set files write delay 500 millis set files backup increment true set files cache size 10000 set files cache rows 50000 set files scale 32 set files lob scale 32 set files defrag 0 set files nio true set files nio size 256 set files log true set files log size 50 create user sa password digest 'd41d8cd98f00b204e9800998ecf8427e' alter user sa set local true create schema public authorization dba set schema public create memory table public.product(id integer generated default identity(start 1) not null primary key,title varchar(50),description varchar(90),information varchar(200),type varchar(50),price double,shippingprice double) alter table public.product alter column id restart 15 alter sequence system_lobs.lob_id restart 1 set database default initial schema public grant usage on domain information_schema.sql_identifier public grant usage on domain information_schema.yes_or_no public grant usage on domain information_schema.time_stamp public grant usage on domain information_schema.cardinal_number public grant usage on domain information_schema.character_data public grant dba sa set schema system_lobs insert blocks values(0,2147483647,0) set schema public insert product values(1,'a','b','c','miscellaneous',4.0e0,4.0e0)

i'm not sure whether problem access permissions or not recognise user table exists - have created method show table names within database , show product not user. suggestions solve this?

i hope have provided enough information - please let me know if there further information required , appreciate given.

if create table named user, show in .script file alongside other tables.

it possible did create table in later session did not shutdown database or perform checkpoint, create table user ... statement not saved.


Comments

Post a Comment

Popular posts from this blog

angularjs - ADAL JS Angular- WebAPI add a new role claim to the token -

i have created angular spa webapi backend using adal js authentication.as there no roles in ad, need manually add role claims in order give users access different api controllers. the roles stored in database. expecting inject claim through call webapi after authentication ad. webapi code might this. identity.addclaim(new claim("role", "user")); var ticket = new authenticationticket(identity, props); var accesstoken = startup.oauthbeareroptions.accesstokenformat.protect(ticket); is possible replace adal idtoken new token? is viable solution or there other better way handle this? as initial token generated azuread, possible edit token add new claim? appreciated. graph api supporting group claims. see here: http://justazure.com/azure-active-directory-part-4-group-claims/ if @ examples on page, users assigned groups , app can check group in claims. in current version of portal, need app manifest , modify it.
Read more

php - CakePHP HttpSockets send array of paramms -

i problem when make request (i can request). $link = 'http://uri/path/?param1=1&sid=2&sid=3&sid=4' $http = $httpsocket = new httpsocket(); $res = $httpsocket->get($link); if check request pr($http); i see : [line] => /url/path/?param1=1&sid%5b0%5d=2&sid%5b1%5d=3&sid%5b2%5d=4 http/1.1 and i'm getting empty response because server doesn't know parameters sid%5b0%5d=2 when try send parameters array : $data = array('param1' => '1', 'sid' => array('2','3', '4')); i see same changes %5b0%5d - additional indexes. how fix it? unfortunately , can not change server side, if send request in browser, i'll normal response in json format. when make request, can parameters this: $param1 = $_get['param1']; $sid= $_get['sid']; tip: use diferente names parameters. have multiples sid. use sid1, sid2, sid3... update: can parameters this:
Read more

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more