1 Reply Latest reply on Apr 20, 2010 4:00 PM by Sully Zhang

    GateIn on mssql 2005

    Sully Zhang Newbie

      GateIn 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

        • 1. Re: GateIn on mssql 2005
          Sully Zhang Newbie

          add :

           

           

               <property name="hibernate.c3p0.min_size" value="5" />
                  <property name="hibernate.c3p0.max_size" value="20" />
                  <property name="hibernate.c3p0.timeout" value="1800" />
                  <property name="hibernate.c3p0.max_statements" value="50" />

           

          to idm-configuration.xml file around line 48.

           

          just slove the "BLOB".