Hello,
Your configuration seems to be correct. Take care to only keep one
driver into JBoss directory (the opensource one).
Then, did you try to connect to http://localhost:8080/nuxeo/ ?
Do you have errors into C:\opt\jboss\server\default\log\server.log ?
Regards,
Julien
Ramon De Abreu a écrit :
Hi!
In my work environment i am supposed to set up Nuxeo DM 5.2 with
Microsoft SQL Server.
I have been able to successfully change the default Derby database to
MySQL and also to Postgres but i am having problems with MS SQL Server.
I supposed that the PostGres setup is basically similar to the MS SQL
server setup so i proceeded to do the same:
Current setup:
Platform: Windows XP
Nuxeo 5.2
MS SQL Server 2005
Jboss 4.2.3.GA <http://4.2.3.GA>
JDK 5.0
I have followed the following FAQ used to setup Postgres and applied
it to MS SQL Server:
*http://doc.nuxeo.org/xwiki/bin/view/FAQ/Nuxeo52VcsPostgreSQL*
Also, i have used the nuxeo-book-administration.pdf
I have tried installing MS SQL Server 2005 on the current machine that
i have Nuxeo and also on an another pc in the network.
I will comment first my experience with the other pc in the network.
I have downloaded the Microsoft SQL Server JDBC drivers
(sqljdbc_1.0.809.102_enu) and put it in the following directory:
$JBOSS_HOME\server\default\lib
I created a new database called *nuxeo* on the network pc.
I proceeded to use the Visible Content Store Configuration (i have not
tried the jackrabbit option).
I have modified the following files with what i think is the correct
configuration for MS SQL Server.
1) El contenido de *default-repository-config.xml*:
$JBOSS_HOME\server\default\deploy\nuxeo.ear\config
<?xml version="1.0"?>
<component name="org.nuxeo.ecm.core.storage.sql.config">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"
factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository name="default">
<indexing>
<!-- configuration MS SQL SERVERS -->
<fulltext catalog="nuxeo" analyzer="english"/>
</indexing>
</repository>
</repository>
</extension>
</component>
2) El contenido del *default-repository-ds.xml*
C:\opt\jboss\server\default\deploy\nuxeo.ear\datasources
<?xml version="1.0"?>
<!-- MICROSOFT SQL SERVER -->
<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.5.1-SNAPSHOT.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">com.microsoft.sqlserver.jdbc.SQLServerXADataSource</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=192.168.0.2</config-property>
<config-property name="property"
type="java.lang.String">PortNumber=1433</config-property>
<config-property name="property"
type="java.lang.String">DatabaseName=nuxeo</config-property>
<config-property name="property"
type="java.lang.String">User=ramon</config-property>
<config-property name="property"
type="java.lang.String">Password=admin</config-property>
<max-pool-size>20</max-pool-size>
</tx-connection-factory>
</connection-factories>
I have read somewhere in earlier posts that there has been problems
with the Microsoft JDBC drivers and that one should download the ones
from sourceforge (downloaded and installed .jar in same directory
as the microsoft JDBC one).
You can see that in the above file i have commented the version that
uses the Microsoft drivers in favour of the source forge.
And the same goes for the following files.
Of course, i have tried both cases and none of them work.
3) El contenido del fichero: *unified-nuxeo-ds.xml*
$JBOSS_HOME\server\default\deploy\nuxeo.ear\datasources
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<!-- DEFAULT UNIFIED DATASOURCE CONFIGURATION -->
<!--
This is the default unified datasource configuration. All
datasources from nuxeo
points to this datasource so it will use only 1 database.
To use another database than Derby, comment out the following
section and uncomment
your database configuration or add it if not present.
If you wish to use a different database for a service, comment out
the link in the relevant
xxx-ds.xml file and add a datasource configuration.
-->
<!-- Configuration for MS SQL SERVER -->
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>jdbc:jtds:sqlserver://192.168.0.2:1433/nuxeo;user=ramon;password=admin
<http://192.168.0.2:1433/nuxeo;user=ramon;password=admin>;</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<!--
<connection-url>jdbc:microsoft:sqlserver://192.168.0.2:1433;databaseName=nuxeo</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
-->
<user-name>ramon</user-name>
<password>admin</password>
<check-valid-connection-sql>;</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
4)El fichero: *sql.properties*
$JBOSS_HOME\server\default\deploy\nuxeo.ear\config
# Jena database type and transaction mode
org.nuxeo.ecm.sql.jena.databaseType=MsSQL
org.nuxeo.ecm.sql.jena.databaseTransactionEnabled=false
Finally, i execute the run.bat from my JBOSS_HOME\bin
And open firefox:
192.168.0.2:8080/nuxeo <http://192.168.0.2:8080/nuxeo>
And no connection occurs.
Thanks in advance
Ramon De Abreu
------------------------------------------------------------------------
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
--
Julien Carsique, Nuxeo (Paris, France)
www.nuxeo.com - The Open Source ECM Platform - www.nuxeo.org
Nuxeo ECM Stack - The Java EE, scalable, standard-based ECM Platform
[email protected] | Tel: +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
