Getting NPE when trying to run gradlew load

I just started exploring moqui by trying to configure and run moqui Marble ERP locally with MySql(ver 9) setup.
This might be something really silly but somehow not able to crack the issue.

This is my configuration
(MoquiDefaultConf.xml):

<default-property name="entity_ds_db_conf" value="mysql"/>
<default-property name="entity_ds_host" value="localhost"/>
<default-property name="entity_ds_port" value="3306"/>
<default-property name="entity_ds_database" value="mysql8"/>
<default-property name="entity_ds_url" value="jdbc:${moqui_runtime}/lib/mysql-connector-j-9.0.0.jar;lock_timeout=30000"/>
<default-property name="entity_ds_schema" value=""/>
<default-property name="entity_ds_user" value="moqui"/>
<default-property name="entity_ds_password" value="l0tHLOrIen$" is-secret="true"/>
<default-property name="entity_ds_crypt_pass" value="changeMeToSomethingDifferentSep" is-secret="true"/>

MoquiDevConf.xml:

*<entity-facade query-stats="true">*
*        <!-- add datasource elements here to configure databases -->*
*        <datasource group-name="transactional" database-conf-name="mysql" schema-name="">*
*            <inline-jdbc><xa-properties user="moqui" password="l0tHLOrIen$" pinGlobalTxToPhysicalConnection="true"*
*                                        serverName="localhost" port="3306" databaseName="moqui" autoReconnectForPools="true"*
*                                        useUnicode="true" encoding="UTF-8"/></inline-jdbc>*
*        </datasource>*
*    </entity-facade>*

Exception stacktrace:

command used to run:
./gradlew load --debug

I am trying to run the app on MySql 9 DB, using driver mysql-connector-9.0.jar kept inside runtime/lib folder.
Java 17

Can someone please tell me what is missing or wrong done here?

1 Like

Your entity_ds_url needs to be the accessible mysql dabase url. Like localhost:3306 if it’s accessible on the localhost.

I would also start with java 11, because that’s the most tested version at the moment.

If that doesn’t work let me know

Thanks Michael for the pointers, after few hit and trails, the app started working.

1 Like

Great! Good to hear