Who has a jdbc driver for Oracle that support jdbc 2.0 standard extension
specification ?
[EMAIL PROTECTED] wrote:
>I may have answers to some of your questions.>
>>How do we create PORTABLE beans accessing db and using ND db services ?
>>What would be the best option to develop a bean in ND (any bean other than a
>container managed entity bean) that accesses
>>a database directly, but is still portable across different app server ?
>> Should I not use ND specific classes from spider.database.* package ? Should I use
>java.sql.* package instead ?
>> But if I do, how about the db connection pooling management, that is usually
>handled by ND app server ?
>>What services from ND would I miss by not using spipder.database.* classes.
>
>I am assuming you are using ND 5.0 which supports only session beans right now (no
>entity beans).
>So your only option right now is to develop session beans that directly use JDBC
>(java.sql.*).
>JDBC is the only way to access databases from EJBs if you want to take advantage of
>container
>managed transactions (including two phase commits between different databases).
>Moreover if
>you use spider.database.*, your bean woun't be portable across different EJB servers.
>As fas as connection pooling is concerned, it can be handled by the JDBC layer (JDBC
>2.0 Standard
>Extention API with DataSource interface that does the connection pooling). Any JDBC
>driver that
>supports 2.0 extentions (implements javax.sql.* interfaces) will do the connection
>pooling for you.
>
>Hope this helps.
>
>
>
>
>[EMAIL PROTECTED] wrote:
>>How do we create PORTABLE beans accessing db and using ND db services ? What would
be the best option to develop a bean in ND (any bean other than a container
managed
entity bean) that accesses a database directly, but is still portable across
different
app server ? Should I not use ND specific classes from spider.database.*
package
? Should I use java.sql.* package instead ? But if I do, how about the db
connection
pooling management, that is usually handled by ND app server ? What services
from
ND would I miss by not using spipder.database.* classes. Can the ND database
services
still be u
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
