Re: Oracle Blob Clob Lob Problem

[Armin Waibel]

could you post the mapping and source code of class 
de.on_ergy.lakon.data.model.Log (it's sufficient to post fields/columns 
log_data_export, og_data_default).

regards,
Armin
Josef Wagner wrote:
Hello Armin,
The problem width my outOfMemory apears also width 1.0.5
I have written a small test code an now I know, why I'm getting the 
outOfMemory width OJB. I think it is a "bug" in OJB, because you read 
the data from ResultSet width getString() instead of getClob(). Width 
getString(), i get the outOfMemory

Here my test
-----------
   public void clobTest() {
       PersistenceBroker pb = getBroker();
             JdbcAccess jdbcAccess = pb.serviceJdbcAccess();
       ClassDescriptor logClassDesc = 
pb.getClassDescriptor(de.on_ergy.lakon.data.model.Log.class);
       ResultSetAndStatement rs = jdbcAccess.executeSQL("Select * from 
Log", logClassDesc, false);
       ResultSet r = rs.m_rs;
       Vector logDataExpVec = new Vector();
       Vector logDataDefaultVec = new Vector();
       try {
           while(r.next()) {
               logDataExpVec.addElement(r.getClob("log_data_export"));
               logDataDefaultVec.addElement(r.getClob("log_data_default"));
           }
                 } catch(SQLException ex) {
           _log.error(ex);
       }
       _log.info("Fertig!!!");
   }

-----

How can we get a quick solution?
Thanks a lot for your spend time!

regards, josef



Armin Waibel schrieb:

by the way, do your test pass if you set the 'proxy-prefetching-limit' 
of the relevant class-descriptor or reference/collection-descriptor's 
to '0'? Then OJB shouldn't prefetch the references.

regards,
Armin



Armin Waibel wrote:
Hi Josef,

Josef Wagner wrote:
Hello Armin,

no, I have allready replaced all CGLib classes width JDK classes. My
problem is, that i can't debug the following issue: -------- Caused
by: java.lang.NullPointerException at 
org.apache.ojb.broker.core.QueryReferenceBroker.access$000(QueryReferenceBroker.java:64) 



I think this is the access from the inner class 
PBMaterializationListener to the private field 'pb' in class 
QueryReferenceBroker.
Decompiled code for QueryReferenceBroker:
...
static org.apache.ojb.broker.core.PersistenceBrokerImpl 
access$000(org.apache.ojb.broker.core.QueryReferenceBroker);
  Code:
   0:   aload_0
   1:   getfield        #4; //Field 
pb:Lorg/apache/ojb/broker/core/PersistenceBrokerImpl;
   4:   areturn



at 
org.apache.ojb.broker.core.QueryReferenceBroker$PBMaterializationListener.addThisListenerTo(QueryReferenceBroker.java:990) 



-------- <code> Line 990: _listenedHandler = 
pb.getProxyFactory().getIndirectionHandler(owner); </code>

pb is != null

I have no idea :o/. Are there any no features, that I have to keep in
mind?


I remember that I got a similar ".access$000" error some weeks ago. 
But I can't remember the reason. I thought it was a proxy issue (do 
you get the same error when using CGLIB-proxy classes?) - but seems 
this isn't the reason.

Could you describe or post the test source code to reproduce the issue?

regards,
Armin


regards, Josef



Armin Waibel schrieb:
Hi Josef,

could this be a proxy issue? Please check the settings in 
OJB.properties file - do you need CGLib based proxies?

regards, Armin

Josef Wagner wrote:
Hi Armin, i tried to starting my application width 1.0.5, but no
success. I can`t get any informations when looking into the log. I 
think, it`s an Java Reflection Problem: Hier is the log output,
have you any idee ?

java.lang.reflect.InvocationTargetException at 
org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:357) 



at 
org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291)
 at 
org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:447) 



at 
de.on_ergy.lakon.rcp.dialog.LoginDialog.buttonPressed(LoginDialog.java:114) 



at
org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:556)
 at 
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90) 

 at
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) 
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at 
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
 at
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
 at org.eclipse.jface.window.Window.runEventLoop(Window.java:809)
 at org.eclipse.jface.window.Window.open(Window.java:787) at
de.on_ergy.base.ui.OnErgyDialog.open(OnErgyDialog.java:132) at 
de.on_ergy.lakon.rcp.LakonWorkbenchWindowAdviser.postWindowOpen(LakonWorkbenchWindowAdviser.java:209) 



at 
org.eclipse.ui.internal.WorkbenchWindow.fireWindowOpened(WorkbenchWindow.java:1070) 



at 
org.eclipse.ui.internal.WorkbenchWindow.open(WorkbenchWindow.java:701) 

 at 
org.eclipse.ui.internal.Workbench.busyOpenWorkbenchWindow(Workbench.java:677) 



at 
org.eclipse.ui.internal.Workbench.doOpenFirstTimeWindow(Workbench.java:1282) 



at 
org.eclipse.ui.internal.Workbench.openFirstTimeWindow(Workbench.java:1223) 



at 
org.eclipse.ui.internal.WorkbenchConfigurer.openFirstTimeWindow(WorkbenchConfigurer.java:190) 



at 
org.eclipse.ui.application.WorkbenchAdvisor.openWindows(WorkbenchAdvisor.java:706) 



at org.eclipse.ui.internal.Workbench.init(Workbench.java:1034) at
org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1636) at 
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) 



at 
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
 at
de.on_ergy.lakon.rcp.RcpApplication.run(RcpApplication.java:44) at 
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) 



at 
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) 



at 
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) 



at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at 
java.lang.reflect.Method.invoke(Unknown Source) at
org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at
org.eclipse.core.launcher.Main.basicRun(Main.java:278) at
org.eclipse.core.launcher.Main.run(Main.java:973) at
org.eclipse.core.launcher.Main.main(Main.java:948) Caused by:
org.apache.ojb.broker.PersistenceBrokerException: 
java.lang.NullPointerException at 
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:290) 



at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1597) 



at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:393) 



at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:393) 



at 
de.on_ergy.base.provider.OnErgyDataProviderOjb.select(OnErgyDataProviderOjb.java:518) 



at 
de.on_ergy.lakon.data.DataProviderOjb.select(DataProviderOjb.java:1486) 

 at 
de.on_ergy.lakon.data.DataProviderOjb.select(DataProviderOjb.java:1473) 

 at 
de.on_ergy.base.provider.OnErgyDataProviderOjb.select(OnErgyDataProviderOjb.java:480) 



at
de.on_ergy.lakon.data.DataProvider.select(DataProvider.java:248) at
de.on_ergy.lakon.bp.stammdaten.LakonBP.select(LakonBP.java:131) at
de.on_ergy.lakon.rcp.dialog.LoginDialog$1.run(LoginDialog.java:97)
 at 
org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) 



... 36 more Caused by: java.lang.NullPointerException at 
org.apache.ojb.broker.core.QueryReferenceBroker.access$000(QueryReferenceBroker.java:64) 



at 
org.apache.ojb.broker.core.QueryReferenceBroker$PBMaterializationListener.addThisListenerTo(QueryReferenceBroker.java:990) 



at 
org.apache.ojb.broker.core.QueryReferenceBroker$PBPrefetchingListener.<init>(QueryReferenceBroker.java:1048) 



at 
org.apache.ojb.broker.core.QueryReferenceBroker$PBMaterializationListener.<init>(QueryReferenceBroker.java:985) 



at 
org.apache.ojb.broker.core.QueryReferenceBroker.retrieveReference(QueryReferenceBroker.java:413) 



at 
org.apache.ojb.broker.core.QueryReferenceBroker.retrieveReferences(QueryReferenceBroker.java:495) 



at 
org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:490) 



at 
org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:280) 

 at 
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:143) 



at 
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:277) 



... 47 more


thanks for your help! regrads Josef

Armin Waibel schrieb:
Hi Josef,

Josef Wagner wrote:
Hello List,

I have a problem width loading large data from tables width 
clob-culumns. db: oracle 9.2.0.8 ojb: 1.0.4 driver: thin

When i load 15000 rows, my applikation gets an
OutOfMemoryError. I have ensure, that Oracle width clobs is
the problem, width HSQLDB, all works fine. The data in the
clob-culumns are texts width AKTUALLY no more then 100
charakters.

I have checked out the trunk of ojb and I see, that in the
platform package are some wrapper-classes for clob und blob?

yep, I reworked the LOB-support a bit and add Blob/Clob
java-types support (before OJB converts all LOB's to byte[]).


Unforunatelly, I can't test if this is the solution of my
problem, because I get lots of errors when starting my
application width a jar from the trunk version.


Don't use the trunk it's the alpha OJB 2.x. Please check out
the OJB_1_0_RELEASE branch it's the stable upcoming OJB 1.0.5
version.


Can anybody tell me, if the source in the trunk is the
solution for such problems I have?

Don't know - give it a try.


Or is the solution to switch to oralce 10g?

I run the LOB-test against OracleXE 10.2.0.1 and 
classes12_g_10.2.0.2.jar driver. 
http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/src/test/org/apache/ojb/broker/lob/LOBTest.java?view=markup 



The tests handle CLOB's up to 5000 characters.

Or should I use OCI instead of THIN driver?

Sorry I don't know (not a Oracle expert).

regards, Armin

Thanks a lot for your answers.

regrads Josef Wagner

--------------------------------------------------------------------- 

 To unsubscribe, e-mail: [EMAIL PROTECTED] For 
additional commands, e-mail: [EMAIL PROTECTED]



--------------------------------------------------------------------- 

 To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
 To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
 To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
 To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]