Spring Hibernate: Identify which database connection

Question

NOTE: I know I can fix this using scripts or a database field, but I am curious about accessing the connection string.

I have two testing environments. Each has its own database, one for Chinese and one for English data. Otherwise the two databases are identical.

The only difference is the connection string in my beans.xml (ctest vs ctestzh).

	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">
		<property name="driverClass" value="org.postgresql.Driver" />
		<property name="jdbcUrl" value="jdbc:postgresql://localhost/ctest?useUnicode=true&#38;characterEncoding=utf8" />
		<property name="user" value="testuser" />
		<property name="password" value="xxxx" />
....
	</bean>

	<!-- Hibernate 
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">
		<property name="driverClass" value="org.postgresql.Driver" />
		<property name="jdbcUrl" value="jdbc:postgresql://localhost/ctestzh?useUnicode=true&#38;characterEncoding=utf8" />
		<property name="user" value="testuser" />
		<property name="password" value="xxxx" />
.....
	</bean>-->

I use an xml configuration file that configures my application to either process English or Chinese data. If I forget to change the beans.xml to the appropriate data, however, I corrupt the database (i.e., put Chinese data in the English database)

Can I access the connection string in code so I can fail if I am connected to the wrong database? I have looked at SessionFactory, but saw nothing obvious.

Strelok · Accepted Answer · 2017-02-23 03:07:31Z

1

public String getConnectionString(DataSource dataSource) {
  return dataSource.getConnection().getMetaData().getURL();
}

See DatabaseMetaData class for more info.

answered Feb 23, 2017 at 3:07

Strelok

51.7k9 gold badges106 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring Hibernate: Identify which database connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related