[gatein-issues] [JBoss JIRA] Created: (GTNPORTAL-563) Unable to use SQLServer 2008

[Kevin Seegmiller (JIRA)]

Unable to use SQLServer 2008
----------------------------

                 Key: GTNPORTAL-563
                 URL: https://jira.jboss.org/jira/browse/GTNPORTAL-563
             Project: GateIn Portal
          Issue Type: Bug
    Affects Versions: 3.0.0-Beta05
         Environment: GateIn beta 5 on a SQLServer 2008 using the SQLServer JDBC Driver 2.0 sqljdbc4.jar
            Reporter: Kevin Seegmiller


I am running into some issues trying to use GateIn with SQLServer 2008.  I made the following configuration changes according to a wiki post for mysql, but I am getting the following error.


database-configuration.xml

    <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
    <property name="url" value="jdbc:sqlserver://phx-kevins3:1433;DatabaseName=carefx;selectMethod=direct"/>
    <property name="username" value="carefx"/>
    <property name="password" value=""/>

 

jcr-configuration.xml

     <property name="dialect" value="sqlserver"/>


repository-configuration.xml

      <property name="dialect" value="sqlserver"/>

 

 

I am getting the following error:

 

SEVERE: Cannot create the portal container 'portal' . ServletContext: org.apache

.catalina.core.ApplicationContextFacade at e8c7db

org.picocontainer.PicoIntrospectionException: Failed when calling start on org.e

xoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl at 15e8aa5

        at org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor

.java:81)

        at org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.ja

va:113)

        at org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoCont

...

Caused by: java.lang.RuntimeException: org.exoplatform.services.jcr.config.Repos

itoryConfigurationException: Database exception. com.microsoft.sqlserver.jdbc.SQ

LServerException: 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.RepositoryServiceConfigurati

onImpl.start(RepositoryServiceConfigurationImpl.java:282)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

 



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira