Modifying MoquiDefaultConf.xml is not the correct way of configuring moqui
for mysql. You should be modifying the config file you are using to run moqui.
In your case, I think it is
D:\workspace\moqui\moqui\runtime\conf\MoquiProductionConf.xml. Add your
datasource configuration in this file and rerun it. I am not getting any error
with this configuration. I am reproducing the entity-facade definition that I
used in MoquiProductionConf.xml. Please note that I also setting(overriding)
schema-name="".
One more thing I observed is - there is no reference to mysql classes in your
stack trace. I am curious to know where in the classpath have you placed
mysql-connector-java-x.xxx.jar. Are you sure that mysql driver is being loaded
properly?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Caused by: java.lang.AbstractMethodError: com.mysql.jdbc.ResultSet.isClosed()Z
at java_sql_ResultSet$isClosed.call(Unknown Source)
which tells me that you are running a jvm which has different implementation
of jdbc than that of your driver. Try using later versions of mysql driver.
I have an installation of moqui on a windows machine. Mysql version is 5.1.57.
The driver version I used is mysql-connector-java-5.1.18-bin.jar and it works
for me. I see that you are using mysql-connector-java-5.0.5-bin.jar, which is
a tad old. See if you can use the same driver as I have.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi David!
modify moqui\framework\src\main\resources\MoquiDefaultConf.xml config file
<datasource group-name="transactional" database-conf-name="mysql"
check-pks-on-start="false">
<inline-jdbc jdbc-
uri="jdbc:mysql://127.0.0.1:3307/moquitransactional?autoReconnect=true"
jdbc-username="moqui" jdbc-password="moqui"
pool-minsize="2" pool-maxsize="50"/>
</datasource>
exec gradle build ok
exec gradle load error :
--- 6035 INFO org.moqui.impl.entity.EntityFacadeImpl
Found entity definitions in
--- 8181 WARN moqui.impl.context.TransactionFacadeImpl
java.lang.reflect.InvocationTargetException Transaction rollback. Here is the
cu
rrent location:
java.lang.Exception: Rollback Locations
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Method.invoke(Method.java:597)
at MoquiStart.main(MoquiStart.java:115)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
Caused by: java.lang.IllegalArgumentException: Error loading XML data file
at
org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.jav
a:77)
at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteN
oUnwrapNoCoerce.callConstructor(ConstructorSite.java:102)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstru
ctor(CallSiteArray.java:54)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:182)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:190)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.moqui.impl.context.TransactionFacadeImpl.rollback(TransactionFaca
deImpl.groovy:316)
at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstru
ctor.java:77)
at org.moqui.context.TransactionFacade$rollback$0.callCurrent(Unknown So
urce)
at org.codehaus.groovy.reflection.CachedConstructor.doConstructorInvoke(
CachedConstructor.java:71)
at
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSit
eArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteN
oUnwrap.callConstructor(ConstructorSite.java:81)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:145)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstru
ctor(CallSiteArray.java:54)
at org.moqui.impl.context.TransactionFacadeImpl.rollback(TransactionFaca
deImpl.groovy:302)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:182)
at org.moqui.context.TransactionFacade$rollback.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:194)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
Modifying MoquiDefaultConf.xml is not the correct way of configuring moqui
for mysql. You should be modifying the config file you are using to run moqui.
In your case, I think it is
D:\workspace\moqui\moqui\runtime\conf\MoquiProductionConf.xml. Add your
datasource configuration in this file and rerun it. I am not getting any error
with this configuration. I am reproducing the entity-facade definition that I
used in MoquiProductionConf.xml. Please note that I also setting(overriding)
schema-name="".
<entity-facade crypt-pass="MoquiProductionDefaultPassword:CHANGEME">
<datasource group-name="transactional" database-conf-name="mysql" schema-="" name="">
<inline-jdbc jdbc-uri="jdbc:mysql://127.0.0.1/dummy?autoReconnect=true"
jdbc-username="dummy" jdbc-password="dummy" pool-minsize="2"
pool-maxsize="50" />
</datasource>
</entity-facade>
One more thing I observed is - there is no reference to mysql classes in your
stack trace. I am curious to know where in the classpath have you placed
mysql-connector-java-x.xxx.jar. Are you sure that mysql driver is being loaded
properly?
thanks,
I only modifying
D:\workspace\moqui\moqui\runtime\conf\MoquiProductionConf.xml. content :
<moqui-conf xmlns:xsi="http://www.w3.org/2001/XMLSchema-
instance"
xsi:noNamespaceSchemaLocation="http://moqui.org/xsd/moqui-
conf-1.0.xsd">
<server-stats stats-skip-condition="ec.web!=null && ec.web.request.pathInfo == '/status'">
<artifact-stats type="screen" persist-bin="true" persist-hit="true"/>
<artifact-stats type="screen-content" persist-bin="true" persist-hit="true"/>
<artifact-stats type="transition" persist-bin="true" persist-hit="true"/>
<artifact-stats type="service" persist-bin="true" persist-hit="false"/>
<artifact-stats type="entity" persist-bin="false"/>
</server-stats>
<webapp-list>
<webapp name="webroot" https-enabled="false">
<root-screen host=".*" location="component://webroot/screen/webroot.xml"/>
</webapp>
</webapp-list>
<screen-facade boundary-comments="false"/>
<entity-facade crypt-pass="MoquiProductionDefaultPassword:CHANGEME">
<datasource group-name="transactional" database-conf-name="mysql" schema-="" name="">
<inline-jdbc jdbc-
uri="jdbc:mysql://127.0.0.1:3307/moquitransactional?autoReconnect=true"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2"
pool-maxsize="50" />
</datasource>
</entity-facade>
<repository-list>
<repository name="main" location="<a class=" "="" href="http://localhost:8081/server">http://localhost:8081/server" type="davex" workspace="production"/>
</repository-list>
</moqui-conf>
runtime dir structure:
├─component
│ ├─example
│ │ ├─data
│ │ │ ExampleL10nData.xml
│ │ │ ExampleSecurityData.xml
│ │ │ ExampleTenantData.xml
│ │ │ ExampleTypeData.xml
│ │ │
│ │ ├─entity
│ │ │ ExampleEntities.xml
│ │ │ ExampleViewEntities.xml
│ │ │
│ │ ├─screen
│ │ │ │ ExampleApp.xml
│ │ │ │ LookupExampleFeature.xml
│ │ │ │
│ │ │ └─ExampleApp
│ │ │ │ Example.xml
│ │ │ │ ExamplePolicies.html.ftl
│ │ │ │ ExampleTerms.html.gstring
│ │ │ │ ExampleWiki.cwiki.ftl
│ │ │ │ Feature.xml
│ │ │ │
│ │ │ ├─Example
│ │ │ │ EditExample.xml
│ │ │ │ EditExampleFeatureAppls.xml
│ │ │ │ EditExampleItems.xml
│ │ │ │ FindExample.xml
│ │ │ │
│ │ │ ├─ExampleWiki
│ │ │ │ SubPage1.cwiki
│ │ │ │ SubPage2.cwiki
│ │ │ │
│ │ │ └─Feature
│ │ │ EditExampleFeature.xml
│ │ │ EditExampleFeatureExampleAppls.xml
│ │ │ FindExampleFeature.xml
│ │ │
│ │ ├─script
│ │ │ └─org
│ │ │ └─moqui
│ │ │ └─example
│ │ │ testCreateExampleService.xml
│ │ │
│ │ └─service
│ │ │ Example.secas.xml
│ │ │
│ │ └─org
│ │ └─moqui
│ │ └─example
│ │ ExampleServices.xml
│ │
│ ├─tools
│ │ ├─data
│ │ │ ToolsSecurityData.xml
│ │ │
│ │ ├─entity
│ │ │ ToolTestEntities.xml
│ │ │
│ │ ├─screen
│ │ │ │ Tools.xml
│ │ │ │
│ │ │ └─Tools
│ │ │ │ AutoScreen.xml
│ │ │ │ DataView.xml
│ │ │ │ Entity.xml
│ │ │ │ Localization.xml
│ │ │ │ Service.xml
│ │ │ │ System.xml
│ │ │ │
│ │ │ ├─AutoScreen
│ │ │ │ │ AutoEdit.xml
│ │ │ │ │ AutoFind.xml
│ │ │ │ │ MainEntityList.xml
│ │ │ │ │
│ │ │ │ └─AutoEdit
│ │ │ │ AutoEditDetail.xml
│ │ │ │ AutoEditMaster.xml
│ │ │ │
│ │ │ ├─DataView
│ │ │ │ EditDbView.xml
│ │ │ │ FindDbView.xml
│ │ │ │ ViewDbView.xml
│ │ │ │
│ │ │ ├─Entity
│ │ │ │ │ DataEdit.xml
│ │ │ │ │ DataExport.xml
│ │ │ │ │ DataImport.xml
│ │ │ │ │ SpeedTest.xml
│ │ │ │ │
│ │ │ │ └─DataEdit
│ │ │ │ EntityDataEdit.xml
│ │ │ │ EntityDataFind.xml
│ │ │ │ EntityList.xml
│ │ │ │
│ │ │ ├─Localization
│ │ │ │ EntityFields.xml
│ │ │ │ Messages.xml
│ │ │ │
│ │ │ ├─Service
│ │ │ │ ServiceRun.xml
│ │ │ │
│ │ │ └─System
│ │ │ │ ArtifactHitBins.xml
│ │ │ │ ArtifactHitSummary.xml
│ │ │ │ AuditLog.xml
│ │ │ │ Cache.xml
│ │ │ │ Visit.xml
│ │ │ │
│ │ │ ├─Cache
│ │ │ │ CacheElements.xml
│ │ │ │ CacheList.xml
│ │ │ │
│ │ │ └─Visit
│ │ │ VisitDetail.xml
│ │ │ VisitList.xml
│ │ │
│ │ └─template
│ │ AutoScreenMenu.ftl
│ │
│ └─webroot
│ ├─data
│ │ WebrootThemeData.xml
│ │
│ └─screen
│ │ webroot.xml
│ │
│ ├─includes
│ │ Header.html.ftl
│ │ Header.xsl-fo.ftl
│ │
│ └─webroot
│ │ apps.xml
│ │ ChangePassword.xml
│ │ echopath.xml
│ │ ipad.ico
│ │ ipad.xml
│ │ Login.xml
│ │ moqui.ico
│ │ rpc.xml
│ │ status.xml
│ │
│ ├─css
│ │ │ default.css
│ │ │
│ │ └─smoothness
│ │ │ jquery-ui-1.8.14.custom.css
│ │ │
│ │ └─images
│ │ ui-bg_flat_0_aaaaaa_40x100.png
│ │ ui-bg_flat_75_ffffff_40x100.png
│ │ ui-bg_glass_55_fbf9ee_1x400.png
│ │ ui-bg_glass_65_ffffff_1x400.png
│ │ ui-bg_glass_75_dadada_1x400.png
│ │ ui-bg_glass_75_e6e6e6_1x400.png
│ │ ui-bg_glass_95_fef1ec_1x400.png
│ │ ui-bg_highlight-soft_75_cccccc_1x100.png
│ │ ui-icons_222222_256x240.png
│ │ ui-icons_2e83ff_256x240.png
│ │ ui-icons_454545_256x240.png
│ │ ui-icons_888888_256x240.png
│ │ ui-icons_cd0a0a_256x240.png
│ │
│ ├─images
│ │ wait_anim_16x16.gif
│ │
│ ├─ipad
│ │ │ Login.xml
│ │ │
│ │ └─css
│ │ ipad.css
│ │
│ └─js
│ jquery-1.5.1.min.js
│ jquery-ui-1.8.14.custom.min.js
│ jquery-ui-combobox.js
│ jquery-ui-timepicker-addon-0.9.3.min.js
│ jquery-validate-1.7-100644.js
│
├─conf
│ MoquiDevConf.xml
│ MoquiProductionConf.xml
│ MoquiStagingConf.xml
│ README
│
├─db
│ └─derby
├─lib
│ mysql-connector-java-5.0.5-bin.jar
│ README
│
├─log
│ 192.168.80.1.tm8.epoch
│ atomikos_console.out
│ atomikos_log.lck
│ atomikos_log8.log
│ error.log
│ moqui.log
│
└─template
└─screen-macro
ScreenHtmlMacros.ftl
TestScreenHtmlMacros.ftl
run gradle build ok,gradle load error :
Found entity definitions in
--- 4833 INFO org.moqui.impl.entity.EntityFacadeImpl
Found entity definitions in
--- 6200 WARN moqui.impl.context.TransactionFacadeImpl
Transaction rollback. Here is the current location:
java.lang.Exception: Rollback Locations
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstru
ctor.java:77)
at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteN
oUnwrapNoCoerce.callConstructor(ConstructorSite.java:102)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstru
ctor(CallSiteArray.java:54)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:182)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:190)
at org.moqui.impl.context.TransactionFacadeImpl.rollback(TransactionFaca
deImpl.groovy:316)
at org.moqui.context.TransactionFacade$rollback$0.callCurrent(Unknown So
urce)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:145)
at org.moqui.impl.context.TransactionFacadeImpl.rollback(TransactionFaca
deImpl.groovy:302)
at org.moqui.context.TransactionFacade$rollback.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:124)
at org.moqui.impl.entity.EntityDataLoaderImpl.loadSingleFile(EntityDataL
oaderImpl.groovy:182)
at org.moqui.impl.entity.EntityDataLoaderImpl$loadSingleFile.callCurrent
(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:145)
at org.moqui.impl.entity.EntityDataLoaderImpl.internalRun(EntityDataLoad
erImpl.groovy:149)
at org.moqui.impl.entity.EntityDataLoaderImpl$internalRun.callCurrent(Un
known Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityDataLoaderImpl.load(EntityDataLoaderImpl.
groovy:80)
at org.moqui.Moqui.loadData(Moqui.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at MoquiStart.main(MoquiStart.java:103)
--- 6206 WARN moqui.impl.context.TransactionFacadeImpl
Transaction rollback. The rollback was originally caused by: Error loading XML
text
org.moqui.entity.EntityException: Error in find
at org.moqui.impl.entity.EntityFindImpl.iteratorPlain(EntityFindImpl.gro
ovy:676)
at org.moqui.impl.entity.EntityFindImpl.list(EntityFindImpl.groovy:560)
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityF
acadeImpl.groovy:275)
at org.moqui.impl.entity.EntityFacadeImpl.loadEntityDefinition(EntityFac
adeImpl.groovy:350)
at org.moqui.impl.entity.EntityFacadeImpl.getEntityDefinition(EntityFaca
deImpl.groovy:596)
at org.moqui.impl.entity.EntityDataLoaderImpl$EntityXmlHanartElement(Ent
ityDataLoaderImpl.groovy:276)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startEle
ment(AbstractSAXParser.java:501)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.
emptyElement(AbstractXMLDocumentParser.java:179)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X
MLDocumentScannerImpl.java:648)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:807)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.
java:107)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Ab
stractSAXParser.java:1205)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p
arse(SAXParserImpl.java:522)
at org.moqui.impl.entity.EntityDataLoaderImpl.loadSingleFile(EntityDataL
oaderImpl.groovy:173)
at org.moqui.impl.entity.EntityDataLoaderImpl.internalRun(EntityDataLoad
erImpl.groovy:149)
at org.moqui.impl.entity.EntityDataLoaderImpl.load(EntityDataLoaderImpl.
groovy:80)
at org.moqui.Moqui.loadData(Moqui.java:92)
at MoquiStart.main(MoquiStart.java:103)
Caused by: java.lang.AbstractMethodError: com.mysql.jdbc.ResultSet.isClosed()Z
at java_sql_ResultSet$isClosed.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:112 )
at org.moqui.impl.entity.EntityDbMeta.tableExists(EntityDbMeta.groovy:99
)
at org.moqui.impl.entity.EntityDbMeta$tableExists.callCurrent(Unknown So
urce)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityDbMeta.internalCheckTable(EntityDbMeta.gr
oovy:66)
at org.moqui.impl.entity.EntityDbMeta$internalCheckTable.callCurrent(Unk
nown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityDbMeta.checkTableRuntime(EntityDbMeta.gro
ovy:50)
at org.moqui.impl.entity.EntityDbMeta$checkTableRuntime.call(Unknown Sou
rce)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:116)
at org.moqui.impl.entity.EntityFindImpl.iteratorPlain(EntityFindImpl.gro
ovy:669)
at org.moqui.impl.entity.EntityFindImpl.list(EntityFindImpl.groovy:560)
at org.moqui.entity.EntityFind$list.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:112)
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityF
acadeImpl.groovy:275)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl(NativeMethodAccessorImpl.java:39
)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMet
hodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:267)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(P
ogoMetaMethodSite.java:52)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:137)
at org.moqui.impl.entity.EntityFacadeImpl.loadEntityDefinition(EntityFac
adeImpl.groovy:350)
at org.moqui.impl.entity.EntityFacadeImpl.getEntityDefinition(EntityFaca
deImpl.groovy:596)
at org.moqui.impl.entity.EntityFacadeImpl$getEntityDefinition.call(Unkno
wn Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:116)
at org.moqui.impl.entity.EntityDataLoaderImpl$EntityXmlHandler.startElem
ent(EntityDataLoaderImpl.groovy:276)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startEle
ment(AbstractSAXParser.java:501)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.
emptyElement(AbstractXMLDocumentParser.java:179)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X
MLDocumentScannerImpl.java:648)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragnnerImpl.scanD
ocument(XMLDocumentFragmentScannerImpl.java:510)
java.lang.reflect.InvocationTargetException
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:807)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:737)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.
java:107)
at MoquiStart.main(MoquiStart.java:103)
Caused by: java.lang.IllegalArgumentException: Error loading XML data file
at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSA
XParser.java:1205)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p
arse(SAXParserImpl.java:522)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at org.xml.sax.XMLReader$parse.call(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstru
ctor.java:77)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.reflection.CachedConstructor.doConstructorInvoke(
CachedConstructor.java:71)
at
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.j
ava:116)
at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteN
oUnwrap.callConstructor(ConstructorSite.java:81)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstru
ctor(CallSiteArray.java:54)
at org.moqui.impl.entity.EntityDataLoaderImpl.loadSingleFile(EntityDataL
oaderImpl.groovy:173)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:182)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor
(AbstractCallSite.java:194)
at org.moqui.impl.entity.EntityDataLoaderImpl.loadSingleFile(EntityDataL
oaderImpl.groovy:183)
at
org.moqui.impl.entity.EntityDataLoaderImpl$loadSingleFile.callCurrent(Unknown
Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.moqui.impl.entity.EntityDataLoaderImpl$loadSingleFile.callCurrent
(Unknown Source)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:145)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:145)
at org.moqui.impl.entity.EntityDataLoaderImpl.internalRun(EntityDataLoad
erImpl.groovy:149)
at org.moqui.impl.entity.EntityDataLoaderImpl.internalRun(EntityDataLoad
erImpl.groovy:149)
at org.moqui.impl.entity.EntityDataLoaderImpl$internalRun.callCurrent(Un
known Source)
at org.moqui.impl.entity.EntityDataLoaderImpl$internalRun.callCurrent(Unknown
So
urce)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityDataLoaderImpl.load(EntityDataLoaderImpl.
groovy:80)
at org.moqui.Moqui.loadData(Moqui.java:92)
... 5 more
Caused by: org.moqui.entity.EntityException: Error in find
at org.moqui.impl.entity.EntityFindImpl.iteratorPlain(EntityFindImpl.gro
ovy:676)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.moqui.impl.entity.EntityFindImpl.list(EntityFindImpl.groovy:560)
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityF
acadeImpl.groovy:275)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityFacadeImpl.loadEntityDefinition(EntityFac
adeImpl.groovy:350)
at org.moqui.impl.entity.EntityFacadeImpl.getEntityDefinition(EntityFaca
deImpl.groovy:596)
at org.moqui.impl.entity.EntityDataLoaderImpl$EntityXmlHandler.startElem
ent(EntityDataLoaderImpl.groovy:276)
at org.moqui.impl.entity.EntityDataLoaderImpl.load(EntityDataLoaderImpl.
groovy:80)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startEle
ment(AbstractSAXParser.java:501)
at org.moqui.Moqui.loadData(Moqui.java:92)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.
emptyElement(AbstractXMLDocumentParser.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)
at sun at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentSc
annerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X
MLDocumentScannerImpl.java:648)
t.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:807)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.
java:107)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Ab
stractSAXParser.java:1205)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p
arse(SAXParserImpl.java:522)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.moqui.impl.entity.EntityDataLoaderImpl.loadSingleFile(EntityDataL
oaderImpl.groovy:173)
... 1 more
Error loading or running Moqui.loadData with args : java.lang.reflect.I
nvocationTargetException
at org.moqui.impl.entity.EntityDataLoaderImpl.internalRun(EntityDataLoad
erImpl.groovy:149)
at org.moqui.impl.entity.EntityDataLoaderImpl.load(EntityDataLoaderImpl.
groovy:80)
at org.moqui.Moqui.loadData(Moqui.java:92)
... 1 more
Caused by: java.lang.AbstractMethodError: com.mysql.jdbc.ResultSet.isClosed()Z
at java_sql_ResultSet$isClosed.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:112)
at org.moqui.impl.entity.EntityDbMeta.tableExists(EntityDbMeta.groovy:99
)
at org.moqui.impl.entity.EntityDbMeta$tableExists.callCurrent(Unknown So
urce)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityDbMeta.internalCheckTable(EntityDbMeta.gr
oovy:66)
at org.moqui.impl.entity.EntityDbMeta$internalCheckTable.callCurrent(Unk
nown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityDbMeta.checkTableRuntime(EntityDbMeta.gro
ovy:50)
at org.moqui.impl.entity.EntityDbMeta$checkTableRuntime.call(Unknown Sou
rce)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:116)
at org.moqui.impl.entity.EntityFindImpl.iteratorPlain(EntityFindImpl.gro
ovy:669)
at org.moqui.impl.entity.EntityFindImpl.list(EntityFindImpl.groovy:560)
at org.moqui.entity.EntityFind$list.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:112)
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityF
acadeImpl.groovy:275)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMet
hodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:267)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(P
ogoMetaMethodSite.java:52)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:137)
at org.moqui.impl.entity.EntityFacadeImpl.loadEntityDefinition(EntityFac
adeImpl.groovy:350)
at org.moqui.impl.entity.EntityFacadeImpl.getEntityDefinition(EntityFaca
deImpl.groovy:596)
at org.moqui.impl.entity.EntityFacadeImpl$getEntityDefinition.call(Unkno
wn Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:116)
at org.moqui.impl.entity.EntityDataLoaderImpl$EntityXmlHandler.startElem
ent(EntityDataLoaderImpl.groovy:276)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startEle
ment(AbstractSAXParser.java:501)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.
emptyElement(AbstractXMLDocumentParser.java:179)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X
MLDocumentScannerImpl.java:648)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:807)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.
java:107)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Ab
stractSAXParser.java:1205)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p
arse(SAXParserImpl.java:522)
at org.xml.sax.XMLReader$parse.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSi
teArray.java:42)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCa
llSite.java:116)
at org.moqui.impl.entity.EntityDataLoaderImpl.loadSingleFile(EntityDataL
oaderImpl.groovy:173)
at org.moqui.impl.entity.EntityDataLoaderImpl$loadSingleFile.callCurrent
(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:145)
at org.moqui.impl.entity.EntityDataLoaderImpl.internalRun(EntityDataLoad
erImpl.groovy:149)
at org.moqui.impl.entity.EntityDataLoaderImpl$internalRun.callCurrent(Un
known Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent
(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(Abs
tractCallSite.java:141)
at org.moqui.impl.entity.EntityDataLoaderImpl.load(EntityDataLoaderImpl.
groovy:80)
at org.moqui.Moqui.loadData(Moqui.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
... 1 more
The culprit is:
Caused by: java.lang.AbstractMethodError: com.mysql.jdbc.ResultSet.isClosed()Z
at java_sql_ResultSet$isClosed.call(Unknown Source)
which tells me that you are running a jvm which has different implementation
of jdbc than that of your driver. Try using later versions of mysql driver.
I have an installation of moqui on a windows machine. Mysql version is 5.1.57.
The driver version I used is mysql-connector-java-5.1.18-bin.jar and it works
for me. I see that you are using mysql-connector-java-5.0.5-bin.jar, which is
a tad old. See if you can use the same driver as I have.
thanks .
mysql-connector-java-5.0.5-bin.jar change mysql-connector-java-5.1.18-bin.jar
run gradle load ,success.
thanks again.
help ,moqui mysql chinese mojibake .