Tim,
When you are using BMP is actually encourage to use an "helper" class that
connects and makes all the transactions needed to the DB. However, when opening your
jdbc connection it's highly recomended to get a connection from one of the connections
pools throught JNDI. I think there is examples on the docuemtation of doing this. Let
me know if this helps. If needed I can send you an example of doing this.
-thanks
Rolando Rivera "El Matador"
---------- Original Message ----------------------------------
From: "Tim Yates" <[EMAIL PROTECTED]>
Reply-To: "jBoss" <[EMAIL PROTECTED]>
Date: Wed, 20 Dec 2000 11:22:48 -0000
>Hiya!
>
>We have a working BMP/EJB model for content entry into our oracle database,
>and I would just like to check that it is OK to have a JavaBean query the
>database directly via JDBC to select all rows? I ask this, as the page
>which lists all current content is a bit slow (and we only have 200 bits of
>content in at the moment), so it would be quicker to perform a SELECT
>statement on the dB...
>
>Am I best doing this in the JavaBean layer, or the EJB layer (or does it not
>really make a difference?)
>
>Just thought I would consult the wise people of this list before I did
>something stupid and got myself shouted at ;-)
>
>Thanks for any response,
>
>Tim.
>
>
>
>--
>--------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>List Help?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
