Hibernate 3.3 : javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection in websphere
landoa
in Websphere 7.0 and test connection was successful. in Webpshere
console. but when i run the application, i got the error as below as i
try to call the following EntityManager to retrieve data.
Below is source code :
// Use container managed persistence - inject the EntityManager
@PersistenceContext(unitName = "afesjpa")
private EntityManager em;
....................................
Query q = em.createQuery("SELECT a FROM UWPA_ASSTFEES a");
List results = q.getResultList();
Persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://
www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="afesjpa" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jdbc/IIMSDB</jta-data-source>
<properties>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.WebSphereExtendedJTATransactionLookup"/
>
<property name="hibernate.dialect"
value="org.hibernate.dialect.DB2Dialect"/>
</properties>
</persistence-unit>
</persistence>
Error Code :
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R
javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: Cannot open connection
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:
614)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
allianz.service.sysadmin.SascLoginImpl.increment(SascLoginImpl.java:
81)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
allianz.iface.sysadmin.EJSLocal0SLSascLoginImpl_fc7767e6.increment(EJSLocal0SLSascLoginImpl_fc7767e6.java)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
45)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
37)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
java.lang.reflect.Method.invoke(Method.java:599)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
org.springframework.ejb.access.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:
70)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:
188)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
166)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:
204)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
$Proxy48.increment(Unknown Source)
[3/14/10 15:50:40:922 SGT] 00000023 SystemErr R at
allianz.action.sysadmin.SascLoginAction.setName(SascLoginAction.java:
80)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
45)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
37)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
java.lang.reflect.Method.invoke(Method.java:599)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:830)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1253)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.OgnlRuntime.setMethodValue(OgnlRuntime.java:1454)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.ObjectPropertyAccessor.setPossibleProperty(ObjectPropertyAccessor.java:
85)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.ObjectPropertyAccessor.setProperty(ObjectPropertyAccessor.java:
162)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.ognl.accessor.ObjectAccessor.setProperty(ObjectAccessor.java:
28)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.OgnlRuntime.setProperty(OgnlRuntime.java:2225)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.ognl.accessor.CompoundRootAccessor.setProperty(CompoundRootAccessor.java:
65)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.OgnlRuntime.setProperty(OgnlRuntime.java:2225)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.ASTProperty.setValueBody(ASTProperty.java:127)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.SimpleNode.evaluateSetValueBody(SimpleNode.java:220)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.SimpleNode.setValue(SimpleNode.java:301)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
ognl.Ognl.setValue(Ognl.java:737)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.ognl.OgnlUtil.setValue(OgnlUtil.java:198)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.ognl.OgnlValueStack.setValue(OgnlValueStack.java:
161)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.ognl.OgnlValueStack.setValue(OgnlValueStack.java:
149)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.ParametersInterceptor.setParameters(ParametersInterceptor.java:
276)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:
187)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
87)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:
195)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
87)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:
179)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:
75)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:
94)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:
235)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:
89)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:
130)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:
267)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:
126)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:
138)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
87)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:
165)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:
164)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:
179)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:
176)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
237)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:
52)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:
488)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:
395)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:
188)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:
116)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:
77)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:
852)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:
917)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.invokeFilters(DefaultExtensionProcessor.java:
924)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:
852)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3610)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:
274)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:
926)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:
1557)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:
173)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:
455)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:
384)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:
83)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:
165)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:
217)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:
161)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:
766)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R Caused by:
org.hibernate.exception.GenericJDBCException: Cannot open connection
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:
126)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
114)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:
66)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:
52)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:
449)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:
167)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:
161)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.loader.Loader.doQuery(Loader.java:696)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:
259)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.loader.Loader.doList(Loader.java:2228)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.loader.Loader.list(Loader.java:2120)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:
361)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:
196)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R ... 92 more
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R Caused by:
java.sql.SQLException: [jcc][10216][11231][3.52.90] Required property
"databaseName" is not set. ERRORCODE=-4462, SQLSTATE=nullDSRA0010E:
SQL State = null, Error Code = -4,462
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.a.ad.a(ad.java:647)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.a.ad.a(ad.java:60)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.a.ad.a(ad.java:103)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.uw.UWConnection.xd(UWConnection.java:371)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.uw.UWConnection.<init>(UWConnection.java:289)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2PooledConnection.java:
90)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPooledConnectionX(DB2ConnectionPoolDataSource.java:
348)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPooledConnection(DB2ConnectionPoolDataSource.java:
156)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper
$1.run(InternalGenericDataStoreHelper.java:1175)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:
118)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:
1212)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:
2019)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:
1422)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:
1874)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1609)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2436)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:
955)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:
609)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:
646)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:
613)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:
46)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:
446)
[3/14/10 15:50:40:938 SGT] 00000023 SystemErr R ... 106 more
anyone knows whats happening? i couldnt find any solution in
web.anyone has idea? thanks and appreciate.
DSPS
java.sql.SQLException: [jcc][10216][11231][3.52.90] Required property
"databaseName" is not set. ERRORCODE=-4462, SQLSTATE=nullDSRA0010E:
SQL State = null, Error Code = -4,462
So, it seems to be a DB2 database and somewhere in the datasource
definition, down at the bottom of the administrative console screen,
there are usually common and required data source properties. Driver
type, database name, server hostname and port. Shouldn't have
successfully tested the connection though in that condition. Wonder
if there's a name resolution issue somewhere.
Good luck with this one, and thank you for posting the solution to the
problem you had earlier.
Pete
