Trying to use POI 3.11 jar crashing

dev google-group-archive
21

the createObject() works fine. It crashes when you try to do a
wb.create(). I tried using an InputStream as well as a File, same result.
The problem seems to be in in org.apache.poi.util.IOUtils. My laptop has
the same Lucee version as the server, but if I
dump() org.apache.poi.util.IOUtils on my laptop there are quite a few
methods shown. The same dump() on the server shows only two readFully()
methods. Something in there is why create() is failing. Here is the error
that occurs:
org.apache.poi.util.IOUtils.readFully(Ljava/nio/channels/ReadableByteChannel
;Ljava/nio/ByteBuffer;)I at org.apache.poi.poifs.filesystem.NPOIFSFileSystem
.(NPOIFSFileSystem.java:195):195 at org.apache.poi.poifs.filesystem.
NPOIFSFileSystem.(NPOIFSFileSystem.java:163):163 at org.apache.poi.
poifs.filesystem.NPOIFSFileSystem.(NPOIFSFileSystem.java:145):145 at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:87):
87 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method):-2 at sun.
reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57):57
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43):43 at java.lang.reflect.Method.invoke(
Method.java:606):606 at lucee.runtime.reflection.pairs.MethodInstance.invoke
(MethodInstance.java:55):55 at lucee.runtime.java.JavaObject.call(JavaObject
.java:234):234 at lucee.runtime.java.JavaObject.call(JavaObject.java:256):
256 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(
VariableUtilImpl.java:742):742 at lucee.runtime.PageContextImpl.getFunction(
PageContextImpl.java:1586):1586 at cewit2015.test_cfm$cf.call(C:\inetpub
wwwroot\r1.events-registration.com\cewit2015\test.cfm:14):14 at lucee.
runtime.PageContextImpl.doInclude(PageContextImpl.java:948):948 at lucee.
runtime.PageContextImpl.doInclude(PageContextImpl.java:900):900 at lucee.
runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):
223 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.
java:35):35 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:
2254):2254 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:
2221):2221 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl
.java:456):456 at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-
1 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727 at org
.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:303):303 at org.apache.catalina.core.
ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.
apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52 at org
.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241):241 at org.apache.catalina.core.
ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.
apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
220):220 at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:122):122 at org.apache.catalina.authenticator.
AuthenticatorBase.invoke(AuthenticatorBase.java:504):504 at org.apache.
catalina.core.StandardHostValve.invoke(StandardHostValve.java:170):170 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103
):103 at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:116):116 at org.apache.catalina.connector.
CoyoteAdapter.service(CoyoteAdapter.java:421):421 at org.apache.coyote.ajp.
AjpProcessor.process(AjpProcessor.java:190):190 at org.apache.coyote.
AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611
):611 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(
JIoEndpoint.java:314):314 at java.util.concurrent.ThreadPoolExecutor.
runWorker(ThreadPoolExecutor.java:1145):1145 at java.util.concurrent.
ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615 at org.apache
.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
at java.lang.Thread.run(Thread.java:745):745On Monday, April 27, 2015 at 6:04:36 AM UTC-4, Micha wrote:

between the lines

Micha

On Mon, Apr 27, 2015 at 8:02 AM, Jonathan Brookins <jon.br...@gmail.com <javascript:>> wrote:

Micha,

I’m not using the jars anymore, just trying to use the POI 3.8 inside of
Lucee. Does this not instantiate the Workbook Factory, or is there a
specific Lucee-based namespace to access it?

nope

wb = createObject(“java”, “org.apache.poi.ss.usermodel.WorkbookFactory”);

looks right to me, what happens?

On Sunday, April 26, 2015 at 3:41:27 AM UTC-4, Micha wrote:

If you get that error you still have a version conflict for sure, I
cannot say why. Don’t forget rename the jar or move it to a sub folder will
not hide it from the servlet engine…

Micha

Am Samstag, 25. April 2015 schrieb Jonathan Brookins :

The problem now isn’t a 3.11 vs 3.8 issue. I’m not using the 3.11 jar
any longer, but I’m still getting the same error.

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/3bb8e9c3-7763-4d67-9756-fe493cee8045%40googlegroups.com
https://groups.google.com/d/msgid/lucee/3bb8e9c3-7763-4d67-9756-fe493cee8045%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/59a64817-5db8-41f9-a7aa-6a65b95c194a%40googlegroups.com
https://groups.google.com/d/msgid/lucee/59a64817-5db8-41f9-a7aa-6a65b95c194a%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

22

I ran into similar problems when attempting to use the included POI
jars directly via CreateObject(). I went back to JavaLoader which
worked well and allowed me to use the latest POI, despite what Micha
says. Have you tried that?

Alternatively have you tried my library? It will save you the bother
of setting up JavaLoader/POI 3.11 and give you a wide range of
functions in CFML

If you’ve got a specific need which it doesn’t cover I’d welcome
suggestions/feedback.

JulianOn 27 April 2015 at 15:42, Jonathan Brookins <@Jonathan_Brookins> wrote:

the createObject() works fine. It crashes when you try to do a
wb.create(). I tried using an InputStream as well as a File, same result.
The problem seems to be in in org.apache.poi.util.IOUtils. My laptop has
the same Lucee version as the server, but if I dump()
org.apache.poi.util.IOUtils on my laptop there are quite a few methods
shown. The same dump() on the server shows only two readFully() methods.
Something in there is why create() is failing.

23

One thing I just realized about this. My local Lucee copy is a Railo
upgrade, while the server is a clean install. Perhaps that is why it works
locally and not on the server.On Tuesday, April 28, 2015 at 2:32:30 PM UTC-4, Jonathan Brookins wrote:

Micha,

Since the Lucee POI libs aren’t working, at least on the server, should I
file a bug report?

24

Micha,

Since the Lucee POI libs aren’t working, at least on the server, should I
file a bug report?

25

Hi,

My instance has the same issue, installed from scratch.

To rectify I:

moved apache-poi* out of the lucee/lib/ directory.
Downloaded and extracted the latest POI from the apache site.
Copied/movied poi-3.11/poi-* to the lucee/lib/ directory.
Stopped then started lucee

Re-running the code then worked, no ‘no method’ error.

HTH

JediOn 28 April 2015 at 19:36, Jonathan Brookins <@Jonathan_Brookins> wrote:

One thing I just realized about this. My local Lucee copy is a Railo
upgrade, while the server is a clean install. Perhaps that is why it works
locally and not on the server.

On Tuesday, April 28, 2015 at 2:32:30 PM UTC-4, Jonathan Brookins wrote:

Micha,

Since the Lucee POI libs aren’t working, at least on the server, should I
file a bug report?

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/702a971c-0eb5-43c1-b632-58c2710d515b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

26

Thanks, Jedi! I’ll give it a shot and let you know how it goes.On Wednesday, April 29, 2015 at 12:25:28 PM UTC-4, Jedihomer Townend wrote:

Hi,

My instance has the same issue, installed from scratch.

To rectify I:

moved apache-poi* out of the lucee/lib/ directory.
Downloaded and extracted the latest POI from the apache site.
Copied/movied poi-3.11/poi-* to the lucee/lib/ directory.
Stopped then started lucee

Re-running the code then worked, no ‘no method’ error.

HTH

Jedi

On 28 April 2015 at 19:36, Jonathan Brookins <jon.br...@gmail.com <javascript:>> wrote:

One thing I just realized about this. My local Lucee copy is a Railo
upgrade, while the server is a clean install. Perhaps that is why it
works
locally and not on the server.

On Tuesday, April 28, 2015 at 2:32:30 PM UTC-4, Jonathan Brookins wrote:

Micha,

Since the Lucee POI libs aren’t working, at least on the server, should
I
file a bug report?

–
You received this message because you are subscribed to the Google
Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit

https://groups.google.com/d/msgid/lucee/702a971c-0eb5-43c1-b632-58c2710d515b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.