Hello,
I have tried to setup appfuse 2 with Oracle10gXE, but when running the
integration tests I get the following three failures :
Tests in error:
testAddAndRemoveUser(eastBanquet.dao.UserDaoTest)
testCRUD(eastBanquet.dao.UniversalDaoTest)
testAddAndRemoveRole(eastBanquet.dao.RoleDaoTest)
If i study the surefire reports, I observe the following :
...Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into
("SYSTEM"."APP_USER"."ID")...
...Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into
("SYSTEM"."ROLE"."ID")...
All the oracle objects (the tables and the sequence seem to have been
created fine, and the sample-data has been inserted into the tables). It
looks to me as if the saveUser(user), save(user) etc.. methods fail, because
the id is null, but I can't figure out why the id is null.
This is my Oracle profile from the pom.xml :
<profile>
<id>oracle</id>
<properties>
<dbunit.dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</dbunit.dataTypeFactoryName>
<dbunit.schema>SYSTEM</dbunit.schema> <!-- Make sure to
capitalize the schema name -->
<hibernate.dialect>org.hibernate.dialect.Oracle10gDialect</hibernate.dialect>
<jdbc.groupId>com.oracle</jdbc.groupId>
<jdbc.artifactId>ojdbc14</jdbc.artifactId>
<jdbc.version>10.2.0.2.0</jdbc.version>
<jdbc.driverClassName>oracle.jdbc.OracleDriver</jdbc.driverClassName>
<jdbc.url><![CDATA[jdbc:oracle:thin:@localhost:1521:XE]]></jdbc.url>
<jdbc.username>system</jdbc.username>
<jdbc.password>root</jdbc.password>
</properties>
</profile>
and I am executing the following command : mvn -Poracle jetty:run-war
This is the code in the User, as well as the Role class, for the id.
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
public Long getId() {
return id;
}
Thank you for the help,
Andrei
--
View this message in context:
http://www.nabble.com/Oracle-setup-fails-3-tests-%28cannot-insert-NULL-into-%28%22SYSTEM%22.%22APP_USER%22.%22ID%22%29%29-tp25750597s2369p25750597.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
