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]