JDBC namespace, extra configuration features

[opyate]

Hey folks,

I'm using jdbc:embedded-database (type = HSQL) but would like to configure it with extra parameters, e.g.

hibernate.connection.hsqldb.default_table_type=cached

Here's an excerpt from my configuration:

	<bean id="jobRepository" class="org.springframework.batch.core.repository.support.JobRepositoryFactoryBean">
		<description>
			PS jdbc:embedded-database tag spawns an HSQL db by default.
			Supported databaseType otherwise can be found here:
			http://static.springsource.org/spring-batch/apidocs/org/springframework/batch/support/DatabaseType.html
		</description>
        <property name="dataSource" ref="dataSourceBatch"/>
        <property name="databaseType" value="HSQL"/>
        <property name="transactionManager" ref="transactionManager"/>
    </bean>
    
    <jdbc:embedded-database id="dataSourceBatch" type="HSQL">
    	<jdbc:script location="classpath:batch-jobrepository.sql"></jdbc:script>
    </jdbc:embedded-database>

Please let me know how to get this property into the HSQL configuration.

Thanks,
Juan

[Marten Deinum]

Ehrm why do you want to change a hibernate property by adding it to a jdbc configuration?!`

But to answer your question, with the jdbc embedded tag it isn't possible to add properties. You would have to a datasource yourself and configure it completly.