my project concept is to create the databases which have table "user" and "service". each user can require for many services.how to make related? the hbm file is shown as below:

user.hbm.xml

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

<hibernate-mapping
>
<class
name="model.User"
table="USER"
>

<id
name="empNo"
column="EMP_NO"
type="java.lang.String"
>
<generator class="assigned">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-User.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<property
name="firstName"
type="string"
update="true"
insert="true"
>
<column
name="FIRST_NAME"
/>
</property>

<property
name="lastName"
type="string"
update="true"
insert="true"
>
<column
name="LAST_NAME"
/>
</property>

<property
name="company"
type="string"
update="true"
insert="true"
>
<column
name="COMPANY"
/>
</property>

<property
name="department"
type="string"
update="true"
insert="true"
>
<column
name="DEPARTMENT"
/>
</property>

<property
name="designation"
type="string"
update="true"
insert="true"
>
<column
name="DESIGNATION"
/>
</property>

<property
name="extNo"
type="string"
update="true"
insert="true"
>
<column
name="EXT_NO"
/>
</property>

<list
name="userInfo"
lazy="false"
inverse="true"
cascade="none"
>

<key
column="EMP_NO"
>
</key>

<index
column="NO"
type="integer"
/>

<one-to-many
class="model.Service"
/>

</list>


<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-User.xml
containing the additional properties and place it in your merge dir.
-->

</class>

</hibernate-mapping>

service.hbm.xml


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

<hibernate-mapping
>
<class
name="model.Service"
table="SERVICE"
>

<id
name="serviceId"
column="SERVICE_ID"
type="java.lang.String"
>
<generator class="assigned">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-User.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<property
name="requireDate"
type="Date"
update="true"
insert="true"
>
<column
name="REQUIRE_DATE"
/>
</property>

<property
name="issueDate"
type="Date"
update="true"
insert="true"
>
<column
name="ISSUE_DATE"
/>
</property>

<many-to-one
name="empNo"
class="model.User"
cascade="none"
lazy="false"
update="true"
insert="true"
foreign-key="FK1_EMP_NO"
column=""
not-null="true"
/>

<property
name="state"
type="int"
update="true"
insert="true"
>
<column
name="STATE"
/>
</property>

<property
name="serviceRemark"
type="string"
update="true"
insert="true"
>
<column
name="SERVICE_REMARK"
/>
</property>

<property
name="service"
type="string"
update="true"
insert="true"
>
<column
name="SERVICE"
/>
</property>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-User.xml
containing the additional properties and place it in your merge dir.
-->

</class>

</hibernate-mapping>

can anyone comment on my script??

Use another generator method, example "native" instead of "assigned".

Urs

when i try to connect in hibernator, the error states that "unknown database symis'. what happened??

i'm using org.hibernate.dialect.MySql but i can''t change dialect 'net.sf.hibernate.dialect.MySql' to 'org.hibernate.dialect.MySql'. anyone can help???

Maybe you can post your hibernate.cfg.xml file here.
Which hibernate version do you use?

i have this 'mysql-mis-ds.xml' in the deploy folder of jboss directory. the coding is as shown below:

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

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for MySQL using 2.0.11 driver -->
<!-- ==================================================================== -->
<!--?profileSql=true-->

<datasources>

<local-tx-datasource>
<jndi-name>MySqlDSMIS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/symis?profileSql=true&amp;useUnicode=true&amp;characterEncoding=UTF8
</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>user</user-name>
<password>123</password>
</local-tx-datasource>

</datasources>

the error now is access of the user to database 'symis' is denied. i think i can't even map into database. so anyone can help??