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 jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user