import javax.sql.ConnectionPoolDataSource;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;

public class DerbyTest {

    public static void main(String[] args) throws Exception {
	//ConnectionPoolDataSource ds = initializeDataSource();
        DataSource ds = initializeDataSource();
	Connection con = ds.getConnection();
	System.out.println("Autocommit : " + con.getAutoCommit());
	con.commit();
	con.close();
    }

    private static org.apache.derby.jdbc.ClientDataSource initializeDataSource() {
        org.apache.derby.jdbc.ClientDataSource ds = new org.apache.derby.jdbc.ClientDataSource();	    
	try {
	    ds.setUser("dbuser");
	    ds.setPassword("dbpassword");
	    ds.setDatabaseName("sun-appserv-samples");
	    ds.setPortNumber(1527);
	    ds.setServerName("localhost");
	    ds.setCreateDatabase("");
	    ds.setRetrieveMessageText(true);
	    ds.setShutdownDatabase("");
            ds.setSsl("off");
	    ds.setTraceDirectory("");
	    ds.setTraceFile("");
	    ds.setTraceFileAppend(false);
	    ds.setTraceLevel(-1);
	} catch(Exception ex) {
	    ex.printStackTrace();
	}
	return ds;
    }
}