Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] Microsoft SQL does not create Tables
[CDO] Microsoft SQL does not create Tables [message #1392330] Wed, 02 July 2014 07:03 Go to next message
Samuel Leisering is currently offline Samuel LeiseringFriend
Messages: 34
Registered: July 2014
Member
Hi

I tried to use the DBAdapter provided by Thomas Schindl (https://www.eclipse.org/forums/index.php/mv/msg/446871/998288/#msg_998288). On Startup i get the following error (For those who dont know german, it says "invalid objectname"):

org.eclipse.net4j.util.lifecycle.LifecycleException: java.sql.SQLException: Ungültiger Objektname 'CDO_PROPERTIES'.

       at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:104)

       at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)

       at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)

       at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)

       at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1980)

       at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)

       at org.eclipse.net4j.util.lifecycle.ShareableLifecycle.internalActivate(ShareableLifecycle.java:43)

       at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)

       at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)

       at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)

       at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:291)

       at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:116)

       at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)

       at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)

       at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

       at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)

       at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: Ungültiger Objektname 'CDO_PROPERTIES'.

       at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

       at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)

       at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)

       at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)

       at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)

       at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)

       at org.eclipse.emf.cdo.server.internal.db.DBStore.selectSchemaVersion(DBStore.java:842)

       at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:607)

       at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)

       ... 16 more


CDO does not create any tables in the database. I connect with a user and password, with sufficient permissions to create tables. I also tested the official JDBC driver by microsoft instead of JTDS, but got the same error. When i create the CDO_PROPERTIES table by hand, CDO complains about missing columns, so it seems that CDO connects successfully to the database.

Any ideas?
Re: [CDO] Microsoft SQL does not create Tables [message #1392535 is a reply to message #1392330] Wed, 02 July 2014 13:24 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6447
Registered: July 2009
Senior Member
Hi Samuel,

Have you already asked Tom Schindl?

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper



Am 02.07.2014 14:29, schrieb Samuel Leisering:
> Hi
>
> I tried to use the DBAdapter provided by Thomas Schindl
> (https://www.eclipse.org/forums/index.php/mv/msg/446871/998288/#msg_998288). On Startup i get the following error (For
> those who dont know german, it says "invalid objectname"):
>
>
> org.eclipse.net4j.util.lifecycle.LifecycleException: java.sql.SQLException: Ungültiger Objektname 'CDO_PROPERTIES'.
>
> at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:104)
>
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
>
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
>
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
>
> at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1980)
>
> at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
>
> at org.eclipse.net4j.util.lifecycle.ShareableLifecycle.internalActivate(ShareableLifecycle.java:43)
>
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
>
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
>
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
>
> at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:291)
>
> at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:116)
>
> at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
>
> at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
>
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
>
> at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
>
> at java.lang.Thread.run(Unknown Source)
>
> Caused by: java.sql.SQLException: Ungültiger Objektname 'CDO_PROPERTIES'.
>
> at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
>
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
>
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
>
> at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
>
> at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
>
> at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
>
> at org.eclipse.emf.cdo.server.internal.db.DBStore.selectSchemaVersion(DBStore.java:842)
>
> at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:607)
>
> at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
>
> ... 16 more
>
>
> CDO does not create any tables in the database. I connect with a user and password, with sufficient permissions to
> create tables. I also tested the official JDBC driver by microsoft instead of JTDS, but got the same error. When i
> create the CDO_PROPERTIES table by hand, CDO complains about missing columns, so it seems that CDO connects
> successfully to the database.
>
> Any ideas?


Re: [CDO] Microsoft SQL does not create Tables [message #1392607 is a reply to message #1392535] Wed, 02 July 2014 15:28 Go to previous messageGo to next message
Samuel Leisering is currently offline Samuel LeiseringFriend
Messages: 34
Registered: July 2014
Member
No, i thought this would be the place to do that.
Re: [CDO] Microsoft SQL does not create Tables [message #1392669 is a reply to message #1392607] Wed, 02 July 2014 17:23 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6447
Registered: July 2009
Senior Member
Am 02.07.2014 17:28, schrieb Samuel Leisering:
> No, i thought this would be the place to do that.
It's certainly not forbidden to ask any kind of EMF-related question here ;-)

You prefixed your question with [CDO] and I wasn't sure if Tom reads each CDO question here.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


Re: [CDO] Microsoft SQL does not create Tables [message #1395867 is a reply to message #1392669] Mon, 07 July 2014 14:09 Go to previous messageGo to next message
Samuel Leisering is currently offline Samuel LeiseringFriend
Messages: 34
Registered: July 2014
Member
Ok, the Problem was that the adapter did not implement the is*Exception
methods and CDO did not understand that the tables were missing.

Greetings,
Samuel

On 02.07.2014 19:23, Eike Stepper wrote:
> Am 02.07.2014 17:28, schrieb Samuel Leisering:
>> No, i thought this would be the place to do that.
> It's certainly not forbidden to ask any kind of EMF-related question
> here ;-)
>
> You prefixed your question with [CDO] and I wasn't sure if Tom reads
> each CDO question here.
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
Re: [CDO] Microsoft SQL does not create Tables [message #1396460 is a reply to message #1395867] Tue, 08 July 2014 10:24 Go to previous message
Thomas Schindl is currently offline Thomas SchindlFriend
Messages: 6505
Registered: July 2009
Senior Member
If you have a patch we would certainly apply it to our code base ;-)

Tom

On 07.07.14 16:09, Samuel Leisering wrote:
> Ok, the Problem was that the adapter did not implement the is*Exception
> methods and CDO did not understand that the tables were missing.
>
> Greetings,
> Samuel
>
> On 02.07.2014 19:23, Eike Stepper wrote:
>> Am 02.07.2014 17:28, schrieb Samuel Leisering:
>>> No, i thought this would be the place to do that.
>> It's certainly not forbidden to ask any kind of EMF-related question
>> here ;-)
>>
>> You prefixed your question with [CDO] and I wasn't sure if Tom reads
>> each CDO question here.
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>
>
Previous Topic:CDO Usage with Oracle
Next Topic:[EMF] Change-Notifications in ItemProviders
Goto Forum:
  


Current Time: Tue Oct 22 21:57:45 GMT 2019

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

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

Back to the top