¡¡¡¡ÎÊÌâ2£ºÊý¾Ý¿â½Å±¾ÎÞ·¨Ö´ÐС£µ½myproject\core\targetĿ¼Ï£¬ÕÒµ½schema.sql¡£´ò¿ª²é¿´£¬·¢ÏÖÒ»ÇÐÕý³££¬Äãµ½sqlplusÏÂÃæÖ´ÐÐÕâ¸ösqlÎļþҲûÓÐÎÊÌâ¡£
¡¡¡¡Îļþ·¢ÉúµÄÔÒòÊÇÕâ¸ösql²»ÊÇÓÉsqlplusÖ´Ðеģ¬¶øÊÇ2.ÓÐhibernateÖ´Ðеģ¡hibernateÖ´ÐÐsqlÓï¾äµÄʱºò£¬²»ÄÜÓжÎÂä½áÊø·ûºÏ¡°£»¡±¡£ËùÒÔ±¨´í£¡½â¾ö°ì·¨ÊÇÔÚappfuse-3.5.0.pomÖеÄoracle profileÖÐÔö¼ÓÒ»¸öÉèÖ㬰ѶÎÂä·Ö¸î·ûÉèÖóɿգº
¡¡¡¡<hibernate.export.schema.delimiter></hibernate.export.schema.delimiter>
¡¡¡¡ÕâÑùÎÊÌâ¾Í½â¾öÁË£¡
¡¡¡¡ÎÊÌâ3£ºµ¥Ôª²âÊÔ²»ÄÜͨ¹ý¡£±¨Ò»¸öÆæ¹ÖµÄ´íÎó£º
¡¡¡¡Tests run: 9, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 2.167 sec <<< FAILURE!
¡¡¡¡testUpdateUser(com.exam.dao.UserDaoTest) Time elapsed: 0.088 sec <<< ERROR!
¡¡¡¡java.lang.Exception: Unexpected exception, expected<org.springframework.dao.DataIntegrityViolationException> but was<org.springframework.orm.hibernate4.HibernateSystemException>
¡¡¡¡Õâ¸öÎÊÌâÒѾ±»Ìá½»µ½AppFuseµÄÓʼþÁбíÖУ¬µ«ÊÇ»¹Ã»ÓÐÕýÃæµÄ»Ø¸´£¬Ö»ÓÐÒ»¸ö¹æ±ÜµÄ°ì·¨¡£Éî²ã´ÎµÄÔÒòÐèÒªÓÐÄÜÁ¦µÄÈ˼ÌÐøÍÚ¾ò£¡
¡¡¡¡¹æ±Ü°ì·¨ÊÇ×¢Ê͵ô²âÊÔ´úÂëUserDaoTest.javaµÄµÚ68ÐУº//user2.setRoles(user.getRoles());
¡¡¡¡user2.setLastName(user.getLastName());
¡¡¡¡user2.setPassword(user.getPassword());
¡¡¡¡user2.setPasswordHint(user.getPasswordHint());
¡¡¡¡//user2.setRoles(user.getRoles());
¡¡¡¡user2.setUsername(user.getUsername());
¡¡¡¡user2.setWebsite(user.getWebsite());
¡¡¡¡ÐÞ¸ÄÁËÕ⼸¸öÎÊÌ⣬oracle profile¾Í»á³É¹¦¼¤»î£¬²âÊÔͨ¹ý²¢Éú³Éjar°ü¡¢war°ü¡£
¡¡¡¡ÁíÍ⣬ÎÒÐÞ¸ÄoracleÊý¾Ý¿âprofile(appfuse-3.5.0.pom)µÄ·½Ê½±È½Ï²»¿ÉÈ¡£¬¸ü¿ÆѧµÄ·½Ê½ÊÇÐÞ¸ÄmyprojectÏÂÃæµÄpom.xml.
<properties> ...ÆäËûÉèÖà <!-- ΪÁ´½ÓoracleÊý¾Ý¿âÌí¼ÓÁËÒÔÏÂÉèÖÃÏÕâЩÉèÖÃÏîµÄĬÈÏÖµÖ¸ÏòmysqlÊý¾Ý¿â --> <dbunit.dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</dbunit.dataTypeFactoryName> <dbunit.schema>MYPROJECT</dbunit.schema> <hibernate.dialect>org.hibernate.dialect.Oracle10gDialect</hibernate.dialect> <jdbc.groupId>com.oracle</jdbc.groupId> <jdbc.artifactId>ojdbc6</jdbc.artifactId> <jdbc.version>11.2.0</jdbc.version> <jdbc.driverClassName>oracle.jdbc.OracleDriver</jdbc.driverClassName> <jdbc.url><![CDATA[jdbc:oracle:thin:@localhost:1521:Orcl]]></jdbc.url> <jdbc.username>myproject</jdbc.username> <jdbc.password>myproject</jdbc.password> <jdbc.validationQuery><![CDATA[SELECT 1 + 1 from DUAL]]></jdbc.validationQuery> </properties> |