Hi,

I am trying to follow the tutorial to create a J2EE application. I started with hybernate since I want to interface quickly to our existing database. I generated the file mapping using your tool, but it has an error:

The content of element type "class" must match
"(meta*,(cache|jcs-cache)?,(id|composite-id),discriminator?,(version|timestamp)?,(property|many-to-one|one-to-one|component|dynamic-component|any|map|set|list|bag|idbag|array|primitive-array)*,(subclass*|joined-subclass*))".

What do I need to do to fix that error?

TIA

Pascal

Pascal,
This is the hbm.xml file that is giving the error right? Can you paste it here for us to see?

Here is my hbm.xml. Apart from the error you will also notice that the property name doesn't keep the proper capitalization.

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" > <!-- DO NOT EDIT: This is a generated file that is synchronized --> <!-- by MyEclipse Hibernate tool integration.                   --> <!-- Created Mon Oct 18 16:01:56 PDT 2004                         --> <hibernate-mapping package="com.newgenesys.crs.backend.hibernate">    <class name="Items" table="Items">       <property name="sku" column="SKU" type="java.lang.String"          not-null="true" />       <property name="description" column="Description"          type="java.lang.String" not-null="true" />       <property name="model" column="Model" type="java.lang.String"          not-null="true" />       <property name="productcode" column="ProductCode"          type="java.lang.String" not-null="true" />       <property name="price1" column="Price1" type="java.lang.Float"          not-null="true" />       <property name="price2" column="Price2" type="java.lang.Float"          not-null="true" />       <property name="price3" column="Price3" type="java.lang.Float"          not-null="true" />       <property name="currentpriceindex" column="CurrentPriceIndex"          type="java.lang.Short" not-null="true" />       <property name="averagecost" column="AverageCost"          type="java.lang.Double" not-null="true" />       <property name="lastcost" column="LastCost" type="java.lang.Double"          not-null="true" />       <property name="lastcostdate" column="LastCostDate"          type="java.lang.Integer" />       <property name="qtyonhand" column="QtyOnHand" type="java.lang.Integer"          not-null="true" />       <property name="reorderlevel" column="ReorderLevel"          type="java.lang.Integer" not-null="true" />       <property name="qtycommitted" column="QtyCommitted"          type="java.lang.Integer" not-null="true" />       <property name="qtyonorder" column="QtyOnOrder"          type="java.lang.Integer" not-null="true" />       <property name="lastorderdate" column="LastOrderDate"          type="java.lang.Integer" />       <property name="lastpurchaseorder" column="LastPurchaseOrder"          type="java.lang.String" not-null="true" />       <property name="primaryvendor" column="PrimaryVendor"          type="java.lang.String" not-null="true" />       <property name="backordercode" column="BackOrderCode"          type="java.lang.String" not-null="true" />       <property name="taxablecode" column="TaxableCode"          type="java.lang.String" not-null="true" />       <property name="locationcode" column="LocationCode"          type="java.lang.String" not-null="true" />       <property name="stockstatus" column="StockStatus"          type="java.lang.String" not-null="true" />       <property name="lastsolddate" column="LastSoldDate"          type="java.lang.Integer" />       <property name="qtysoldperiodtodate" column="QtySoldPeriodToDate"          type="java.lang.Integer" not-null="true" />       <property name="qtysoldyeartodate" column="QtySoldYearToDate"          type="java.lang.Integer" not-null="true" />       <property name="salesperiodtodate" column="SalesPeriodToDate"          type="java.lang.Double" not-null="true" />       <property name="salesyeartodate" column="SalesYearToDate"          type="java.lang.Double" not-null="true" />       <property name="costperiodtodate" column="CostPeriodToDate"          type="java.lang.Double" not-null="true" />       <property name="costyeartodate" column="CostYearToDate"          type="java.lang.Double" not-null="true" />    </class> </hibernate-mapping>

Thanks for helping me with this

Pascal

Pascal,
Does this table not have any PKs or FKs in it? It looks like the hibernate tool mapped everything to a property and forgot to set a valid ID.

Yes it does. The SKU is PK. However the JDBC driver has its problems and sometimes fail to rerieve metadata. Maybe this is why.

Hmm could be, I've ask our hib dev to look at this. Stay tuned. In the mean time, is there another driver you can try with this DB?

If the JDBC driver cannot access the proper metadata on PKs in the database, then you are out-of-luck I am afraid. You will need to manually alter the mapping file to make sku the id. Just be aware that if you chose to re-map the table at a later date, it will over-write your customizations so be sure to backup.

I suppose that a warning should be posted to the error logs - to bring this more clearly into focus as the problem.

As for capitalization, for now the mappings only handle the 'pseudo-SQL standard' of using underscores: attribute_with_this_name would become attributeWithThisName in java. attributeWithThisName in a database table would become attributewiththisname as you see in your mapping. This will be made more customizable in the future.

My problem seems smilar: the hibernate tool does not generate an <id> tag in the
mapping file. I followed the BasicDB demo and selected "native" generator in
the tool window. I am using MySQL. I am not familiar with database tools and
don't understand what PKs or SKU mean. Do I need to do something to the
database table in order to let the hibernate tool generate the <id> tag?

Thanks.

Hisao

You must declare at least one column in a table to be a primary key in order for an id to be generated. Use the Db Explorer to view the table structure - is there a column that is marked as a primary key in the db browser? In the table view, is there an entry in the Primary Key tab? If not, that explains why there is no id generated.

Thanks jeff! I added a primary key to my table and now the id tag is generated.

Hisao