Eclipselink 3.0没有找到合适的JDBC（Jakarta EE）

Question

我正在尝试运行一个简单的Web应用程序，我希望在该应用程序上运行雅加达EE 9.1（完整平台）上的一些测试。我将应用程序部署在玻璃鱼6.2.5上。当我运行一些使用JPA实现的代码时，此例外是抛出的（持久性提供者是Eclipselink 3.0.2）：

jakarta.persistence.persistenceException：异常[eclipselink-4002] （Eclipse持久服务-3.0.2.v202107160933）： org.eclipse.persistence.exceptions.databaseexception内部 例外：java.sql.sqlexception：找不到合适的驱动程序 JDBC：mysql：// localhost：3306; create = true错误代码：0

persistence.xml是：

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<persistence xmlns="https://jakarta.ee/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="https://jakarta.ee/xml/ns/persistence https://jakarta.ee/xml/ns/persistence/persistence_3_0.xsd"
             version="3.0">
    <persistence-unit name="GestoreDB" transaction-type="RESOURCE_LOCAL">
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
        <class>testJPA.ValueBeen</class>
        <properties>
            <property name="jakarta.persistence.schema-generation.action" value="drop-and-create"/>
            <property name="jakarta.persistence.schema-generation.scripts.create-target" value="database-and-scripts"/>
            <property name="jakarta.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>
            <property name="jakarta.persistence.jdbc.url" value="jdbc:mysql://localhost:3306;create=true"/>
            <property name="jakarta.persistence.jdbc.user" value="root"/>
            <property name="jakarta.persistence.jdbc.password" value="myPwd"/>
        </properties>
    </persistence-unit>
</persistence>

实体是（省略getters and steters）：

@Entity
@NamedQuery(name = "ValueBeen.selectTable", query = "select u from ValueBeen u")
public class ValueBeen
{
    public ValueBeen(){
    }
    
    public ValueBeen(String value)
    {
        this.value = value;
    }
    
    public ValueBeen(int id, String value)
    {
        this.id = id;
        this.value = value;
    }
    
    @Id
    @GeneratedValue
    private int id;
    @NotNull
    private String value;
...
}

执行持久性的webServlet是：

@WebServlet(name = "helloServlet", value = "/hello-servlet")
public class HelloServlet extends HttpServlet
{
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException
    {
        
        ValueBeen valueBeen=new ValueBeen("Hello");
        
        
        //Manager persistence and manager been
        EntityManagerFactory managerPersistence = Persistence.createEntityManagerFactory("GestoreDB");
        EntityManager entityManager = managerPersistence.createEntityManager();
        
        //Do persistence
        EntityTransaction transaction = entityManager.getTransaction();
        transaction.begin();
        entityManager.persist(valueBeen);
        transaction.commit();
        
        //close managers
        entityManager.close();
        managerPersistence.close();
    }
}

我放置JDBC Connector jar（mysql Connector jar） 8.0.28）in。\ glassfish-6.2.5 \ glassfish \ domains \ domain1 \ lib

Answer 1

当您将应用程序部署到玻璃鱼容器中时，然后在permistence.xml中“交易型”时，我猜应该是“ jta”，属性“ jakarta.persistence.jdbc.url”无效，因为您没有表示任何数据库 /架构名称之后任何数据库名称“：3306”。 Glassfish文档提供了说明和示例如何设置全局JDBC连接，而仅限于应用程序范围的连接。