Hello all,
My problem is simple schemaexport doesn't generate my table.
Hibernate version: 2.1.6
Config file:
Code:
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory name="FostisWeb" >
<property name="connection.datasource">java:comp/env/jdbc/fostisweb</property>
<property name="show_sql">false</property>
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<mapping resource="csc/fostis/bean/Employee.hbm.xml"/>
</session-factory>
</hibernate-configuration>
hibernate.properties:Code:
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/fostisweb
hibernate.connection.username=test
hibernate.connection.password=test
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
Mapping documents: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="csc.fostis.bean.Employee"
table="employeetest"
proxy="csc.fostis.bean.Employee"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
optimistic-lock="version"
mutable="true"
>
<id
name="employeeId"
column="employee_id"
type="int"
unsaved-value="0"
>
<generator class="identity">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-Employee.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>
<property
name="sapNb"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="sap_nb"
not-null="false"
unique="true"
/>
<property
name="firstName"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="employee_first_name"
not-null="true"
unique="false"
/>
<property
name="lastName"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="employee_last_name"
not-null="true"
unique="false"
/>
<property
name="status"
type="char"
update="true"
insert="true"
access="property"
column="employee_status"
not-null="true"
unique="false"
/>
<property
name="staffingRemarks"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="staffing_remarks"
not-null="false"
unique="false"
/>
<property
name="actionPlanned"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="action_planned"
not-null="false"
unique="false"
/>
<property
name="decisionDate"
type="java.util.Date"
update="true"
insert="true"
access="property"
column="decision_date"
not-null="false"
unique="false"
/>
<property
name="language"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="language"
not-null="true"
unique="false"
/>
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-Employee.xml
containing the additional properties and place it in your merge dir.
-->
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs:
[schemaexport] 13:10:00,418 INFO Environment:469 - Hibernate 2.1.6
[schemaexport] 13:10:00,428 INFO Environment:503 - loaded properties from resource hibernate.properties: {hibernate.connection.username=cofo, hibernate.connection.password=cofo, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://localhost:3306/fostisweb, hibernate.connection.driver_class=com.mysql.jdbc.Driver}
[schemaexport] 13:10:00,448 INFO Environment:529 - using CGLIB reflection optimizer
[schemaexport] 13:10:00,468 INFO Configuration:929 - configuring from file: hibernate.cfg.xml
[schemaexport] 13:10:00,739 INFO Configuration:331 - Mapping resource: csc/fostis/bean/Employee.hbm.xml
[schemaexport] 13:10:00,999 INFO Binder:229 - Mapping class: csc.fostis.bean.Employee -> employeetest
[schemaexport] 13:10:01,199 INFO Configuration:1053 - Configured SessionFactory: FostisWeb
[schemaexport] 13:10:01,249 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
[schemaexport] 13:10:01,259 INFO Configuration:627 - processing one-to-many association mappings
[schemaexport] 13:10:01,269 INFO Configuration:636 - processing one-to-one association property references
[schemaexport] 13:10:01,269 INFO Configuration:661 - processing foreign key constraints
[schemaexport] 13:10:01,350 INFO Configuration:627 - processing one-to-many association mappings
[schemaexport] 13:10:01,360 INFO Configuration:636 - processing one-to-one association property references
[schemaexport] 13:10:01,360 INFO Configuration:661 - processing foreign key constraints
[schemaexport] 13:10:01,380 INFO SchemaExport:98 - Running hbm2ddl schema export
[schemaexport] 13:10:01,380 INFO SchemaExport:112 - writing generated schema to file: schema.sql
[schemaexport] drop table if exists employeetest;
[schemaexport] 13:10:01,390 DEBUG SchemaExport:132 -
drop table if exists employeetest;
[schemaexport] 13:10:01,400 INFO SchemaExport:160 - schema export complete
BUILD SUCCESSFUL
Total time: 3 seconds
Name and version of the database you are using: MySql 4.1.7
The generated SQL (show_sql=true): Nothing except the drop SQL command. That's my problem!
Debug level Hibernate log excerpt: debug