Help about the sample !

[ktrinad]

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 ?