Eclipse Community Forums: EMF » [CDO] Microsoft SQL does not create Tables

Help

Home

Home » Modeling » EMF » [CDO] Microsoft SQL does not create Tables

Show: Today's Messages :: Show Polls :: Message Navigator

[CDO] Microsoft SQL does not create Tables [message #1392330]

Wed, 02 July 2014 07:03

Samuel Leisering

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?

Report message to a moderator

Re: [CDO] Microsoft SQL does not create Tables [message #1392535 is a reply to message #1392330]

Wed, 02 July 2014 13:24

Eike Stepper

Messages: 6682
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?

Cheers
/Eike

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

Report message to a moderator

Re: [CDO] Microsoft SQL does not create Tables [message #1392607 is a reply to message #1392535]

Wed, 02 July 2014 15:28

Samuel Leisering

Messages: 34
Registered: July 2014

Member

No, i thought this would be the place to do that.

Report message to a moderator

Re: [CDO] Microsoft SQL does not create Tables [message #1392669 is a reply to message #1392607]

Wed, 02 July 2014 17:23

Eike Stepper

Messages: 6682
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

Cheers
/Eike

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

Report message to a moderator

Re: [CDO] Microsoft SQL does not create Tables [message #1395867 is a reply to message #1392669]

Mon, 07 July 2014 14:09

Samuel Leisering

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
>
>
>

Report message to a moderator

Re: [CDO] Microsoft SQL does not create Tables [message #1396460 is a reply to message #1395867]

Tue, 08 July 2014 10:24

Thomas Schindl

Messages: 6651
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
>>
>>
>>
>

Report message to a moderator

Previous Topic:	CDO Usage with Oracle
Next Topic:	[EMF] Change-Notifications in ItemProviders

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 10:09:17 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter