We have developed an application that is deployed into weblogic application server.
This application executes one SELECT INTO OUTFILE statement using one defined JDBC resource. Database access uses JPA with EclipseLink provider with next configuration:
<persistence-unit name="HandleData" transaction-type="JTA">
<jta-data-source>jdbc/HandleData</jta-data-source>
<properties>
<property name="javax.persistence.ddl-generation" value="update" />
<property name="eclipselink.logging.level" value="INFO"/>
<property name="eclipselink.cache.shared.default" value="false"/>
</properties>
</persistence-unit
And we are obtaining the following exception while trying to execute the mentioned query in the logs:
[#|2013-05-22T15:32:27.107+0200|FINEST|ece|com.ericsson.jee.ngin.asc.dao.impl.AscAccessDataBean|_ThreadID=79;_ThreadName=[ACTIVE] ExecuteThread: '43' for queue: 'weblogic.kernel.Default (self-tuning)';ClassName=com.ericsson.jee.ngin.asc.dao.impl.AscAccessDataBean;MethodName=generateSnapshotOneTable;_RequestID=<unavailable>|Attribute AscEricssonSubscribers Query: SELECT 'Msisdn','CarrierCode','AscProfileId','AscBarringProfileId','AdminBlocking' UNION SELECT * FROM asc_subscribers INTO OUTFILE '/home/asc/db_snapshots/AscEricssonSubscribers_20130522_153227.txt' FIELDS TERMINATED BY ':';|#]
[#|2013-05-22T15:32:27.109+0200|SEVERE|ece|com.ericsson.jee.ngin.asc.dao.impl.AscAccessDataBean|_ThreadID=79;_ThreadName=[ACTIVE] ExecuteThread: '43' for queue: 'weblogic.kernel.Default (self-tuning)';ClassName=com.ericsson.jee.ngin.asc.dao.impl.AscAccessDataBean;MethodName=generateSnapshotOneTable;_RequestID=<unavailable>|org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:687)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:530)
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:914)
org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:131)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:245)
org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:188)
Is additional configuration needed in persistence.xml file?
Thanks a lot for your support
Best Regards,
Jorge