Ajuda - The DELETE statement conflicted with the REFERENCE constraint

Programação Java
#1

Pessoal, estou tentando fazer um projeto somente de testes, utilizando o JUnit e DBUnit.

Favor olharem o anexo e se possível identificar o porque do erro

Exportanto para o XML:

public void exportXML() throws Exception {

		//partial database export
		IDatabaseConnection connection = new DatabaseConnection(DBUnitUtil.getDefaultConnection());			
		QueryDataSet dataSet = new QueryDataSet(connection);
		
		dataSet.addTable("PointOfAccessGroup", "SELECT * FROM PointOfAccessGroup");
		dataSet.addTable("PointOfAccessGroupPointOfAccess", "SELECT * FROM PointOfAccessGroupPointOfAccess");
		dataSet.addTable("PointOfAccess", "SELECT * FROM PointOfAccess");
		dataSet.addTable("OrganizationOrganizationType", "SELECT * FROM OrganizationOrganizationType");			
		dataSet.addTable("OrganizationKeyStore", "SELECT * FROM OrganizationKeyStore"); 
		dataSet.addTable("ServiceBladePointOfAccessGroup", "SELECT * FROM ServiceBladePointOfAccessGroup");
		dataSet.addTable("ServiceBladeOutputEndpoint", "SELECT * FROM ServiceBladeOutputEndpoint");		
		dataSet.addTable("ServiceBlade", "SELECT * FROM ServiceBlade"); 
		dataSet.addTable("ConnectorEndpoint", "SELECT * FROM ConnectorEndpoint"); 	
		dataSet.addTable("Organization", "SELECT * FROM Organization"); 
		
		FlatXmlDataSet.write(dataSet, new FileOutputStream("c:\\organization.dataset.xml")); 
		
		System.out.println("Export Finalizado."); 		
	}

getDataSet:

protected IDataSet getDataSet() throws Exception {
        return new FlatXmlDataSetBuilder().build(new FileInputStream("c:\\organization.dataset.xml"));
}	
@Before
public void setup() throws Exception {		
	this.exportXML();
		
	//initialize dataset  
	IDatabaseConnection connection1 	= new DatabaseConnection(DBUnitUtil.getDefaultConnection());			
        DatabaseOperation.CLEAN_INSERT.execute(connection1, getDataSet());

}

Trace do Erro:

java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "FKOrganizationConnectorEndpoint". The conflict occurred in database "SIEConformedDB", table "dbo.ConnectorEndpoint", column 'OrganizationID'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
	at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)
	at org.dbunit.database.statement.SimpleStatement.executeBatch(SimpleStatement.java:69)
	at org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:126)
	at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:79)
	at com.diebold.sie.management.organization.test.ClientTest.setup(ClientTest.java:61)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
	at org.junit.internal.runners.BeforeAndAfterRunner.runBefores(BeforeAndAfterRunner.java:50)
	at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:33)
	at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
	at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
	at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
	at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
	at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
	at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
	at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

Obs1.: As tabelas ServiceBladeScenarioRoutingRule, ServiceBladeScenarioRoutingCondition e ServiceBladeVariable estão vazias.
Obs2.: Direto pelo BD eu consigo deletar os registros das tabelas exatamente na sequencia q esta no código, não dá esse problema de conflito.

Desde já agradeço!

#2

Olá Amigo!
Parece um erro de banco normal. Você está tentando excluir um registro que possui dependências de outra tabela.

Até mais!

#3

Opa! Sorry, não tinha visto o final do post! :cry:

Vou dar uma lida novamente! :wink:

#4