Forum Discussion

_ivanovich_'s avatar
_ivanovich_
Frequent Contributor
11 years ago

Read Excel file with Groovy code works with SOAPUI free version but not with the Ready API

Hi, i downloaded the same jars files in Soapui free V 5.2.1 and Ready API 1.4.0. with licence. i have a groovy to read excel file, it works with the free version in win7 but not with the pro versio...
_ivanovich_'s avatar
_ivanovich_
Frequent Contributor
11 years ago

Hi Rao,

 

this is the stack trace:

java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTExtensionList
    at java.lang.Class.getDeclaredMethods0(Native Method)
    at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
    at java.lang.Class.privateGetPublicMethods(Unknown Source)
    at java.lang.Class.getMethods(Unknown Source)
    at org.codehaus.groovy.reflection.stdclasses.CachedSAMClass.getSAMMethod(CachedSAMClass.java:161)
    at org.codehaus.groovy.reflection.ClassInfo.isSAM(ClassInfo.java:356)
    at org.codehaus.groovy.reflection.ClassInfo.createCachedClass(ClassInfo.java:346)
    at org.codehaus.groovy.reflection.ClassInfo.access$700(ClassInfo.java:38)
    at org.codehaus.groovy.reflection.ClassInfo$LazyCachedClassRef.initValue(ClassInfo.java:494)
    at org.codehaus.groovy.reflection.ClassInfo$LazyCachedClassRef.initValue(ClassInfo.java:485)
    at org.codehaus.groovy.util.LazyReference.getLocked(LazyReference.java:46)
    at org.codehaus.groovy.util.LazyReference.get(LazyReference.java:33)
    at org.codehaus.groovy.reflection.ClassInfo.getCachedClass(ClassInfo.java:108)
    at org.codehaus.groovy.reflection.ReflectionCache.getCachedClass(ReflectionCache.java:107)
    at org.codehaus.groovy.reflection.ParameterTypes.getParametersTypes0(ParameterTypes.java:78)
    at org.codehaus.groovy.reflection.ParameterTypes.getParameterTypes(ParameterTypes.java:64)
    at org.codehaus.groovy.reflection.CachedMethod.compareToMethod(CachedMethod.java:183)
    at org.codehaus.groovy.reflection.CachedMethod.compareTo(CachedMethod.java:139)
    at org.codehaus.groovy.reflection.CachedMethod$MyComparator.compare(CachedMethod.java:312)
    at java.util.Arrays.binarySearch0(Unknown Source)
    at java.util.Arrays.binarySearch(Unknown Source)
    at org.codehaus.groovy.reflection.CachedMethod.find(CachedMethod.java:65)
    at groovy.lang.MetaClassImpl.applyPropertyDescriptors(MetaClassImpl.java:2519)
    at groovy.lang.MetaClassImpl.setupProperties(MetaClassImpl.java:2258)
    at groovy.lang.MetaClassImpl.addProperties(MetaClassImpl.java:3299)
    at groovy.lang.MetaClassImpl.initialize(MetaClassImpl.java:3263)
    at org.codehaus.groovy.reflection.ClassInfo.getMetaClassUnderLock(ClassInfo.java:251)
    at org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:282)
    at org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:292)
    at org.codehaus.groovy.runtime.metaclass.MetaClassRegistryImpl.getMetaClass(MetaClassRegistryImpl.java:259)
    at org.codehaus.groovy.runtime.InvokerHelper.getMetaClass(InvokerHelper.java:868)
    at org.codehaus.groovy.runtime.callsite.CallSiteArray.createPojoSite(CallSiteArray.java:122)
    at org.codehaus.groovy.runtime.callsite.CallSiteArray.createCallSite(CallSiteArray.java:163)
    at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:110)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:114)
    at ExcelReader.readData(Script1.groovy:39)
    at ExcelReader$readData.call(Unknown Source)
    at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:110)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:114)
    at Script1.run(Script1.groovy:52)
    at com.eviware.soapui.support.scripting.groovy.SoapUIGroovyScriptEngine.run(SoapUIGroovyScriptEngine.java:92)
    at com.eviware.soapui.support.scripting.groovy.SoapUIProGroovyScriptEngineFactory$SoapUIProGroovyScriptEngine.run(SoapUIProGroovyScriptEngineFactory.java:76)
    at com.eviware.soapui.impl.wsdl.teststeps.WsdlGroovyScriptTestStep.run(WsdlGroovyScriptTestStep.java:155)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.GroovyScriptStepDesktopPanel$RunAction$1.run(GroovyScriptStepDesktopPanel.java:263)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTExtensionList
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)

_ivanovich_'s avatar
_ivanovich_
Frequent Contributor
11 years ago

TanyaYatskovska

Thank you Tanya,

i will check your link but i have some problems with Ready API with license,

when i create a project, if i rename the name of the project, later when i re-open Ready API the project name remain a Project.

And sometime, READY API is toyally stuck with a black screen then i lost everything, i lost the whole project.

So i have to copy_paste the project file manually every 15min.even i configure in the Preference.

 

I prefer groovy because i have control, i know what i'm doing, if i use new functionnalities of Ready API, i do not know what is happening.

And i observed some functionalities are working well in soapui 5 and not in Ready API

I will check the link you mentioned for data test driven

 

Is there some known bugs in Ready API?

Thank you