thanks for the reply:
seam-gen generated ds.xml
-----------------
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>ndpjDatasource</jndi-name>
<connection-url>jdbc:hsqldb:.</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>sa</user-name>
<!--
<exception-sorter-class-name>
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
</exception-sorter-class-name>
<type-mapping>mySQL</type-mapping>
-->
</local-tx-datasource>
-----------------------------
then i modified this ds.xml to connect to mssql server
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>ndpjDatasource</jndi-name>
<connection-url>jdbc:jtds:sqlserver://localhost:1433;DatabaseName=ndpj;SelectMethod=cursor</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name>sa</user-name>
sa
<!--
<exception-sorter-class-name>
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
</exception-sorter-class-name>
<type-mapping>mySQL</type-mapping>
-->
</local-tx-datasource>
--------------
it ONLY work when you connect to hypersonic db first, then modify the ds.xml to
connect to sql server, it will NOT work if you use seam gen directly connect to
mssql server!!!
strange.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4001084#4001084
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4001084
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
