Payara Web应用配置XML后部署报错：Invalid resource :datasource.mceAPPDb

Alright, let's break down the issues in your configuration that are causing this deployment error, and walk through how to fix them step by step:

1. Broken XML Structure in web.xml #

Looking at your web.xml, there’s an empty, incomplete <resource-ref> tag at the end:

<resource-ref>
 </resource-ref>

This invalid XML will confuse Payara’s parser, preventing it from correctly recognizing your valid resource reference. Delete this empty node entirely to fix the syntax. Your valid resource-ref section should look like this:

<resource-ref>
 <res-ref-name>datasource.mceAPPDb</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
 <res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

2. Missing Oracle JDBC Driver in Payara #

Your JDBC connection pool uses oracle.jdbc.pool.OracleDataSource, but Payara doesn’t include Oracle’s JDBC driver out of the box. Without this driver, Payara can’t initialize the connection pool, making the datasource.mceAPPDb resource unavailable:

• Download the correct ojdbc*.jar matching your Oracle database version
• Place it in the glassfish/domains/[your-domain-name]/lib directory of your Payara installation
• Restart the Payara server to load the driver

3. JDBC Resource Deployment Pitfalls #

Your glassfish-resource.xml defines the connection pool and JDBC resource, but there are two common issues here:

Option A: Deploying via Packaged glassfish-resource.xml #

If you’re relying on the WAR-packaged glassfish-resource.xml to create resources during deployment:

• Ensure the file is placed in the WEB-INF or META-INF directory of your WAR
• When deploying via the Payara GUI, check the "Create resources" option in deployment settings. This tells Payara to create the defined resources if they don’t already exist.

Option B: Manual Resource Setup (More Reliable) #

For consistent deployments, it’s better to create resources directly in Payara:

1. Log into the Payara Admin Console
2. Navigate to Resources > JDBC > JDBC Connection Pools
3. Create a new pool named app_emailverification, set resource type to javax.sql.DataSource, and datasource classname to oracle.jdbc.pool.OracleDataSource
4. Add the required properties:
   • URL: jdbc:oracle:thin:@localhost:1522:MCE0_D1
   • user: app_emailverification
   • password: app_emailverification
5. Test the connection pool to confirm it can reach your Oracle database
6. Go to Resources > JDBC > JDBC Resources, create a new resource with JNDI name datasource.mceAPPDb, and link it to the app_emailverification pool

4. Double-Check JNDI Name Consistency #

While JNDI names are often case-insensitive, verify that datasource.mceAPPDb is spelled exactly the same across all three files (web.xml, glassfish-resource.xml, persistence.xml). Your current config looks consistent here, but it’s a quick check to rule out typos.

Final Verification #

After fixing these issues, redeploy your WAR. The Invalid resource error should be resolved if:

• Your XML is valid
• The Oracle driver is in Payara’s classpath
• The JDBC connection pool and resource are properly configured and accessible

内容的提问来源于stack exchange，提问作者MiGo