ktrinad Posted August 10, 2006 Share Posted August 10, 2006 By: kaeyann - cvc Help about the sample ! 2001-11-17 22:46 I download the jasperreports-0.2.0.sample.zip and already set the classpath whit D:apjavaJasperReports 0.2.0jasperreports.jar;D:apjavaJasperReports 0.2.0commons-digester.jar;D:apjavaJasperReports 0.2.0commons-beanutils.jar;D:apjavaJasperReports 0.2.0commons-collections.jar and also modify the JasperReportsTestApp.java's JDBC parameter to fit my envirement , but when I run "java -Dorg.xml.sax.driver=org.apache.xerces.parsers.SAXParser JasperReportsTestApp -Tfill -FFirstJasper.jasper" , I got a exception " java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]?L?Ī??Ôz????Þ¦nbsp;at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringDate(Unknown Source) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringDate(Unknown Source) at sun.jdbc.odbc.JdbcOdbcResultSet.getDate(Unknown Source) at sun.jdbc.odbc.JdbcOdbcResultSet.getDate(Unknown Source) at dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.j ava:140) at dori.jasper.engine.JRVerticalFiller.fillReport(JRVerticalFiller.java: 57) at dori.jasper.engine.JRFiller.fillReport(JRFiller.java:84) at dori.jasper.engine.JasperManager.fillReport(JasperManager.java:383) at dori.jasper.engine.JasperManager.fillReportToFile(JasperManager.java: 361) at dori.jasper.engine.JasperManager.fillReportToFile(JasperManager.java: 310) at JasperReportsTestApp.main(JasperReportsTestApp.java:60) " Can someone tell me where was wrong ? thanks By: kaeyann - cvc RE: Help about the sample ! 2001-11-18 05:58 Now I know the problem and the solution is : In FirstJasper.xml , we must replace queryString with " SELECT ShippedDate,ShipCountry ,RequiredDate,CustomerID,OrderID,ShipName,ShipVia,ShipPostalCode,OrderDate,ShipCity,ShipAddress,EmployeeID,ShipRegion,Freight FROM Orders WHERE OrderID <= 12000 ORDER BY ShipCountry " , and it will ok .... But , I don't know why we need to do this ? Why we must select columns in this order ? 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