Hi All,
Please guide me if i am wrong,
I know that getSerialNumber() method in weblogic.jdbc.informix4.Statement class would retrieve the serial key after insertion.
I am type casting
Java sql statement to informix statement to get the serial number, please look at the code below.
--stmt = (weblogic.jdbc.informix4.Statement)con.createStatement()
This code is working fine when i open a connection directly (by-passing connection pool), please look at the code below.
--Driver myDriver= (Driver) Class.forName("DriverName").newInstance();
--Connection con = myDriver.connect("DriverClass", Properties)
But if i get the connection using DataSource, type casting statement to informix is throwing an exception
java.lang.ClassCastException: weblogic.jdbc.rmi.SerialStatement
--DataSource ds = (DataSource) ctx.lookup ("DataSourceName");
--Connection conn = ds.getConnection();
Opening a connection directly would not allow the connection to participate in the current transaction and so rollbacks are giving weird results.
Can anybody help me in this regard.
Thanks in advance,
-Sridhar Kancharlapalli.