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-owl] Bug using OWL + DB Backend

Tania Tudorache tudorache at stanford.edu
Mon Mar 30 16:28:31 PDT 2009


Simon,

I am also using MySQL: 5.1.31 and driver: 5.1.7 and do not get those 
exceptions.

Our guess it is the table name. What table name did you use? Please make 
a test with table name "protegeTable", see if you get the exception.

Another thing that was not clear in your email was that the "Protege 
server" cannot load it. Did you try to load the pprj in standalone (not 
in multi-user mode)?

If you had an old database from a previous Protege version, then it will 
not work, because the database format has changed.

I suggest the following experiment: Open pizza.owl from the examples 
folder, convert it to OWL/RDF database using the table name 
"protegeTable", and save it under the name "pizza_db.pprj". Then try to 
open the "pizza_db.pprj" in Protege to see if you get any exceptions.

Let us know how the experiment went. If you still have problems, please 
post also the OS you are using and the Java version.

Tania


Paradies, Simon wrote:
> Hi,
>
> I am posting here as bugzilla at http://smi-protege.stanford.edu/
> bugzilla/ won't let me. Message was: "Either no products have been defined to 
> enter bugs against or you have not been given access to any." However, I am 
> logged in but don't know ho to "define products".
> Anyway, when trying to store OWL ontologies (the examples shipping with Protégé)
> in the database every time on reloading it an execption is raised (see below).
> However, I still can write and read the ontology using direct access with the client.
> But Protege-Server won't load it. Frames ontologies work correctly. 
> Protege Version is Build 533 (updated half an hour ago from SVN, also recreated 
> Ontologies in DB after update)
> MySQL: 5.1.30, mySQL Adapter: 5.1.7
>
> Cheers
> Simon
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in 
> your SQL syntax; check the manual that corresponds to your MySQL server version 
> for the right syntax to use near 'WHERE frame = ':OWL-ONTOLOGY-POINTER-CLASS' 
> AND slot = ':DIRECT-INSTANCES' AND f' at line 1
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance
> (NativeConstructorAccessorImpl.java:39)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
> (DelegatingConstructorAccessorImpl.java:27)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:381)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal
> (PreparedStatement.java:1761)
> 	at com.mysql.jdbc.PreparedStatement.executeQuery
> (PreparedStatement.java:1912)
> 	at 
> edu.stanford.smi.protege.storage.database.AbstractDatabaseFrameDb.executeQuery
> (AbstractDatabaseFrameDb.java:87)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValuesSQL
> (DefaultDatabaseFrameDb.java:711)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValues
> (DefaultDatabaseFrameDb.java:684)
> 	at 
> edu.stanford.smi.protegex.owl.database.DatabaseFactoryUtils.getOntologyFromTable
> (DatabaseFactoryUtils.java:122)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.addTable
> (DatabaseRepository.java:159)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.<init>
> (DatabaseRepository.java:115)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepositoryFactoryPlugin.createRepository
> (DatabaseRepositoryFactoryPlugin.java:20)
> 	at 
> edu.stanford.smi.protegex.owl.repository.factory.RepositoryFactory.createOntRepository
> (RepositoryFactory.java:81)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadRepositoriesFromFile
> (RepositoryFileManager.java:184)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:82)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:92)
> 	at 
> edu.stanford.smi.protegex.owl.model.impl.AbstractOWLModel.getRepositoryManager
> (AbstractOWLModel.java:1423)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.<init>
> (RepositoryFileManager.java:67)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadProjectRepositories
> (RepositoryFileManager.java:55)
> 	at 
> edu.stanford.smi.protegex.owl.database.OWLDatabaseKnowledgeBaseFactory.loadKnowledgeBase
> (OWLDatabaseKnowledgeBaseFactory.java:108)
> 	at edu.stanford.smi.protege.model.Project.loadDomainKB
> (Project.java:1346)
> 	at edu.stanford.smi.protege.model.Project.createDomainKnowledgeBase
> (Project.java:456)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:359)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:341)
> 	at edu.stanford.smi.protege.model.Project.loadProjectFromURI
> (Project.java:1456)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProjectFromURI
> (ProjectManager.java:557)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProject
> (ProjectManager.java:523)
> 	at edu.stanford.smi.protege.ui.ProjectMenuBar$1.actionPerformed
> (ProjectMenuBar.java:284)
> 	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:1225)
> 	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased
> (BasicMenuItemUI.java:1266)
> 	at java.awt.Component.processMouseEvent(Component.java:6134)
> 	at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
> 	at java.awt.Component.processEvent(Component.java:5899)
> 	at java.awt.Container.processEvent(Container.java:2023)
> 	at java.awt.Component.dispatchEventImpl(Component.java:4501)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2081)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.LightweightDispatcher.retargetMouseEvent
> (Container.java:4301)
> 	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3965)
> 	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3895)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2067)
> 	at java.awt.Window.dispatchEventImpl(Window.java:2458)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
> 	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)
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in 
> your SQL syntax; check the manual that corresponds to your MySQL server version 
> for the right syntax to use near 'WHERE frame = ':OWL-ONTOLOGY-POINTER-CLASS' 
> AND slot = ':DIRECT-INSTANCES' AND f' at line 1
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance
> (NativeConstructorAccessorImpl.java:39)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
> (DelegatingConstructorAccessorImpl.java:27)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:381)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal
> (PreparedStatement.java:1761)
> 	at com.mysql.jdbc.PreparedStatement.executeQuery
> (PreparedStatement.java:1912)
> 	at 
> edu.stanford.smi.protege.storage.database.AbstractDatabaseFrameDb.executeQuery
> (AbstractDatabaseFrameDb.java:87)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValuesSQL
> (DefaultDatabaseFrameDb.java:711)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValues
> (DefaultDatabaseFrameDb.java:684)
> 	at 
> edu.stanford.smi.protegex.owl.database.DatabaseFactoryUtils.getOntologyFromTable
> (DatabaseFactoryUtils.java:122)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.addTable
> (DatabaseRepository.java:159)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.<init>
> (DatabaseRepository.java:115)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepositoryFactoryPlugin.createRepository
> (DatabaseRepositoryFactoryPlugin.java:20)
> 	at 
> edu.stanford.smi.protegex.owl.repository.factory.RepositoryFactory.createOntRepository
> (RepositoryFactory.java:81)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadRepositoriesFromFile
> (RepositoryFileManager.java:184)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:82)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:92)
> 	at 
> edu.stanford.smi.protegex.owl.model.impl.AbstractOWLModel.getRepositoryManager
> (AbstractOWLModel.java:1423)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.<init>
> (RepositoryFileManager.java:67)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadProjectRepositories
> (RepositoryFileManager.java:55)
> 	at 
> edu.stanford.smi.protegex.owl.database.OWLDatabaseKnowledgeBaseFactory.loadKnowledgeBase
> (OWLDatabaseKnowledgeBaseFactory.java:108)
> 	at edu.stanford.smi.protege.model.Project.loadDomainKB
> (Project.java:1346)
> 	at edu.stanford.smi.protege.model.Project.createDomainKnowledgeBase
> (Project.java:456)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:359)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:341)
> 	at edu.stanford.smi.protege.model.Project.loadProjectFromURI
> (Project.java:1456)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProjectFromURI
> (ProjectManager.java:557)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProject
> (ProjectManager.java:523)
> 	at edu.stanford.smi.protege.ui.ProjectMenuBar$1.actionPerformed
> (ProjectMenuBar.java:284)
> 	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:1225)
> 	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased
> (BasicMenuItemUI.java:1266)
> 	at java.awt.Component.processMouseEvent(Component.java:6134)
> 	at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
> 	at java.awt.Component.processEvent(Component.java:5899)
> 	at java.awt.Container.processEvent(Container.java:2023)
> 	at java.awt.Component.dispatchEventImpl(Component.java:4501)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2081)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.LightweightDispatcher.retargetMouseEvent
> (Container.java:4301)
> 	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3965)
> 	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3895)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2067)
> 	at java.awt.Window.dispatchEventImpl(Window.java:2458)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
> 	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)
>
> Importing http://protege.stanford.edu/plugins/owl/protege from location: D:
> \workspace\protege-core\examples\server\protege.owl
> Loading triples from: http://protege.stanford.edu/plugins/owl/protege
>     Completed triple loading after 47 ms
> Postprocess: Process entities with incorrect Java type (0 entities) ... 0 ms
> Postprocess: Process metaclasses (3 metaclasses) ... 0 ms
> Postprocess: Process subclasses of rdf:List (1 classes) ... 0 ms
> Postprocess: Instances with multiple types (9 instances) ... 15 ms
> Postprocess: Add inferred superclasses ... 0 ms
> Postprocess: Process orphan classes (0 classes) ... 0 ms
> Postprocess: Generalized Concept Inclusion (0 axioms) ... 0 ms
> Postprocess: Abstract classes... 0 ms
> Postprocess: Domain and range of properties... 16 ms
> Postprocess: Possibly typed entities (0 resources) ... 0 ms
> Started Collaborative Protege on Mon Mar 30 17:23:17 CEST 2009
> Load time for file:\D:\workspace\protege-core\examples\collaborativePizza
> \collaborativePizza.owl.pprj = 2 sec (project) + 0 sec (ui)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in 
> your SQL syntax; check the manual that corresponds to your MySQL server version 
> for the right syntax to use near 'WHERE frame = ':OWL-ONTOLOGY-POINTER-CLASS' 
> AND slot = ':DIRECT-INSTANCES' AND f' at line 1
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance
> (NativeConstructorAccessorImpl.java:39)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
> (DelegatingConstructorAccessorImpl.java:27)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:381)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal
> (PreparedStatement.java:1761)
> 	at com.mysql.jdbc.PreparedStatement.executeQuery
> (PreparedStatement.java:1912)
> 	at 
> edu.stanford.smi.protege.storage.database.AbstractDatabaseFrameDb.executeQuery
> (AbstractDatabaseFrameDb.java:87)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValuesSQL
> (DefaultDatabaseFrameDb.java:711)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValues
> (DefaultDatabaseFrameDb.java:684)
> 	at 
> edu.stanford.smi.protegex.owl.database.DatabaseFactoryUtils.getOntologyFromTable
> (DatabaseFactoryUtils.java:122)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.addTable
> (DatabaseRepository.java:159)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.<init>
> (DatabaseRepository.java:115)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepositoryFactoryPlugin.createRepository
> (DatabaseRepositoryFactoryPlugin.java:20)
> 	at 
> edu.stanford.smi.protegex.owl.repository.factory.RepositoryFactory.createOntRepository
> (RepositoryFactory.java:81)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadRepositoriesFromFile
> (RepositoryFileManager.java:184)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:82)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:92)
> 	at 
> edu.stanford.smi.protegex.owl.model.impl.AbstractOWLModel.getRepositoryManager
> (AbstractOWLModel.java:1423)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.<init>
> (RepositoryFileManager.java:67)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadProjectRepositories
> (RepositoryFileManager.java:55)
> 	at 
> edu.stanford.smi.protegex.owl.database.OWLDatabaseKnowledgeBaseFactory.loadKnowledgeBase
> (OWLDatabaseKnowledgeBaseFactory.java:108)
> 	at edu.stanford.smi.protege.model.Project.loadDomainKB
> (Project.java:1346)
> 	at edu.stanford.smi.protege.model.Project.createDomainKnowledgeBase
> (Project.java:456)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:359)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:341)
> 	at edu.stanford.smi.protege.model.Project.loadProjectFromURI
> (Project.java:1456)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProjectFromURI
> (ProjectManager.java:557)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProject
> (ProjectManager.java:523)
> 	at edu.stanford.smi.protegex.owl.model.impl.OWLUtil.saveAndReloadProject
> (OWLUtil.java:563)
> 	at 
> edu.stanford.smi.protegex.owl.ui.repository.RepositoryManagerPanel.showDialog
> (RepositoryManagerPanel.java:95)
> 	at 
> edu.stanford.smi.protegex.owl.ui.repository.ShowRepositoryEditorAction.run
> (ShowRepositoryEditorAction.java:41)
> 	at 
> edu.stanford.smi.protegex.owl.ui.menu.OWLModelActionAction.actionPerformed
> (OWLModelActionAction.java:42)
> 	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:1225)
> 	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased
> (BasicMenuItemUI.java:1266)
> 	at java.awt.Component.processMouseEvent(Component.java:6134)
> 	at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
> 	at java.awt.Component.processEvent(Component.java:5899)
> 	at java.awt.Container.processEvent(Container.java:2023)
> 	at java.awt.Component.dispatchEventImpl(Component.java:4501)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2081)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.LightweightDispatcher.retargetMouseEvent
> (Container.java:4301)
> 	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3965)
> 	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3895)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2067)
> 	at java.awt.Window.dispatchEventImpl(Window.java:2458)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
> 	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)
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in 
> your SQL syntax; check the manual that corresponds to your MySQL server version 
> for the right syntax to use near 'WHERE frame = ':OWL-ONTOLOGY-POINTER-CLASS' 
> AND slot = ':DIRECT-INSTANCES' AND f' at line 1
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance
> (NativeConstructorAccessorImpl.java:39)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
> (DelegatingConstructorAccessorImpl.java:27)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:381)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal
> (PreparedStatement.java:1761)
> 	at com.mysql.jdbc.PreparedStatement.executeQuery
> (PreparedStatement.java:1912)
> 	at 
> edu.stanford.smi.protege.storage.database.AbstractDatabaseFrameDb.executeQuery
> (AbstractDatabaseFrameDb.java:87)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValuesSQL
> (DefaultDatabaseFrameDb.java:711)
> 	at 
> edu.stanford.smi.protege.storage.database.DefaultDatabaseFrameDb.getValues
> (DefaultDatabaseFrameDb.java:684)
> 	at 
> edu.stanford.smi.protegex.owl.database.DatabaseFactoryUtils.getOntologyFromTable
> (DatabaseFactoryUtils.java:122)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.addTable
> (DatabaseRepository.java:159)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepository.<init>
> (DatabaseRepository.java:115)
> 	at 
> edu.stanford.smi.protegex.owl.repository.impl.DatabaseRepositoryFactoryPlugin.createRepository
> (DatabaseRepositoryFactoryPlugin.java:20)
> 	at 
> edu.stanford.smi.protegex.owl.repository.factory.RepositoryFactory.createOntRepository
> (RepositoryFactory.java:81)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadRepositoriesFromFile
> (RepositoryFileManager.java:184)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:82)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadGlobalRepositories
> (RepositoryFileManager.java:92)
> 	at 
> edu.stanford.smi.protegex.owl.model.impl.AbstractOWLModel.getRepositoryManager
> (AbstractOWLModel.java:1423)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.<init>
> (RepositoryFileManager.java:67)
> 	at 
> edu.stanford.smi.protegex.owl.repository.util.RepositoryFileManager.loadProjectRepositories
> (RepositoryFileManager.java:55)
> 	at 
> edu.stanford.smi.protegex.owl.database.OWLDatabaseKnowledgeBaseFactory.loadKnowledgeBase
> (OWLDatabaseKnowledgeBaseFactory.java:108)
> 	at edu.stanford.smi.protege.model.Project.loadDomainKB
> (Project.java:1346)
> 	at edu.stanford.smi.protege.model.Project.createDomainKnowledgeBase
> (Project.java:456)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:359)
> 	at edu.stanford.smi.protege.model.Project.<init>(Project.java:341)
> 	at edu.stanford.smi.protege.model.Project.loadProjectFromURI
> (Project.java:1456)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProjectFromURI
> (ProjectManager.java:557)
> 	at edu.stanford.smi.protege.ui.ProjectManager.loadProject
> (ProjectManager.java:523)
> 	at edu.stanford.smi.protegex.owl.model.impl.OWLUtil.saveAndReloadProject
> (OWLUtil.java:563)
> 	at 
> edu.stanford.smi.protegex.owl.ui.repository.RepositoryManagerPanel.showDialog
> (RepositoryManagerPanel.java:95)
> 	at 
> edu.stanford.smi.protegex.owl.ui.repository.ShowRepositoryEditorAction.run
> (ShowRepositoryEditorAction.java:41)
> 	at 
> edu.stanford.smi.protegex.owl.ui.menu.OWLModelActionAction.actionPerformed
> (OWLModelActionAction.java:42)
> 	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:1225)
> 	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased
> (BasicMenuItemUI.java:1266)
> 	at java.awt.Component.processMouseEvent(Component.java:6134)
> 	at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
> 	at java.awt.Component.processEvent(Component.java:5899)
> 	at java.awt.Container.processEvent(Container.java:2023)
> 	at java.awt.Component.dispatchEventImpl(Component.java:4501)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2081)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.LightweightDispatcher.retargetMouseEvent
> (Container.java:4301)
> 	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3965)
> 	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3895)
> 	at java.awt.Container.dispatchEventImpl(Container.java:2067)
> 	at java.awt.Window.dispatchEventImpl(Window.java:2458)
> 	at java.awt.Component.dispatchEvent(Component.java:4331)
> 	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
> 	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)
>
> Importing http://protege.stanford.edu/plugins/owl/protege from location: Table 
> protegemetaont of the database jdbc:mysql://localhost/protege
> Started Collaborative Protege on Mon Mar 30 17:23:43 CEST 2009
> Load time for file:\D:\workspace\protege-core\examples\collaborativePizza
> \collaborativePizza.owl.pprj = 1 sec (project) + 0 sec (ui)
> _______________________________________________
> protege-owl mailing list
> protege-owl at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/protege-owl
>
> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03 
>
>   




More information about the protege-owl mailing list