Not Finding DataSource in JNDI Tree

[Russell Ray]

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:

Code:

19:46:04,927 INFO  [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceB
inding,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 (4
0000000) 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

[Russell Ray]

I found my mistake.........you can close this.