Copy the definition of a JDBC connection pool when installing a new version of Payara Server

Technical Discussion
2

Hey, you can do it via a script.

You create a textfile and then you can put commands in it like:

create-jdbc-connection-pool --datasourceclassname driversourceName --restype javax.sql.ConnectionPoolDataSource --property driverType=4:password=my_passwd:databaseName=MYDATABASE:serverName=MYSERVER:user=myuser:portNumber=42 MyConnectionPool

create-jdbc-resource --connectionpoolid MyConnectionPool --property fullyMaterializeLobData=true:fullyMaterializeInputStreams=true:progressiveStreaming=2:progressiveLocators=2 jdbc/MyConnection

Those options like progressiveStreaming are optional.

Then you create a textfile with the admin password. The content should be:
AS_ADMIN_PASSWORD=myadminpassword

And then you start the script with:
./asadmin --user admin --passwordfile passwordfile.txt multimode --file create_domain.txt

Cheers