MySQLTest.java

package org.oddjob.sql;

import junit.framework.TestCase;

import org.oddjob.Oddjob;
import org.oddjob.OddjobLookup;
import org.oddjob.arooa.convert.ArooaConversionException;
import org.oddjob.arooa.reflect.ArooaPropertyException;
import org.oddjob.arooa.xml.XMLConfiguration;
import org.oddjob.state.ParentState;

public class MySQLTest extends TestCase {

	public void testCallable() throws ArooaPropertyException, ArooaConversionException {
		
		if (System.getProperty("mysql.home") == null) {
			return;
		}
		
		Oddjob oddjob = new Oddjob();
		oddjob.setConfiguration(new XMLConfiguration(
				"org/oddjob/sql/MySQLCallable.xml",
				getClass().getClassLoader()));
		oddjob.run();

		assertEquals(ParentState.COMPLETE, 
				oddjob.lastStateEvent().getState());

		OddjobLookup lookup = new OddjobLookup(oddjob);
		
		assertEquals(new Integer(0), lookup.lookup(
				"sp-result1", Integer.class));
		
		assertEquals(new Integer(0), lookup.lookup(
				"sp-result2", Integer.class));
				
		oddjob.destroy();

	}
}