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

[Luc Texier (JIRA)]

     [ https://jira.jboss.org/jira/browse/GTNPORTAL-563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luc Texier closed GTNPORTAL-563.
--------------------------------



> 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 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