How to connect to Oracle database through EJB application

[Former Member]

Hi,

I need to connect to Oracle database ( to perform some operations on tables) through EJB application.

can any one help me out in this. I need to perfom this only though EJB application, since my requirement is to create a Webservice to connect to Oracle database. So i need to develop an EJB application and expose it as Webservice.

Thanks & Regards,

Lakshmi.

[Former Member · Accepted solution]

Hi Prasanna,

Go through the thread, may help u.

Regards,

Sri

[Former Member]

Hi,

As you have to connect to a oracle database you have to use a entity bean bellow is the link which explains how to create a entity bean.

http://help.sap.com/saphelp_nw70/helpdata/EN/d8/955ef8e8302a4aa3feb0f3dfcc06fd/frameset.htm

But as you mentioned later that you have to expose it as the webservice that is why you are creating a EJB. In that case if you create a normal java class and connect to oracle database using JDBC connector this will also work and still you can publish that class as a webservice, Its not mandatory to have a EJB to publish as a webservice.

Ninad

[Former Member]

Hi

check this link

/docs/DOC-8061#20 [original link is broken]

there is doc available and also the ready made project available ,