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 13:01 |
Fredrik Gustafsson Messages: 5 Registered: April 2016 |
Junior Member |
|
|
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 18:09 |
Chris Delahunt Messages: 1389 Registered: July 2009 |
Senior Member |
|
|
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 18:11] Report message to a moderator
|
|
| | | |
Re: Non-foreign key added in batchfetch select [message #1729721 is a reply to message #1729602] |
Mon, 18 April 2016 13:12 |
Fredrik Gustafsson Messages: 5 Registered: April 2016 |
Junior Member |
|
|
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 #1729803 is a reply to message #1729768] |
Tue, 19 April 2016 08:13 |
Fredrik Gustafsson Messages: 5 Registered: April 2016 |
Junior Member |
|
|
Sorry, my bad... 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'. )
Sorry for the confusion, clumsy of me.
|
|
|
Goto Forum:
Current Time: Fri Mar 29 09:39:38 GMT 2024
Powered by FUDForum. Page generated in 0.02753 seconds
|