Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] Table CDO_COMMIT_INFOS uses Derby reserved word 'user' as column name
[CDO] Table CDO_COMMIT_INFOS uses Derby reserved word 'user' as column name [message #512894] Mon, 08 February 2010 10:09 Go to next message
Bjoern Sundin is currently offline Bjoern SundinFriend
Messages: 47
Registered: July 2009
Member
Using CDO HEAD and starting a CDO server with a DBStore and a Derby database throws following exception during initiation:

org.eclipse.net4j.db.DBException: Table/View 'CDO_COMMIT_INFOS' does not exist.
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.j ava:428)
at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.jav a:144)
at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.ja va:109)
at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:106)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DB Store.java:261)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:70)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:98)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:88)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Re pository.java:941)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:70)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:98)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:88)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOSe rverUtil.java:89)
at org.eclipse.emf.cdo.internal.server.RepositoryConfigurator.c onfigure(RepositoryConfigurator.java:93)
at ch.bergauer.rcp.amset.server.application.AmsetServer.doStart (AmsetServer.java:102)
at ch.bergauer.rcp.amset.server.application.ApplicationWorkbenc hWindowAdvisor$1.run(ApplicationWorkbenchWindowAdvisor.java: 89)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr onizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav a:3959)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3580)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:2407)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2371)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:22 20)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault (Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:149)
at ch.bergauer.rcp.amset.server.application.Application.start(A pplication.java:20)
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:367)
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:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 611)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:566)
at org.eclipse.equinox.launcher.Main.run(Main.java:1363)
at org.eclipse.equinox.launcher.Main.main(Main.java:1339)

The traces show the real problem of this:
main [debug.sql] CREATE TABLE cdo_objects (cdo_id BIGINT, cdo_class BIGINT)
main [debug.sql] CREATE UNIQUE INDEX cdo_objects_idx0 ON cdo_objects (cdo_id)
main [debug.sql] CREATE TABLE cdo_branches (id INTEGER, name VARCHAR(255), base_id INTEGER, base_time BIGINT)
main [debug.sql] CREATE INDEX cdo_branches_idx0 ON cdo_branches (id)
main [debug.sql] CREATE INDEX cdo_branches_idx1 ON cdo_branches (timestamp)
main [debug.sql] -- 'TIMESTAMP' is not a column in table or VTI 'CDO_BRANCHES'.
main [debug.sql] CREATE TABLE cdo_package_units (id VARCHAR(255), original_type INTEGER, time_stamp BIGINT, package_data BLOB)
main [debug.sql] CREATE INDEX cdo_package_units_idx0 ON cdo_package_units (id)
main [debug.sql] CREATE TABLE cdo_package_infos (uri VARCHAR(255), parent VARCHAR(255), unit VARCHAR(255), meta_lb BIGINT, meta_ub
BIGINT)
main [debug.sql] CREATE INDEX cdo_package_infos_idx0 ON cdo_package_infos (uri)
main [debug.sql] CREATE INDEX cdo_package_infos_idx1 ON cdo_package_infos (parent)
main [debug.sql] CREATE INDEX cdo_package_infos_idx2 ON cdo_package_infos (unit)
main [debug.sql] CREATE TABLE cdo_external_refs (id BIGINT, uri VARCHAR(255))
main [debug.sql] CREATE INDEX cdo_external_refs_idx0 ON cdo_external_refs (id)
main [debug.sql] CREATE INDEX cdo_external_refs_idx1 ON cdo_external_refs (uri)
main [debug.sql] CREATE TABLE cdo_commit_infos (timestamp BIGINT, branch INTEGER, user VARCHAR(255), comment VARCHAR(255))
main [debug.sql] -- Syntax error: Encountered "user" at line 1, column 66.

According to the Derby documentation user is a reserved word and can only be used if surrounded by quotes.
Reference: http://db.apache.org/derby/docs/10.5/ref/rrefkeywords29722.h tml

Should I file a Bugzilla for this?

Cheers
Bjoern
Re: [CDO] Table CDO_COMMIT_INFOS uses Derby reserved word 'user' as column name [message #512944 is a reply to message #512894] Mon, 08 February 2010 12:03 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6690
Registered: July 2009
Senior Member
Hi Bjoern,

Good catch. Please file a bugzilla.

Cheers
/Eike


Am 08.02.2010 11:09, schrieb Bjoern Sundin:
> Using CDO HEAD and starting a CDO server with a DBStore and a Derby database throws following exception during initiation:
>
> org.eclipse.net4j.db.DBException: Table/View 'CDO_COMMIT_INFOS' does not exist.
> at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.j ava:428)
> at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.jav a:144)
> at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.ja va:109)
> at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:106)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DB Store.java:261)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:70)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:98)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:88)
> at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Re pository.java:941)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:70)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:98)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:88)
> at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOSe rverUtil.java:89)
> at org.eclipse.emf.cdo.internal.server.RepositoryConfigurator.c onfigure(RepositoryConfigurator.java:93)
> at ch.bergauer.rcp.amset.server.application.AmsetServer.doStart (AmsetServer.java:102)
> at ch.bergauer.rcp.amset.server.application.ApplicationWorkbenc hWindowAdvisor$1.run(ApplicationWorkbenchWindowAdvisor.java: 89)
> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr onizer.java:134)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav a:3959)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3580)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:2407)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2371)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:22 20)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault (Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:493)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:149)
> at ch.bergauer.rcp.amset.server.application.Application.start(A pplication.java:20)
> 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:367)
> 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:597)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 611)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:566)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1363)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1339)
>
> The traces show the real problem of this:
> main [debug.sql] CREATE TABLE cdo_objects (cdo_id BIGINT, cdo_class BIGINT)
> main [debug.sql] CREATE UNIQUE INDEX cdo_objects_idx0 ON cdo_objects (cdo_id)
> main [debug.sql] CREATE TABLE cdo_branches (id INTEGER, name VARCHAR(255), base_id INTEGER, base_time BIGINT)
> main [debug.sql] CREATE INDEX cdo_branches_idx0 ON cdo_branches (id)
> main [debug.sql] CREATE INDEX cdo_branches_idx1 ON cdo_branches (timestamp)
> main [debug.sql] -- 'TIMESTAMP' is not a column in table or VTI 'CDO_BRANCHES'.
> main [debug.sql] CREATE TABLE cdo_package_units (id VARCHAR(255), original_type INTEGER, time_stamp BIGINT, package_data BLOB)
> main [debug.sql] CREATE INDEX cdo_package_units_idx0 ON cdo_package_units (id)
> main [debug.sql] CREATE TABLE cdo_package_infos (uri VARCHAR(255), parent VARCHAR(255), unit VARCHAR(255), meta_lb BIGINT, meta_ub
> BIGINT)
> main [debug.sql] CREATE INDEX cdo_package_infos_idx0 ON cdo_package_infos (uri)
> main [debug.sql] CREATE INDEX cdo_package_infos_idx1 ON cdo_package_infos (parent)
> main [debug.sql] CREATE INDEX cdo_package_infos_idx2 ON cdo_package_infos (unit)
> main [debug.sql] CREATE TABLE cdo_external_refs (id BIGINT, uri VARCHAR(255))
> main [debug.sql] CREATE INDEX cdo_external_refs_idx0 ON cdo_external_refs (id)
> main [debug.sql] CREATE INDEX cdo_external_refs_idx1 ON cdo_external_refs (uri)
> main [debug.sql] CREATE TABLE cdo_commit_infos (timestamp BIGINT, branch INTEGER, user VARCHAR(255), comment VARCHAR(255))
> main [debug.sql] -- Syntax error: Encountered "user" at line 1, column 66.
>
> According to the Derby documentation user is a reserved word and can only be used if surrounded by quotes.
> Reference: http://db.apache.org/derby/docs/10.5/ref/rrefkeywords29722.h tml
>
> Should I file a Bugzilla for this?
>
> Cheers
> Bjoern
>
>
>


Re: [CDO] Table CDO_COMMIT_INFOS uses Derby reserved word 'user' as column name [message #512952 is a reply to message #512944] Mon, 08 February 2010 12:23 Go to previous message
Bjoern Sundin is currently offline Bjoern SundinFriend
Messages: 47
Registered: July 2009
Member
Filed Bug 302124

/Bjoern

"Eike Stepper" <stepper@esc-net.de> schrieb im Newsbeitrag news:hkouio$okj$1@build.eclipse.org...
> Hi Bjoern,
>
> Good catch. Please file a bugzilla.
>
> Cheers
> /Eike
>
>
> Am 08.02.2010 11:09, schrieb Bjoern Sundin:
>> Using CDO HEAD and starting a CDO server with a DBStore and a Derby database throws following exception during initiation:
>>
>> org.eclipse.net4j.db.DBException: Table/View 'CDO_COMMIT_INFOS' does not exist.
>> at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.j ava:428)
>> at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.jav a:144)
>> at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.ja va:109)
>> at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:106)
>> at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DB Store.java:261)
>> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:70)
>> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:98)
>> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:88)
>> at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Re pository.java:941)
>> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycl e.java:70)
>> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:98)
>> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(Life cycleUtil.java:88)
>> at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOSe rverUtil.java:89)
>> at org.eclipse.emf.cdo.internal.server.RepositoryConfigurator.c onfigure(RepositoryConfigurator.java:93)
>> at ch.bergauer.rcp.amset.server.application.AmsetServer.doStart (AmsetServer.java:102)
>> at ch.bergauer.rcp.amset.server.application.ApplicationWorkbenc hWindowAdvisor$1.run(ApplicationWorkbenchWindowAdvisor.java: 89)
>> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
>> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr onizer.java:134)
>> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav a:3959)
>> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3580)
>> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:2407)
>> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2371)
>> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:22 20)
>> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
>> at org.eclipse.core.databinding.observable.Realm.runWithDefault (Realm.java:332)
>> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:493)
>> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:149)
>> at ch.bergauer.rcp.amset.server.application.Application.start(A pplication.java:20)
>> 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:367)
>> 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:597)
>> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 611)
>> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:566)
>> at org.eclipse.equinox.launcher.Main.run(Main.java:1363)
>> at org.eclipse.equinox.launcher.Main.main(Main.java:1339)
>>
>> The traces show the real problem of this:
>> main [debug.sql] CREATE TABLE cdo_objects (cdo_id BIGINT, cdo_class BIGINT)
>> main [debug.sql] CREATE UNIQUE INDEX cdo_objects_idx0 ON cdo_objects (cdo_id)
>> main [debug.sql] CREATE TABLE cdo_branches (id INTEGER, name VARCHAR(255), base_id INTEGER, base_time BIGINT)
>> main [debug.sql] CREATE INDEX cdo_branches_idx0 ON cdo_branches (id)
>> main [debug.sql] CREATE INDEX cdo_branches_idx1 ON cdo_branches (timestamp)
>> main [debug.sql] -- 'TIMESTAMP' is not a column in table or VTI 'CDO_BRANCHES'.
>> main [debug.sql] CREATE TABLE cdo_package_units (id VARCHAR(255), original_type INTEGER, time_stamp BIGINT, package_data BLOB)
>> main [debug.sql] CREATE INDEX cdo_package_units_idx0 ON cdo_package_units (id)
>> main [debug.sql] CREATE TABLE cdo_package_infos (uri VARCHAR(255), parent VARCHAR(255), unit VARCHAR(255), meta_lb BIGINT,
>> meta_ub
>> BIGINT)
>> main [debug.sql] CREATE INDEX cdo_package_infos_idx0 ON cdo_package_infos (uri)
>> main [debug.sql] CREATE INDEX cdo_package_infos_idx1 ON cdo_package_infos (parent)
>> main [debug.sql] CREATE INDEX cdo_package_infos_idx2 ON cdo_package_infos (unit)
>> main [debug.sql] CREATE TABLE cdo_external_refs (id BIGINT, uri VARCHAR(255))
>> main [debug.sql] CREATE INDEX cdo_external_refs_idx0 ON cdo_external_refs (id)
>> main [debug.sql] CREATE INDEX cdo_external_refs_idx1 ON cdo_external_refs (uri)
>> main [debug.sql] CREATE TABLE cdo_commit_infos (timestamp BIGINT, branch INTEGER, user VARCHAR(255), comment VARCHAR(255))
>> main [debug.sql] -- Syntax error: Encountered "user" at line 1, column 66.
>>
>> According to the Derby documentation user is a reserved word and can only be used if surrounded by quotes.
>> Reference: http://db.apache.org/derby/docs/10.5/ref/rrefkeywords29722.h tml
>>
>> Should I file a Bugzilla for this?
>>
>> Cheers
>> Bjoern
>>
>>
>>
Previous Topic:EMF 2.1 with Eclipse 3.1 compatiblity
Next Topic:Create diagram for metamodel not in workspace but in EMF registry
Goto Forum:
  


Current Time: Thu Sep 19 08:05:05 GMT 2024

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

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

Back to the top