Search code examples
asynchronoussql-server-2000ejb-3.0procedurejava1.4

how to call procedure in database asynchronously from java 1.4 code?

platform: Sql server 2000 java 1.4 ejb 3.0

Solution

  • I'm not sure to get the question but calling a stored procedure involves using a CallableStatement. For the asynchronous part, and because you mentioned EJBs, the standard way would be to use JMS and a Message Driven Bean. But I'm a bit confused by the part where you mention Java 1.4 and EJB 3.0 (that requires Java 1.5). Maybe you should clarify that requirement. Sending JMS messages to a MDB 3.0 from a Java 1.4 client should be possible though.