[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[birt-report-engine-dev] Cannot open the connection for the JDBC driver

Hi, im new to birt, and im doing a web application, i have make the data set
correctly, i have the property binding correctly, and 1 parameter, when i
run the report it work great the parameter, but when i run my application on
tomcat server, display the report but cant load the data from the database,
i have the following stack trace:


Nov 12, 2007 9:35:45 AM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in
production environments was not found on the java.library.path: C:\Program
Files\Java\jre1.5.0_10\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program
Files\Java\jre1.6.0_02\bin\client;C:\Program
Files\Java\jre1.6.0_02\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Common
Files\Adaptec
Shared\System;;C:\PROGRA~1\ATT\Graphviz\bin;C:\PROGRA~1\ATT\Graphviz\bin\tools;C:\Sun\SDK\bin
Nov 12, 2007 9:35:45 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 12, 2007 9:35:45 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1141 ms
Nov 12, 2007 9:35:45 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Nov 12, 2007 9:35:45 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.20
Nov 12, 2007 9:35:45 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 12, 2007 9:36:02 AM
org.eclipse.birt.report.data.oda.sampledb.SampledbPlugin start
INFO: Sampledb plugin starts up. Current startCount=0
Nov 12, 2007 9:36:02 AM
org.eclipse.birt.report.data.oda.sampledb.SampledbPlugin init
INFO: Creating Sampledb database at location
C:\DOCUME~1\user01\LOCALS~1\Temp\/BIRTSampleDB_1194885362067_1a918d5
Nov 12, 2007 9:36:09 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 12, 2007 9:36:09 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 12, 2007 9:36:09 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/62  config=null
Nov 12, 2007 9:36:09 AM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Nov 12, 2007 9:36:09 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 24558 ms
Nov 12, 2007 9:36:29 AM org.apache.axis.utils.JavaUtils
isAttachmentSupported
WARNING: Unable to find required classes (javax.activation.DataHandler and
javax.mail.internet.MimeMultipart). Attachment support is disabled.
Nov 12, 2007 9:37:01 AM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver
WARNING: Failed to load JDBC driver class:
com.microsoft.jdbc.sqlserver.SQLServerDriver
Nov 12, 2007 9:37:01 AM
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Cannot open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver
class: com.microsoft.jdbc.sqlserver.SQLServerDriver 
	at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:623)
	at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:731)
	at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:192)
	at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:158)
	at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:158)
	at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:115)
	at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
	at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:145)
	at
org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:134)
	at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:121)
	at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:214)
	at
org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:265)
	at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:210)
	at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:500)
	at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:161)
	at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:142)
	at
org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:438)
	at
org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:149)
	at
org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:111)
	at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:182)
	at
org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1683)
	at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:76)
	at
org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:61)
	at
org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
	at
org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
	at
org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
	at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
	at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
	at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
	at
org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:189)
	at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:224)
	at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)
	at org.eclipse.birt.report.service.ReportEngineService.runReport(Unknown
Source)
	at
org.eclipse.birt.report.service.BirtViewerReportService.runReport(Unknown
Source)
	at
org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(Unknown
Source)
	at
org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(Unknown
Source)
	at
org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(Unknown
Source)
	at
org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(Unknown
Source)
	at
org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown
Source)
	at
org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(Unknown
Source)
	at
org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(Unknown
Source)
	at
org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(Unknown
Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at
org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(Unknown
Source)
	at
org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(Unknown
Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
	at
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
	at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
	at
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
	at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
	at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(Unknown
Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown Source)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
Nov 12, 2007 9:37:02 AM
org.eclipse.birt.report.engine.data.dte.DataGenerationEngine doExecuteQuery
SEVERE: Cannot open the connection for the driver:
org.eclipse.birt.report.data.oda.jdbc
Cannot load JDBC Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver 
Nov 12, 2007 9:37:03 AM
org.eclipse.birt.report.engine.data.dte.DataPresentationEngine
doExecuteQuery
SEVERE: Can't load the report query

i have put my 3 jar files of the driver in the web apps of tomcat but i dont
know if im ok, i will apreciate your replies thanks



-- 
View this message in context: http://www.nabble.com/Cannot-open-the-connection-for-the-JDBC-driver-tf4792493.html#a13709791
Sent from the Eclipse BIRT - Report Engine - Dev mailing list archive at Nabble.com.