You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by waynej <wa...@thejohnstons.com> on 2008/03/26 20:30:23 UTC

data source without trace file specified is unusable

I defined a DB2 data source at the Console and found I would have fatal
exceptions if I do not fill in the "Trace File" box.  Is this supposed to
happen?  I start the server in "C:\ResolverDeployment".  I have DB2 v9.5 and
Hibernate.  Here's the first exception I get if "Trace File" isn't filled
in:

[MCFConnectionInterceptor] Error occurred creating ManagedConnection for
org.apache.geronimo.connector.outbound.ConnectionInfo@19cbd8a
javax.resource.spi.ResourceAdapterInternalException: Unable to obtain
physical connection to com.ibm.db2.jcc.DB2XADataSource@1c3b70f
	at
org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:76)
	at org.tranql.connector.db2.XAMCF.createManagedConnection(XAMCF.java:59)
	at
org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:48)
	at
org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
	at
org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:67)
	at
org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
	at
org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46)
	at
org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:88)
	at
org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
	at
org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
	at
org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)
	at
org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:87)
	at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
	at
org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
	at
org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27)
	at
org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:107)
	at
org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:317)
	at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
	at
com.framework.integration.dao.FrameworkHibernateDAO.<clinit>(FrameworkHibernateDAO.java:37)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at java.lang.Class.newInstance0(Class.java:355)
	at java.lang.Class.newInstance(Class.java:308)
	at java.beans.Beans.instantiate(Beans.java:204)
	at java.beans.Beans.instantiate(Beans.java:48)
	at
com.framework.common.FrameworkBaseObjectFactory.getObjectHelper(FrameworkBaseObjectFactory.java:144)
	at
com.framework.common.FrameworkBaseObjectFactory.getObject(FrameworkBaseObjectFactory.java:109)
	at
com.framework.integration.dao.FrameworkDAOFactory.getFrameworkDAO(FrameworkDAOFactory.java:68)
	at
com.mycompany.myapp.locator.UserFieldsLocator.createUserFieldsDAO(UserFieldsLocator.java:60)
	at
com.mycompany.myapp.ejb.UserFieldsSessionBean.getUserFieldsDAO(UserFieldsSessionBean.java:242)
	at
com.mycompany.myapp.ejb.UserFieldsSessionBean.create(UserFieldsSessionBean.java:130)
	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.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:146)
	at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:129)
	at
org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:67)
	at
org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:203)
	at
org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
	at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:223)
	at
org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:77)
	at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:245)
	at
org.apache.openejb.util.proxy.Jdk13InvocationHandler.invoke(Jdk13InvocationHandler.java:49)
	at $Proxy40.create(Unknown Source)
	at
org.apache.jsp.UserFieldsTest_jsp._jspService(UserFieldsTest_jsp.java:84)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
	at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
	at
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:353)
	at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:47)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:619)
Caused by: com.ibm.db2.jcc.b.SqlException: [jcc][10257][10960][3.50.152]
Unable to open file . ERRORCODE=-4223, SQLSTATE=null
	at com.ibm.db2.jcc.b.wc.a(wc.java:55)
	at com.ibm.db2.jcc.b.wc.a(wc.java:84)
	at com.ibm.db2.jcc.b.sl.a(sl.java:111)
	at
com.ibm.db2.jcc.DB2BaseDataSource.computePrintWriter(DB2BaseDataSource.java:8391)
	at
com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriter(DB2BaseDataSource.java:8286)
	at
com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriterForNewConnection(DB2BaseDataSource.java:8263)
	at
com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriterForNewConnection(DB2BaseDataSource.java:8221)
	at
com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:125)
	at
org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:74)
	... 69 more
Caused by: java.io.FileNotFoundException: C:\GeronimoDeployment (Access is
denied)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
	at com.ibm.db2.jcc.b.sl.a(sl.java:103)
	... 75 more
-- 
View this message in context: http://www.nabble.com/data-source-without-trace-file-specified-is-unusable-tp16314244s134p16314244.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.

Re: data source without trace file specified is unusable

Posted by David Jencks <da...@yahoo.com>.
See https://issues.apache.org/jira/browse/GERONIMO-3440.

I've fixed the source and deployed a 1.2-SNAPSHOT to the codehaus  
snapshot repo so you should be able to pick up the rar from there.   
I'll try to get this released in the next few days.

thanks
david jencks

On Mar 26, 2008, at 12:30 PM, waynej wrote:

>
> I defined a DB2 data source at the Console and found I would have  
> fatal
> exceptions if I do not fill in the "Trace File" box.  Is this  
> supposed to
> happen?  I start the server in "C:\ResolverDeployment".  I have DB2  
> v9.5 and
> Hibernate.  Here's the first exception I get if "Trace File" isn't  
> filled
> in:
>
> [MCFConnectionInterceptor] Error occurred creating  
> ManagedConnection for
> org.apache.geronimo.connector.outbound.ConnectionInfo@19cbd8a
> javax.resource.spi.ResourceAdapterInternalException: Unable to obtain
> physical connection to com.ibm.db2.jcc.DB2XADataSource@1c3b70f
> 	at
> org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnectio 
> n(AbstractXADataSourceMCF.java:76)
> 	at org.tranql.connector.db2.XAMCF.createManagedConnection 
> (XAMCF.java:59)
> 	at
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getCon 
> nection(MCFConnectionInterceptor.java:48)
> 	at
> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterce 
> ptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
> 	at
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor 
> .internalGetConnection(SinglePoolConnectionInterceptor.java:67)
> 	at
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInt 
> erceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java: 
> 78)
> 	at
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor 
> .getConnection(TransactionEnlistingInterceptor.java:46)
> 	at
> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.g 
> etConnection(TransactionCachingInterceptor.java:88)
> 	at
> org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.get 
> Connection(ConnectionHandleInterceptor.java:43)
> 	at
> org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection 
> (TCCLInterceptor.java:39)
> 	at
> org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.g 
> etConnection(ConnectionTrackingInterceptor.java:66)
> 	at
> org.apache.geronimo.connector.outbound.AbstractConnectionManager.alloc 
> ateConnection(AbstractConnectionManager.java:87)
> 	at org.tranql.connector.jdbc.DataSource.getConnection 
> (DataSource.java:56)
> 	at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection 
> (DatasourceConnectionProvider.java:69)
> 	at
> org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper. 
> prepare(SuppliedConnectionProviderConnectionHelper.java:27)
> 	at
> org.hibernate.tool.hbm2ddl.SchemaValidator.validate 
> (SchemaValidator.java:107)
> 	at
> org.hibernate.impl.SessionFactoryImpl.<init> 
> (SessionFactoryImpl.java:317)
> 	at
> org.hibernate.cfg.Configuration.buildSessionFactory 
> (Configuration.java:1294)
> 	at
> com.framework.integration.dao.FrameworkHibernateDAO.<clinit> 
> (FrameworkHibernateDAO.java:37)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native  
> Method)
> 	at
> sun.reflect.NativeConstructorAccessorImpl.newInstance 
> (NativeConstructorAccessorImpl.java:39)
> 	at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance 
> (DelegatingConstructorAccessorImpl.java:27)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> 	at java.lang.Class.newInstance0(Class.java:355)
> 	at java.lang.Class.newInstance(Class.java:308)
> 	at java.beans.Beans.instantiate(Beans.java:204)
> 	at java.beans.Beans.instantiate(Beans.java:48)
> 	at
> com.framework.common.FrameworkBaseObjectFactory.getObjectHelper 
> (FrameworkBaseObjectFactory.java:144)
> 	at
> com.framework.common.FrameworkBaseObjectFactory.getObject 
> (FrameworkBaseObjectFactory.java:109)
> 	at
> com.framework.integration.dao.FrameworkDAOFactory.getFrameworkDAO 
> (FrameworkDAOFactory.java:68)
> 	at
> com.mycompany.myapp.locator.UserFieldsLocator.createUserFieldsDAO 
> (UserFieldsLocator.java:60)
> 	at
> com.mycompany.myapp.ejb.UserFieldsSessionBean.getUserFieldsDAO 
> (UserFieldsSessionBean.java:242)
> 	at
> com.mycompany.myapp.ejb.UserFieldsSessionBean.create 
> (UserFieldsSessionBean.java:130)
> 	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.openejb.core.interceptor.ReflectionInvocationContext 
> $Invocation.invoke(ReflectionInvocationContext.java:146)
> 	at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.procee 
> d(ReflectionInvocationContext.java:129)
> 	at
> org.apache.openejb.core.interceptor.InterceptorStack.invoke 
> (InterceptorStack.java:67)
> 	at
> org.apache.openejb.core.stateless.StatelessContainer._invoke 
> (StatelessContainer.java:203)
> 	at
> org.apache.openejb.core.stateless.StatelessContainer.invoke 
> (StatelessContainer.java:165)
> 	at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod 
> (EjbObjectProxyHandler.java:223)
> 	at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke 
> (EjbObjectProxyHandler.java:77)
> 	at
> org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke 
> (BaseEjbProxyHandler.java:245)
> 	at
> org.apache.openejb.util.proxy.Jdk13InvocationHandler.invoke 
> (Jdk13InvocationHandler.java:49)
> 	at $Proxy40.create(Unknown Source)
> 	at
> org.apache.jsp.UserFieldsTest_jsp._jspService 
> (UserFieldsTest_jsp.java:84)
> 	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
> 	at
> org.apache.jasper.servlet.JspServletWrapper.service 
> (JspServletWrapper.java:388)
> 	at org.apache.jasper.servlet.JspServlet.serviceJspFile 
> (JspServlet.java:320)
> 	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
> (ApplicationFilterChain.java:290)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter 
> (ApplicationFilterChain.java:206)
> 	at
> org.apache.catalina.core.StandardWrapperValve.invoke 
> (StandardWrapperValve.java:230)
> 	at
> org.apache.catalina.core.StandardContextValve.invoke 
> (StandardContextValve.java:175)
> 	at
> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke 
> (DefaultSubjectValve.java:56)
> 	at
> org.apache.geronimo.tomcat.GeronimoStandardContext 
> $SystemMethodValve.invoke(GeronimoStandardContext.java:353)
> 	at
> org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke 
> (GeronimoBeforeAfterValve.java:47)
> 	at
> org.apache.catalina.core.StandardHostValve.invoke 
> (StandardHostValve.java:128)
> 	at
> org.apache.catalina.valves.ErrorReportValve.invoke 
> (ErrorReportValve.java:104)
> 	at
> org.apache.catalina.core.StandardEngineValve.invoke 
> (StandardEngineValve.java:109)
> 	at
> org.apache.catalina.valves.AccessLogValve.invoke 
> (AccessLogValve.java:563)
> 	at
> org.apache.catalina.connector.CoyoteAdapter.service 
> (CoyoteAdapter.java:261)
> 	at
> org.apache.coyote.http11.Http11Processor.process 
> (Http11Processor.java:844)
> 	at
> org.apache.coyote.http11.Http11Protocol 
> $Http11ConnectionHandler.process(Http11Protocol.java:581)
> 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run 
> (JIoEndpoint.java:447)
> 	at java.lang.Thread.run(Thread.java:619)
> Caused by: com.ibm.db2.jcc.b.SqlException: [jcc][10257][10960] 
> [3.50.152]
> Unable to open file . ERRORCODE=-4223, SQLSTATE=null
> 	at com.ibm.db2.jcc.b.wc.a(wc.java:55)
> 	at com.ibm.db2.jcc.b.wc.a(wc.java:84)
> 	at com.ibm.db2.jcc.b.sl.a(sl.java:111)
> 	at
> com.ibm.db2.jcc.DB2BaseDataSource.computePrintWriter 
> (DB2BaseDataSource.java:8391)
> 	at
> com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriter 
> (DB2BaseDataSource.java:8286)
> 	at
> com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriterForNewConnection( 
> DB2BaseDataSource.java:8263)
> 	at
> com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriterForNewConnection( 
> DB2BaseDataSource.java:8221)
> 	at
> com.ibm.db2.jcc.DB2XADataSource.getXAConnection 
> (DB2XADataSource.java:125)
> 	at
> org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnectio 
> n(AbstractXADataSourceMCF.java:74)
> 	... 69 more
> Caused by: java.io.FileNotFoundException: C:\GeronimoDeployment  
> (Access is
> denied)
> 	at java.io.FileOutputStream.open(Native Method)
> 	at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
> 	at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
> 	at com.ibm.db2.jcc.b.sl.a(sl.java:103)
> 	... 75 more
> -- 
> View this message in context: http://www.nabble.com/data-source- 
> without-trace-file-specified-is-unusable-tp16314244s134p16314244.html
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>