You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Damian Hofmann <da...@gmx.ch> on 2009/12/30 18:58:23 UTC
XBM0J Directory already exists
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
Re: XBM0J Directory already exists
Posted by Bryan Pendleton <bp...@amberpoint.com>.
> 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.
I think it would be good if you could file an issue in the Derby JIRA
tracking system describing the confusing error message, what the real
problem was, and how the error message could be improved.
http://db.apache.org/derby/DerbyBugGuidelines.html
thanks,
bryan
Re: XBM0J Directory already exists
Posted by Damian Hofmann <da...@gmx.ch>.
Hi,
Today I found the problem. The Exception was a bit missleading, because
it seemed to me, that derby tries to create the database at
C:\db-derby-10.5.1.1-bin\bin\C:\myapp\db. At that location realy no such
directory existed and I was wondering, why it tries to create the db at
this location. Now it seems, that only path in the Exception message is
wrong.
Derby realy tried to create the database at the *correct* location
(C:\myapp\db). There an empty directory "db" already existed. I have not
expcepted, that the empty directory could be a problem, but derby seems
to insists on creating it's own directory and the creation of the
database fails, if it can't do that.
Lesson learned: Make sure, derby can create it's database directory. Do
not create your own database directory. Derby doesn't like that.
Possible improvement: Make the Exception message more clear. Why does
derby tell me, that it tries to create the database at
"C:\db-derby-10.5.1.1-bin\bin\C:\myapp\db" instead of the correct location?
Damian
Am 30.12.09 18:58, schrieb Damian Hofmann:
> 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
>
Re: XBM0J Directory already exists
Posted by Sylvain Leroux <sy...@chicoree.fr>.
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
>
>
>
--
sylvain@chicoree.fr
http://www.chicoree.fr