Search Mailing List Archives


Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[protege-discussion] HyperSQL back-end problem

Ruslan Sorokin sorokin at oogis.ru
Thu May 19 03:44:51 PDT 2011


Hello protege-users and team,

Trying to use HyperSQL as a back-end for a Protege project got this 
error message:

WARNING: Failed to create table on database HSQL Database Engine with 
command 'CREATE TABLE ProtegeTable (frame NVARCHAR NOT NULL, frame_type 
SMALLINT NOT NULL, slot NVARCHAR NOT NULL, facet NVARCHAR NOT NULL, 
is_template BIT NOT NULL, value_index INTEGER NOT NULL, value_type 
SMALLINT NOT NULL, short_value NVARCHAR, long_value CLOB)' :length must 
be specified in type definition: VARCHAR -- 
DefaultDatabaseFrameDb.createTable()
WARNING: Errors at copying knowledgebase jdbc:hsqldb:file:hsqldb -- 
java.sql.SQLSyntaxErrorException: length must be specified in type 
definition: VARCHAR
     at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
     at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
     at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
     at 
edu.stanford.smi.protege.storage.database.AbstractDatabaseFrameDb.executeUpdate(Unknown 
Source)
     at 
edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.createTable(Unknown 
Source)
     at 
edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.ensureEmptyTableExists(Unknown 
Source)
     at 
edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.overwriteKB(Unknown 
Source)
     at 
edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.copyKnowledgeBase(Unknown 
Source)
     at 
edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.copyKnowledgeBase(Unknown 
Source)
     at 
edu.stanford.smi.protege.storage.database.DatabaseKnowledgeBaseFactory.saveKnowledgeBase(Unknown 
Source)
     at edu.stanford.smi.protege.model.Project.saveDomainKB(Unknown Source)
     at edu.stanford.smi.protege.model.Project.save(Unknown Source)
     at edu.stanford.smi.protege.ui.ProjectManager.save(Unknown Source)
     at 
edu.stanford.smi.protege.ui.ProjectManager.changeProjectStorageFormatRequest(Unknown 
Source)
     at 
edu.stanford.smi.protege.action.ChangeProjectStorageFormat.actionPerformed(Unknown 
Source)
     at 
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
     at 
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
     at 
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
     at 
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
     at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
     at 
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
     at 
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
     at java.awt.Component.processMouseEvent(Component.java:6289)
     at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
     at java.awt.Component.processEvent(Component.java:6054)
     at java.awt.Container.processEvent(Container.java:2041)
     at java.awt.Component.dispatchEventImpl(Component.java:4652)
     at java.awt.Container.dispatchEventImpl(Container.java:2099)
     at java.awt.Component.dispatchEvent(Component.java:4482)
     at 
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
     at 
java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
     at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
     at java.awt.Container.dispatchEventImpl(Container.java:2085)
     at java.awt.Window.dispatchEventImpl(Window.java:2478)
     at java.awt.Component.dispatchEvent(Component.java:4482)
     at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
     at java.awt.EventQueue.access$000(EventQueue.java:85)
     at java.awt.EventQueue$1.run(EventQueue.java:603)
     at java.awt.EventQueue$1.run(EventQueue.java:601)
     at java.security.AccessController.doPrivileged(Native Method)
     at 
java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
     at 
java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
     at java.awt.EventQueue$2.run(EventQueue.java:617)
     at java.awt.EventQueue$2.run(EventQueue.java:615)
     at java.security.AccessController.doPrivileged(Native Method)
     at 
java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
     at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
     at 
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
     at 
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
     at 
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
     at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
     at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
     at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: org.hsqldb.HsqlException: length must be specified in type 
definition: VARCHAR
     at org.hsqldb.error.Error.error(Unknown Source)
     at org.hsqldb.error.Error.error(Unknown Source)
     at org.hsqldb.ParserDQL.readTypeDefinition(Unknown Source)
     at org.hsqldb.ParserDDL.readColumnDefinitionOrNull(Unknown Source)
     at org.hsqldb.ParserDDL.compileCreateTableBody(Unknown Source)
     at org.hsqldb.ParserDDL.compileCreateTable(Unknown Source)
     at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
     at org.hsqldb.ParserCommand.compilePart(Unknown Source)
     at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
     at org.hsqldb.Session.executeDirectStatement(Unknown Source)
     at org.hsqldb.Session.execute(Unknown Source)
     ... 52 more

What's wrong? Is anybody used HyperSQL with Protege? Any help would be 
very appreciated.

Sincerely,
    Ru




More information about the protege-discussion mailing list