NoSuchTableException when (trying) to use DBUnit

[William Fernandes]

Hello,

I'm trying to use DBUnit (version 2.4.8) because I like the idea but the framework is detestable.

I'm following the Getting Started session of the official website, doing the most simple basic test, but it's not working when I try to run the test:

//imports
public class SampleTest extends DBTestCase {

	public SampleTest(String name) {
		super(name);

		System.setProperty(
				PropertiesBasedJdbcDatabaseTester.DBUNIT_DRIVER_CLASS,
				"com.mysql.jdbc.Driver");
		System.setProperty(
				PropertiesBasedJdbcDatabaseTester.DBUNIT_CONNECTION_URL,
				"jdbc:mysql://localhost");
		System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_USERNAME,
				"root");
		System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_PASSWORD,
				"senha");
		System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_SCHEMA,
				"teste");
	}

	@Override
	protected IDataSet getDataSet() throws Exception {
		FlatXmlDataSetBuilder xmlDataSetBuilder = new FlatXmlDataSetBuilder();
	
		return xmlDataSetBuilder.build(new FileInputStream("dataset.xml"));
	}

	@Test
	public void test() {
		String url = "jdbc:msql://localhost";
		Connection con = null;

		try {
                    //Tries a JDBC connection for a Select query...
                }
              ...
          }
}

My dataset.xml (which it loads - located in the classpath, above src folder):

<?xml version="1.0" encoding="UTF-8"?>
<dataset>    
	<users id="1" name="John" password="senhas2" emailaddress="[e-mail]"/>
</dataset>

The error stack I get when I run my test:

org.dbunit.dataset.NoSuchTableException: users
	at org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:288)
	at org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:109)
	at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:79)
	at org.dbunit.AbstractDatabaseTester.executeOperation(AbstractDatabaseTester.java:190)
	at org.dbunit.AbstractDatabaseTester.onSetup(AbstractDatabaseTester.java:103)
	at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:156)
	at junit.framework.TestCase.runBare(TestCase.java:132)
	at junit.framework.TestResult$1.protect(TestResult.java:110)
	at junit.framework.TestResult.runProtected(TestResult.java:128)
	at junit.framework.TestResult.run(TestResult.java:113)
	at junit.framework.TestCase.run(TestCase.java:124)
	at junit.framework.TestSuite.runTest(TestSuite.java:232)
	at junit.framework.TestSuite.run(TestSuite.java:227)
	at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:79)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Yes, the table users does exist in my local MySQL. I tried to debug and I saw that the Map which it loads with the table names comes empty, so it considers that the current schema is empty, which is not.

What am I doing wrong?

Thanks