[hibernate-issues] [Hibernate-JIRA] Commented: (METAGEN-51) C3P0 connection pool tester is not called if buildSessionFactory failed due to wrong password

[Andrey Dryahlov (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/METAGEN-51?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39682#action_39682 ] 

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: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira