Hi
The answer is weblogic specific.
Configure a database pool in weblogic.properties file.
weblogic.jdbc.connectionPool.testPool=\
url=...,\
driver=...,\
....
# Add a TXDataSource for the connection pool:
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.testPool=testPool
Add the following entry to ejb-jar.xml
<resource-ref>
<res-ref-name>jdbc/labPool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
and the following to weblogic-ejb-jar.xml
<reference-descriptor>
<resource-description>
<res-ref-name>jdbc/labPool</res-ref-name>
<jndi-name>weblogic.jdbc.jts.labPool</jndi-name>
</resource-description>
</reference-descriptor>
Now, from the bean you can access the connection pool like this :-
Context ctx = new InitialContext();
DataSource ds = (javax.sql.DataSource)
ctx.lookup("java:comp/env/jdbc/labPool");
Connection conn = ds.getConnection();
For accessing oracle's sequence, I have a stateless session bean which has a
nextValue() and currentValue() method :-
-- SequenceBean.java --
public int nextValue(String sequenceName) {
int nextval;
String query = "select " + sequenceName + ".nextval from dual";
Statement stmt = conn.createStatement();
Resultset rs = stmt.executeQuery(query);
..
..
return nextval;
}
Hope it helps.
--
shiv
[EMAIL PROTECTED]
Sripada Srinivas wrote:
> Hi Ana,
>
> If you open a connection like this for every user, then the whole purpose of
> connection pooling used by the EJB Server is lost I suppose. (In CMP).
>
> By the way, is there anyway, I can get access to the connection pools used by
> the EJB Servers?? Does any of the EJB servers provide API to access the
> connections in their connection pool??
>
> Regards,
> Sripada
>
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
