Eclipse Community Forums: EclipseLink » Non-foreign key added in batchfetch select

Home » Eclipse Projects » EclipseLink » Non-foreign key added in batchfetch select(Non-foreign key added in batchfetch select)

Non-foreign key added in batchfetch select [message #1729476]

Thu, 14 April 2016 09:01

Eclipse User

Hi!
I am using Eclipselink 2.3.1 with Oracle.
I have two tables, MALH and MALHAND. In both tables I have a primary key 'ID'. Table MALHAND has a foreign key 'MALH_ID', which points to the column MALH.ID. There may be multiple rows in MALHAND for each row in MALH.

In Malh.java I have the following notation:
@OneToMany(fetch = FetchType.LAZY, mappedBy = "mal", cascade = CascadeType.ALL)
@BatchFetch(value = BatchFetchType.EXISTS, size = 2)
private List<Malhand> malhandelser = new LinkedList<Malhandelse>();

whereas in Malhand.java I have
@ManyToOne
@JoinColumn(name = "VERKSTALLIGHETSMAL_ID")
private Malh mal;

However, this fails, and when looking in the logs I see the error below, where another, non-foreign key, column 'MALNUMMER' has been added to the query!
That column exists for sure, but it is definitely not a foreign key, nor is it by any means a primary key! Why is it added? And why doesn't it get any values?

Error Code: 936
Query: ReadAllQuery(name="malhand" referenceClass=Malhand sql="SELECT t0.ID, [...truncated...] FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ?) AND (t0.MALH_ID = t1.ID))) ")
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00936

Thanks in advance for any suggestions!

Re: Non-foreign key added in batchfetch select [message #1729497 is a reply to message #1729476]

Thu, 14 April 2016 14:09

Eclipse User

You are using batchFetching to bring in the related Malhand instances, but have specified BatchFetchType.EXISTS as the mechanism to create that query - batching uses aspects of the orignal query to bring in only instances that relate to the read in Malh instances. In this case, your original query had the (t1.MALNUMMER IN ?) clause, so this query only needs to return Malhand instances associated to the Malh instances returned from the original query.

Turn on logging and parameter logging to see the orginal query and this one, and include the full stack trace and error to see why the parameters might be getting lost. Is there any way you can also try a later version, or a different batch option?

[Updated on: Thu, 14 April 2016 14:11] by Moderator

Re: Non-foreign key added in batchfetch select [message #1729532 is a reply to message #1729497]

Fri, 15 April 2016 03:45

Eclipse User

Thanks for your answer, but if that is the case, I'm afraid I don't understand why there are no values in the 'MALNUMMER' list of values. Because that is where the real showstopper is: Oracle claims that list is completely empty, and that is what makes the query fail. Sorry if I didn't make that clear in my original post. (And no, the MALNUMMER column definitely contains values: it has a not-null constraint on it.)

Unfortunately I cannot upgrade to a later version of Eclipselink, due to company policy - for some reason 2.3.1 is the "approved" version. (Actually I cannot even download it to our system, due to filtering).

Re: Non-foreign key added in batchfetch select [message #1729547 is a reply to message #1729497]

Fri, 15 April 2016 06:45

Eclipse User

Update:
1) Everything works fine when using Hsqldb
2) Everything works fine when using Oracle through the thin driver in our Eclipselink-provided version of eclipselink
3) It doesn't work when using our (company provided) datasource to access Oracle together with the Eclipselink version bundled with our version of weblogic.

Since it seems to work with batchfetchtype JOIN instead of EXISTS it seems we have to go by that for now.

Thank you Chris Delahunt for your kind response!

Re: Non-foreign key added in batchfetch select [message #1729602 is a reply to message #1729547]

Fri, 15 April 2016 15:17

Eclipse User

Odd that different drivers seem to affect the results. Can you provide the log of the two queries being executed and parameters being logged? The first query for Malh and the second that gets the issue for the referenced Malhand instances. Seems like a bug, but I'm not sure where it would be, or why different drivers/datasource would make a difference. The logging should show what EclipseLink is using when creating the JDBC statements, and with the version of the drivers, might help issolate if there is a driver bug or something else.

Best Regards,
Chris

Re: Non-foreign key added in batchfetch select [message #1729721 is a reply to message #1729602]

Mon, 18 April 2016 09:12

Eclipse User

Setup:
Oracle database, the same data used in both tests below.

Test 1: JUnit test, i.e., no WebLogic involved. Works.

In pom.xml:
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>10.3.6</version>
</dependency>
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>eclipselink</artifactId>
<version>2.3.1</version>
</dependency>
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>javax.persistence</artifactId>
<version>2.0.0</version>
</dependency>

In persistence.xml:
<property name="javax.persistence.jdbc.url" value="jdbc:oracle:thin:@//<removed>" />
<property name="javax.persistence.jdbc.driver" value="oracle.jdbc.driver.OracleDriver" />
<property name="javax.persistence.jdbc.user" value="<removed>" />
<property name="javax.persistence.jdbc.password" value="<removed>" />
<property name="eclipselink.target-database" value="org.eclipse.persistence.platform.database.OraclePlatform" />
<property name="eclipselink.cache.shared.default" value="false" />
<property name="eclipselink.jdbc.batch-writing" value="jdbc" />
<property name="eclipselink.jdbc.batch-writing.size" value="100" />

From log:
[EL Finest]: 2016-04-18 11:39:02.723--UnitOfWork(6534179)--Thread(Thread[main,5,main])
--Execute query ReadAllQuery(name="findByMalnummer" referenceClass=Malh sql="SELECT ID, DTYPE, MALID, MALNUMMER, ORIGIN_SYSTEM, REFERENSNUMMER, REGISTRERINGSDATUM, UPDATED, UPDATED_BY, VERSION FROM MALH WHERE (MALNUMMER = ?)"
)
[EL Fine]: 2016-04-18 11:39:02.725--ClientSession(22732137)--Connection(12942642)--Thread(Thread[main,5,main])
--SELECT ID, DTYPE, MALID, MALNUMMER, ORIGIN_SYSTEM, REFERENSNUMMER, REGISTRERINGSDATUM, UPDATED, UPDATED_BY, VERSION FROM MALH WHERE (MALNUMMER = ?)
bind => [198702031280-3]
[EL Finest]: 2016-04-18 11:39:02.873--UnitOfWork(6534179)--Thread(Thread[main,5,main])
--Execute query ReadAllQuery(name="malhands" referenceClass=Malhand sql="SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER = ?) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID))) ")
[EL Fine]: 2016-04-18 11:39:02.873--ClientSession(22732137)--Connection(12942642)--Thread(Thread[main,5,main])
--SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER = ?) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID)))
bind => [198702031280-3]

Test 2: Accessing the same data using WebLogic. Doesn't work.

WebLogic info:
<2016-apr-18 kl 11:52 CEST> <Info> <WebLogicServer> <BEA-000377> <Starting WebLogic Server with Java HotSpot(TM) Client VM Version 20.4-b02 from Sun Microsystems Inc.>
<2016-apr-18 kl 11:52 CEST> <Info> <Management> <BEA-141107> <Version: WebLogic Server Temporary Patch for 9923849 Tue Oct 18 16:53:26 MDT 2011
WebLogic Server 10.3.6.0.6 PSU Patch for BUG17071663 Tue OCT 02 13:01:30 IST 2013

Eclipselink info:
Eclipse Persistence Services - 2.3.1.v20111018-r10243

Oracle info:
<BEA-001177> <Creating data source connection pool named oraclePool, URL = jdbc:oracle:thin:@<removed>, Properties = user=<removed>;.>
<BEA-000626> <Free resources in pool "oraclePool" will be tested every "600" seconds.>
<BEA-001516> <Data source connection pool "oraclePool" connected to Database: "Oracle", Version: "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options".>
<BEA-001517> <Data source connection pool "oraclePool" using Driver: "Oracle JDBC driver", Version: "11.2.0.1.0".>

From persistence.xml:
<property name="eclipselink.target-server" value="WebLogic_10" />
<property name="eclipselink.jdbc.batch-writing" value="jdbc" />
<property name="eclipselink.jdbc.batch-writing.size" value="100" />

From persistence log:
[EL Finest]: 2016-04-18 14:19:45.246--ServerSession(24317947)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--reconnecting to external connection pool
[EL Fine]: 2016-04-18 14:19:45.25--ServerSession(24317947)--Connection(24167087)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--SELECT ID, DTYPE, MALID, MALNUMMER, ORIGIN_SYSTEM, REFERENSNUMMER, REGISTRERINGSDATUM, UPDATED, UPDATED_BY, VERSION FROM MALH WHERE (MALNUMMER IN (?))
bind => [198702031280-3]
[EL Finest]: 2016-04-18 14:19:45.252--ServerSession(24317947)--Connection(24483974)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--Connection released to connection pool [read].
[...]
[EL Finest]: 2016-04-18 14:19:45.256--UnitOfWork(3593080)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--Execute query ReadAllQuery(name="malhands" referenceClass=Malhand sql="SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ?) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID))) ")
[EL Finest]: 2016-04-18 14:19:45.256--ServerSession(24317947)--Connection(53028)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--Connection acquired from connection pool [read].
[EL Finest]: 2016-04-18 14:19:45.256--ServerSession(24317947)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--reconnecting to external connection pool
[EL Fine]: 2016-04-18 14:19:45.256--ServerSession(24317947)--Connection(18840807)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ()) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID)))
[EL Fine]: 2016-04-18 14:19:45.259--ServerSession(24317947)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--SELECT 1 FROM DUAL
[EL Finest]: 2016-04-18 14:19:45.26--ServerSession(24317947)--Connection(53028)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--Connection released to connection pool [read].
[EL Warning]: 2016-04-18 14:19:45.26--UnitOfWork(3593080)--Thread(Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00936: uttryck saknas

Error Code: 936
Call: SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ()) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID)))
Query: ReadAllQuery(name="malhands" referenceClass=Malhand sql="SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ?) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID))) ")

From exception log:
2016-04-18 12:01:07,272 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR stacktrace:11 -
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00936: uttryck saknas

Error Code: 936
Call: SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ()) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID)))
Query: ReadAllQuery(name="malhands" referenceClass=Malhand sql="SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ?) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID))) ")
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00936: uttryck saknas

Error Code: 936
Call: SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ()) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID)))
Query: ReadAllQuery(name="malhands" referenceClass=Malhand sql="SELECT t0.ID, t0.EXNUMMER, t0.NOTERING, t0.STATUS, t0.TEAM, t0.VERKSTALLIGHETSMAL_ID FROM MALHAND t0 WHERE EXISTS (SELECT t1.ID FROM MALH t1 WHERE ((t1.MALNUMMER IN ?) AND (t0.VERKSTALLIGHETSMAL_ID = t1.ID))) ")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:646)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2611)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2570)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:420)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1081)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1040)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:392)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1128)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
at org.eclipse.persistence.mappings.CollectionMapping.executeBatchQuery(CollectionMapping.java:883)
at org.eclipse.persistence.mappings.ForeignReferenceMapping.extractResultFromBatchQuery(ForeignReferenceMapping.java:579)
at org.eclipse.persistence.mappings.CollectionMapping.extractResultFromBatchQuery(CollectionMapping.java:864)
at org.eclipse.persistence.internal.indirection.BatchValueHolder.instantiate(BatchValueHolder.java:58)
at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:88)
at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:161)
at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:222)
at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
at org.eclipse.persistence.indirection.IndirectList.buildDelegate(IndirectList.java:244)
at org.eclipse.persistence.indirection.IndirectList.getDelegate(IndirectList.java:414)
at org.eclipse.persistence.indirection.IndirectList$1.<init>(IndirectList.java:542)
at org.eclipse.persistence.indirection.IndirectList.listIterator(IndirectList.java:541)
at org.eclipse.persistence.indirection.IndirectList.iterator(IndirectList.java:505)
at malh.interfaces.gui.dto.MalhandConverter.entityListToInternalList(MalhandConverter.java:40)
at malh.interfaces.gui.dto.MalhAssembler.toDto(MalhAssembler.java:20)
at malh.interfaces.gui.MalhFacadeBean.getMalh(MalhFacadeBean.java:66)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at re.common.ejb.interceptor.JPAFlushingInterceptor.flushIfPossible(JPAFlushingInterceptor.java:40)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at auth.AuthInterceptor.auth(AuthInterceptor.java:17)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at re.common.ejb.interceptor.WebExceptionInterceptor.logCall(WebExceptionInterceptor.java:35)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at re.common.ejb.interceptor.ResponseStateInterceptor.processCall(ResponseStateInterceptor.java:22)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at kz.framework.audit.KzWebAuditInterceptor.logCall(KzWebAuditInterceptor.java:38)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at kz.ejb.callcontext.KzCallContextInterceptor.auth(KzCallContextInterceptor.java:42)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy204.getMalh(Unknown Source)
at malh.interfaces.gui.MalhFacadeBean_w630g_MalhFacadeImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at malh.interfaces.gui.MalhFacadeBean_w630g_MalhFacadeImpl.getMalh(Unknown Source)
at malh.interfaces.gui.MalhFacadeBean_w630g_MalhFacadeImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:347)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:261)
at malh.interfaces.gui.MalFacadeBean_w630g_MalFacadeImpl_1036_WLStub.getAktivaOchAvstalldaVerkstallighetsmal(Unknown Source)
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:597)
at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
at $Proxy203.getMalh(Unknown Source)
at re.web.service.MalhServiceAdapter.hamtaMalh(MalhServiceAdapter.java:48)
at re.web.mal.MalhHolder.laddaMalh(MalhHolder.java:76)
at re.web.mal.maloversikt.MalhController.sokMalh(MalhController.java:152)
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:597)
at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at re.web.infra.listener.ReginaActionListener.callSuperProcessAction(ReginaActionListener.java:33)
at re.web.infra.listener.ReginaActionListener$1.processAction(ReginaActionListener.java:21)
at re.web.infra.listener.ActionListenerChain.execute(ActionListenerChain.java:26)
at re.web.infra.listener.ExceptionListenerWrapper.processAction(ExceptionListenerWrapper.java:16)
at re.web.infra.listener.ActionListenerChain.execute(ActionListenerChain.java:26)
at re.web.infra.listener.TraceLoggingListenerWrapper.executeChain(TraceLoggingListenerWrapper.java:155)
at re.web.infra.listener.TraceLoggingListenerWrapper$ProcessEventMethodInvocation.proceed(TraceLoggingListenerWrapper.java:59)
at kz.guice.interceptor.TraceLoggingInterceptor.invoke(TraceLoggingInterceptor.java:105)
at re.web.infra.listener.TraceLoggingListenerWrapper.processAction(TraceLoggingListenerWrapper.java:162)
at re.web.infra.listener.ActionListenerChain.execute(ActionListenerChain.java:26)
at re.web.infra.listener.ReginaActionListener.processAction(ReginaActionListener.java:29)
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:409)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at re.web.infra.filter.SessionBeanInitializationFilter.doFilter(SessionBeanInitializationFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at kz.ejb.callcontext.KzCallContextFilter.doFilter(KzCallContextFilter.java:48)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2282)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2181)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: uttryck saknas

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:931)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:607)
... 175 more
2016-04-18 12:01:07,300 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR stacktrace:11 - ORA-00936: uttryck saknas

java.sql.SQLSyntaxErrorException: ORA-00936: uttryck saknas

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:931)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:607)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:646)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2611)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2570)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:420)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1081)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1040)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:392)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1128)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
at org.eclipse.persistence.mappings.CollectionMapping.executeBatchQuery(CollectionMapping.java:883)
at org.eclipse.persistence.mappings.ForeignReferenceMapping.extractResultFromBatchQuery(ForeignReferenceMapping.java:579)
at org.eclipse.persistence.mappings.CollectionMapping.extractResultFromBatchQuery(CollectionMapping.java:864)
at org.eclipse.persistence.internal.indirection.BatchValueHolder.instantiate(BatchValueHolder.java:58)
at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:88)
at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:161)
at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:222)
at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:88)
at org.eclipse.persistence.indirection.IndirectList.buildDelegate(IndirectList.java:244)
at org.eclipse.persistence.indirection.IndirectList.getDelegate(IndirectList.java:414)
at org.eclipse.persistence.indirection.IndirectList$1.<init>(IndirectList.java:542)
at org.eclipse.persistence.indirection.IndirectList.listIterator(IndirectList.java:541)
at org.eclipse.persistence.indirection.IndirectList.iterator(IndirectList.java:505)
at malh.interfaces.gui.dto.MalhandConverter.entityListToInternalList(MalhandConverter.java:40)
at malh.interfaces.gui.dto.MalhAssembler.toDto(MalhAssembler.java:20)
at malh.interfaces.gui.MalhFacadeBean.getMalh(MalhFacadeBean.java:66)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at re.common.ejb.interceptor.JPAFlushingInterceptor.flushIfPossible(JPAFlushingInterceptor.java:40)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at auth.AuthInterceptor.auth(AuthInterceptor.java:17)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at re.common.ejb.interceptor.WebExceptionInterceptor.logCall(WebExceptionInterceptor.java:35)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at re.common.ejb.interceptor.ResponseStateInterceptor.processCall(ResponseStateInterceptor.java:22)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at framework.audit.KzWebAuditInterceptor.logCall(KzWebAuditInterceptor.java:38)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
at kz.ejb.callcontext.KzCallContextInterceptor.auth(KzCallContextInterceptor.java:42)
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:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy204.getMalh(Unknown Source)
at malh.interfaces.gui.MalhFacadeBean_w630g_MalhFacadeImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at malh.interfaces.gui.MalhFacadeBean_w630g_MalhFacadeImpl.getMalh(Unknown Source)
at malh.interfaces.gui.MalhFacadeBean_w630g_MalhFacadeImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:347)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:261)
at malh.interfaces.gui.MalhFacadeBean_w630g_MalhFacadeImpl_1036_WLStub.getMalh(Unknown Source)
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:597)
at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
at $Proxy203.getMalh(Unknown Source)
at re.web.service.MalhServiceAdapter.hamtaMalh(MalhServiceAdapter.java:48)
at re.web.mal.MalhHolder.laddaMalh(MalhHolder.java:76)
at re.web.mal.maloversikt.MalhController.sokMalh(MalhController.java:152)
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:597)
at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at re.web.infra.listener.ReginaActionListener.callSuperProcessAction(ReginaActionListener.java:33)
at re.web.infra.listener.ReginaActionListener$1.processAction(ReginaActionListener.java:21)
at re.web.infra.listener.ActionListenerChain.execute(ActionListenerChain.java:26)
at re.web.infra.listener.ExceptionListenerWrapper.processAction(ExceptionListenerWrapper.java:16)
at re.web.infra.listener.ActionListenerChain.execute(ActionListenerChain.java:26)
at re.web.infra.listener.TraceLoggingListenerWrapper.executeChain(TraceLoggingListenerWrapper.java:155)
at re.web.infra.listener.TraceLoggingListenerWrapper$ProcessEventMethodInvocation.proceed(TraceLoggingListenerWrapper.java:59)
at guice.interceptor.TraceLoggingInterceptor.invoke(TraceLoggingInterceptor.java:105)
at re.web.infra.listener.TraceLoggingListenerWrapper.processAction(TraceLoggingListenerWrapper.java:162)
at re.web.infra.listener.ActionListenerChain.execute(ActionListenerChain.java:26)
at re.web.infra.listener.ReginaActionListener.processAction(ReginaActionListener.java:29)
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:409)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at re.web.infra.filter.SessionBeanInitializationFilter.doFilter(SessionBeanInitializationFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at kz.ejb.callcontext.KzCallContextFilter.doFilter(KzCallContextFilter.java:48)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2282)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2181)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Re: Non-foreign key added in batchfetch select [message #1729768 is a reply to message #1729721]

Mon, 18 April 2016 14:03

Eclipse User

Strange, as the first query is different in the two tests -the first uses "FROM MALH WHERE (MALNUMMER = ?)" while the second uses "FROM MALH WHERE (MALNUMMER IN (?))". I'm not sure what is causing it, so it might be a slight difference in the EclipseLink version that ships with WLS causing the 'in' collection to go missing or be treated differently. The only solution I can suggest at this point would be to try a later version (2.5.2 etc) and see if it still reproduces in WLS, and file a bug if it does.

Best Regards,
Chris

Re: Non-foreign key added in batchfetch select [message #1729803 is a reply to message #1729768]

Tue, 19 April 2016 04:13

Eclipse User

Sorry, my bad... Sad

there are two similar methods in our code, one taking a list as argument, the other just taking a single value, and I posted the latter version by mistake.
However, I just doublechecked, and the outcome is exactly the same (i.e., in the log '= ?' is naturally replaced by 'IN (?)', but the test works the same. With emphasis on 'works'. Smile

)
Sorry for the confusion, clumsy of me.

Previous Topic:	Query Results Cache with OneToMany and "Fetch Join"
Next Topic:	Unmarshalling inheritance based entity failed in WebLogic

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 13:58:49 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter