hello friends,

i here pasted my conf file for the Hibernate using postgresql here tables are not created automatically its shows me error because all the tablenames which are generated and mapping by hibernate are prefix with "..tablename" so tables are not created. What is the problem please tell me it is very needful to me.


<?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 name="SessionFact">
<property name="hibernate.connection.driver_class">
org.postgresql.Driver
</property>
<property name="hibernate.dialect">
org.hibernate.dialect.PostgreSQLDialect
</property>
<property name="hibernate.connection.url">
jdbc:postgresql://localhost:5432/pubgather
</property>
<property name="hibernate.connection.username">postgres</property>
<property name="hibernate.connection.password">cdfre</property>
<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<!-- thread is the short name for
org.hibernate.context.ThreadLocalSessionContext
and let Hibernate bind the session automatically to the thread
-->
<property name="current_session_context_class">thread</property>
<!--<property name="connection.autocommit">true</property> -->
<!-- Echo all executed SQL to stdout -->
<property name="hibernate.show_sql">true</property>
<!-- configuration pool via c3p0-->
<property name="c3p0.acquire_increment">1</property>
<property name="c3p0.idle_test_period">100</property> <!-- seconds -->
<property name="c3p0.max_size">4</property>
<property name="c3p0.max_statements">0</property>
<property name="c3p0.min_size">1</property>
<property name="c3p0.timeout">100</property> <!-- seconds -->
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>
<!--<mapping resource="com/propel/PropelHost/object/all.hbm.xml" /> -->

<mapping resource="com/propel/PropelHost/object/Alert.hbm.xml" />

<mapping resource="com/propel/PropelHost/object/AnalysisRule.hbm.xml" />
<mapping resource="com/propel/PropelHost/object/AnalyticAlert.hbm.xml" />
<mapping
resource="com/propel/PropelHost/object/Attributelog.hbm.xml" />

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


Thanks in advance
Venkat