java - Acess Denied exception while trying to set table clustered in HSQLDB -
I have a table command with a unique index on it - 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> what The Msya be here? 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.
create unique index Idx_Date_States On Orders (Report Debt, CustomerState, VendorState);
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)
Comments
Post a Comment