Micale Raj

I have a Web application which uses hiberante 4. When i deployed it on tomcat ( Tomcat 7 ) and try to do database operation it throws
"com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source." Exception.
But when I'm doing same thing using testng it run without a problem

Full stack trace:
javax.faces.el.EvaluationException: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:315) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:440) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy12.signInUser(Unknown Source) at com.myproject.managed.beans.UserManagedBean.signIn(UserManagedBean.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.el.parser.AstValue.invoke(AstValue.java:264) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278) at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) ... 24 more Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:304) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:169) at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67) at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160) at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1309) at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:399) ... 39 more Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128) at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141) at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:277) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297) ... 44 more Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525) ... 48 more

My Data source ( spring xml )
<!-- Data Source Declaration --> <bean id="DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="idleConnectionTestPeriod" value="10800"/> <property name="maxIdleTime" value="21600"/> <property name="driverClass" value="com.mysql.jdbc.Driver" /> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/myproject_owner" /> <property name="user" value="root" /> <property name="password" value="" /> <property name="maxPoolSize" value="10" /> <property name="maxStatements" value="0" /> <property name="minPoolSize" value="5" /> </bean> <!-- Session Factory Declaration --> <bean id="SessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> <property name="dataSource" ref="DataSource" /> <property name="annotatedClasses"> <list> <value>com.myproject.model.User</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean>

Any idea what would be wrong ?

Thanks in advance for any help.

Thank you very much for you reply..Yes I know how to add jar to classpath and I will follow the apache ant manual.

Hi

I have following questions ( may be these could be very elementary , but i appreciate if someone could answer them ).

1. How to create mysql database, tables, etc ( included in mysql script ) using ant ?
2. What is the best driver to connect to mysql from my ant script ?
( i found use of "org.gjt.mm.mysql.Driver" in one tutorial. Are there any other drivers which could you for same purpose . i.e to connect to mysql )

Thanks !

Hi,

Is there a way to create EAR file from Exploded EAR folder using a java class. i.e from java class like creating other files, to create EAR file.

Thanks !

Finally found a way to that. Just added the verbose=10 to testng ant task.
<testng outputdir="${testng.output.dir}" classpathref="classes" verbose="10" > ...

Thanks

hi ,

I running test suite ( testng) using ant. After running the test, terminal output shows the test suite, no of passed test , no of failed test.
[testng] =============================================== [testng] Project Bussiness Logic Tests [testng] Total tests run: 3, Failures: 2, Skips: 0 [testng] ===============================================

I want to know, is there a way to output passed/failed test name to terminal output, something like following ( It will be effective if I can see the output on terminal )
[testng] PASSED: testAdd [testng] FAILED: testSubtract [testng] FAILED: tesMutliply [testng] =============================================== [testng] Project Bussiness Logic Tests [testng] Total tests run: 3, Failures: 2, Skips: 0 [testng] ===============================================

Thanks

Thank your very much for your reply . I think I can do the same as you suggested. Thanks for taking time to reply such a confusing problem

Peter Johnson wrote:I don't understand what you are asking for. The antcall you have will run the task1 target, but before it does that it will run the layout target. Are you saying that you don't want layout to run? Also, your text uses different names than your example build.xml, so that makes it even more confusing.

Sorry for the confusing text, It's like this,
In my project there's target called "layout".This "layout" task build the project. Everybody run that target to build the project. Now I have to add another target,
let's say it name is "test" and it must be run after "layout" task. Now "test" target has been put as antcall in the "layout" task.
The "test" target must be able to run alone, but before that project must be build ( calling "layout"). How could I achieve this kind of behavior.

Thanks for your reply.

Hi All,

I want to do following task with ant
<target name="task1" depends="layout"> <echo message="task1"/> </target> <target name="task2"> <echo message="task2"/> <antcall target="task1" /> </target>

Here, my main target is target2 and it must call target1. But target1 should be able to run alone and it has some dependency on main target ( target1).
How to do this kind of task ?

Thanks !

Thank you very much Peter. Your post helped me resolve the problem. Thanks again !

Hi All,

I want to copy files using fileset like following,

<fileset id="test"> <include name="commons-lang-2.1.jar"/> </fileset> <target name="def"> <copy todir="jar/"> <fileset dir="target/layout/lib"> <exclude refid="test"/> </fileset> </copy> </target>
(This code don't work.)

In the copy task I want to include/exclude previously defined fileset. How to do this ?

Thanks !

James Boswell wrote:Don't you need to use setSearchSystemEnvironment(boolean) and setSystemPropertiesMode(int) to search for environment variables with a PropertyPlaceholderConfigurer?

Thanks for the reply James. I tried this . but no luck ! . Only the jvm args are taken when you give as <value>file:${CONF_LOCATION}/jndi.properties</value>

HI All

I want to access property file which the path given from env variable.
Spring xml as following

<bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>file:${CONF_LOCATION}/jndi.properties</value> </list> </property> </bean> ..... <!-- Using properties given in jndi.properties as following --> <prop key="hibernate.jndi.class">${java.naming.factory.initial}</prop> <prop key="hibernate.jndi.url">${java.naming.provider.url}</prop>

the CONF_LOCATION given in .bash_profile as env variable.
However i can't access CONF_LOCATION like given in spring xml. How to do this correctly ?

Thanks !

Joe Ess wrote:You need some way to receive an HTTP request. The standard way to to that in Java is a Servlet. The servlet loads the form bean and puts it in the request as an attribute. In the JSP you can access the form bean via the implicit request object.
Frankly, it is easier to work with the framework rather than against it.

Thank you very much for the reply. I did it using <html:form action="formBeanMappingName"></html:form> from struts taglib. Thanks !

HI,

I want to load data for a popup window just using a form bean's load method (without using action class ). How to do this ?

Thank you !