Sequence

FA_INDY · **Joined:** Tue Feb 03, 2004 4:53 pm **Posts:** 28

Ok here goes --
Got Hibernate working with Jboss and oracle...
each table has a specific sequence/table Id...
Person (table) has a Person_SQ for sequence on ids

I have a person Object with Person.hbm.xml of:
[code]
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>


<class
name="com.ata.hibernate.databean.Person"
table="PERSON"
>

<id
name="id"
type="java.math.BigDecimal"
column="ID"
>
<generator class="sequence">

emmanuel · **Posted:** Tue Feb 17, 2004 11:48 am

Sounds like you saved your xml file in a tricky encoding.

Try adding explicit encoding in the xml header (UTF-8, ISO-8859-1, etc

FA_INDY · **Joined:** Tue Feb 03, 2004 4:53 pm **Posts:** 28

emmanuel wrote:

Sounds like you saved your xml file in a tricky encoding.

Try adding explicit encoding in the xml header (UTF-8, ISO-8859-1, etc

here is the header ---

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

FA_INDY · **Joined:** Tue Feb 03, 2004 4:53 pm **Posts:** 28

This problem did not start until I setup the sequence under the Id's

FA_INDY · **Joined:** Tue Feb 03, 2004 4:53 pm **Posts:** 28

Using Hibernate 2.1 final

Defined -- the above -- changed it to the following
[code]
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>


<class
name="com.ata.hibernate.databean.Person"
table="PERSON"
>

<id
name="id"
type="long"
column="ID"
>
<generator class="native">
<param>PERSON_SQ</param>

FA_INDY · **Joined:** Tue Feb 03, 2004 4:53 pm **Posts:** 28

This might help !
Platform = Jboss & Oracle8
Application structure =
EAR--
|-hibernate.cfg.xml
|-himbernate.properties
|-hibernateXML/
|-Person.hbm.xml
|-EJB-jar
|-META-INF
|-lib
|-hibernateClasses.jar -- Containes the Hibernate generated classes.
|-Other Hibernate dependent jar files
|-com/ (Session Beans)
|-WAR--
|WEB-INF
|--classes --Contains a single servlet only

with this construct the hibernate cfg.xml and properties files are availible to all under the Application as well as the hbm.xml files since the application layor is the root of the application in regards to classpath.

I have a singleton in the hibernateClasses.jar which is responsible to initializing a single SessionFactory, it is called by the EJB layor..

Can any one understand why I am getting the above exceptions ?

emmanuel · **Posted:** Tue Feb 17, 2004 2:35 pm

Code:

<generator class="sequence">
  <param name="sequence">MYSEQ</param>
</...>

david · **Posted:** Tue Feb 17, 2004 7:53 pm

Not sure what version of the MIddlegen Plugin your using but I tested it to make sure it was generating the correct hbm for a sequence id generator. It was correctly mapped. Have you hand edited the Hbm?