Re: Help with ERXEOAccessUtilities
Re: Help with ERXEOAccessUtilities
- Subject: Re: Help with ERXEOAccessUtilities
- From: Ramsey Gurley <email@hidden>
- Date: Mon, 14 Nov 2011 17:00:38 -0700
I get a red X in eclipse because of the unescaped " before the last FROM.
On Nov 14, 2011, at 4:34 PM, Gino Pacitti wrote:
> Hi All
> Any help with this code:
>
> I am trying to execute this code:
>
> EOEditingContext ec = new EOEditingContext();
>
> ERXEOAccessUtilities.evaluateSQLWithEntityNamed(ec, "Sitedata", "SELECT 'resourceName','address','place' UNION SELECT resourceName,address,place INTO OUTFILE '/Users/Gino/Desktop/salesreport.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' FROM Sitedata;");
>
> And I get this exception?
>
> Any help or experience..
>
> Access denied for user 'admin'@'127.0.0.1' (using password: YES)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
> at com.mysql.jdbc.Statement.execute(Statement.java:529)
> at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:272)
> at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
> at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
> at er.extensions.ERXEOAccessUtilities.evaluateSQLWithEntity(ERXEOAccessUtilities.java:191)
> at er.extensions.ERXEOAccessUtilities.evaluateSQLWithEntityNamed(ERXEOAccessUtilities.java:164)
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden