How to invoke DB stored procedures from EJB3.0

In our project we are using EJB3.0.I got one situation, where i need to call a db stored procedure through my code. But i couldn't find any possibilities.Can any body help me in this regardThanks in advanceKiran

[247 byte] By [kirankumar@suna] at [2007-11-26 15:36:54]

«« passing string variable to java script
»» HTML Select Tag

# 1

> I got one situation, where i need to call a db stored> procedure through my code. But i couldn't find any> possibilities.BMP

annie79a at 2007-7-8 21:54:40 >

top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...

# 2

Hi,

As per ejb3.0 spec is conserned it doesnt specify anything with regard to stored procedures as of now, it means ejb3.0 cannot handle stored procedures as of now, of course it still depends on vendor implemenation u can check out for any possibilities wether vendor provides support for it or not, as for as i am conserned they dont as of now.

Possible Alternative:

This can be achived only through BMT using 2 transactions.

Open a seperate JDBC managed Transaction(by setting AutoCommit to false) execute the stored procedures from here, u can commit or roll back from there on.

Thanks and Regards

Srikanth S

Srikanth_s_reddya at 2007-7-8 21:54:40 >

# 3

> As per ejb3.0 spec is conserned it doesnt specify

> anything with regard to stored procedures as of now,

> it means ejb3.0 cannot handle stored procedures as of

> now

As far as I remember EJB specifications never addressed stored procedures.

> Possible Alternative:

> This can be achived only through BMT using 2

> transactions.

Why two transactions?

annie79a at 2007-7-8 21:54:40 >

# 4

The problem with the above solution is data visibility is not proper

Srikanth_s_reddya at 2007-7-8 21:54:40 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

How to invoke DB stored procedures from EJB3.0

Enterprise & Remote Computing New Topic

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified