[
https://jira.nuxeo.org/browse/NXP-4883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alain Escaffre closed NXP-4883.
-------------------------------
Resolution: Not A Bug
> 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
> Attachments: nuxeo-error.log, server.log
>
>
> 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
