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

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 Assignee: Luc Texier 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@e8c7db org.picocontainer.PicoIntrospectionException: Failed when calling start on org.e xoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@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.