[jboss-user] [JCA/JBoss] - Re: Class Cast Exception when connecting to DataSource--JBos

[russray]

Weston:

   You are absolutely 100% right, but somehow I think you knew that--- :-)

   The -ds.xml was incorrect.  There is not such property as a URL or Port for that matter.  I knew I was jumping to conclusions almost immediately as I hit the submit button.  

  Here the the new -ds.xml 

   
  |    <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>
  |    

I am getting into the database and things are working!  Thank you for being so gracious!!!!!   

I have the logging set to TRACE hoping I spot anything that would tell me I don't have the server setup properly.  I am getting this WARNING.  I am not sure what it means in SQL Server.  

  
  |   15:14:16,269 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
  | 	at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
  |   

Would you have any thoughts on this area?


Thanks so much on this.......I am so new to JBoss; I would have been here alot longer had I not been coached to *READ* the documentation throughly.  :-)

Russ


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987106#3987106

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3987106