Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: Problems with SELECT INTO OUTFILE with EclipseLink JPA Provider


Advanced Search

Problems with SELECT INTO OUTFILE with EclipseLink JPA Provider
Posted by: Jorge García ()
Date: May 22, 2013 12:03PM

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

Options: ReplyQuote


Subject Written By Posted
Problems with SELECT INTO OUTFILE with EclipseLink JPA Provider Jorge García 05/22/2013 12:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.