Saving remote object into local system using mysql database

kagitala · **Posted:** Fri Feb 23, 2007 4:45 am

Hi i have an object..i am getting this object from my webservices. this object is coming from oracle into local system. but i need to store this object into local system using mysql and hibernate.
How to store this object into mysql using hibernate. ples help me it is very urget.

My Configuration File:
-------------------------

<?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.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/emb3</property>
<property name="connection.username">root</property>
<property name="hibernate.connection.password">password</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="myeclipse.connection.profile">mysql</property>
<property name="hbm2ddl.auto">update</property>
<property name="show_sql">true</property>

<mapping resource="RefOffice.hbm.xml" />
<mapping resource="User.hbm.xml" />
<mapping resource="RefDepartment.hbm.xml" />
<mapping resource="RefDesignation.hbm.xml" />
<mapping resource="RefCity.hbm.xml" />
<mapping resource="RefState.hbm.xml" />
<mapping resource="RefArea.hbm.xml" />
<mapping resource="RefCountry.hbm.xml" />

</session-factory>
</hibernate-configuration>

my main file is <mapping resource="RefOffice.hbm.xml" />
This RefOffice.java class object is there i need to store this object into mysql using hibernate. both table fields are same means remote and local database schema is same.

RefOffice.hbm.xml:
-----------------------

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping auto-import="false">
<class name="emb.RefOffice" table="EMS_REF_OFFICE" schema="emb3">
<meta attribute="class-description">
JTK Offices Reference Table
</meta>
<comment>JTK Offices Reference Table</comment>

<id name="officeCode" type="string">
<meta attribute="use-in-equals">true</meta>
<meta attribute="field-description">
JTK office code
</meta>
<column name="OFFICE_CODE" length="5" />
<generator class="assigned" />
</id>
<version name="version" type="integer">
<column name="VERSION" precision="10" scale="0" not-null="true">
<comment>A version number to ensure that data is not mistakenly overwritten by stale data</comment>
</column>
</version>
<many-to-one name="ocUserId" class="emb.User" fetch="select">
<meta attribute="field-description">
Oc User Id
</meta>
<column name="OC_USER_ID" length="20">
<comment>User ID of Officer in Charge for this office</comment>
</column>
</many-to-one>
<many-to-one name="lastUpdatedBy" class="emb.User" fetch="select">
<meta attribute="field-description">
Last Updated By
</meta>
<column name="LAST_UPDATED_BY" length="20" not-null="true">
<comment>The user who last updated the record</comment>
</column>
</many-to-one>
<many-to-one name="department" class="emb.RefDepartment" fetch="select">
<meta attribute="field-description">
Department
</meta>
<column name="DEPARTMENT_CODE" length="1">
<comment>Department Code</comment>
</column>
</many-to-one>
<property name="name" type="string">
<meta attribute="field-description">
JTK office name in BM
</meta>
<column name="NAME" length="80" not-null="true">
<comment>JTK office name in BM</comment>
</column>
</property>
<property name="nameEn" type="string">
<meta attribute="field-description">
JTK office name in English
</meta>
<column name="NAME_EN" length="80" not-null="true">
<comment>JTK office name in English</comment>
</column>
</property>
<property name="lastUpdatedDate" type="timestamp">
<meta attribute="field-description">
Last updated date
</meta>
<column name="LAST_UPDATED_DATE" length="7">
<comment>Last updated date</comment>
</column>
</property>
<property name="effectiveDate" type="timestamp">
<meta attribute="field-description">
Effective date
</meta>
<column name="EFFECTIVE_DATE" length="7">
<comment>Effective date</comment>
</column>
</property>
<property name="inactiveDate" type="timestamp">
<meta attribute="field-description">
Inactive date
</meta>
<column name="INACTIVE_DATE" length="7">
<comment>Inactive date</comment>
</column>
</property>
<property name="postCode" type="string">
<meta attribute="field-description">
Post Code
</meta>
<column name="POST_CODE" length="5">
<comment>Post Code</comment>
</column>
</property>
<property name="telephoneNumber1" type="string">
<meta attribute="field-description">
Telephone Number 1
</meta>
<column name="TELEPHONE_NUMBER1" length="20">
<comment>Telephone Number 1</comment>
</column>
</property>
<property name="telephoneNumber2" type="string">
<meta attribute="field-description">
Telephone Number 2
</meta>
<column name="TELEPHONE_NUMBER2" length="20">
<comment>Telephone Number 2</comment>
</column>
</property>
<property name="faxNumber" type="string">
<meta attribute="field-description">
Fax Number
</meta>
<column name="FAX_NUMBER" length="20">
<comment>Fax Number</comment>
</column>
</property>
<property name="emailAddress" type="string">
<meta attribute="field-description">
Email Address
</meta>
<column name="EMAIL_ADDRESS" length="30">
<comment>Email Address</comment>
</column>
</property>
<property name="buildingInsp" type="integer">
<meta attribute="field-description">
The target figure for building inspection
</meta>
<column name="BUILDING_INSP" precision="10" scale="0">
<comment>The target figure for building inspection</comment>
</column>
</property>
<property name="estateInsp" type="integer">
<meta attribute="field-description">
The target figure for estate inspection
</meta>
<column name="ESTATE_INSP" precision="10" scale="0">
<comment>The target figure for estate inspection</comment>
</column>
</property>
<property name="statutoryInsp" type="integer">
<meta attribute="field-description">
The target figure for statutory inspection
</meta>
<column name="STATUTORY_INSP" precision="10" scale="0">
<comment>The target figure for statutory inspection</comment>
</column>
</property>
<property name="tradeUnionInsp" type="integer">
<meta attribute="field-description">
The target figure for Trade Union inspection
</meta>
<column name="TRADE_UNION_INSP" precision="10" scale="0">
<comment>The target figure for Trade Union inspection</comment>
</column>
</property>
<property name="ptjOfficeCode" type="string">
<meta attribute="field-description">
Office code for the Pusat Tanggungjawab
</meta>
<column name="PTJ_OFFICE_CODE" length="5">
<comment>Office code for the Pusat Tanggungjawab</comment>
</column>
</property>

<component name="address" class="emb.Address">
<many-to-one name="state" class="emb.RefState">
<column name="STATE_CODE" length="2">
<comment>State Code</comment>
</column>
</many-to-one>
<property name="line3" type="string">
<column name="ADDRESS3" length="30">
<comment>Address (line 3 of 3)</comment>
</column>
</property>
<many-to-one name="area" class="emb.RefArea">
<column name="AREA_CODE" length="4">
<comment>Area Code</comment>
</column>
</many-to-one>
<property name="line2" type="string">
<column name="ADDRESS2" length="30">
<comment>Address (line 2 of 3)</comment>
</column>
</property>
<property name="poBoxNumber" type="string">
<column name="PO_BOX_NO" length="5">
<comment>P. O. Box Number</comment>
</column>
</property>
<property name="line1" type="string">
<column name="ADDRESS1" length="30">
<comment>Address (line 1 of 3)</comment>
</column>
</property>
<many-to-one name="city" class="emb.RefCity">
<column name="CITY_CODE" length="4">
<comment>City Code</comment>
</column>
</many-to-one>
</component>
</class>
</hibernate-mapping>

when i run this script i am getting the below error:

An error occured: org.hibernate.MappingException: Unknown entity: gov.mohr.ems.core.ref.entity.RefOffice

this package name is in remote but i changed this package name as emb as i mentioned in mapping file.

init:
deps-jar:
compile-single:
run-single:
Query XML
=========
Result XML
==========
aadfjlakdfjkljdfkl[gov.mohr.ems.core.ref.entity.RefOffice@2d730ea, gov.mohr.ems.core.ref.entity.RefOffice@2d734ab, gov.mohr.ems.core.ref.entity.RefOffice@2d7386c, gov.mohr.ems.core.ref.entity.RefOffice@2d73c2d, gov.mohr.ems.core.ref.entity.RefOffice@2d72d2a, gov.mohr.ems.core.ref.entity.RefOffice@2d743af, gov.mohr.ems.core.ref.entity.RefOffice@2d74770, gov.mohr.ems.core.ref.entity.RefOffice@2d79a06, gov.mohr.ems.core.ref.entity.RefOffice@2d7a188, gov.mohr.ems.core.ref.entity.RefOffice@2e53d28, gov.mohr.ems.core.ref.entity.RefOffice@2e540e9, gov.mohr.ems.core.ref.entity.RefOffice@2e544aa, gov.mohr.ems.core.ref.entity.RefOffice@2e5486b, gov.mohr.ems.core.ref.entity.RefOffice@2e54c2c, gov.mohr.ems.core.ref.entity.RefOffice@2e54fed, gov.mohr.ems.core.ref.entity.RefOffice@2e553ae, gov.mohr.ems.core.ref.entity.RefOffice@2e5576f, gov.mohr.ems.core.ref.entity.RefOffice@2e55b30, gov.mohr.ems.core.ref.entity.RefOffice@2e55ef1, gov.mohr.ems.core.ref.entity.RefOffice@2e5b187, gov.mohr.ems.core.ref.entity.RefOffice@2f354a9, gov.mohr.ems.core.ref.entity.RefOffice@2f3586a, gov.mohr.ems.core.ref.entity.RefOffice@2f35c2b, gov.mohr.ems.core.ref.entity.RefOffice@2f35fec, gov.mohr.ems.core.ref.entity.RefOffice@2f363ad, gov.mohr.ems.core.ref.entity.RefOffice@2f3676e, gov.mohr.ems.core.ref.entity.RefOffice@2f36b2f, gov.mohr.ems.core.ref.entity.RefOffice@2f36ef0, gov.mohr.ems.core.ref.entity.RefOffice@2f372b1, gov.mohr.ems.core.ref.entity.RefOffice@2f37672, gov.mohr.ems.core.ref.entity.RefOffice@2f3ccc9, gov.mohr.ems.core.ref.entity.RefOffice@2f3d08a, gov.mohr.ems.core.ref.entity.RefOffice@2f3d44b, gov.mohr.ems.core.ref.entity.RefOffice@2f3d80c, gov.mohr.ems.core.ref.entity.RefOffice@2f3dbcd, gov.mohr.ems.core.ref.entity.RefOffice@2f3df8e, gov.mohr.ems.core.ref.entity.RefOffice@3016c2a, gov.mohr.ems.core.ref.entity.RefOffice@3016feb, gov.mohr.ems.core.ref.entity.RefOffice@3016fec, gov.mohr.ems.core.ref.entity.RefOffice@3016fed, gov.mohr.ems.core.ref.entity.RefOffice@30173ac, gov.mohr.ems.core.ref.entity.RefOffice@301776d, gov.mohr.ems.core.ref.entity.RefOffice@3017b2e, gov.mohr.ems.core.ref.entity.RefOffice@3017eef, gov.mohr.ems.core.ref.entity.RefOffice@30182b0, gov.mohr.ems.core.ref.entity.RefOffice@3018671, gov.mohr.ems.core.ref.entity.RefOffice@3018a32, gov.mohr.ems.core.ref.entity.RefOffice@301e089, gov.mohr.ems.core.ref.entity.RefOffice@301e44a, gov.mohr.ems.core.ref.entity.RefOffice@301e80b, gov.mohr.ems.core.ref.entity.RefOffice@301ebcc, gov.mohr.ems.core.ref.entity.RefOffice@301ef8d, gov.mohr.ems.core.ref.entity.RefOffice@30f83ab, gov.mohr.ems.core.ref.entity.RefOffice@31d9b2c, gov.mohr.ems.core.ref.entity.RefOffice@32bb66e, gov.mohr.ems.core.ref.entity.RefOffice@32bba2f, gov.mohr.ems.core.ref.entity.RefOffice@32bbdf0, gov.mohr.ems.core.ref.entity.RefOffice@32bc1b1, gov.mohr.ems.core.ref.entity.RefOffice@32bc572, gov.mohr.ems.core.ref.entity.RefOffice@32bc933, gov.mohr.ems.core.ref.entity.RefOffice@32bccf4, gov.mohr.ems.core.ref.entity.RefOffice@32bd0b5, gov.mohr.ems.core.ref.entity.RefOffice@32c270c, gov.mohr.ems.core.ref.entity.RefOffice@32c2acd, gov.mohr.ems.core.ref.entity.RefOffice@32c2e8e, gov.mohr.ems.core.ref.entity.RefOffice@32c324f, gov.mohr.ems.core.ref.entity.RefOffice@32c3610, gov.mohr.ems.core.ref.entity.RefOffice@339ca2e, gov.mohr.ems.core.ref.entity.RefOffice@2baf6a5, gov.mohr.ems.core.ref.entity.RefOffice@2c90e26, gov.mohr.ems.core.ref.entity.RefOffice@2c911e7, gov.mohr.ems.core.ref.entity.RefOffice@2c915a8, gov.mohr.ems.core.ref.entity.RefOffice@2c91969, gov.mohr.ems.core.ref.entity.RefOffice@2c91d2a, gov.mohr.ems.core.ref.entity.RefOffice@2c920eb, gov.mohr.ems.core.ref.entity.RefOffice@2c924ac, gov.mohr.ems.core.ref.entity.RefOffice@2c9286d, gov.mohr.ems.core.ref.entity.RefOffice@2c92c2e, gov.mohr.ems.core.ref.entity.RefOffice@2c98285, gov.mohr.ems.core.ref.entity.RefOffice@2c98646, gov.mohr.ems.core.ref.entity.RefOffice@2c99189, gov.mohr.ems.core.ref.entity.RefOffice@2c9954a, gov.mohr.ems.core.ref.entity.RefOffice@2c911e8, gov.mohr.ems.core.ref.entity.RefOffice@2c911e9, gov.mohr.ems.core.ref.entity.RefOffice@2c911ea, gov.mohr.ems.core.ref.entity.RefOffice@2c911eb, gov.mohr.ems.core.ref.entity.RefOffice@2c911ec, gov.mohr.ems.core.ref.entity.RefOffice@2c915a9, gov.mohr.ems.core.ref.entity.RefOffice@2c915aa, gov.mohr.ems.core.ref.entity.RefOffice@2c915ab, gov.mohr.ems.core.ref.entity.RefOffice@2c915ac, gov.mohr.ems.core.ref.entity.RefOffice@2c915ad, gov.mohr.ems.core.ref.entity.RefOffice@2c9196a, gov.mohr.ems.core.ref.entity.RefOffice@2c9196b, gov.mohr.ems.core.ref.entity.RefOffice@2c91d2b, gov.mohr.ems.core.ref.entity.RefOffice@2c920ec, gov.mohr.ems.core.ref.entity.RefOffice@2c920ed, gov.mohr.ems.core.ref.entity.RefOffice@2c924ad, gov.mohr.ems.core.ref.entity.RefOffice@2c924ae, gov.mohr.ems.core.ref.entity.RefOffice@2c924af, gov.mohr.ems.core.ref.entity.RefOffice@2c924b0, gov.mohr.ems.core.ref.entity.RefOffice@2c924b1, gov.mohr.ems.core.ref.entity.RefOffice@2c9286e, gov.mohr.ems.core.ref.entity.RefOffice@2c9286f, gov.mohr.ems.core.ref.entity.RefOffice@2c92c2f, gov.mohr.ems.core.ref.entity.RefOffice@2c92c30, gov.mohr.ems.core.ref.entity.RefOffice@2c92c31, gov.mohr.ems.core.ref.entity.RefOffice@2c92c32, gov.mohr.ems.core.ref.entity.RefOffice@2c92c33, gov.mohr.ems.core.ref.entity.RefOffice@2c92c34, gov.mohr.ems.core.ref.entity.RefOffice@2c92c35, gov.mohr.ems.core.ref.entity.RefOffice@2c98286, gov.mohr.ems.core.ref.entity.RefOffice@2c98287, gov.mohr.ems.core.ref.entity.RefOffice@2c98288, gov.mohr.ems.core.ref.entity.RefOffice@2c98289, gov.mohr.ems.core.ref.entity.RefOffice@2c98647, gov.mohr.ems.core.ref.entity.RefOffice@2c98648, gov.mohr.ems.core.ref.entity.RefOffice@2c98649, gov.mohr.ems.core.ref.entity.RefOffice@2c9918a, gov.mohr.ems.core.ref.entity.RefOffice@2d725a7, gov.mohr.ems.core.ref.entity.RefOffice@2d72968, gov.mohr.ems.core.ref.entity.RefOffice@2d72d29]
- Hibernate 3.1.3
- hibernate.properties not found
- using CGLIB reflection optimizer
- using JDK 1.4 java.sql.Timestamp handling
- configuring from resource: /hibernate.cfg.xml
- Configuration resource: /hibernate.cfg.xml
- Reading mappings from resource: RefOffice.hbm.xml
- Mapping class: emb.RefOffice -> EMS_REF_OFFICE
- Reading mappings from resource: User.hbm.xml
- Mapping class: emb.User -> EMS_AC_USER
- Reading mappings from resource: RefDepartment.hbm.xml
- Mapping class: emb.RefDepartment -> EMS_REF_DEPARTMENT
- Reading mappings from resource: RefDesignation.hbm.xml
- Mapping class: emb.RefDesignation -> EMS_REF_DESIGNATION
- Reading mappings from resource: RefCity.hbm.xml
- Mapping class: emb.RefCity -> EMS_REF_CITY
- Reading mappings from resource: RefState.hbm.xml
- Mapping class: emb.RefState -> EMS_REF_STATE
- Reading mappings from resource: RefArea.hbm.xml
- Mapping class: emb.RefArea -> EMS_REF_AREA
- Configured SessionFactory: null
- Using Hibernate built-in connection pool (not for production use!)
- Hibernate connection pool size: 20
- autocommit mode: false
- using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/emb3
- connection properties: {user=root, password=****}
- RDBMS: MySQL, version: 5.0.24-community-nt
- JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.3 ( $Date: 2006-07-26 17:26:47 +0200 (Wed, 26 Jul 2006) $, $Revision: 5553 $ )
- Using dialect: org.hibernate.dialect.MySQLDialect
- Using default transaction strategy (direct JDBC transactions)
- No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
- Automatic flush during beforeCompletion(): disabled
- Automatic session close at end of transaction: disabled
- JDBC batch size: 15
- JDBC batch updates for versioned data: disabled
- Scrollable result sets: enabled
- JDBC3 getGeneratedKeys(): enabled
- Connection release mode: auto
- Maximum outer join fetch depth: 2
- Default batch fetch size: 1
- Generate SQL with comments: disabled
- Order SQL updates by primary key: disabled
- Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
- Using ASTQueryTranslatorFactory
- Query language substitutions: {}
- Second-level cache: enabled
- Query cache: disabled
- Cache provider: org.hibernate.cache.EhCacheProvider
- Optimize cache for minimal puts: disabled
- Structured second-level cache entries: disabled
- Echoing all SQL to stdout
- Statistics: disabled
- Deleted entity synthetic identifier rollback: disabled
- Default entity-mode: pojo
- building session factory
- No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/IMATERA_13/src/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
- Not binding factory to JNDI, no JNDI name configured
- Running hbm2ddl schema update
- fetching database metadata
- updating schema
- table found: emb3.ems_ac_user
- columns: [active, division_code, user_id, last_updated_date, designation_code, last_updated_by, office_code, email, name, telephone_number, version]
- foreign keys: []
- indexes: []
- table found: emb3.ems_ref_area
- columns: [last_updated_date, sort_order, area_code, effective_date, state_code, inactive_date, last_updated_by, description, version]
- foreign keys: []
- indexes: []
- table found: emb3.ems_ref_city
- columns: [last_updated_date, sort_order, city_code, effective_date, state_code, inactive_date, last_updated_by, description, version]
- foreign keys: []
- indexes: []
- table found: emb3.ems_ref_department
- columns: [last_updated_date, department_code, bitwise_value, effective_date, inactive_date, last_updated_by, description_full, version, description_short]
- foreign keys: []
- indexes: []
- table found: emb3.ems_ref_designation
- columns: [last_updated_date, department_code, effective_date, designation_code, inactive_date, last_updated_by, name_en, name, version]
- foreign keys: []
- indexes: []
- table found: emb3.ems_ref_office
- columns: [department_code, city_code, state_code, inactive_date, last_updated_by, address1, ptj_office_code, post_code, address2, telephone_number2, area_code, telephone_number1, name_en, name, po_box_no, statutory_insp, office_code, version, fax_number, last_updated_date, trade_union_insp, building_insp, oc_user_id, effective_date, address3, estate_insp, email_address]
- foreign keys: []
- indexes: []
- table found: emb3.ems_ref_state
- columns: [last_updated_date, sort_order, effective_date, inactive_date, last_updated_by, description, state_code, version]
- foreign keys: []
- indexes: []
- Unsuccessful: alter table emb3.EMS_AC_USER add index FK20A73234F2D3E6D (DESIGNATION_CODE), add constraint FK20A73234F2D3E6D foreign key (DESIGNATION_CODE) references emb3.EMS_REF_DESIGNATION (DESIGNATION_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_AC_USER add index FK20A732347A007043 (LAST_UPDATED_BY), add constraint FK20A732347A007043 foreign key (LAST_UPDATED_BY) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_AC_USER add index FK20A732341905C26B (OFFICE_CODE), add constraint FK20A732341905C26B foreign key (OFFICE_CODE) references emb3.EMS_REF_OFFICE (OFFICE_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_AREA add index FK19DB49ED6113536D (STATE_CODE), add constraint FK19DB49ED6113536D foreign key (STATE_CODE) references emb3.EMS_REF_STATE (STATE_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_AREA add index FK19DB49ED7A007043 (LAST_UPDATED_BY), add constraint FK19DB49ED7A007043 foreign key (LAST_UPDATED_BY) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_CITY add index FK19DC12CB6113536D (STATE_CODE), add constraint FK19DC12CB6113536D foreign key (STATE_CODE) references emb3.EMS_REF_STATE (STATE_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_CITY add index FK19DC12CB7A007043 (LAST_UPDATED_BY), add constraint FK19DC12CB7A007043 foreign key (LAST_UPDATED_BY) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_DEPARTMENT add index FK66628B27A007043 (LAST_UPDATED_BY), add constraint FK66628B27A007043 foreign key (LAST_UPDATED_BY) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_DESIGNATION add index FK7171A6777A007043 (LAST_UPDATED_BY), add constraint FK7171A6777A007043 foreign key (LAST_UPDATED_BY) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_OFFICE add index FK276BDC1CF1E30343 (OC_USER_ID), add constraint FK276BDC1CF1E30343 foreign key (OC_USER_ID) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_OFFICE add index FK276BDC1C9007138B (CITY_CODE), add constraint FK276BDC1C9007138B foreign key (CITY_CODE) references emb3.EMS_REF_CITY (CITY_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_OFFICE add index FK276BDC1C6113536D (STATE_CODE), add constraint FK276BDC1C6113536D foreign key (STATE_CODE) references emb3.EMS_REF_STATE (STATE_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_OFFICE add index FK276BDC1C7A007043 (LAST_UPDATED_BY), add constraint FK276BDC1C7A007043 foreign key (LAST_UPDATED_BY) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_OFFICE add index FK276BDC1CCBF638CB (AREA_CODE), add constraint FK276BDC1CCBF638CB foreign key (AREA_CODE) references emb3.EMS_REF_AREA (AREA_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_OFFICE add index FK276BDC1C61C108AB (DEPARTMENT_CODE), add constraint FK276BDC1C61C108AB foreign key (DEPARTMENT_CODE) references emb3.EMS_REF_DEPARTMENT (DEPARTMENT_CODE)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- Unsuccessful: alter table emb3.EMS_REF_STATE add index FK228C77117A007043 (LAST_UPDATED_BY), add constraint FK228C77117A007043 foreign key (LAST_UPDATED_BY) references emb3.EMS_AC_USER (USER_ID)
- Can't create table '.\emb3\#sql-258_17.frm' (errno: 150)
- schema update complete
RefOffice Values are :gov.mohr.ems.core.ref.entity.RefOffice@2d730ea
BUILD SUCCESSFUL (total time: 1 minute 8 seconds)

please can anybody help.
where i am doing mistake i could not understand.