db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Leroux <sylv...@chicoree.fr>
Subject Re: XBM0J Directory already exists
Date Thu, 31 Dec 2009 10:55:44 GMT
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



Mime
View raw message