Using DB Connection with DBPool

[Former Member]

Hi,

We are about to develop some Webdynpro applications and we have a requirement of accesing R/3 and a DB in the same Webdynpro Component, I understand you can not use the DB as a model but maybe use a Java component that can be instantiated from the Webdynpro to achieve this and the Java component accesses the DB, my question is if WAS JAVA has a DB Connection Pool already that we can use to achieve our porpose?

Thanx in Advanced!

Kind Regards,

Gerardo J

[Vlado · Accepted solution]

Hi Gerardo,

Indeed, it has. <a href="http://help.sap.com/saphelp_nw04/helpdata/en/fe/9e362f3d954e8e8555007d8030df63/frameset.htm">This</a> should be a good starting point.

You could have a stateless session bean to access the DB and call it from the WD component. Check <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1f5f3366-0401-0010-d6b0-e85a49e93a5c">this</a> article.

Hope that helps!

-- Vladimir

[Former Member · Accepted solution]

Looks Great!

Thanx Alot!

Kind Regards,

Gerardo J

[Former Member · Accepted solution]

Vladimir,

Does this JavaBean Model can be mixed in the same webdynpro with an RFC model? I mean in the same Webdynpro interacting with both of the models in a view. is this posible?

Kind Regards!

Gerardo J

[Vlado · Accepted solution]

Hi Gerardo,

Actually I was not talking about the JavaBean Model but about calling an EJB from your WD component as described in the before mentioned article. EJB (<b>Enterprise</b> JavaBeans) != JavaBeans and in NW 7.0 there is no EJB Model - which is however available now in NW CE 7.1.

Hope it clarifies things a bit!

-- Vladimir