]
Andrey Dryahlov commented on METAGEN-51:
----------------------------------------
Settings:
<parm name="ConnectionAcquireIncrement" default="2" />
<parm name="IdleTestPeriod" default="30"/>
<parm name="IdleTimeOut" default="0" />
<parm name="MaxConnections" default="10"/>
<parm name="StatementCache" default="5" />
<parm name="InitialPoolSize" default="2" />
<parm default="5" name="AcquireRetryAttempts" />
<parm default="5000" name="AcquireRetryDelay" />
<parm default="3306" name="Port" />
C3P0 connection pool tester is not called if buildSessionFactory
failed due to wrong password
---------------------------------------------------------------------------------------------
Key: METAGEN-51
URL:
http://opensource.atlassian.com/projects/hibernate/browse/METAGEN-51
Project: Hibernate Metamodel Generator
Issue Type: Bug
Environment: I used Hibernate+C3P0.
Here is a my config:
setProperty("hibernate.connection.driver_class",
"com.mysql.jdbc.Driver");
setProperty("hibernate.dialect",
"org.hibernate.dialect.MySQLDialect");
setProperty("hibernate.connection.url",
"jdbc:mysql://localhost:"
+ getDBPort() + "/emplatcore");
setProperty("hibernate.connection.username", Network.getInstance()
.getMASDBAccountCred().getUserName());
setProperty("hibernate.connection.password", Network.getInstance()
.getMASDBAccountCred().getPassword());
setProperty("hibernate.show_sql", "false");
setProperty("hibernate.c3p0.aquire_increment",
Integer.toString(getConnectionAcquireIncrement()));
setProperty("hibernate.c3p0.idle_test_period",
Integer.toString(getIdleTestPeriod()));
setProperty("hibernate.c3p0.timeout",
Integer.toString(getIdleTimeout()));
setProperty("hibernate.c3p0.max_size",
Integer.toString(getMaxConnections()));
setProperty("hibernate.c3p0.max_statements",
Integer.toString(getStatementCache()));
setProperty("hibernate.c3p0.min_size",
Integer.toString(getInitialPoolSize()));
setProperty(
"c3p0.connectionTesterClassName",
"com.nortelnetworks.mcp.ne.mediaserver.db.dao.hibernate.c3p0.MCPHibernateConnectionTester");
setProperty("c3p0.acquireRetryAttempts",
Integer.toString(getAcquireRetryAttempts()));
setProperty("c3p0.acquireRetryDelay",
Long.toString(getAcquireRetryDelay()));
Reporter: Andrey Dryahlov
Assignee: Hardy Ferentschik
Priority: Critical
Original Estimate: 8h
Remaining Estimate: 8h
I tried to check if connect is up or down to MySQL using C3P0 connection pool tester. It
works if password is correct. But password can be changed and I need to let user know that
there is no connection to MySQL.
I want to understand why buildSessionFactory() does not start connection tester.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: