Hi Damian,
I'm not a Windows guy, but as a first guess, I think you should try one of
these:
1) Use only forward slashes in your path (i.e.:
jdbc:derby://127.0.1.1:1527/C:/myapp/db;create=true )
2) Set derby.system.home to your working directory (C:\myapp) and only use
relative path in you connection URL (jdbc:derby://127.0.1.1:1527/db;create=true).
See http://db.apache.org/derby/docs/10.5/devguide/cdevdvlp40350.html
Regards,
Sylvain
Damian Hofmann a écrit :
Hi,
On a Windows Vista machine I get an SQLException, when my application is
connecting to the derby network server. The Server runs on the same
machine, as my application (localhost on port 1527).
The exception is:
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041,
SQLERRMC: Failed to create database 'C:\myapp\db', see the next
exception for details.::SQLSTATE: XBM0JDirectory
C:\db-derby-10.5.1.1-bin\bin\C:\myapp\db already exists.
The connection url looks like this:
jdbc:derby://127.0.1.1:1527/C:\myapp\db;create=true
It seems the Server is trying to create the database under
C:\db-derby-10.5.1.1-bin\bin\C:\myapp\db what isn't the place i excepted
the database to live. Derby is not only using the wrong place, but the
directory also doesn't exist, contrary to the exceptions claim, that the
directory is already there.
If I start the network server from a different working directory, the
path before the second C:\ changes to the current working directory. So
I belive, that this is actualy a problem with my derby server
configuration, not with the my application.
The problem doesent' occur if I run the application on my Windows XP
machine.
Any ideas, what causes the derby server to search for the database at
the wrong place?
Thanks Damian
Here is the complete Stacktrace:
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041,
SQLERRMC: Failed to create database 'C:\verteilcenter\db\licenses', see
the next exception for details.::SQLSTATE: XBM0JDirectory
C:\Development\Galileo\SR1\eclipse\C:\verteilcenter\db\licenses already
exists.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
at
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
at
ag.leonardo.judocu.verteilcenter.model.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:37)
at
ag.leonardo.judocu.verteilcenter.model.util.HibernateUtil.<clinit>(HibernateUtil.java:29)
at
ag.leonardo.judocu.verteilcenter.model.ModelProvider.getSession(ModelProvider.java:104)
at
ag.leonardo.judocu.verteilcenter.model.ModelProvider.getBenutzerListe(ModelProvider.java:35)
at
ag.leonardo.judocu.verteilcenter.essentials.ui.editors.BenutzerEditor.createViewer(BenutzerEditor.java:156)
at
ag.leonardo.judocu.verteilcenter.essentials.ui.editors.BenutzerEditor.createControls(BenutzerEditor.java:103)
at
ag.leonardo.judocu.verteilcenter.essentials.ui.editors.BenutzerEditor.createPartControl(BenutzerEditor.java:73)
at
org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:658)
at
org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:429)
at
org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:594)
at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:312)
at
org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:185)
at
org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:265)
at
org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:64)
at
org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:478)
at
org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1267)
at
org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1220)
at org.eclipse.ui.internal.PartStack.showPart(PartStack.java:1619)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:508)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:103)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:494)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:112)
at
org.eclipse.ui.internal.EditorSashContainer.addEditor(EditorSashContainer.java:64)
at
org.eclipse.ui.internal.EditorAreaHelper.addToLayout(EditorAreaHelper.java:217)
at
org.eclipse.ui.internal.EditorAreaHelper.addEditor(EditorAreaHelper.java:207)
at
org.eclipse.ui.internal.EditorManager.createEditorTab(EditorManager.java:782)
at
org.eclipse.ui.internal.EditorManager.openEditorFromDescriptor(EditorManager.java:680)
at
org.eclipse.ui.internal.EditorManager.openEditor(EditorManager.java:640)
at
org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2716)
at
org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2630)
at
org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2622)
at
org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2574)
at
org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:66)
at
org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2569)
at
org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2553)
at
org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2536)
at
ag.leonardo.judocu.verteilcenter.essentials.ui.views.Navigation.selectionChanged(Navigation.java:120)
at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:163)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.runtime.Platform.run(Platform.java:888)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at
org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:161)
at
org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:2060)
at
org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1136)
at
org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1166)
at
org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:223)
at
org.eclipse.jface.util.OpenStrategy.access$3(OpenStrategy.java:217)
at
org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:394)
at
org.eclipse.swt.internal.widgets.UntypedEventAdapter.dispatchEvent(UntypedEventAdapter.java:594)
at
org.eclipse.swt.internal.widgets.UntypedEventAdapter.widgetSelected(UntypedEventAdapter.java:85)
at
org.eclipse.swt.events.SelectionEvent.dispatchToObserver(SelectionEvent.java:194)
at org.eclipse.rwt.internal.events.Event.processEvent(Event.java:44)
at
org.eclipse.swt.events.TypedEvent.processEvent(TypedEvent.java:129)
at org.eclipse.swt.events.TypedEvent.executeNext(TypedEvent.java:169)
at
org.eclipse.rwt.internal.lifecycle.RWTLifeCycle.readAndDispatch(RWTLifeCycle.java:240)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:981)
at
org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2396)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2355)
at org.eclipse.ui.internal.Workbench.access$5(Workbench.java:2206)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:424)
at
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at
org.eclipse.jface.internal.databinding.realmadapter.RealmAdapter.run(RealmAdapter.java:44)
at
org.eclipse.rap.ui.internal.RealmAdapterHook.runWithDefault(RealmAdapterHook.java:48)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:427)
at
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:157)
at
ag.leonardo.judocu.verteilcenter.essentials.application.EntryPoint.createUI(EntryPoint.java:13)
at
org.eclipse.rwt.internal.lifecycle.EntryPointManager.createUI(EntryPointManager.java:92)
at
org.eclipse.rwt.internal.lifecycle.RWTLifeCycle.createUI(RWTLifeCycle.java:227)
at
org.eclipse.rwt.internal.lifecycle.RWTLifeCycle$UIThreadController.run(RWTLifeCycle.java:115)
at java.lang.Thread.run(Thread.java:619)
at org.eclipse.rwt.internal.lifecycle.UIThread.run(UIThread.java:80)
Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error:
SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database
'C:\verteilcenter\db\licenses', see the next exception for
details.::SQLSTATE: XBM0JDirectory
C:\Development\Galileo\SR1\eclipse\C:\verteilcenter\db\licenses already
exists.
at org.apache.derby.client.am.Connection.completeSqlca(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown
Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown
Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown
Source)
... 80 more
--
[email protected]
http://www.chicoree.fr
