Hi All, I was wondering if anyone had any insight into some issues were are looking at in our project. disclaimer: Some or all of this may be vendor specific, and we are trying to follow through with our vendors ... so replies to that end do not need to be sent. First ... some config info : Weblogic TopLink CMP Oracle The problem : We are in a bit of a pinch because we really need to be able to use "direct" connections to Oracle ... as well as calls to entities ... within a single CMP transaction. In order for this to work correctly we need the environment to do the following things for us : Allow for some way for the _same physical connection_ to the DBMS to be used by the code that needs to use the "raw" JDBC connection ... and allow for some way for the container to ALSO get the same connection that is currently "setAutoCommit(false)" and "associated" with the "current" transaction when our code asks an entity bean to do CRUD. In our travels ... the following bits of magic seem to have come to us ... We have seen some information from Weblogic that implies that this can be done. The information we have come across seems to be written assuming that the reader is doing BMP ... not CMP. The gist of the info though is apparently to create a JTS connection "on top" of a connection pool. There also seem to be a myriad of options within the TopLink framework that hint at being able to configure TopLink ... and indirectly our CMP persistence ... to use connection pool URL's and Datasources ... but in our barely scientific attempts thus far ... we have not hit upon a combo that seems to work. For testing this, we have configured our "base" connection pool to only allow 1 connection at any time in the pool, and we have built a SessionBean wrapping an Entity ... where the transaction demarcation is on the Session. We then get a JDBC connection, write a record, then try to read it from the entity ... as a baseline test. Are any of you folks out there by any chance doing something as we have described ... even if you vendor "bits" are not the same ? Should we be able to do CRUD within the JTS framework both through CMP entity and JDBC and have things work ... going to the same database ? We are really struggling with this ... finding it hard to believe that this requirement is turning out to be so elusive. TIA, Tony --- Tony Pelton Developer tpelton at imany dot com http://www.i-many.com "Hail to the King, Baby" =========================================================================== 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".
