Re: Oracle Blob Clob Lob Problem

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