java - how to deploy a webapp and create its resources

Question

before deploy "myapp.war" on glassfish 4 i have to

1. create jdbc connection pool (/WEB-INF/glassfish-resources.xml -> jdbc-connection-pool does not work by itself... fine from asadmin)
2. create jdbc resource for pool (/WEB-INF/glassfish-resources.xml -> jdbc-resource same as above)
3. create auth-realm (nothing auto, using asadmin for now)
4. create schema (peristence.xml -> property javax.persistence.schema-generation.create-database-schemas, but is bogus)
5. create tables (persistence.xml -> `create-tables', not perfect but at least it works)

now i'm doing:

1. upload "myapp.war", "glassfish-resources.xml" on /tmp/install
2. asadmin add-resources ...
3. asadmin create-auth-realm ...
4. asadmin deploy ...
5. asadmin disable myapp ...
6. nano /.../glassfish/applications/myapp/WEB-INF/classes/META-INF/persistence.xml
7. comment a few lines, ctrl+o, enter, ctrl+x, enter
8. asadmin enable myapp ...
9. rm -Rf /tmp/install

and without other suggestion i'm planning to:

1. upload "myapp.war", "deploy.sh" on /tmp/install
2. chmod +x deploy.sh
3. ./deploy.sh

and the script will take care of everything. but i'd like to upload only a war file via glassfish http console and obtain the same result.

is there a way to have a class or script called before contextInitialized?

how would you deploy this thing?

---

for completeness here are some additional info:

/myapp/WEB-INF/classes/META-INF/persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
    <persistence-unit name="myapp" transaction-type="JTA">
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
        <jta-data-source>jdbc/myapp</jta-data-source>
        <exclude-unlisted-classes>false</exclude-unlisted-classes>
        <shared-cache-mode>NONE</shared-cache-mode>
        <properties>
            <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
            <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/myapp"/>
            <property name="javax.persistence.jdbc.user" value="root"/>
            <property name="javax.persistence.jdbc.password" value="password"/>
            <property name="javax.persistence.schema-generation.database.action" value="create"/>
            <property name="javax.persistence.schema-generation.create-database-schemas" value="false"/>
            <property name="javax.persistence.schema-generation.scripts.action" value="drop-and-create"/>
            <property name="javax.persistence.schema-generation.scripts.create-target" value="C:/tmp/myapp_create.ddl"/>
            <property name="javax.persistence.schema-generation.scripts.drop-target" value="C:/tmp/myapp_drop.ddl"/>
            <property name="eclipselink.deploy-on-startup" value="true"/>
            <property name="eclipselink.target-database" value="MySQL"/>
<!--            <property name="eclipselink.ddl-generation" value="create-tables"/> -->
<!--            <property name="eclipselink.ddl-generation.output-mode" value="database"/> -->
<!--            <property name="eclipselink.create-ddl-jdbc-file-name" value="myapp.ddl"/> -->
<!--            <property name="eclipselink.logging.level" value="FINE" /> -->
<!--            <property name="eclipselink.logging.level.sql" value="FINE"/> -->
<!--            <property name="eclipselink.logging.parameters" value="true"/> -->
<!--            <property name="eclipselink.logging.logger" value="org.eclipse.persistence.logging.DefaultSessionLog"/> -->
        </properties>
    </persistence-unit>
</persistence>

/myapp/WEB-INF/glassfish-resources.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE resources PUBLIC "-//GlassFish.org//DTD GlassFish Application Server 3.1 Resource Definitions//EN" "http://glassfish.org/dtds/glassfish-resources_1_5.dtd">
<resources>
    <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="jdbc/myapp_pool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
        <property name="serverName" value="localhost"/>
        <property name="portNumber" value="3306"/>
        <property name="databaseName" value="myapp"/>
        <property name="User" value="root"/>
        <property name="Password" value="password"/>
        <property name="URL" value="jdbc:mysql://localhost:3306/myapp"/>
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
    </jdbc-connection-pool>
    <jdbc-resource enabled="true" jndi-name="jdbc/myapp" object-type="user" pool-name="jdbc/myapp_pool"/>
</resources>

while glassfish understands /myapp/.../persistence.xml (sometimes executing also CREATE SCHEMA myapp, sometimes not, apparently random - but it's fine),

i definitely can't make glassfish read /myapp/WEB-INF/glassfish-resources.xml. it ignores this file.

UPDATE glassfish reads the file but prefixes jndi names with java:app/ breaking other references. being aware of this thing i rewrite references with prefix and now it is working fine. lastly, i noted that if glassfish-resources.xml is inside META-INF (instead of WEB-INF) glassfish reads the file and it is also present in http ui under "applications > myapp > descriptors"

Answer 1

finally i found a solution:

1. database create/upgrade: in ServletContextListener.contextInitialized i use compile-time-generated ddl script to create database if not exists, or use liquibase to upgrade database if exists. no more persistence.xml usage for database generation.

2. authentication realm deploy: i don't deploy or create any container-specific realm. in ServletContextListener.contextInitialized i register a custom JASPIC implementation, which is itself a JAAS login module wrapper. thanks to @ArjanTijms for this aricle and this answer