Hi,
Am get the following error message when upgrading from Dataverse 5.2 to 5.3:
remote failure: Error occurred during deployment: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.7.payara-p3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: FATAL: database "null" does not exist
Error Code: 0. Please see server.log for more details.
What I have done.
Update the database connection (domain.xml):
/usr/local/payara5/bin/asadmin create-system-properties "dataverse.db.user=xxxuser"
/usr/local/payara5/bin/asadmin create-system-properties "dataverse.db.host=localhost"
/usr/local/payara5/bin/asadmin create-system-properties "dataverse.db.port=5432"
echo "AS_ADMIN_ALIASPASSWORD=xxxpassword" > /tmp/password.txt
/usr/local/payara5/bin/asadmin create-password-alias --passwordfile /tmp/password.txt dataverse.db.password
rm -rf /tmp/password.txt
Replace from the GF4 version of domain.xml:
<jdbc-connection-pool datasource-classname="org.apache.derby.jdbc.EmbeddedXADataSource" name="__TimerPool" res-type="javax.sql.XADataSource">
<property name="databaseName" value="${com.sun.aas.instanceRoot}/lib/databases/ejbtimer"></property>
<property name="connectionAttributes" value=";create=true"></property>
</jdbc-connection-pool>
with P5 version of domain.xml:
<jdbc-connection-pool datasource-classname="org.h2.jdbcx.JdbcDataSource" name="__TimerPool" res-type="javax.sql.XADataSource">
<property name="URL" value="jdbc:h2:${com.sun.aas.instanceRoot}/lib/databases/ejbtimer;AUTO_SERVER=TRUE"></property>
</jdbc-connection-pool>
Copied postgresql-42.2.23.jar and postgresql-42.2.12.jar to /usr/local/payara5/glassfish/lib
The log file says:
...
[2021-08-24T02:29:21.323+0200] [Payara 5.2020.6] [INFO] [] [javax.enterprise.system.tools.deployment.common] [tid: _ThreadID=87 _ThreadName=admin-thread-pool::admin-listener(3)] [timeMillis: 1629764961323] [levelValue: 800] [[
visiting unvisited references]]
[2021-08-24T02:29:21.324+0200] [Payara 5.2020.6] [INFO] [] [javax.enterprise.system.tools.deployment.common] [tid: _ThreadID=87 _ThreadName=admin-thread-pool::admin-listener(3)] [timeMillis: 1629764961324] [levelValue: 800] [[
visiting unvisited references]]
...
I have tried to install dataverse 5.3 with Payara-5.2020.7 and Payara-5.2021.6 and no luck. What am I doing wrong here? I upgraded from 5.2 to 5.3 on our test server some weeks ago and everything went fine.
Cheers
Obi