Ok, I got it running... problem was in the oracle profile in the top pom.xml:
<dbunit.schema>VDS</dbunit.schema> <!-- Make sure to capitalize
the schema name -->
'VDS' is the right scheme, not the default 'SYSTEM'.
MANY THANKS !!!!
________________________________
From: Michael Horwitz [mailto:[EMAIL PROTECTED]
Sent: woensdag 31 oktober 2007 15:14
To: users@appfuse.dev.java.net
Subject: Re: [appfuse-user] Tables not generated by dbunit-maven-plugin -- part
2
On 10/31/07, Bonami, Christian <[EMAIL PROTECTED]> wrote:
Aha, ok, I see. But how come that tables are not automatically generated by the
hibernate3-maven-plugin before the dbunit-maven-plugin starts its CLEAN_INSERT?
They should be. However the hibernate3-maven-plugin only runs as part of the
build on the core module, so they will only exist if the build completed
successfully. Have you checked the contents of the database manually to see if
any tables were created? Also how have you configured your databse connection
in AppFuse?
Mike.
Thx
Christian
Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek
VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100
0925 0452, SWIFT : BBRUBEBB
________________________________
From: Michael Horwitz [mailto: [EMAIL PROTECTED]
Sent: woensdag 31 oktober 2007 14:56
To: users@appfuse.dev.java.net
Subject: Re: [appfuse-user] Tables not generated by dbunit-maven-plugin
-- part 2
They are included via the dependency on appfuse-data-common (which is a
transitive dependency through appfuse-hibernate).
Mike
On 10/31/07, Bonami, Christian < [EMAIL PROTECTED] <mailto:[EMAIL
PROTECTED]> > wrote:
But, where are those annotated Java classes in the JSF modular
archetype? I see only 1 class: Core.java.
Where are the annotated model classes?
Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek
VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100
0925 0452, SWIFT : BBRUBEBB
________________________________
From: Michael Horwitz [mailto: [EMAIL PROTECTED]
Sent: woensdag 31 oktober 2007 14:37
To: users@appfuse.dev.java.net
Subject: Re: [appfuse-user] Tables not generated by dbunit-maven-plugin
-- part 2
AppFuse 2.0 uses Hibernate Annotations - no more .hbm.xml files.
Mike
On 10/31/07, Bonami, Christian < [EMAIL PROTECTED] <mailto:[EMAIL
PROTECTED]> > wrote:
Ok, by now I've discovered that it is not dbunit but the
hibernate3-maven-plugin that generates the tables (hbm2ddl).
But where is the *.hbm file?? It is not included in the appFuse
archetype that I downloaded (JSF modular).
Plz help
Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek
VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100
0925 0452, SWIFT : BBRUBEBB
________________________________
From: Bonami, Christian [mailto: [EMAIL PROTECTED]
Sent: woensdag 31 oktober 2007 14:04
To: users@appfuse.dev.java.net
Cc: Mariën, Sven; Houckx, Marc
Subject: [appfuse-user] Tables not generated by dbunit-maven-plugin
Hi,
I'm using oracle XE as underlying DB in appFuse 2 standard distribution.
So, on the commandline in .../web I run:
mvn jetty-run:war -P oracle
Apparently dbunit-maven-plugin connects well to the database, but then
starts complaining about a table (user_role) that is not found:
[INFO] [dbunit:operation]
[INFO]
Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek
VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100
0925 0452, SWIFT : BBRUBEBB
Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek
VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100 0925
0452, SWIFT : BBRUBEBB
---------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
---------------------------------------------------------------------
[INFO] Error executing database operation: CLEAN_INSERT
Embedded error: user_role
[INFO] -------------------------------------------------------------
...
Caused by: org.apache.maven.plugin.MojoExecutionException: Error
executing datab
ase operation: CLEAN_INSERT
at
org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:110
)
at
org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPlugi
nManager.java:443)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa
ultLifecycleExecutor.java:539)
20 more
Caused by: org.dbunit.dataset.NoSuchTableException: user_role
...
[INFO]
---------------------------------------------------------------------
[INFO] For more information, run Maven with the -e switch
[INFO]
---------------------------------------------------------------------
[INFO] Total time: 3 seconds
[INFO] Finished at: Wed Oct 31 13:44:19 CET 2007
[INFO] Final Memory: 7M/14M
[INFO]
--------------------------------------------------------------------
Why aren't the tables generated automatically?
Do I have to create them manually?
What am I missing here?
Kind regards
Christian Bonami
