Hi to everyone!
I have a problem with hibernate. I'm developing a GWT project, and on server-side I use the hibernate technology to map my persistent classes. In the spring configuration file I wrote:

<bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url" value="jdbc:hsqldb:mem:smartTasksDB" />
<property name="username" value="sa" />
<property name="password" value="" />
</bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager" scope="singleton">
<property name="sessionFactory">
<ref bean="smartTasksSessionFactory" />
</property>
</bean>

<bean id="smartTasksSessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"
scope="singleton">
<property name="packagesToScan">
<list>
...
</list>
</property>
<property name="dataSource">
<ref bean="myDataSource" />
</property>
<property name="hibernateProperties">
<ref bean="hibernateProperties"/>
</property>
</bean>

<bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="properties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">create-drop</prop>
</props>
</property>
</bean>

To test my application I would like to use the import.sql file to "initialize" my database. But unfortunately the file is ignored :( Its insert clauses are never read and never executed...

The file is in the war directory. I have the latest versions of hibernate's jars and the mapping is completely done by annotations (no hbm files)....

Can anyone help me?

Thanks a lot,
Marco

Maybe you need more informations? I don't know what to do, I've tried everything :(

can anyone help me? :(

I'm not exactly sure of what you are trying to accomplish, but if I understand correctly, your "import.sql" contains some data that needs to initialize your database: why don't you just run your sql script against your db instance before you start up the app? Initialization data should only be ran once anyways.

Hi,

Did you manage to get this issue resolved as I am having the same problem?

Cheers

You just need to add a file named import.sql in your classpath root and set either create or create-drop as your hibernate.hbm2ddl.auto property.