how can get the datasource configuration for spring from persistence.xml?

Question

I need a spring datasource like:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">                  
  <property name="driverClassName" value="<driver>"/>                
  <property name="url" value="<url>" />                
  <property name="username" value="<user>" />     
  <property name="password" value="<pass>" />
</bean>

I need to obtain driver, url, user, pass from persistence.xml.

Tanks a lot!

I would suggest you to avoid unnecessary complexity and to bind your DataSource to JNDI. Then you can easily refer this DataSource from [Spring](http://static.springsource.org/spring/docs/3.0.x/spring-framework-reference/html/xsd-config.html#xsd-config-body-schemas-jee-jndi-lookup) and from `persistence.xml`. — dma_k, Feb 19 '12 at 21:04

score 0 · Answer 1 · answered Feb 13 '12 at 13:35

Here is my snippet for doign the same, you will obviously have to use your BasicDataSource instead of the ComboPooledDataSource I use. But they are pretty much the same, replace getDriverClass() with driverClassName, apparently.

@Autowired
private ComboPooledDataSource dataSource;

public String myMethod() {
  return dataSource.getDriverClass());
}

score 0 · Answer 2 · answered Feb 13 '12 at 13:39

Do you want to print it, or use it in your application for connecting to the dB?

If later one is the case, then, create a bean for sessionFactory, set hibernateProperties for the same where you can inject datasource as well.

In java code, autowire sessionFactory object (or set it using a setter method) and call getCurrentSession method for the same.

For getting various attributes, use chained getter methods to return datasource and extract all the details.

Let me know if you face any issue or need more details for the same.

how can get the datasource configuration for spring from persistence.xml?

2 Answers2