hibernate.cfg.xml: <!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.url">jdbc:mysql://localhost/hibase</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.connection.password">long</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <!--oracle10g: --> <property name="hibernate.connection.url">jdbc:oracle:thin:@192.168.0.2:1521:orcl</property> <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="hibernate.connection.username">orcle</property> <property name="hibernate.connection.password">orcle</property> <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property> <property name="hibernate.show_sql">true</property> <property name="hibernate.format_sql">true</property> <mapping resource="com/test/bean/User.hbm.xml"/> </session-factory> </hibernate-configuration>
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="com.test.bean.User" table="users"> <id name="id" type="java.lang.Integer" column="id"> <generator class="increment"></generator> </id> <property name="firstname" type="string" column="fname" length="50"> </property> <property name="lastname" type="string" column="lname" length="50"> </property> <property name="age" type="java.lang.Integer" column="age"> </property> </class> </hibernate-mapping>