-
1. Re: Problem with Lookup XADataSource
jaikiran Jun 5, 2006 3:37 AM (in response to tamri)When I run java program
That means you are accessing the datasource remotely. Have a look at:
http://wiki.jboss.org/wiki/Wiki.jsp?page=HowCanIAccessADataSourceFromAClient -
2. Re: Problem with Lookup XADataSource
tamri Jun 5, 2006 7:22 AM (in response to tamri)Now remote Lookup works, container returns dataSource bat when I return connection
javax.sql.DataSource dataSource = (javax.sql.DataSource)context.lookup("java:/MSSQLXADS");
con=dataSource.getConnection("sa","sa");
it throws Exception:
org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_open (0) returns -3); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_open (0) returns -3))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:109)
enyone knows ,how to do ?