Weblogic pool connection Vs JDBC Connection

[Raj Sikka]

Hi
I have a user managed transaction.
I am inserting a record in database using a weblogic connection (ejbCreate method of CMP Bean).
In the same transaction, I open a JDBC connection from the same class.
I am trying to access the records inserted using the weblogic connection through the JDBC connection.
I am not able to view the records in the JDBC connection.
Is there a way to make the data visible to the JDBC connection as well.
Following is the pseudocode of what I am doing:
Begin User Transaction;
Call ejbCreate() method of CMP Bean (Insert record in database);
Open JDBC connection(user name, password, driver, datasource);
read record from database using JDBC connection
(This read does not return the inserted data through ejbCreate())
End User Transaction;
One more question .
Does weblogic supports passing arrays from oracle to java ?
Thanks,
Srikanth

[Marcos Maia]

Hi,
as far as the transaction is running u're not suppose to see the data, only after the transaction commits.
About passing arrays, u can pass them as long as they have only serializable objects in it.