Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] SQL Exception: Failed to create database
[CDO] SQL Exception: Failed to create database [message #431914] Wed, 29 July 2009 11:28 Go to next message
Eclipse UserFriend
Originally posted by: ralph.kretzler.gmail.com

Hello,

I try to start the CDO Server. For that I followed the instructions of
this tutorial ... http://wiki.eclipse.org/Getting_started_with_CDO_Galileo

But when I hit the run button I got an exception.
I am using Mac OS X and the Eclipse Modelling Package. EMF 2.5 and CDO 2.0.


Thanks,
Ralph


cdo-server.xml
--------------
<?xml version="1.0" encoding="UTF-8"?>
<cdoServer>

<!--acceptor type="http"/ -->

<acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
<!-- negotiator type="challenge" description="/temp/users.db"/ -->
</acceptor>

<repository name="repo1">
<property name="overrideUUID"
value="1ff5d226-b1f0-40fb-aba2-0c31b38c764f"/>
<property name="supportingAudits" value="true"/>
<property name="verifyingRevisions" value="false"/>
<property name="currentLRUCapacity" value="10000"/>
<property name="revisedLRUCapacity" value="100"/>

<store type="db">
<mappingStrategy type="horizontal">
<property name="qualifiedNames" value="false"/>
<property name="toManyReferences" value="ONE_TABLE_PER_REFERENCE"/>
<property name="toOneReferences" value="LIKE_ATTRIBUTES"/>
</mappingStrategy>

<dbAdapter name="derby-embedded"/>
<dataSource class="org.apache.derby.jdbc.EmbeddedDataSource"
databaseName="/temp/cdodb1"
createDatabase="create"/>
</store>
</repository>

</cdoServer>

============================================================ ===

Exception
---------
[INFO] CDO Server starting
[ERROR] SQL Exception: Failed to create database '/temp/cdodb1', see the
next exception for details.
org.eclipse.net4j.db.DBException: SQL Exception: Failed to create
database '/temp/cdodb1', see the next exception for details.
at
org.eclipse.net4j.internal.db.DataSourceConnectionProvider.g etConnection(DataSourceConnectionProvider.java:46)
at
org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection (DBStore.java:180)
at
org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DB Store.java:230)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:65)
at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:94)
at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:84)
at
org.eclipse.emf.cdo.internal.server.Repository.doActivate(Re pository.java:581)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:65)
at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:94)
at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:84)
at
org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOSe rverUtil.java:73)
at
org.eclipse.emf.cdo.internal.server.RepositoryConfigurator.c onfigure(RepositoryConfigurator.java:83)
at
org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplicat ion.doStart(CDOServerApplication.java:51)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplicat ion.java:61)
at
org.eclipse.equinox.internal.app.EclipseAppHandle.run(Eclips eAppHandle.java:194)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .runApplication(EclipseAppLauncher.java:110)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .start(EclipseAppLauncher.java:79)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:368)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by: SQL Exception: Failed to create database '/temp/cdodb1', see
the next exception for details.
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(U nknown
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.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unkno wn Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unkno wn Source)
at
org.eclipse.net4j.internal.db.DataSourceConnectionProvider.g etConnection(DataSourceConnectionProvider.java:42)
... 26 more
Re: [CDO] SQL Exception: Failed to create database [message #431916 is a reply to message #431914] Wed, 29 July 2009 14:02 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: hamak.email.cz

Hi. I solved this error on linux by changing /temp/cdodb1 to
/tmp/cdodb1. So I guess you don't have the /temp/ directory. Either
create /temp/ or change it to something else in <dataSource>.

Ondrej Hamak

Ralph Kretzler napsal(a):
> Hello,
>
> I try to start the CDO Server. For that I followed the instructions of
> this tutorial ... http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
>
> But when I hit the run button I got an exception.
> I am using Mac OS X and the Eclipse Modelling Package. EMF 2.5 and CDO 2.0.
>
>
> Thanks,
> Ralph
>
>
> cdo-server.xml
> --------------
> <?xml version="1.0" encoding="UTF-8"?>
> <cdoServer>
>
> <!--acceptor type="http"/ -->
>
> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
> <!-- negotiator type="challenge" description="/temp/users.db"/ -->
> </acceptor>
>
> <repository name="repo1">
> <property name="overrideUUID"
> value="1ff5d226-b1f0-40fb-aba2-0c31b38c764f"/>
> <property name="supportingAudits" value="true"/>
> <property name="verifyingRevisions" value="false"/>
> <property name="currentLRUCapacity" value="10000"/>
> <property name="revisedLRUCapacity" value="100"/>
>
> <store type="db">
> <mappingStrategy type="horizontal">
> <property name="qualifiedNames" value="false"/>
> <property name="toManyReferences"
> value="ONE_TABLE_PER_REFERENCE"/>
> <property name="toOneReferences" value="LIKE_ATTRIBUTES"/>
> </mappingStrategy>
>
> <dbAdapter name="derby-embedded"/>
> <dataSource class="org.apache.derby.jdbc.EmbeddedDataSource"
> databaseName="/temp/cdodb1"
> createDatabase="create"/>
> </store>
> </repository>
>
> </cdoServer>
>
> ============================================================ ===
>
> Exception
> ---------
> [INFO] CDO Server starting
> [ERROR] SQL Exception: Failed to create database '/temp/cdodb1', see the
> next exception for details.
> org.eclipse.net4j.db.DBException: SQL Exception: Failed to create
> database '/temp/cdodb1', see the next exception for details.
> at
> org.eclipse.net4j.internal.db.DataSourceConnectionProvider.g etConnection(DataSourceConnectionProvider.java:46)
>
> at
> org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection (DBStore.java:180)
>
> at
> org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DB Store.java:230)
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:65)
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:94)
>
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:84)
>
> at
> org.eclipse.emf.cdo.internal.server.Repository.doActivate(Re pository.java:581)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:65)
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:94)
>
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:84)
>
> at
> org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOSe rverUtil.java:73)
>
> at
> org.eclipse.emf.cdo.internal.server.RepositoryConfigurator.c onfigure(RepositoryConfigurator.java:83)
>
> at
> org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplicat ion.doStart(CDOServerApplication.java:51)
>
> at
> org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplicat ion.java:61)
> at
> org.eclipse.equinox.internal.app.EclipseAppHandle.run(Eclips eAppHandle.java:194)
>
> at
> org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .runApplication(EclipseAppLauncher.java:110)
>
> at
> org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .start(EclipseAppLauncher.java:79)
>
> at
> org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:368)
>
> at
> org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:179)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 559)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
> Caused by: SQL Exception: Failed to create database '/temp/cdodb1', see
> the next exception for details.
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(U nknown 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.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unkno wn
> Source)
> at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unkno wn
> Source)
> at
> org.eclipse.net4j.internal.db.DataSourceConnectionProvider.g etConnection(DataSourceConnectionProvider.java:42)
>
> ... 26 more
Re: [CDO] SQL Exception: Failed to create database [message #431926 is a reply to message #431916] Wed, 29 July 2009 17:02 Go to previous message
Eclipse UserFriend
Originally posted by: ralph.kretzler.gmail.com

ohh, so simple ... it works also under Mac OS X.

Thanks a lot,
Ralph

Ondrej Hamak schrieb:
> Hi. I solved this error on linux by changing /temp/cdodb1 to
> /tmp/cdodb1. So I guess you don't have the /temp/ directory. Either
> create /temp/ or change it to something else in <dataSource>.
>
> Ondrej Hamak
>
> Ralph Kretzler napsal(a):
>> Hello,
>>
>> I try to start the CDO Server. For that I followed the instructions of
>> this tutorial ...
>> http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
>>
>> But when I hit the run button I got an exception.
>> I am using Mac OS X and the Eclipse Modelling Package. EMF 2.5 and CDO
>> 2.0.
>>
>>
>> Thanks,
>> Ralph
>>
>>
>> cdo-server.xml
>> --------------
>> <?xml version="1.0" encoding="UTF-8"?>
>> <cdoServer>
>> <!--acceptor type="http"/ -->
>> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
>> <!-- negotiator type="challenge" description="/temp/users.db"/
>> -->
>> </acceptor>
>> <repository name="repo1">
>> <property name="overrideUUID"
>> value="1ff5d226-b1f0-40fb-aba2-0c31b38c764f"/>
>> <property name="supportingAudits" value="true"/>
>> <property name="verifyingRevisions" value="false"/>
>> <property name="currentLRUCapacity" value="10000"/>
>> <property name="revisedLRUCapacity" value="100"/>
>> <store type="db">
>> <mappingStrategy type="horizontal">
>> <property name="qualifiedNames" value="false"/>
>> <property name="toManyReferences"
>> value="ONE_TABLE_PER_REFERENCE"/>
>> <property name="toOneReferences"
>> value="LIKE_ATTRIBUTES"/>
>> </mappingStrategy>
>> <dbAdapter name="derby-embedded"/>
>> <dataSource class="org.apache.derby.jdbc.EmbeddedDataSource"
>> databaseName="/temp/cdodb1"
>> createDatabase="create"/>
>> </store>
>> </repository>
>> </cdoServer>
>>
>> ============================================================ ===
>>
>> Exception
>> ---------
>> [INFO] CDO Server starting
>> [ERROR] SQL Exception: Failed to create database '/temp/cdodb1', see
>> the next exception for details.
>> org.eclipse.net4j.db.DBException: SQL Exception: Failed to create
>> database '/temp/cdodb1', see the next exception for details.
>> at
>> org.eclipse.net4j.internal.db.DataSourceConnectionProvider.g etConnection(DataSourceConnectionProvider.java:46)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection (DBStore.java:180)
>>
>> at
>> org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DB Store.java:230)
>>
>> at
>> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:65)
>> at
>> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:94)
>>
>> at
>> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:84)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.Repository.doActivate(Re pository.java:581)
>>
>> at
>> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:65)
>> at
>> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:94)
>>
>> at
>> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:84)
>>
>> at
>> org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOSe rverUtil.java:73)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.RepositoryConfigurator.c onfigure(RepositoryConfigurator.java:83)
>>
>> at
>> org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplicat ion.doStart(CDOServerApplication.java:51)
>>
>> at
>> org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplicat ion.java:61)
>> at
>> org.eclipse.equinox.internal.app.EclipseAppHandle.run(Eclips eAppHandle.java:194)
>>
>> at
>> org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .runApplication(EclipseAppLauncher.java:110)
>>
>> at
>> org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .start(EclipseAppLauncher.java:79)
>>
>> at
>> org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:368)
>>
>> at
>> org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:179)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
>>
>> at java.lang.reflect.Method.invoke(Method.java:585)
>> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 559)
>> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
>> at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
>> at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
>> Caused by: SQL Exception: Failed to create database '/temp/cdodb1',
>> see the next exception for details.
>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(U nknown
>> 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.jdbc.Driver30.getNewEmbedConnection(Unknown
>> Source)
>> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>> at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unkno wn
>> Source)
>> at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unkno wn
>> Source)
>> at
>> org.eclipse.net4j.internal.db.DataSourceConnectionProvider.g etConnection(DataSourceConnectionProvider.java:42)
>>
>> ... 26 more
Previous Topic:Dynamic subclassing of static model classes
Next Topic:EMF generics and Rational Rose
Goto Forum:
  


Current Time: Mon Dec 09 07:38:59 GMT 2019

Powered by FUDForum. Page generated in 0.01587 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top