Print at Mar 12, 2010 6:10:00 AM

Posted by laurentlecomte51 at Dec 24, 2006 1:34:27 AM
[DERBY][SPRING]
HI,

I try to use Apache DERBY instead of mysql.

With all the same, I encouter some problems while creating schemas.

I have this errors:
[ERROR][AWT-EventQueue-0] 01:27:42,890 JPOX.RDBMS.Schema - An exception was thrown while adding/validating class(es) : DERBY SQL error: SQLCODE: -1, SQLSTATE: 38000, SQLERRMC: java.sql.SQLException: Java exception: '0: java.lang.ArrayIndexOutOfBoundsException'.38000XJ001:java.lang.ArrayIndexOutOfBoundsException0XJ001.U
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: 38000, SQLERRMC: java.sql.SQLException: Java exception: '0: java.lang.ArrayIndexOutOfBoundsException'.38000XJ001:java.lang.ArrayIndexOutOfBoundsException0XJ001.U
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.DatabaseMetaData.getIndexInfo(Unknown Source)
at org.jpox.store.rdbms.adapter.DatabaseAdapter.getExistingIndexes(DatabaseAdapter.java:1583)
at org.jpox.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1013)
at org.jpox.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:615)
at org.jpox.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:393)
at org.jpox.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:2817)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3110)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1151)
at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1354)
at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2332)
at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileCandidates(JDOQLQuery.java:1114)
at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.executionCompile(JDOQLQuery.java:881)
at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:497)
at org.jpox.store.query.Query.executeWithMap(Query.java:959)
at org.jpox.store.query.Query.executeWithArray(Query.java:932)
at org.jpox.store.query.Query.execute(Query.java:855)
at org.dicom4jserver.dao.support.BaseDao.executeSelectQuery(BaseDao.java:179)
at org.dicom4jserver.dao.DicomNodeBeanDAO.getAllDicomNodes(DicomNodeBeanDAO.java:38)
at org.dicom4jserver.gui.tabpanels.DicomNodesPanel.readActionFired(DicomNodesPanel.java:108)
at org.dicom4jserver.gui.tabpanels.DicomNodesPanel.readDicomNodesFromDB(DicomNodesPanel.java:79)
at org.dicom4jserver.gui.Main.OnActiveDicomNodesTabPanel(Main.java:246)
at org.dicom4jserver.gui.Main.access$3(Main.java:244)
at org.dicom4jserver.gui.Main$TabChangeHandler.stateChanged(Main.java:219)
at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)
at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown Source)
at javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown Source)
at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown Source)
at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)
at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)
at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)


Here to configuration of my spring file :
<prop key="javax.jdo.PersistenceManagerFactoryClass">org.jpox.PersistenceManagerFactoryImpl</prop>
<prop key="javax.jdo.option.ConnectionURL">jdbc:derby://127.0.0.1:1527/login;create=true</prop>
<prop key="javax.jdo.option.ConnectionUserName">sa</prop>
<prop key="javax.jdo.option.ConnectionPassword">sa</prop>
<prop key="javax.jdo.option.ConnectionDriverName">org.apache.derby.jdbc.ClientDriver</prop>
<prop key="org.jpox.autoCreateSchema">true</prop>


I don't know how to resolve this issue.


Thanks in advance