portal-sqlserver-ds.xml

[pedrosacosta]

This portal-sqlserver-ds.xml is right?

The 192.168.25.23 is a remote database.

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>MSSQLDS</jndi-name>

 <connection-url>jdbc:microsoft:sqlserver://192.168.25.23:1433;databaseName=bts</connection-url>
 <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
 <driver-class>com.microsoft.jdbc.base.BaseDriver</driver-class>
 <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

 <user-name>HFDEV</user-name>
 <password>HFDEV</password>

 <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
 <metadata>
 <type-mapping>MS SQLSERVER2000</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

Thanks,
Pedro