?????????·?????????????????????????

???????????? ???????[ 2013/7/24 15:10:31 ] ????????

???????д????????????????????????????????Щ????????????Google???????????????Щ???????о?????????????????????????????????????

?????????????????????? Spring Test + SpringTestDbUnit + DbUnit??

??????????????????????

????Spring???<jdbc??embedded-database>??????????????????????磺

<jdbc:embeded-database id="dataSource" type="HSQL">

????????????????????????????

????Caused by?? org.xml.sax.SAXParseException?? lineNumber?? 31?? columnNumber?? 57?? cvc-complex-type.2.4.c?? ????????????棬 ??????????? 'jdbc??embedded-database' ????????
????at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java??198)
????at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java??134)
????at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java??437)
????……

??????????????????????Σ??????dtd???????飬?????з?????????????俴??context???????????????????????????

<beans xmlns=http://www.springframework.org/schema/beans
       xmlns:p=http://www.springframework.org/schema/p
       xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
       xmlns:context=http://www.springframework.org/schema/context
       xmlns:tx=http://www.springframework.org/schema/tx xmlns:jpa=http://www.springframework.org/schema/data/jpa
       xmlns:task=http://www.springframework.org/schema/task xmlns:aop=http://www.springframework.org/schema/aop
       xmlns:jdbc=http://www.springframework.org/schema/jdbc
       xsi:schemaLocation="http://www.springframework.org/schema/<SPAN style="COLOR: #ff0000">tx</SPAN>/spring-jdbc-3.2.xsd">

????????????￡?????????tx????????????????????tx?????jdbc??????????·????tx???jdbc???????????????????У?????????????????????????????????

??????????????????μ????????

?????????д?????????????????????ж?????????????????????У??????????????
????Tests run: 5?? Failures: 0?? Errors: 3?? Skipped: 0?? Time elapsed: 0.879 sec <<< FAILURE! - in com.noyaxe.nso.service.DeviceServiceTest
????testInitializedForBindedSpaceForceBind(com.noyaxe.nso.service.DeviceServiceTest) Time elapsed: 0.309 sec <<< ERROR!
????java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK_L6IDVK78B2TLU8NO6EDJ0G6U8 table: CUSTOM_TABLE_COLUMN_SPACE_TYPE
????at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
????at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
????at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
????……
????……

????Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; FK_L6IDVK78B2TLU8NO6EDJ0G6U8 table: CUSTOM_TABLE_COLUMN_SPACE_TYPE

????at org.hsqldb.error.Error.error(Unknown Source)
????at org.hsqldb.StatementDML.performReferentialActions(Unknown Source)
????at org.hsqldb.StatementDML.delete(Unknown Source)
????at org.hsqldb.StatementDML.executeDeleteStatement(Unknown Source)
????at org.hsqldb.StatementDML.getResult(Unknown Source)
????at org.hsqldb.StatementDMQL.execute(Unknown Source)
????at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
????at org.hsqldb.Session.executeDirectStatement(Unknown Source)
????at org.hsqldb.Session.execute(Unknown Source)
????at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
????……