-
1. Gatein with MaxDB
theute Feb 7, 2011 10:34 AM (in response to mjuergens)Yes, you could change to anything you want.
But we didn't test GateIn with MaxDB AFAIK, so you may want to give it a try.
If you don't have any portal container deployed (such as not having gatein-samples*), by default it will try to create "jdbcjcr" so that should fit with that limitation. You could try with that first.
-
2. Gatein with MaxDB
rraposa Feb 8, 2011 8:55 AM (in response to mjuergens)I think you can name your databases whatever you want. The "_portal" part of the name only applies to the JNDI name. You should be able to create the JCR database (using your choice of name), then point to that database using the appropritate JNDI name in your *-ds.xml file.
Michael - does that make sense?
-
3. Gatein with MaxDB
theute Feb 8, 2011 9:44 AM (in response to rraposa)Rich,
the community project isn't set to use managed datasource out of the box
-
4. Gatein with MaxDB
rraposa Feb 8, 2011 10:04 AM (in response to theute)I didn't realize that - good to know!
-
5. Gatein with MaxDB
mjuergens Feb 8, 2011 11:03 AM (in response to theute)Hi Thomas,
I´ve tried this.
Here is my config:
gatein.jcr.config.type=local
gatein.jcr.datasource.name=java:jdbcjcr
gatein.jcr.datasource.dialect=org.hibernate.dialect.SAPDBDialect
gatein.jcr.datasource.driver=com.sap.dbtech.jdbc.DriverSapDB
gatein.jcr.datasource.url=jdbc:sapdb://dbdev04.lg.xxx.de/jdbcjcr
gatein.jcr.datasource.username=xxx
gatein.jcr.datasource.password=xxx
So far so good. But one component does not accept the "gatein.jcr.datasource.dialect" property.
I´m not sure which component-configuration is faulty.
If I look at GateIn-3.1.0-GA/server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ all dialects are set to ${gatein.jcr.datasource.dialect}
Any help?
Best regards,
Michael
Here is the Stacktrace:
...
16:40:54,728 INFO [TRAXTemplatesServiceImpl] XSLT schema found by relative path: xslt/get-method.xsl
16:40:55,250 INFO [FileValueStorage] Directory created: /Users/michael/Work/Message-Mobile/JBoss/GateIn-3.1.0-GA/server/default/data/gatein/jcr/values/system
16:40:55,251 INFO [StandaloneStoragePluginProvider] Value Storage Plugin initialized org.exoplatform.services.jcr.impl.storage.value.fs.TreeFileValueStorage@1d68b01
16:40:55,300 INFO [JDBCWorkspaceDataContainer] Using a dialect 'Generic'
16:40:55,502 ERROR [JDBCWorkspaceDataContainer] Error of init db org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create db schema of DataSource: 'system'. Reason: [-5016] (at 38): Missing delimiter: ); . Last command: CREATE TABLE JCR_SVALUE( ID BIGINT generated by default as identity (START WITH 2, INCREMENT BY 1) NOT NULL, DATA VARBINARY(65535), ORDER_NUM INTEGER NOT NULL, PROPERTY_ID VARCHAR(96) NOT NULL, STORAGE_DESC VARCHAR(512), CONSTRAINT JCR_PK_SVALUE PRIMARY KEY(ID), CONSTRAINT JCR_FK_SVALUE_PROPERTY FOREIGN KEY(PROPERTY_ID) REFERENCES JCR_SITEM(ID) )
org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create db schema of DataSource: 'system'. Reason: [-5016] (at 38): Missing delimiter: ); . Last command: CREATE TABLE JCR_SVALUE( ID BIGINT generated by default as identity (START WITH 2, INCREMENT BY 1) NOT NULL, DATA VARBINARY(65535), ORDER_NUM INTEGER NOT NULL, PROPERTY_ID VARCHAR(96) NOT NULL, STORAGE_DESC VARCHAR(512), CONSTRAINT JCR_PK_SVALUE PRIMARY KEY(ID), CONSTRAINT JCR_FK_SVALUE_PROPERTY FOREIGN KEY(PROPERTY_ID) REFERENCES JCR_SITEM(ID) )
at org.exoplatform.services.jcr.impl.util.jdbc.DBInitializer.init(DBInitializer.java:376)
at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCWorkspaceDataContainer.initDatabase(CQJDBCWorkspaceDataContainer.java:252)
at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCWorkspaceDataContainer.<init>(JDBCWorkspaceDataContainer.java:394)
at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCWorkspaceDataContainer.<init>(CQJDBCWorkspaceDataContainer.java:73)
...
-
6. Gatein with MaxDB
theute Feb 8, 2011 2:06 PM (in response to mjuergens)The configuration expects a eXo JCR dialect name, and not an hibernate one (It is not using Hibernate).
MaxDB is actually not supported by eXo JCR and it tries to fallback to a generic RDBMS but seems to just fail.
We certify the product (EPP) against a set of database as described here:
http://www.jboss.com/products/platforms/portals/testedconfigurations/
SAP MaxDB isn't part of them