Thank you for the reply.
I have used the hbm2ddl plugin.
mraible wrote:
>
> When using strategy=GenerationType.AUTO for Hibernate and primary
> keys, Hibernate delegates to your database to create primary keys. It
> indicates it wants one to be created by inserting a NULL. I believe
> your issues is happening because your schema didn't get created
> properly. Did you manually create the schema or use AppFuse and the
> Hibernate 3 plugin to do it?
>
> Matt
>
> On Mon, Oct 5, 2009 at 7:12 AM, andreistoiculescu
> <andreistoicule...@yahoo.com> wrote:
>>
>> 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
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
> For additional commands, e-mail: users-h...@appfuse.dev.java.net
>
>
>
--
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-tp25750597s2369p25752442.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
