Derby DB creation issue [message #597344] |
Tue, 02 March 2010 07:38 |
|
Hello DTP team,
I have already checked some posts on this issue hoping to find and advice but, it seems that the problems shows up depending on the "database location".
The environment is:
Eclipse Galileo EE package. Build id: 20090920-1017
org.apache.derby.core_10.5.3 (installed)
org.apache.derby.plugin.doc_1.1.2 (installed)
org.apache.derby.ui_1.1.2 (installed)
I have created one Derby database and successfully connect to it. During creation process (of this DB) I leaved Database location and Url to their default suggested locations i.e.
Database location: C:\Documents and Settings\EZDAdmin\MyDB
Url: jdbc:derby:C:\Documents and Settings\EZDAdmin\MyDB;create=true
Create database: checked
Driver: Derby Embedded JDBC driver 10.2 default
Then I tried to create another Database at another location of my choice. therefore I changed to:
Database location: C:\DataBases\web1db
Url(changes accordingly to): jdbc:derby:C:\DataBases\web1db;create=true
Trying to ping it or just "finish" the wizard return the log bellow and fails.
I appreciate any help on this issue.
Jorge
java.sql.SQLException: Failed to create database 'C:\DataBases\web1db', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Un known Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnecti on.createConnection(JDBCConnection.java:206)
at org.eclipse.datatools.connectivity.apache.internal.derby.con nection.DerbyEmbeddedJDBCConnection.createConnection(DerbyEm beddedJDBCConnection.java:137)
at org.eclipse.datatools.connectivity.DriverConnectionBase.inte rnalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open (DriverConnectionBase.java:53)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnecti on.open(JDBCConnection.java:72)
at org.eclipse.datatools.connectivity.apache.internal.derby.con nection.DerbyJDBCConnectionFactory.createConnection(DerbyJDB CConnectionFactory.java:32)
at org.eclipse.datatools.connectivity.internal.ConnectionFactor yProvider.createConnection(ConnectionFactoryProvider.java:83 )
at org.eclipse.datatools.connectivity.internal.ConnectionProfil e.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConn ection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.ja va:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: Failed to create database 'C:\DataBases\web1db', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
... 21 more
Caused by: java.sql.SQLException: Directory C:\DataBases\web1db already exists.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQL Exception(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleExc eption(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(U nknown Source)
... 18 more
Caused by: ERROR XBM0J: Directory C:\DataBases\web1db already exists.
at org.apache.derby.iapi.error.StandardException.newException(U nknown Source)
at org.apache.derby.impl.services.monitor.StorageFactoryService $9.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.services.monitor.StorageFactoryService .createServiceRoot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootServi ce(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPer sistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.createPersist entService(Unknown Source)
... 18 more
--
Jorge
Jorge
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03498 seconds