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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to