Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 313709

Summary: [DB] Repository does not start up when PostgreSQL is used
Product: [Modeling] EMF Reporter: Stefan Winkler <stefan>
Component: cdo.dbAssignee: Stefan Winkler <stefan>
Status: CLOSED FIXED QA Contact: Eike Stepper <stepper>
Severity: normal    
Priority: P3    
Version: 3.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:
Attachments:
Description Flags
patch none

Description Stefan Winkler CLA 2010-05-20 08:25:32 EDT 
org.eclipse.emf.cdo.tests.config.impl.ConfigTestException: Error in Net4jDBTest.testBit [Combined, PostgreSQL, JVM, Native]
	at org.eclipse.emf.cdo.tests.config.impl.ConfigTest.runBare(ConfigTest.java:431)
	at junit.framework.TestResult$1.protect(TestResult.java:110)
	at junit.framework.TestResult.runProtected(TestResult.java:128)
	at junit.framework.TestResult.run(TestResult.java:113)
	at junit.framework.TestCase.run(TestCase.java:124)
	at org.eclipse.net4j.util.tests.AbstractOMTest.run(AbstractOMTest.java:146)
	at junit.framework.TestSuite.runTest(TestSuite.java:232)
	at org.eclipse.emf.cdo.tests.config.impl.ConfigTestSuite$TestWrapper.runTest(ConfigTestSuite.java:126)
	at junit.framework.TestSuite.run(TestSuite.java:227)
	at junit.framework.TestSuite.runTest(TestSuite.java:232)
	at junit.framework.TestSuite.run(TestSuite.java:227)
	at junit.framework.TestSuite.runTest(TestSuite.java:232)
	at junit.framework.TestSuite.run(TestSuite.java:227)
	at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.eclipse.net4j.db.DBException: FEHLER: Relation »cdo_properties« existiert nicht
	at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:423)
	at org.eclipse.net4j.db.postgresql.PostgreSQLAdapter.createTable(PostgreSQLAdapter.java:164)
	at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:109)
	at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:106)
	at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:442)
	at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
	at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:98)
	at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:88)
	at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1276)
	at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
	at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:98)
	at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:88)
	at org.eclipse.emf.cdo.tests.config.impl.RepositoryConfig.getRepository(RepositoryConfig.java:114)
	at org.eclipse.emf.cdo.tests.config.impl.RepositoryConfig.setUp(RepositoryConfig.java:143)
	at org.eclipse.emf.cdo.tests.db.DBStoreRepositoryConfig.setUp(DBStoreRepositoryConfig.java:50)
	at org.eclipse.emf.cdo.tests.config.impl.Scenario.setUp(Scenario.java:191)
	at org.eclipse.emf.cdo.tests.config.impl.ConfigTest.doSetUp(ConfigTest.java:512)
	at org.eclipse.emf.cdo.tests.AbstractCDOTest.doSetUp(AbstractCDOTest.java:46)
	at org.eclipse.net4j.util.tests.AbstractOMTest.setUp(AbstractOMTest.java:90)
	at org.eclipse.emf.cdo.tests.config.impl.ConfigTest.setUp(ConfigTest.java:505)
	at junit.framework.TestCase.runBare(TestCase.java:132)
	at org.eclipse.net4j.util.tests.AbstractOMTest.runBare(AbstractOMTest.java:124)
	at org.eclipse.emf.cdo.tests.config.impl.ConfigTest.runBare(ConfigTest.java:422)
	... 18 more
Comment 1 Stefan Winkler CLA 2010-05-20 08:27:28 EDT 
Problem is that PostgreSQL does not know the LONG VARCHAR type.
-> Added LONGVARCHAR -> TEXT type adaption
Comment 2 Stefan Winkler CLA 2010-05-20 08:28:11 EDT 
Created attachment 169324 [details]
patch
Comment 3 Stefan Winkler CLA 2010-05-20 08:28:24 EDT 
Committed to HEAD
Comment 4 Eike Stepper CLA 2010-06-29 04:36:08 EDT 
Available in 3.0 GA:
http://download.eclipse.org/modeling/emf/cdo/updates/3.0-releases/