Eclipse Community Forums: DTP » Derby DB creation issue

Home » Eclipse Projects » DTP » Derby DB creation issue

Derby DB creation issue [message #597344]

Tue, 02 March 2010 02:38

Eclipse User

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

Re: Derby DB creation issue [message #597352 is a reply to message #597344]

Tue, 02 March 2010 13:26

Eclipse User

Hi Jorge,

Do you by chance not have the right permissions to create files/folders
in the other location? Or perhaps the c:\DataBases directory didn't exist?

--Fitz

Jorge Dieguez wrote:
> 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

Re: Derby DB creation issue [message #1815128 is a reply to message #597344]

Wed, 25 September 2019 14:18

Eclipse User

Old thread but issue still persists in derby. It may help someone else.

This is probably because you have started with create=true and the directory specified exists but is empty.

Derby guys if you can please fix this as people will have no clue about the error. The create=true and upgrade=true should be failsafe.

Thanks,
Prasanna

Previous Topic:	Current status of the Proposal
Next Topic:	Eclipse Oracle Connection Fails?

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 12:08:55 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter