Hibernate 3.3 : javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection in websphere

1136 views
Skip to first unread message

landoa

unread,
Mar 14, 2010, 4:04:02 AM3/14/10
to
i run Hibernate 3.3 in Websphere 7.0. i had configured the data source
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

unread,
Mar 15, 2010, 1:42:44 PM3/15/10
to
I suspect that the crucial part of the output is this: -

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

david...@gmail.com

unread,
Nov 6, 2017, 6:18:37 AM11/6/17
to
Reply all
Reply to author
Forward
0 new messages