Detailed Howto

Content

Known Limitation

Description of what you will get

Installation of necessary Software

Configuration

Create the Hibernate part

Build the jar File to feed the Wicketizer

Appendix

Known Limitation

Description of what you will get

Functional View

The Menu

The Listpanel

The Editpanel

Security

Technical View:

Model

Page by Page

DAO

Jetty

Installation of necessary Software

Download and install Eclipse

Alternative one: Yoxos

Alternative two: Enhance Eclipse manually

Database

• Rightclick in Package Explorer on your Project, -> Properties -> Libraries ->add external JARs
• Navigate the jar from your database vendor (e.g. h2.jar) select it and press OK.

Install hibernate

• Rightclick in Package Explorer on your Project, -> Properties -> Libraries ->add external JARs
• Navigate to the folder to which you downloaded and extracted hibernate
• add hibernate.jar

Install hibernate-annotations

• Rightclick in Package Explorer on your Project, -> Properties -> Libraries ->add external JARs
• Navigate to the folder to which you downloaded and extracted hibernate-annotation
• add ejb3-persistence.jar, hibernate-annotations.jar, hibernate-commons-annotations.jar and hibernate-core.jar.

Configuration

Configuration of Hibernate perspective

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
 "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory name="whatever">
        <property name="hibernate.connection.driver_class">org.h2.Driver</property>
        <property name="hibernate.connection.username">rain</property>
        <property name="hibernate.connection.password">man</property>
        <property name="hibernate.connection.url">jdbc:h2:~/wicketizer/dbfile</property>
        <property name="hibernate.dialect">org.hibernate.dialect.H2Dialect</property>
        <property name="hibernate.show_sql">false</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
    </session-factory>
</hibernate-configuration>

• Rightclick under Hibernate (left site, where in Java Perspective usually the Package Explorer is shown) on the white.
• Select Add Configuration
• Provide a Name (e.g Wicketizer, or whatever you like)
• Select Type as Annotations jdk1.5 +
• Select your project with the browse button
• Select Database Connection as Hibernate Configured Connection (only in latest version available)
• Ignore the property file
• Goto Configuration File's Setup button.
  It will ask if a new or an existing file should be used. Choose existing one and select the one you have build one step earlier.

Create the Hibernate part

Alternative one - start with Database

• Provide a name for your configuration e.g myhibgenconfig
• Select your Console configuration (use arrow)
• Specify output dir to $PROJECTNAME/src (use Browse button )
• Check "Reverse engineer form JDBC Connection
• Specify your package structure (e.g. org.wicketizer.hib)

• Check Use Java5 Code
• Check Generate EJB3 Annotations
• Check Domain Code (.java)
• Hibernate XML Configuration(cfg.xml)

Rework

• Column
• Id
• ManyToOne
• OneToMany
• Table

Alternative two - start with Hibernate (generate the Database)

  
<property name="hibernate.hbm2ddl.auto">create</property>

Implement Compareable

• public int hashCode,
• public int compareTo(MyType ob) and
• public boolean equals(Object obj)

	public int compareTo(Bankinginfo o) {
		// equal if ident is equal,
		int result = -1;
		if (o.getIdent() == this.ident) {
			result = 0;
		} else if(o.getIdent() == this.ident) {
			result=1;
		}
		return result;
	}

	@Override
	public boolean equals(Object obj) {
		if (obj.getClass().isInstance(Bankinginfo.class)) {
			Bankinginfo cg= (Bankinginfo) obj;
			return compareTo(cg) == 0;
		} else {
			return super.equals(obj);
		}
	}
	
	@Override
	public int hashCode() {
		return ident>0?ident:super.hashCode();
	}

@Id

and replace it with

@Id
@GenericGenerator(name="gen", strategy="increment")
@GeneratedValue(generator="gen")

Build the jar File to feed the Wicketizer

• Select File -> Export ->Java -> jar File -> Next Button
• Click on the src folder in the left window and select the hibernate.cfg.xml in the right window
• Check in the left window the complete package that holds the annotated java class
• Provide a location under "jar File" and provide a name for your jar.

Go and see it

Appendix

DDL Statements for a simple Test

    create table organisation (

         identifier INT4 NOT NULL

        , organame VARCHAR(25)

        , description VARCHAR(250)

        , adat DATE DEFAULT '2000-01-01'::date

    );

   

    create table person (

         identifier INT4 NOT NULL

         , org_identifier INT4 NOT NULL

        , name VARCHAR(25)

        , firstname VARCHAR(25)

        , birthdate DATE DEFAULT '2222-12-31'::date

        , adat DATE DEFAULT '2000-01-01'::date

    );

   

    create table connection(

         identifier INT4 NOT NULL

         , per_identifier INT4 NOT NULL

        , value VARCHAR(25)

        , type VARCHAR(25)

        , adat DATE DEFAULT '2000-01-01'::date

     );

     

    create table location(

         identifier INT4 NOT NULL

         , per_identifier INT4 NOT NULL

        , value VARCHAR(25)

        , type VARCHAR(25)

        , adat DATE DEFAULT '2000-01-01'::date

     );

    ALTER TABLE organisation

        ADD CONSTRAINT organisation_pkey

             PRIMARY KEY (identifier);

    ALTER TABLE person

        ADD CONSTRAINT person_pkey

             PRIMARY KEY (identifier);

    ALTER TABLE connection

        ADD CONSTRAINT connection_pkey

             PRIMARY KEY (identifier);

    ALTER TABLE location

        ADD CONSTRAINT location_pkey

             PRIMARY KEY (identifier);

    ALTER TABLE person

          ADD CONSTRAINT FK_person_orga

              FOREIGN KEY (org_identifier)

              REFERENCES organisation (identifier); 

    ALTER TABLE connection

          ADD CONSTRAINT FK_conection_person

              FOREIGN KEY (per_identifier)

              REFERENCES person (identifier);

    ALTER TABLE location

          ADD CONSTRAINT FK_location_person

              FOREIGN KEY (per_identifier)

              REFERENCES person (identifier);

hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?> 

<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"

 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

 <session-factory>

  <property name="hibernate.bytecode.use_reflection_optimizer">false</property>

  <property name="hibernate.connection.driver_class">org.h2.Driver</property>

  <property name="hibernate.connection.password">modo</property>

  <property name="hibernate.connection.url">jdbc:h2:~/mbo_db/dbfile</property>

  <property name="hibernate.connection.username">quasi</property>

  <property name="hibernate.dialect">org.hibernate.dialect.H2Dialect</property>

  <! create of update-->

  <property name="hibernate.hbm2ddl.auto">create</property>

  <mapping class="de.upsb.mbo.hib.Connections"/>

  <mapping class="de.upsb.mbo.hib.Locations"/>

  <mapping class="de.upsb.mbo.hib.Persons"/>

  <mapping class="de.upsb.mbo.hib.Textinfo"/>

 </session-factory>

</hibernate-configuration>