Configure DM with MSSQL server
------------------------------
Key: NXP-4883
URL: https://jira.nuxeo.org/browse/NXP-4883
Project: Nuxeo Enterprise Platform
Issue Type: Problem
Environment: windows 2003 server sp2, MSSQL 2005 server , Nuxeo DM 5.3
Reporter: Amjad Karmi
Priority: Critical
I am trying to setup Nuxeo DM to work with MSSQL server. the
NXP_LOGS_MAPEXTINFOS table could not be created
I was checking Nuxeo forum and I found a similar problem where
NXP_LOGS_MAPEXTINFOS table is not created automatically (don't know why) so I
did create manually
Nuxeo starts now without errors , but when importing any document like word
file I get error (it works only for picture jpeg files!!)
2010-03-09 15:47:48,937 ERROR [nuxeo-error-log] javax.servlet.ServletException:
org.hibernate.exception.GenericJDBCException: Cannot open connection
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
at
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
at
org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
following are my configuration files
default-repository-ds.xml
<connection-factories>
<tx-connection-factory>
<jndi-name>NXRepository/default</jndi-name>
<xa-transaction/>
<track-connection-by-tx/>
<adapter-display-name>Nuxeo SQL Repository
DataSource</adapter-display-name>
<rar-name>nuxeo.ear#nuxeo-core-storage-sql-ra-1.6.0.rar</rar-name>
<connection-definition>org.nuxeo.ecm.core.storage.sql.Repository</connection-definition>
<config-property name="name">default</config-property>
<config-property name="xaDataSource"
type="java.lang.String">net.sourceforge.jtds.jdbcx.JtdsDataSource</config-property>
<config-property name="property"
type="java.lang.String">ServerName=localhost</config-property>
<config-property name="property"
type="java.lang.String">PortNumber=1558</config-property>
<config-property name="property"
type="java.lang.String">DatabaseName=nuxeo</config-property>
<config-property name="property"
type="java.lang.String">User=sa</config-property>
<config-property name="property"
type="java.lang.String">Password=nuxeo</config-property>
<max-pool-size>20</max-pool-size>
</tx-connection-factory>
</connection-factories>
unified-nuxeo-ds.xml
<xa-datasource>
<jndi-name>NuxeoDS</jndi-name>
<xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
<xa-datasource-property name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">1558</xa-datasource-property>
<xa-datasource-property name="DatabaseName">nuxeo</xa-datasource-property>
<xa-datasource-property name="User">sa</xa-datasource-property>
<xa-datasource-property name="Password">nuxeo</xa-datasource-property>
<track-connection-by-tx/>
</xa-datasource>
nxtags-ds.xml
<datasources>
<xa-datasource>
<jndi-name>nxtags</jndi-name>
<xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
<xa-datasource-property name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">1558</xa-datasource-property>
<xa-datasource-property name="DatabaseName">nuxeo</xa-datasource-property>
<xa-datasource-property name="User">sa</xa-datasource-property>
<xa-datasource-property name="Password">nuxeo</xa-datasource-property>
<track-connection-by-tx/>
</xa-datasource>
</datasources>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
