Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » java.sql.SQLException: Unknown character set index for field '1075' received from server.
java.sql.SQLException: Unknown character set index for field '1075' received from server. [message #557625] Wed, 08 September 2010 07:31 Go to next message
Eclipse UserFriend
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.
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 14:34 Go to previous message
Eclipse UserFriend
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.
>
>
Previous Topic:Formatting of table messed up when output spans multiple pages
Next Topic:NullPointerException when running com.ibm.examples.chart RCP application
Goto Forum:
  


Current Time: Sun Jul 27 03:06:50 EDT 2025

Powered by FUDForum. Page generated in 0.05083 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly