java - Acess Denied exception while trying to set table clustered in HSQLDB -


text after "

I have a table command with a unique index on it -

  create unique index Idx_Date_States On Orders (Report Debt, CustomerState, VendorState);   

When I try to create a cluster index on the table, I can use one to deny the exception, even if there is no other connection to the database - < Pre> java.sql.SQLException: Access statement is denied in org.hsqldb.jdbc.Util.sqlException (unknown source) at org.hsqldb.jdbc.Util.sqlException (at least [on the set table order ( ReportDate, CustomerState, SellerState) cluster] org.hsqldb.jdbc.JDBCStatement.execute at org.hsqldb.jdbc.JDBCStatement.fetchResult (unknown source) (unknown source at unknown source)

what The Msya be here?

"itemprop =" text ">

Your table should be a cached table, otherwise it has thrown the exception.

If you want specificity for the given columns, instead of creating a primary key or a unique obstacle, rather than an index.

An index does not have to be a unique index to make this cluster.

You can execute the statement for any index or column of the UNIQUE barrier.

Comments

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

Matlab transpose a table vector -

c# - Textbox not clickable but editable -