Solved

Can't parse an expression rm.exec using jxls package

Posted on 2010-08-24
7
2,196 Views
Last Modified: 2012-05-10
Exception in thread "main" java.lang.RuntimeException: Can't parse an expression rm.exec('SELECT d.name depname, e.name empname, payment, bonus FROM employee e, department d where d.id = e.depid order by age desc')
at net.sf.jxls.tag.ForEachTag.parseItemsProperty(ForEachTag.java:142)
at net.sf.jxls.tag.ForEachTag.init(ForEachTag.java:104)
at net.sf.jxls.parser.CellParser.parseTag(CellParser.java:294)
at net.sf.jxls.parser.CellParser.parseCellValue(CellParser.java:196)
at net.sf.jxls.parser.CellParser.parseCell(CellParser.java:57)
at net.sf.jxls.transformer.SheetTransformer.parseCells(SheetTransformer.java:193)
at net.sf.jxls.transformer.SheetTransformer.parseRow(SheetTransformer.java:263)
at net.sf.jxls.transformer.SheetTransformer.transformSheet(SheetTransformer.java:82)
at net.sf.jxls.transformer.XLSTransformer.transformWorkbook(XLSTransformer.java:238)
at net.sf.jxls.transformer.XLSTransformer.transformXLS(XLSTransformer.java:217)
at net.sf.jxls.transformer.XLSTransformer.transformXLS(XLSTransformer.java:196)
at net.sf.jxls.sample.ReportingSample.main(ReportingSample.java:38)
Caused by: java.sql.SQLException: Column 'name' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1093)
at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4951)
at org.apache.commons.beanutils.JDBCDynaClass.getObject(JDBCDynaClass.java:271)
at org.apache.commons.beanutils.RowSetDynaClass.copy(RowSetDynaClass.java:232)
at org.apache.commons.beanutils.RowSetDynaClass.<init>(RowSetDynaClass.java:187)
at org.apache.commons.beanutils.RowSetDynaClass.<init>(RowSetDynaClass.java:152)
at net.sf.jxls.report.ReportManagerImpl.exec(ReportManagerImpl.java:44)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.jexl.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:231)
at org.apache.commons.jexl.parser.ASTMethod.execute(ASTMethod.java:104)
at org.apache.commons.jexl.parser.ASTReference.execute(ASTReference.java:82)
at org.apache.commons.jexl.parser.ASTReference.value(ASTReference.java:56)
at org.apache.commons.jexl.parser.ASTReferenceExpression.value(ASTReferenceExpression.java:50)
at org.apache.commons.jexl.ExpressionImpl.evaluate(ExpressionImpl.java:79)
at net.sf.jxls.parser.Expression.evaluate(Expression.java:69)
at net.sf.jxls.tag.ForEachTag.parseItemsProperty(ForEachTag.java:135)
0
Comment
Question by:rajumuchunde
  • 3
  • 2
  • 2
7 Comments
 
LVL 92

Expert Comment

by:objects
ID: 33518515
appears you are try to use a column name that does not exist
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 33518872
Try
rm.exec('SELECT d.name depname, e.name empname, e.payment payment, e.bonus bonus, e.age age FROM employee e, department d where d.id = e.depid order by age desc')

Open in new window

0
 
LVL 86

Expert Comment

by:CEHJ
ID: 33518887
You might be able to simplify that to
rm.exec('SELECT d.name depname, e.name empname, e.payment, e.bonus FROM employee e, department d where d.id = e.depid order by e.age desc')

Open in new window

0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:rajumuchunde
ID: 33530431
error remain same inspite of changing query .
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 33530620
Please post your current code
0
 
LVL 92

Accepted Solution

by:
objects earned 500 total points
ID: 33536942
> error remain same inspite of changing query .

you need to change it to fix the column name
0
 

Author Closing Comment

by:rajumuchunde
ID: 33549220
alias name problems
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how do i compare an object based on two fields 6 54
oracle 11g 23 82
expectj telnet failing 5 36
Adding multiple JVM environments to RedHat 6 7 21
An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question