Genarating CSV File from OAF:

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.io.FileWriter;




if("printErrors".equals(pageContext.getParameter(EVENT_PARAM))){
try

{
System.out.println("printErrors1");
String csv = "D:\\output.csv";
FileWriter writer = new FileWriter(csv);
Connection conn = am.getOADBTransaction().getJdbcConnection();

String Query = "select attribute1,attribute2,attribute3 from  XXX_ERROR_TBL";

PreparedStatement stmt = conn.prepareStatement(Query);
writer.append("File Name");
writer.append(',');
writer.append("Row Number");
writer.append(',');
writer.append("Error Message");
writer.append('\n');

for(ResultSet resultset = stmt.executeQuery(); resultset.next();)
{
pageContext.writeDiagnostics(this, "Query Executed", 1);
String result = resultset.getString("attribute1");
String result1 = resultset.getString("attribute2");
String result2 = resultset.getString("attribute3");
System.out.println("results are "+result);
System.out.println("results1 are "+result1);
System.out.println("results2 are "+result2);
writer.append(result);
writer.append(',');
writer.append(result1);
writer.append(',');
writer.append(result2);
writer.append('\n');

}
writer.flush();
writer.close();

}

catch(Exception exception)

{
throw new OAException("Error in Staffing Query"+exception, OAException.ERROR);
}

}//close if printErrors

// End writing CSV