taivan.dagva Posted April 21, 2014 Share Posted April 21, 2014 <font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/comp1_mini.jpg"> Compiling to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.jasper</font><font face="SansSerif" size="3" color="#0000CC"><b>Compilation running time: 218!</b></font><hr><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/comp1_mini.jpg"> Compiling to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.jasper</font><font face="SansSerif" size="3" color="#0000CC"><b>Compilation running time: 234!</b></font><hr><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/rundb1_mini.jpg"> Filling report...</font><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/world.png"> Locale: <b>English (United States)</b></font><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/timezone.png"> Time zone: <b>Default</b></font>Error filling print... Error executing SQL statement for : inventorynet.sf.jasperreports.engine.JRException: Error executing SQL statement for : inventory at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1288) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:907) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:852) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STOCKCURRENT.STOCKSECURITY' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 12 more<font face="SansSerif" size="3">Print not filled. Try to use an EmptyDataSource...</font><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/comp1_mini.jpg"> Compiling to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.jasper</font><font face="SansSerif" size="3" color="#0000CC"><b>Compilation running time: 218!</b></font><hr><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/rundb1_mini.jpg"> Filling report...</font><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/world.png"> Locale: <b>English (United States)</b></font><font face="SansSerif" size="3" color="#000000"><img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/timezone.png"> Time zone: <b>Default</b></font>Error filling print... Error executing SQL statement for : inventorynet.sf.jasperreports.engine.JRException: Error executing SQL statement for : inventory at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1288) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:907) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:852) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STOCKCURRENT.STOCKSECURITY' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 12 more<font face="SansSerif" size="3">Print not filled. Try to use an EmptyDataSource...</font> Link to comment Share on other sites More sharing options...
tkavanagh Posted April 23, 2014 Share Posted April 23, 2014 Looks like the inventory table does not have the column: STOCKCURRENT.STOCKSECURITYThis could also potentially be a lowercase/uppercase issue. When MySQL runs under Linux, it is case sensitive. But when MySQL is run under Windows, it is not case sensitive. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now