SQL to Excel

We also tried the fix with applying Trim on sql.

Getting the following exception when trying to export 200 columns to an excel:

Exception in thread "ThreadPoolTaskExecutor-329094" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V

Hello, we had this problem. We were using the fields "cell keys" and "cells values" and the problem was that some values had unnecessary spaces. We fixed it with a trim in the previous rule that calculates the values.

Try using trim function in your SQL query on text columns which has space in the start of the value. for e.g. your sql query should be something like "SELECT TRIM(ADDRESS) AS Address from ADDRESS_TABLE"

Me too

I am facing the same issue. Is there any update on when it is expected to be solved?

I am facing same issue. 

Hi, in the last few weeks we are facing an issue with the plugin failing due to the following error: 

javax.resource.spi.work.WorkCompletedException: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V
	at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V

Does it seem familiar to you?

• Fixed Review Comments
• Added try-with-resources for connections.
• Closed some connections in final blocks.
• Fixed the reported vulnerabilities in the plugin as per the vulnerability report:

1. Update the following Libraries to the latest versions
2. commons-beanutils
3. commons-io
4. commons-lang
5. commons-math
6. poi
7. poi-ooxml
8. xml-beans
9. 
   
10. Added New lib that is compatible with the new version.
11. commons-collections
12. commons-compress
13. poi-ooxml-lite
14. Remove the deprecated setter function that sets cell style

I am facing similar issue. please advise how you resolved it.