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 us
_________________________________________________________________________
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]
