| [CDO] Microsoft SQL does not create Tables [message #1392330] |
Wed, 02 July 2014 03:03  |
Eclipse User |
|
|
|
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 #1396460 is a reply to message #1395867] |
Tue, 08 July 2014 06:24  |
| Eclipse User |
|
|
|
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
>>
>>
>>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03275 seconds
Home