• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

ejb error on simple transaction

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic