hi group,
in weblogic server 6.1,in
jdbc node i have created xxxpool connection.
java.sql.Driver XXXDriver = (java.sql.Driver) Class.forName("weblogic.jdbc.pool.Driver").newInstance();
con = XXXDriver.connect("jdbc:weblogic
ool:xxxpool", null);
when i give these lines to open the connection,no problem ..i got the connection.
rs = stmt.executeQuery(somequerytoCLOB);
if (rs.next())
{
java.sql.Clob clob=rs.getClob(1);
java.io.Writer writer = ((oracle.sql.CLOB)clob).getCharacterOutputStream();
...
...
}
when i try to execute the above lines,no problem at all.
But instead of abv,
I have created one customdatasource in weblogic server 6.1 under jdbc node.
now to open the connection,
javax.naming.InitialContext ctx= new javax.naming.InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("customdatasource");
con = ds.getConnection();
now i got the connection.After that when i try to execute these same lines mentioned abv,(for rs)
I get classcastException.
Exception is:
java.lang.ClassCastException: weblogic.jdbc.rmi.internal.OracleTClobImpl.
I dont't know how to solve this problem.
Can anybody help me to solve this critical problem.Otherwise i have to set any settings in
weblogic server for customdatasource.?
thank u...
---
Shalini.