Check sample-data.xml.
To create tables and fill data use 'mvn compile hibernate3:hbm2ddl
dbunit:operation'
oguzhan tortop wrote:
>
> Hi all ,
> i lost previous data froum app_user , user_role and role tables when i try
> to create Person table which is described in the tutorials. Also it does
> not create Person table too and it deletes the line " <mapping
> class="com.mycompany.app.model.Person"/> " from hibernate.cfg.xml. What
> could be the problem also is there a way to load initial data of app_user
> , user_role and role tables ?
> ---------------*-----------*-*-------------------------------------------
> Here is my class :
> package com.mycompany.app.model;
>
> import javax.persistence.Entity;
> import javax.persistence.GeneratedValue;
> import javax.persistence.GenerationType;
> import javax.persistence.Id;
>
> import org.appfuse.model.BaseObject;
>
> @Entity
> public class Person extends BaseObject {
> private Long id;
> private String firstName;
> private String lastName;
> @Override
> public boolean equals(Object o) {
> // TODO Auto-generated method stub
> return false;
> }
> @Override
> public int hashCode() {
> // TODO Auto-generated method stub
> return 0;
> }
> @Override
> public String toString() {
> // TODO Auto-generated method stub
> return null;
> }
> public String getFirstName() {
> return firstName;
> }
> public void setFirstName(String firstName) {
> this.firstName = firstName;
> }
>
> @Id @GeneratedValue(strategy = GenerationType.AUTO)
> public Long getId() {
> return id;
> }
> public void setId(Long id) {
> this.id = id;
> }
> public String getLastName() {
> return lastName;
> }
> public void setLastName(String lastName) {
> this.lastName = lastName;
> }
>
>
> }
>
> ---------------*-----------*-*-------------------------------------------
> here is hibernate-config file
> <hibernate-configuration>
> <session-factory>
> <mapping class="org.appfuse.model.User"/>
> <mapping class="org.appfuse.model.Role"/>
> <mapping class="com.mycompany.app.model.Person"/>
> </session-factory>
> </hibernate-configuration>
> -----------*--------------*-*--------------------------------------------
> C:\myproject>mvn compile hibernate3:hbm2ddl
> [INFO] Scanning for projects...
> [INFO] Searching repository for plugin with prefix: 'hibernate3'.
> [INFO]
> -------------------------------------------------------------------------
> ---
> [INFO] Building AppFuse JSF Application
> [INFO] task-segment: [compile, hibernate3:hbm2ddl]
> [INFO]
> -------------------------------------------------------------------------
> ---
> [INFO] [warpath:add-classes {execution: default}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
> [INFO] [resources:resources]
> [INFO] Using default encoding to copy filtered resources.
> [INFO] [compiler:compile]
> [INFO] Compiling 1 source file to C:\myproject\target\classes
> [INFO] Preparing hibernate3:hbm2ddl
> [WARNING] Removing: hbm2ddl from forked lifecycle, to prevent recursive
> invocati
> on.
> [INFO] [warpath:add-classes {execution: default}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
> [INFO] [resources:resources]
> [INFO] Using default encoding to copy filtered resources.
> [WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is
> invalid. It w
> ill be ignored for artifact resolution. Reason: Parse error reading POM.
> Reason:
> TEXT must be immediately followed by END_TAG and not START_TAG (position:
> START
> _TAG seen ...<licenses>\n\t\t\t<license>... @12:13)
> [WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is
> invalid. It w
> ill be ignored for artifact resolution. Reason: Parse error reading POM.
> Reason:
> TEXT must be immediately followed by END_TAG and not START_TAG (position:
> START
> _TAG seen ...<licenses>\n\t\t\t<license>... @12:13)
> [WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is
> invalid. It w
> ill be ignored for artifact resolution. Reason: Parse error reading POM.
> Reason:
> TEXT must be immediately followed by END_TAG and not START_TAG (position:
> START
> _TAG seen ...<licenses>\n\t\t\t<license>... @12:13)
> [INFO] [hibernate3:hbm2ddl]
> [INFO] Configuration XML file loaded:
> C:\myproject\src\main\resources\hibernate.
> cfg.xml
> [INFO] Configuration XML file loaded:
> C:\myproject\src\main\resources\hibernate.
> cfg.xml
> [INFO] Configuration Properties file loaded:
> C:\myproject\target\classes\jdbc.pr
> operties
> alter table user_role drop foreign key FK143BF46AF503D155;
> alter table user_role drop foreign key FK143BF46A4FD90D75;
> drop table if exists app_user;
> drop table if exists role;
> drop table if exists user_role;
> create table app_user (id bigint not null auto_increment, address
> varchar(150),
> country varchar(100), city varchar(50) not null, province varchar(100),
> postal_c
> ode varchar(15) not null, version integer, password varchar(255) not null,
> usern
> ame varchar(50) not null unique, account_enabled bit, email varchar(255)
> not nul
> l unique, password_hint varchar(255), first_name varchar(50) not null,
> last_name
> varchar(50) not null, phone_number varchar(255), website varchar(255),
> account_
> expired bit not null, account_locked bit not null, credentials_expired bit
> not n
> ull, primary key (id)) type=InnoDB;
> create table role (id bigint not null auto_increment, name varchar(20),
> descript
> ion varchar(64), primary key (id)) type=InnoDB;
> create table user_role (user_id bigint not null, role_id bigint not null,
> primar
> y key (user_id, role_id)) type=InnoDB;
> alter table user_role add index FK143BF46AF503D155 (user_id), add
> constraint FK1
> 43BF46AF503D155 foreign key (user_id) references app_user (id);
> alter table user_role add index FK143BF46A4FD90D75 (role_id), add
> constraint FK1
> 43BF46A4FD90D75 foreign key (role_id) references role (id);
> [INFO]
> ------------------------------------------------------------------------
> [INFO] BUILD SUCCESSFUL
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Total time: 1 minute 59 seconds
> [INFO] Finished at: Tue Mar 13 14:01:13 EET 2007
> [INFO] Final Memory: 14M/26M
> [INFO]
> ------------------------------------------------------------------------
>
--
View this message in context:
http://www.nabble.com/Creating-Database-Table-tf3395449s2369.html#a9453011
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
