|
| Re: java.sql.SQLException: Unknown character set index for field '1075' received from server. [message #557759 is a reply to message #557625] |
Wed, 08 September 2010 18:34  |
|
What version of Birt and MySQL Driver are you using?
There was a similar post a while back but it does not sound like your issue.
http://www.eclipse.org/forums/index.php?t=tree&th=80640& amp;#page_top
Jason
On 9/8/2010 7:31 AM, laxmipathi raju wrote:
> Hi ,
> While generating report i am getting the following error. Can any body
> help me what is the cause for occurring this error and how to overcome
> this.
>
> Exception:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
> not return a ResultSet object.
> SQL error #1: Unknown character set index for field '1075' received from
> server.
> ;
> java.sql.SQLException: Unknown character set index for field '1075'
> received from server.
> at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery
> (Statement.java:446)
> at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsing
> DefaultPolicy(Statement.java:353)
> at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(
> Statement.java:295)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu
> ery.doGetMetaData(OdaQuery.java:408)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu
> ery.getMetaData(OdaQuery.java:376)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g
> etRuntimeMetaData(PreparedStatement.java:419)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g
> etProjectedColumns(PreparedStatement.java:389)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d
> oGetMetaData(PreparedStatement.java:359)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g
> etMetaData(PreparedStatement.java:346)
> at org.eclipse.birt.data.engine.executor.DataSourceQuery.getMet
> aData(DataSourceQuery.java:393)
> at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar
> e(DataSourceQuery.java:321)
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu
> eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:345)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu
> tion(QueryExecutor.java:331)
> at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr
> eparedQuery.java:437)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr
> oduceQueryResults(PreparedDataSourceQuery.java:189)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex
> ecute(PreparedDataSourceQuery.java:177)
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute
> (PreparedOdaDSQuery.java:143)
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:476)
> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec
> uteQuery(DteDataEngine.java:117)
> at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine
> .doExecuteQuery(DataGenerationEngine.java:79)
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e
> xecute(AbstractDataEngine.java:253)
> at org.eclipse.birt.report.engine.executor.ExecutionContext.exe
> cuteQuery(ExecutionContext.java:1825)
> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex
> ecuteQuery(QueryItemExecutor.java:80)
> at org.eclipse.birt.report.engine.executor.TableItemExecutor.ex
> ecute(TableItemExecutor.java:62)
> at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe
> dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
> at org.eclipse.birt.report.engine.internal.executor.emitter.Rep
> ortItemEmitterExecutor.execute(ReportItemEmitterExecutor.jav a:46)
> at org.eclipse.birt.report.engine.internal.executor.dup.Suppres
> sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking
> LM.layoutNodes(HTMLBlockStackingLM.java:64)
> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout
> (HTMLPageLM.java:90)
> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE
> ngine.layout(HTMLReportLayoutEngine.java:99)
> at org.eclipse.birt.report.engine.presentation.ReportDocumentBu
> ilder.build(ReportDocumentBuilder.java:213)
> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:230)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:79)
> at com.jataayu.reportapp.business.birt.BIRTConfiguration$TaskTh read.
> <init>(BIRTConfiguration.java:654)
> at com.jataayu.reportapp.business.birt.BIRTConfiguration.runTas
> k(BIRTConfiguration.java:277)
> at com.jataayu.reportapp.business.birt.BIRTManager.generateHTML
> File(BIRTManager.java:374)
> at com.jataayu.reportapp.business.birt.BIRTManager.getHTMLlView
> (BIRTManager.java:114)
> at com.jataayu.reportapp.controller.reportmgmt.ReportViewContro
> ller.viewDynamicPages(ReportViewController.java:613)
> at com.jataayu.reportapp.controller.reportmgmt.ReportViewContro
> ller.showReportDownloadHandler(ReportViewController.java:242 )
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.springframework.web.servlet.mvc.multiaction.MultiActionC
> ontroller.invokeNamedMethod(MultiActionController.java:369)
> at org.springframework.web.servlet.mvc.multiaction.MultiActionC
> ontroller.handleRequestInternal(MultiActionController.java:3 25)
> at org.springframework.web.servlet.mvc.AbstractController.handl
> eRequest(AbstractController.java:139)
> at org.springframework.web.servlet.mvc.SimpleControllerHandlerA
> dapter.handle(SimpleControllerHandlerAdapter.java:44)
> at org.springframework.web.servlet.DispatcherServlet.doDispatch
> (DispatcherServlet.java:717)
> at org.springframework.web.servlet.DispatcherServlet.doService(
> DispatcherServlet.java:658)
> at org.springframework.web.servlet.FrameworkServlet.processRequ
> est(FrameworkServlet.java:392)
> at org.springframework.web.servlet.FrameworkServlet.doPost(Fram
> eworkServlet.java:357)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
> lter(ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
> licationFilterChain.java:188)
> at com.jataayu.reportapp.utils.ResponseHeaderFilter.doFilter(Re
> sponseHeaderFilter.java:27)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
> lter(ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
> licationFilterChain.java:188)
> at org.apache.catalina.core.StandardWrapperValve.invoke(Standar
> dWrapperValve.java:210)
> at org.apache.catalina.core.StandardContextValve.invoke(Standar
> dContextValve.java:174)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHo
> stValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
> rtValve.java:117)
> at org.apache.catalina.core.StandardEngineValve.invoke(Standard
> EngineValve.java:108)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd
> apter.java:151)
> at org.apache.coyote.http11.Http11Processor.process(Http11Proce
> ssor.java:870)
> at org.apache.coyote.http11.Http11BaseProtocol$Http11Connection
> Handler.processConnection(Http11BaseProtocol.java:665)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo
> lTcpEndpoint.java:528)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:81)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
> n(ThreadPool.java:685)
> at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException: Unknown character set index for field
> '1075' received from server.
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:105 6)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957 )
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927 )
> at com.mysql.jdbc.ConnectionImpl.getCharsetNameForIndex(Connect
> ionImpl.java:2818)
> at com.mysql.jdbc.Field.<init>(Field.java:198)
> at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:740)
> at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:399)
> at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.j ava:2411)
> at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1657)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2036)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:25 43)
> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedSta
> tement.java:1737)
> at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatem
> ent.java:1888)
> at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery
> (Statement.java:442)
>
> Thanks & Regards,
> Laxmipathi Raju.
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.25240 seconds
] 
Search
Help
Register
Login
Home
