Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes BEA/Weblogic and the fly likes WLI 8.1.6 & Oracle 10g Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Reply Bookmark "WLI 8.1.6 & Oracle 10g" Watch "WLI 8.1.6 & Oracle 10g" New topic
Author

WLI 8.1.6 & Oracle 10g

Nithi Rajan
Greenhorn

Joined: Oct 30, 2005
Posts: 29
posted private message
0
Quote
Hi,

Does Weblogic 8.1.6 support having Integration tables on Oracle 10g?

When I try to configure Connection Pools in Weblogic 8.1.6, when I choose the Database Type as Oracle, I dont see any driver that supports 10g. Only Oracle 8.1.7/9.0.1/9.2.0 are supported. Does it mean 10g is not supported.

I have configured cgPool to use Oracle 10g, But get strange errors like below

Any help is very much appreciated.

Regards!
Nithi.

Error :
2008-11-24 16:15:49,999 DEBUG HolidayUtil.mapUserToCalendar - start - userName = ImrWorklistUser , calendarName = SG
2008-11-24 16:15:52,828 DEBUG HolidayUtil.mapUserToCalendar - javax.transaction.TransactionRolledbackException: EJB Exception: : javax.ejb.TransactionRolledbackLocalException: EJB Exception:; nested exception is: javax.ejb.EJBException: nested exception is: javax.ejb.EJBException: Exception on insert: java.io.IOException: [BEA][Oracle JDBC Driver]No more data available to read.
javax.ejb.EJBException: nested exception is: javax.ejb.EJBException: Exception on insert: java.io.IOException: [BEA][Oracle JDBC Driver]No more data available to read.
javax.ejb.EJBException: Exception on insert: java.io.IOException: [BEA][Oracle JDBC Driver]No more data available to read.
at com.bea.wlw.runtime.core.bean.BMPContainerBean.ejbStore(BMPContainerBean.java:1844)
at com.bea.wli.bpm.runtime.ProcessContainerBean.ejbStore(ProcessContainerBean.java:227)
at com.bea.wli.bpm.runtime.ProcessContainerBean.ejbStore(ProcessContainerBean.java:197)
at com.bea.wlwgen.PersistentContainer_1gbsav_Impl.ejbStore(PersistentContainer_1gbsav_Impl.java:149)
at weblogic.ejb20.manager.ExclusiveEntityManager.flushModified(ExclusiveEntityManager.java:620)
at weblogic.ejb20.internal.TxManager$TxListener.flushModifiedKeys(TxManager.java:801)
at weblogic.ejb20.internal.TxManager.flushModifiedBeans(TxManager.java:326)
at weblogic.ejb20.manager.BaseEntityManager.flushModifiedBeans(BaseEntityManager.java:2610)
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.flushModifiedBeans(RDBMSPersistenceManager.java:3847)
at com.bea.wli.calendar.beans.entity.CalendarBean_m4sbdw__WebLogic_CMP_RDBMS.ejbFindByName(CalendarBean_m4sbdw__WebLogic_CMP_RDBMS.java:680)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.scalarFinder(RDBMSPersistenceManager.java:316)
at weblogic.ejb20.manager.BaseEntityManager.scalarFinder(BaseEntityManager.java:1804)
at weblogic.ejb20.manager.BaseEntityManager.localScalarFinder(BaseEntityManager.java:1753)
at weblogic.ejb20.internal.EntityEJBLocalHome.finder(EntityEJBLocalHome.java:543)
at com.bea.wli.calendar.beans.entity.CalendarBean_m4sbdw_LocalHomeImpl.findByName(CalendarBean_m4sbdw_LocalHomeImpl.java:166)
at com.bea.wli.calendar.beans.RemoteCalendarBean.calendarNameExists(RemoteCalendarBean.java:130)
at com.bea.wli.calendar.beans.RemoteCalendarBean_o8ptm0_EOImpl.calendarNameExists(RemoteCalendarBean_o8ptm0_EOImpl.java:46)
at com.bea.wli.calendar.beans.RemoteCalendarBean_o8ptm0_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:166)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:248)
at com.bea.wli.calendar.beans.RemoteCalendarBean_o8ptm0_EOImpl_816_WLStub.calendarNameExists(Unknown Source)
at com.fedex.apac.oaportal.imr.administration.holiday.utils.HolidayUtil.mapUserToCalendar(HolidayUtil.java:431)
at com.fedex.apac.oaportal.imr.CreateIMR.processes.AssignTask.taskControlSetCompletionDueBusinessDate(AssignTask.jpd:297)
at com.fedex.apac.oaportal.imr.CreateIMR.processes.AssignTask_wf$ImplControlSend8.invoke(AssignTask_wf.java:81)
at com.bea.wli.bpm.runtime.Perform.execute(Perform.java:32)
at com.bea.wli.bpm.runtime.Receive.messageDelivery(Receive.java:91)
at com.bea.wli.bpm.runtime.Receive.messageDeliveryAction(Receive.java:71)
at com.bea.wli.bpm.runtime.ProcessState.processMessage(ProcessState.java:188)
at com.fedex.apac.oaportal.imr.CreateIMR.processes.AssignTask_wf$_ProcessState.processMessage(AssignTask_wf.java:441)
at com.fedex.apac.oaportal.imr.CreateIMR.processes.AssignTask_wf.clientRequest(AssignTask_wf.java:405)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:371)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:433)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:406)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:249)
at com.bea.wlw.runtime.core.bean.BaseContainerBean.invokeBase(BaseContainerBean.java:224)
at com.bea.wlw.runtime.core.bean.BMPContainerBean.invoke(BMPContainerBean.java:2051)
at com.bea.wli.bpm.runtime.ProcessContainerBean.invoke(ProcessContainerBean.java:262)
at com.bea.wlwgen.AssignTaskBMPContImpl.clientRequest(AssignTaskBMPContImpl.java:25)
at com.bea.wlwgen.PersistentContainer_1gbsav_ELOImpl.clientRequest(PersistentContainer_1gbsav_ELOImpl.java:153)
at com.bea.wlwgen.AssignTaskBMPContAdpt.invokeOnBean(AssignTaskBMPContAdpt.java:83)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:175)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:55)
at com.bea.wlw.runtime.core.bean.AsyncDispatcherBean.onMessage(AsyncDispatcherBean.java:248)
at weblogic.ejb20.internal.MDListener.execute(MDListener.java:400)
at weblogic.ejb20.internal.MDListener.transactionalOnMessage(MDListener.java:333)
at weblogic.ejb20.internal.MDListener.onMessage(MDListener.java:298)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:2698)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:2610)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
Caused by: java.lang.Exception: Exception on insert: java.io.IOException: [BEA][Oracle JDBC Driver]No more data available to read.
at com.bea.wlw.runtime.core.bean.BMPContainerBean.doInsert(BMPContainerBean.java:1916)
at com.bea.wlw.runtime.core.bean.BMPContainerBean.ejbStore(BMPContainerBean.java:1824)
... 58 more
[ November 24, 2008: Message edited by: Nithi Rajan ]
SCEA5
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: WLI 8.1.6 & Oracle 10g
 
Similar Threads
Weblogic Integration Migration from 2.1sp1 to 2.1sp2
Exception for EJB CMP table validation URGENT
Accessing Entity from MDB
cannot find my entity bean
EJB 2.0 value larger than specified precision allows for this column