java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Latif M P

Hi,<br />
Can any one help for the following issue.Im using BIRT 232 Scripted data sources. Getting this error.<br />
<strong class='bbc'>Database is</strong><span class='bbc_underline'></span> sqlserver.<strong class='bbc'>Jar using </strong><span class='bbc_underline'></span>opta.jar &sqljdbc4.jar & sqljdbc.jar.All three jar file is saved in \plugins\org.eclipse.birt.report.viewer_2.3.2.r232_20090212\birt\WEB-INF\lib.<br />
& also all three extract in classes folder. <br />
<span class='bbc_underline'><strong class='bbc'>JDK</strong></span> is 1.5.<br />
<br />
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver<br />
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:483)<br />
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:399)<br />
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:387)<br />
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:87)<br />
at java.lang.ClassLoader.loadClass(Unknown Source)<br />
at java.lang.Class.forName0(Native Method)<br />
at java.lang.Class.forName(Unknown Source)<br />
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getDesigntimeConnection(MXReportDataSourceImpl.java:226)<br />
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:144)<br />
at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:126)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br />
at java.lang.reflect.Method.invoke(Unknown Source)<br />
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)<br />
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)<br />
at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)<br />
at org.mozilla.javascript.gen.c9._c1(<inline>:3)<br />
at org.mozilla.javascript.gen.c9.call(<inline>)<br />
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)<br />
at org.mozilla.javascript.gen.c10._c0(<inline>:1)<br />
at org.mozilla.javascript.gen.c10.call(<inline>)<br />
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)<br />
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)<br />
at org.mozilla.javascript.gen.c10.call(<inline>)<br />
at org.mozilla.javascript.gen.c10.exec(<inline>)<br />
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)<br />
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268)<br />
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713)<br />
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)<br />
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71)<br />
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196)<br />
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:77)<br />
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:79)<br />
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:244)<br />
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:220)<br />
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)<br />
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)<br />
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)<br />
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)<br />
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)<br />
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)<br />
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)<br />
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)<br />
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)<br />
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)<br />
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)<br />
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)<br />
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)<br />
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)<br />
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)<br />
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)<br />
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)<br />
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)<br />
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)<br />
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)<br />
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)<br />
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)<br />
at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)<br />
at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:53)<br />
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)<br />
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)<br />
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)<br />
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br />
at java.lang.reflect.Method.invoke(Unknown Source)<br />
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)<br />
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br />
at java.lang.reflect.Method.invoke(Unknown Source)<br />
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)<br />
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)<br />
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)<br />
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)<br />
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)<br />
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)<br />
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)<br />
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)<br />
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)<br />
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)<br />
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)<br />
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)<br />
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)<br />
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)<br />
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)<br />
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)<br />
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:269)<br />
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)<br />
at org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677)<br />
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)<br />
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)<br />
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)<br />
at org.mortbay.http.HttpServer.service(HttpServer.java:909)<br />
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)<br />
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)<br />
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)<br />
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)<br />
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)<br />
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)<br />
<br />
<br />
Thanks<br />
LAtif Patel

JasonW

I am not sure if it will help but have you tried the scriptlib dir instead of the web-inf/lib?

Jason