Re: Oracle Blob Clob Lob Problem

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]
> 
>