Hi
I have a strategy which:-
(a) accesses a table of data, performs data mining and updates the table
(b) continuously writes out debugging data to a file
When I run this strategy in demo state, everything works perfectly

The following is the early code for access to database table..................
private class DerbyApp
{
private String framework = "embedded";
private String driver = "org.apache.derby.jdbc.EmbeddedDriver";
private String protocol = "jdbc:derby:";
void go(String[] args_derby)
{
parseArguments(args_derby);
fw.writetoFile(("DerbyApp starting in " + framework + " mode"), FILE_NAME);
loadDriver();
ArrayList statements = new ArrayList(); // list of Statements, PreparedStatements
PreparedStatement ps = null;
PreparedStatement psInsert = null;
PreparedStatement psUpdate = null;
PreparedStatement psDelete = null;
fw.writetoFile(("DerbyApp starting in " + framework + " mode"), FILE_NAME);
try
{
Properties props = new Properties(); // connection properties
props.put("user", "BobM");
props.put("password", "xxxx");
String dbName = "C:/Users/Stan/.netbeans-derby/us_copiosus_USDJPY_S"; // the name of the database
conn = DriverManager.getConnection(protocol + dbName, props);
fw.writetoFile(("Connected to database " + dbName), FILE_NAME);
conn.setAutoCommit(false);
s = conn.createStatement();
statements.add(s);
When I run this strategy in the Historical Tester
(c) the data table is NOT updated - not sure whether the table is accessed or not
(d) error occurs - File writing error - can't find the path specified
Any ideas on how to correct both of these problems?
Many thanks
Bob M