GateIn on mssql 2005
yelan_gatein Apr 20, 2010 1:08 PMGateIn Portal GateIn-3.0.0-GA
MS-SQL Server 2005
if edit jboss\server\default\conf\gatein\configuration.properties like:
# Data
gatein.data.dir=${jboss.server.data.dir}/gatein
# DB
gatein.db.data.dir=${gatein.data.dir}/db
# JCR
#gatein.jcr.config.type=local
gatein.jcr.datasource.name=jdbcjcr
gatein.jcr.datasource.type=Varbinary
gatein.jcr.datasource.dialect=org.hibernate.dialect.SQLServerDialect
gatein.jcr.datasource.driver=net.sourceforge.jtds.jdbc.Driver
gatein.jcr.datasource.url=jdbc:jtds:sqlserver://rivendell:1433/jdbcjcr_${name}
gatein.jcr.datasource.username=sa
gatein.jcr.datasource.password=l0g1le
gatein.jcr.data.dir=${gatein.data.dir}/jcr
gatein.jcr.storage.data.dir=${gatein.jcr.data.dir}/values
gatein.jcr.index.data.dir=${gatein.jcr.data.dir}/lucene
gatein.jcr.index.changefilterclass=org.exoplatform.services.jcr.impl.core.query.DefaultChangesFilter
# IDM
gatein.idm.datasource.name=jdbcidm
gatein.idm.datasource.type=Varbinary
gatein.idm.datasource.dialect=org.hibernate.dialect.SQLServerDialect
gatein.idm.datasource.driver=net.sourceforge.jtds.jdbc.Driver
gatein.idm.datasource.url=jdbc:jtds:sqlserver://rivendell:1433/jdbcidm_${name}
gatein.idm.datasource.username=sa
gatein.idm.datasource.password=l0g1le
# EMail
gatein.email.smtp.username=
gatein.email.smtp.password=
gatein.email.smtp.host=smtp.gmail.com
gatein.email.smtp.port=465
gatein.email.smtp.starttls.enable=true
gatein.email.smtp.auth=true
gatein.email.smtp.socketFactory.port=465
gatein.email.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
the jbossAS console : classnotfound :net.sourceforge.jtds.jdbc.Driver
even i put jtds-1.2.1.jar to every JbossAS lib folder......
if move the setup from configuration.properties to jcr-configuration.xml, repository-configuration.xml, idm-configuration.xml (jboss\server\default\deploy\gatein.ear\02portal.war\WEB-INF\conf) :
such as: replace "gatein.idm.datasource.driver" by "net.sourceforge.jtds.jdbc.Driver" in that three files.
the jbossAS console:
Caused by: org.exoplatform.services.jcr.config.RepositoryConfigurationException: Database exception. java.sql.SQLException: Column, parameter, or variable #2: Cannot find data type BLOB.. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME))
at org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.write(JDBCConfigurationPersister.java:385)
at org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.initFromStream(RepositoryServiceConfigurationImpl.java:224)
at org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.start(RepositoryServiceConfigurationImpl.java:256)
... 69 more
Caused by: java.sql.SQLException: Column, parameter, or variable #2: Cannot find data type BLOB.
Any replies are very helpful to me.
Thanks,
Sully