net.sf.jasperreports.engine.JRException: Error executing SQL statement for:

-
net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: arrivagk.
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:537)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:512)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:393)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: arrivagk.
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:344)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:548)
at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310)
... 6 more

Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

-Xlint:deprecation | deprecated API | use unchecked or unsafe operations

-
Note: Some input files use or override a deprecated API. ( It simply means that you are calling methods which have been marked with a  @Deprecated  annotation.) Note: Recompile with -Xlint:deprecation for details. (Probably, that is because you need to declare a List object, say (e.g.), without omitting '<' and '>': List < Integer > list = new ArrayList < Integer >();) Note: Some input files use unchecked or unsafe operations. ( for example when you call a function that returns Generic Collections and you don't specify the generic parameters yourself. for a function List < String > getNames () List names = obj . getNames (); will generate this error. To solve it you would just add the parameters List < String > names = obj . getNames ();) Note: Recompile with -Xlint:unchecked for details. ( From what I can tell in the docs, you can't do it on the command-line. According to the  javac  documentati
Lire la suite

Caused by: java.time.temporal.UnsupportedTemporalTypeException: Unsupported field: MinuteOfHour

-
Error ? Caused by: java.time.temporal.UnsupportedTemporalTypeException: Unsupported field: MinuteOfHour Solution : LocalDate  represents just a date, not a DateTime. So "HH:mm:ss" make no sense when formatting a  LocalDate . Use a  LocalDateTime  instead, assuming you want to represent both a date and time. Take a close look !! MinuteOfHour is unsupported /** Map of letters to fields. */ private static final Map < Character , TemporalField > FIELD_MAP = new HashMap <>(); static { FIELD_MAP . put ( 'G' , ChronoField . ERA ); FIELD_MAP . put ( 'y' , ChronoField . YEAR_OF_ERA ); FIELD_MAP . put ( 'u' , ChronoField . YEAR ); FIELD_MAP . put ( 'Q' , IsoFields . QUARTER_OF_YEAR ); FIELD_MAP . put ( 'q' , IsoFields . QUARTER_OF_YEAR ); FIELD_MAP . put ( 'M' , ChronoField . MONTH_OF_YEAR ); FIELD_MAP . put ( 'L' , ChronoField . MONTH_OF_YEAR ); FIELD_MAP . put (
Lire la suite

Jasper Raport bug on mac

-
net.sf.jasperreports.engine.query.JRJdbcQueryExecuter <init> WARNING: The supplied java.sql.Connection object is null. I've been using Jaspersoft paired with Java beans for my reports and everything is going well. It was only when I checked the logs, which can be viewed by the client, that I noticed that there is something wrong. In the code below, the highlighted line, it checks if there is an SQL connection.   Since I don't use SQL it returns a warning message:  JRJdbcQueryExecuter - The supplied java.sql.Connection object is null.  How can the SQL connection validation be prevented? this part of code works for me !!! JasperDesign jd = JRXmlLoader . load ( "C:\\Users\\USER\\DOCUMENTS\\ATHLETICS\\participants.jrxml" ); String sql = "SET @s:=0; select @s:=@s+1 POSITION, CHESTNUMBER AS 'CHEST NUMBER', FULLNAMES AS 'PARTICIPANT', TEAM AS 'TEAM'," + " PHONE AS 'PHONE'
Lire la suite