使用Spring（非Spring Boot）连接数据库：Payara Server配置求助

Hey there, let's work through this together—since you switched from GlassFish to Payara for your Spring non-Boot database app and hit a hiccup setting up the server in NetBeans, I’ve got some targeted steps to help you out.

先排查NetBeans创建Payara服务器的常见坑 #

• 确认插件安装真的生效了
  Head over to 工具 > 插件 > 已安装 in NetBeans and double-check that the Payara Server Integration plugin is listed. If it’s missing, uninstall any partial installs, redownload the plugin, restart NetBeans, and try again. Sometimes plugins fail to register properly on the first go.

• 检查服务器路径与权限
  When you use the NetBeans GUI to add the Payara server, make sure you select the root folder of your unzipped Payara package (not bin or any subfolder). Also, avoid spaces, Chinese characters, or special symbols in the path—Java servers hate those.
  If you’re on Windows, run NetBeans as an administrator to avoid permission blocks. On Linux/macOS, fix folder permissions with:

  chmod -R 755 /your/path/to/payara
  

• 匹配版本兼容性
  Version mismatches are a super common culprit! NetBeans 19+ works best with Payara 6.x, while NetBeans 12–18 pairs with Payara 5.x. Double-check that your NetBeans and Payara versions play nice—this saves so much headache.

如果GUI创建失败，试试手动配置 #

If the NetBeans GUI keeps failing, skip it for now and set up Payara manually:

1. Start Payara by running payara/bin/asadmin start-domain from your terminal.
2. Open the Payara admin console at http://localhost:4848, log in with the default credentials (admin/admin).
3. Go to Resources > JDBC > Connection Pools, click New.
4. Pick your database driver (e.g., com.mysql.cj.jdbc.Driver for MySQL), fill in the pool name, database URL, username, and password.
5. Click Ping to test the connection—if it succeeds, save the pool.
6. Go back to NetBeans, add an existing server, and point it to your running Payara instance.

连接Spring非Boot项目到Payara连接池 #

Once your pool is set up, you don’t need to write raw JDBC code in your Spring app. Use JNDI to grab the datasource:

import javax.naming.InitialContext;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;

public class DatabaseService {
    private JdbcTemplate jdbcTemplate;

    public DatabaseService() {
        try {
            InitialContext ctx = new InitialContext();
            // Replace "jdbc/YourPoolName" with the JNDI name you set in Payara
            DataSource dataSource = (DataSource) ctx.lookup("jdbc/YourPoolName");
            jdbcTemplate = new JdbcTemplate(dataSource);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    // Use jdbcTemplate for all your database operations from here
}

If you’re hitting a specific error (like a popup saying NetBeans can’t find the server, or a startup failure log), share the exact error message and I can help you narrow it down further.

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