Lookup for DataSource failing--Please Help

[russray]

I have port over my application to JBoss. I am confrigured most to the application server, but I am getting an error when the application attempts to make a connection to the DataSource. This is the error:

19:00:39,872 ERROR [STDERR] Looking up DataSource: jdbc/pidbdev
 19:00:39,872 ERROR [STDERR] javax.naming.NameNotFoundException: jdbc not bound

this is the code:

try {
 System.err.println("Looking up DataSource: "+ name);
 ds = (DataSource) context.lookup(name);
 this.dataSourceCache.put(name, ds);
} catch (NamingException ne) {
 ne.printStackTrace();
}

This is how I have my DataSource (*-ds.xml) configured:

<datasources>
 <xa-datasource>
 <jndi-name>jdbc/pidbdev</jndi-name>
 <track-connection-by-tx/>
 <isSameRM-override-value>false</isSameRM-override-value>
 <xa-datasource-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</xa-datasource-class>
 <xa-datasource-property name="ServerName">me_server</xa-datasource-property>
 <xa-datasource-property name="DatabaseName">me_db</xa-datasource-property>
 <xa-datasource-property name="SelectMethod">cursor</xa-datasource-property>
 <xa-datasource-property name="User">p1</xa-datasource-property>
 <xa-datasource-property name="Password">p1</xa-datasource-property>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>20</max-pool-size>
 <metadata>
 <type-mapping>MS SQLSERVER2000</type-mapping>
 </metadata>
 <check-valid-connection-sql>SELECT * FROM invalidate</check-valid-connection-sql>
 </xa-datasource>
</datasources>

This is my web.xml

<resource-ref>
 <description>DB Connection</description>
 <res-ref-name>jdbc/pidbdev</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>

This is my jboss-web.xml

<jboss-web>
 <resource-ref>
 <res-ref-name>jdbc/pidbdev</res-ref-name>
 <jndi-name>java:/pidbdev</jndi-name>
 </resource-ref>
</jboss-web>

When I go back and look at how my dataSource is connection, I discover the DataSource log statement:

19:46:04,927 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=jdbc/pidbdev' to JNDI name 'java:jdbc/pidbdev'
 19:46:05,615 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=rray-wxp/1, BranchQual=, localId=1] errorCode=XAER_RMERR
 javax.transaction.xa.XAException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_commit (40000000) returns -4

I am let to believe the DataSource is setup properly, but for some reason, the JNDI is not.

Any suggestions would be much appreciated.

Thanks for reading my post.

Russ

[russray]

You can close this thread. I found may error.