• Post Reply Bookmark Topic Watch Topic
  • New Topic

ejb error on simple transaction

 
James Drinkard
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,
I'm new to ejb's, but have been developing servlets for a while. I'm trying to fire off an exiting ejb that some other developers created. It returns information from a prepared statement. I created a servlet that calls a getInfo class that in turn calls the getInfo ejb I want. I can find the bean, get into it and call the getInfo method inside the bean that I'm looking for, but it blows up when the prepared statement fires off. I manually run the same query under my sqlplus client and it works fine. I'm not sure if it's a code issue or may be related to oracle? I'm using WSAD 5.0 as the IDE, Oracle 9i, and the Oracle Thin driver (XA) because some of the transactions require a two phase commit. Any ideas?
 
Don Schaefer
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What error do you get? Can you show a stack trace? How is the bean configured related to transactions? Are you using WebSphere's connection pool or Oracle's? Any other details? As a test, can you run invoke the query directly from your servlet?
 
James Drinkard
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
[8/5/03 13:31:47:324 CDT] 23e02392 WSRdbXaResour W DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is: <null>
[8/5/03 13:31:48:085 CDT] 23e02392 XATransaction E J2CA0030E: Method enlist caught javax.transaction.SystemException: Failed to start the transaction association.
while trying to enlist resources from datasource jdbc/MPSDB with the Transaction Manager for the current transaction, and threw a ResourceException.
[8/5/03 13:31:48:656 CDT] 23e02392 SystemOut O SQL Exception in THE QUERYjava.sql.SQLException: DSRA9002E: ResourceException with error code null: javax.resource.ResourceException: enlist: caught Exception
I'm using container managed persistance with a container managed alias. I'm doing more reading on JTA to try and figure out what is happening.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!