[appfuse-user] Oracle setup fails 3 tests (cannot insert NULL into ("SYSTEM"."APP_USER"."ID"))

[andreistoiculescu]

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: users-unsubscr...@appfuse.dev.java.net
For additional commands, e-mail: users-h...@appfuse.dev.java.net