Hi,

I'm using Oracle Type4 driver to connect to Oracle8i Enterprise Edition Release
8.1.7.4.0 in a
clustered environment Weblogic8.1SP2. I want to set the transaction as Read Only
and this works fine with the local unclustered env. The following exception is
raised by the EJB when it
is in the cluster. I tried the Connection.setReadOnly(true) immediately after
acquiring the
connection from the pool. Any information on this would be very helpful. If
you could suggest
different way to initiate a read only txn, it would also be helpful.


during invocation from home: com.hartfordlife.gbd.pvev.ejb.ebilling.ElectronicB
illing_vn4bdv_HomeImpl@d5c657 threw exception: javax.ejb.EJBException: setReadOn
ly: Read-only connections not supported
javax.ejb.EJBException: setReadOnly: Read-only connections not supported
at com.hartfordlife.gbd.pvev.ejb.ebilling.ElectronicB illingEJB.getInvoic
eListing(Unknown Source)
at com.hartfordlife.gbd.pvev.ejb.ebilling.ElectronicB illing_vn4bdv_EOImp
l.getInvoiceListing(ElectronicBilling_vn4bdv_EOImp l.java:410)
at com.hartfordlife.gbd.pvev.web.control.ElectronicBi llingWebImpl.getInv
oiceListing(Unknown Source)
at com.hartfordlife.gbd.pvev.web.taglib.InvoiceListTa g.findCollection(Un
known Source)
at com.hartfordlife.gbd.pvev.web.taglib.ListTag.doSta rtTag(Unknown Sourc
e)
at jsp_servlet._view.__ebill_invoice_list._jspService (__ebill_invoice_li
st.java:1893)
at weblogic.servlet.jsp.JspBase.service(JspBase.java: 33)
at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run
(ServletStubImpl.java:971)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubIm
pl.java:402)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubIm
pl.java:305)
at weblogic.servlet.internal.RequestDispatcherImpl.fo rward(RequestDispat
cherImpl.java:301)
at com.hartfordlife.gbd.pvev.web.control.ControllerSe rvlet.doGet(Unknown
Source)
at com.hartfordlife.gbd.pvev.web.control.ControllerSe rvlet.doPost(Unknow
n Source)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run
(ServletStubImpl.java:971)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubIm
pl.java:402)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubIm
pl.java:305)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationActio
n.run(WebAppServletContext.java:6350)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(Authenticate
dSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:
118)
at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppSe
rvletContext.java:3635)
at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestIm
pl.java:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)


Thanks,
Karthik.