Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 313709 - [DB] Repository does not start up when PostgreSQL is used
Summary: [DB] Repository does not start up when PostgreSQL is used
Status: CLOSED FIXED
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.db (show other bugs)
Version: 3.0   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Stefan Winkler CLA
QA Contact: Eike Stepper CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-05-20 08:25 EDT by Stefan Winkler CLA
Modified: 2010-06-29 04:36 EDT (History)
0 users

See Also:

Attachments
patch (806 bytes, patch)
2010-05-20 08:28 EDT, Stefan Winkler CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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/