Oracle JDBC Errors

jbbaird · October 14, 2006

I have several reports that work fine in iReport but cannot be executed in jasper intelligence. the error starts "java.lang.LinkageError: Class oracle/sql/converter/CharacterConverters violates loader constraints ... (full text below)."

using 0jdbc14.zip

They work fine aimed at MySql ...

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.LinkageError: Class oracle/sql/converter/CharacterConverters violates loader constraints

org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:832)

org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726)

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360)

javax.servlet.http.HttpServlet.service(HttpServlet.java:709)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:137)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195)

org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)

org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)

root cause

java.lang.LinkageError: Class oracle/sql/converter/CharacterConverters violates loader constraints

java.lang.ClassLoader.defineClass1(Native Method)

java.lang.ClassLoader.defineClass(ClassLoader.java:620)

java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)

org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1812)

org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:866)

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1319)

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)

java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)

oracle.sql.CharacterSet1Byte.getInstance(CharacterSet1Byte.java:86)

oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:103)

oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)

oracle.sql.CharacterSet.make(CharacterSet.java:440)

oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:145)

oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:878)

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

java.sql.DriverManager.getConnection(DriverManager.java:525)

java.sql.DriverManager.getConnection(DriverManager.java:171)

org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94)

org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)

org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)

org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)

com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:50)

com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:47)

com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:492)

com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:254)

com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:601)

com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:58)

com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:234)

com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:66)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:231)

org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:141)

org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:67)

org.springframework.webflow.AnnotatedAction.execute(AnnotatedAction.java:208)

org.springframework.webflow.ActionExecutor.execute(ActionExecutor.java:54)

org.springframework.webflow.ActionState.doEnter(ActionState.java:184)

org.springframework.webflow.State.enter(State.java:201)

org.springframework.webflow.Transition.execute(Transition.java:224)

org.springframework.webflow.TransitionableState.onEvent(TransitionableState.java:105)

org.springframework.webflow.Flow.onEvent(Flow.java:545)

org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.signalEvent(FlowExecutionControlContextImpl.java:199)

org.springframework.webflow.ActionState.doEnter(ActionState.java:188)

org.springframework.webflow.State.enter(State.java:201)

org.springframework.webflow.Flow.start(Flow.java:531)

org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.start(FlowExecutionControlContextImpl.java:187)

org.springframework.webflow.SubflowState.doEnter(SubflowState.java:131)

org.springframework.webflow.State.enter(State.java:201)

org.springframework.webflow.Transition.execute(Transition.java:224)

org.springframework.webflow.TransitionableState.onEvent(TransitionableState.java:105)

org.springframework.webflow.Flow.onEvent(Flow.java:545)

org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.signalEvent(FlowExecutionControlContextImpl.java:199)

org.springframework.webflow.execution.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:239)

org.springframework.webflow.executor.FlowExecutorImpl.signalEvent(FlowExecutorImpl.java:177)

org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:100)

org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:198)

org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:792)