org.dbunit.database.AmbiguousTableNameException:

关于org.dbunit.database.AmbiguousTableNameException:异常

org.dbunit.database.AmbiguousTableNameException:
在使用springboot和dbutils时,在测试dao层的时候出现该情况
下面展示一些

public class TestUserDao {
    private UserDao userDao;

    
    private DatabaseConnection databaseConnection;

    @Before
    public  void init() throws SQLException, DatabaseUnitException {
        userDao = new UserDao();
        databaseConnection=new DatabaseConnection(JdbcUtils.getConnection());
    }
    @Test
    public void testfindUserByid() throws Exception {
//        System.out.println("获取链接"+databaseConnection.getConnection());
        //备份数据
        backAllTables();

    }
    /**
     * 备份所有表的数据
     * @author sosmcc
     * @param
     */
    private void backAllTables() throws Exception {
        IDataSet dataSet = connection.createDataSet();
        FlatXmlDataSet.write(dataSet,new FileOutputStream(new File("D:/Desktop/allback.xml")));
    }

}

当运行的时候会出现
原因是:数据库里面你表的名字重复,比如你用的是
user数据库 里面的 t_user表,
但是你的另外一个数据库admin表名也是:
t_user
就会出现该错误
无论你是用德鲁伊还是c3p0

解决办法

把数据库的表名全部改了,别重复
使用dbutils提供的mysql专用的Connection
       IDatabaseConnection connection =new MySqlConnection(Jdbcutils.getconnection(),"cartest");
1
“cartest”指的就是你的数据库名字

org.dbunit.dataset.DataSetException: error producing dataset for table 't_seven_meal_service_order_delivery_details_2' at org.dbunit.dataset.csv.CsvProducer.produce(CsvProducer.java:95) at org.dbunit.dataset.CachedDataSet.<init>(CachedDataSet.java:88) at org.dbunit.dataset.CachedDataSet.<init>(CachedDataSet.java:73) at org.dbunit.dataset.csv.CsvDataSet.<init>(CsvDataSet.java:43) at common.CsvDataSetLoader.createDataSet(CsvDataSetLoader.java:23) at com.github.springtestdbunit.dataset.AbstractDataSetLoader.loadDataSet(AbstractDataSetLoader.java:54) at com.github.springtestdbunit.DbUnitRunner.loadDataset(DbUnitRunner.java:209) at com.github.springtestdbunit.DbUnitRunner.loadDataSets(DbUnitRunner.java:192) at com.github.springtestdbunit.DbUnitRunner.setupOrTeardown(DbUnitRunner.java:173) at com.github.springtestdbunit.DbUnitRunner.beforeTestMethod(DbUnitRunner.java:75) at com.github.springtestdbunit.DbUnitTestExecutionListener.beforeTestMethod(DbUnitTestExecutionListener.java:185) at org.springframework.test.context.TestContextManager.beforeTestMethod(TestContextManager.java:320) at org.springframework.test.context.junit.jupiter.SpringExtension.beforeEach(SpringExtension.java:240) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) Caused by: org.dbunit.dataset.csv.CsvParserException: Expected 23 columns on line 2, got 25. Offending line: "123456","5","1234567890123456789012345678901234","8d8e1f2a5d61d832c3b5ae1f2a5d6","6E656E6265","2","1","12","00","20241230","100","1","1","1234567890123","000001","123456","100","100","1","0","1000","2023-01-01 12:59:59","SPUA3544",'test',"0" at org.dbunit.dataset.csv.CsvParserImpl.collectExpectedNumberOfColumns(CsvParserImpl.java:196) at org.dbunit.dataset.csv.CsvParserImpl.parseTheData(CsvParserImpl.java:159) at org.dbunit.dataset.csv.CsvParserImpl.parse(CsvParserImpl.java:124) at org.dbunit.dataset.csv.CsvParserImpl.parse(CsvParserImpl.java:99) at org.dbunit.dataset.csv.CsvProducer.produceFromFile(CsvProducer.java:112) at org.dbunit.dataset.csv.CsvProducer.produce(CsvProducer.java:93) ... 14 more
最新发布
11-15
"original_store_code","created_datetime","pos_number","pos_sequence_number","amount","update_datetime","update_function_id","update_person_id","update_count" "123456",2024-07-08 19:58:43,"1","0555",99999999999,2025-10-09 17:59:57,"1","1",0 报错:org.dbunit.dataset.DataSetException: error producing dataset for table 't_journal_amount_information_s3' at org.dbunit.dataset.csv.CsvProducer.produce(CsvProducer.java:95) at org.dbunit.dataset.CachedDataSet.<init>(CachedDataSet.java:88) at org.dbunit.dataset.CachedDataSet.<init>(CachedDataSet.java:73) at org.dbunit.dataset.csv.CsvDataSet.<init>(CsvDataSet.java:43) at jp.co.sej.ssc.sh.common.CsvDataSetLoader.createDataSet(CsvDataSetLoader.java:23) at com.github.springtestdbunit.dataset.AbstractDataSetLoader.loadDataSet(AbstractDataSetLoader.java:54) at com.github.springtestdbunit.DbUnitRunner.loadDataset(DbUnitRunner.java:209) at com.github.springtestdbunit.DbUnitRunner.loadDataSets(DbUnitRunner.java:192) at com.github.springtestdbunit.DbUnitRunner.setupOrTeardown(DbUnitRunner.java:173) at com.github.springtestdbunit.DbUnitRunner.beforeTestMethod(DbUnitRunner.java:75) at com.github.springtestdbunit.DbUnitTestExecutionListener.beforeTestMethod(DbUnitTestExecutionListener.java:185) at org.springframework.test.context.TestContextManager.beforeTestMethod(TestContextManager.java:320) at org.springframework.test.context.junit.jupiter.SpringExtension.beforeEach(SpringExtension.java:240) at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625) at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:762) at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625) at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596) at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276) at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625) at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) Caused by: org.dbunit.dataset.csv.CsvParserException: Expected 9 columns on line 2, got 1. Offending line: at org.dbunit.dataset.csv.CsvParserImpl.collectExpectedNumberOfColumns(CsvParserImpl.java:196) at org.dbunit.dataset.csv.CsvParserImpl.parseTheData(CsvParserImpl.java:159) at org.dbunit.dataset.csv.CsvParserImpl.parse(CsvParserImpl.java:124) at org.dbunit.dataset.csv.CsvParserImpl.parse(CsvParserImpl.java:99) at org.dbunit.dataset.csv.CsvProducer.produceFromFile(CsvProducer.java:112) at org.dbunit.dataset.csv.CsvProducer.produce(CsvProducer.java:93) ... 43 more
10-10
org.dbunit.dataset.DataSetException: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.dbunit.database.DatabaseDataSet.getTable(DatabaseDataSet.java:342) at com.github.springtestdbunit.assertion.NonStrictDatabaseAssertion.assertEquals(NonStrictDatabaseAssertion.java:47) at com.github.springtestdbunit.DbUnitRunner.verifyExpected(DbUnitRunner.java:154) at com.github.springtestdbunit.DbUnitRunner.verifyExpected(DbUnitRunner.java:120) at com.github.springtestdbunit.DbUnitRunner.afterTestMethod(DbUnitRunner.java:86) at com.github.springtestdbunit.DbUnitTestExecutionListener.afterTestMethod(DbUnitTestExecutionListener.java:190) at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:487) at org.springframework.test.context.junit.jupiter.SpringExtension.afterEach(SpringExtension.java:278) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:356) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:341) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:317) at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:266) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:123) at jdk.proxy2/jdk.proxy2.$Proxy217.executeQuery(Unknown Source) at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:110) at org.dbunit.database.ForwardOnlyResultSetTable.<init>(ForwardOnlyResultSetTable.java:59) at org.dbunit.database.CachedResultSetTableFactory.createTable(CachedResultSetTableFactory.java:60) at org.dbunit.database.DatabaseDataSet.getTable(DatabaseDataSet.java:338) ... 9 more Caused by: org.postgresql.util.PSQLException: ERROR: numeric field overflow 詳細: A field with precision 10, scale 0 must round to an absolute value less than 10^10. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:123) at jdk.proxy2/jdk.proxy2.$Proxy218.execute(Unknown Source) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58) at jdk.proxy3/jdk.proxy3.$Proxy220.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425) at jdk.proxy2/jdk.proxy2.$Proxy189.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288) at com.nec.jp.rpf.zwb.framework.datastoreaccess.FWSingleDao.update(FWSingleDao.java:52) at jp.co.sej.ssc.pu.spua3546.logic.Spua3546Logic.execute(Spua3546Logic.java:166) at jp.co.sej.ssc.pu.spua3546.Spua3546LogicTest.test_1_1_12(Spua3546LogicTest.java:94) at java.base/java.lang.reflect.Method.invoke(Method.java:569) ... 2 more
10-15
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值