gpt4 book ai didi

Unable to create Derby connection pool in Payara-6 server(无法在Payara-6服务器中创建Derby连接池)

翻译 作者:bug小助手 更新时间:2023-10-26 22:14:32 27 4
gpt4 key购买 nike



I am trying to create a Derby connection pool in Payara-6 server. I tried creating it twice: once with vendor "Derby" and once with "Derby-30" (not sure about the differences). These were the following values that I set:

我正在尝试在Payara-6服务器中创建一个Derby连接池。我尝试创建了两次:一次是使用供应商“Derby”,另一次是使用“Derby-30”(不确定有什么不同)。以下是我设置的值:


Resource Type: java.sql.Driver
Datasource Classname: <empty>
Driver classname: org.apache.derby.jdbc.ClientDriver

I have also set the URL, user, & password for the DB. But, when I try to ping the DB< I get the following error:
enter image description here

我还设置了数据库的URL、用户和密码。但是,当我尝试ping数据库时<我得到以下错误:


I do have the derby jars locally in my machine, but I do not believe that the same is available to the payara server. Please help in debugging the same.

我的机器上确实有本地的derby JAR,但我不相信Payara服务器也有同样的东西可用。请帮助调试相同的程序。


更多回答
优秀答案推荐

Payara doesn’t include Derby driver. You need to add Derby DB JARs into Payara, for example into the lib directory in the domain directory.

帕亚拉不包括德比车手。您需要将Derby DB JAR添加到Payara中,例如添加到域目录中的lib目录中。


If you did it, try setting the following parameters to the connection pool:

如果是这样做的,请尝试将以下参数设置为连接池:


Resource type: javax.sql.DataSource

资源类型:javax.sql.DataSource


Datasource classname: org.apache.derby.jdbc.ClientDataSource

Datasheet类名:org.apache.derby.jdbc.ClientDataSource


You can also try Eclipse GlassFish 7, which includes Derby DB, and even uses it for the default connection pool. You can copy the configuration from GlassFish to Payara, as long as you have the correct Derby JARs to Payara too.

您还可以尝试使用包含Derby DB的Eclipse GlassFish 7,甚至将其用作默认连接池。您可以将配置从GlassFish复制到Payara,只要您也将正确的Derby Jars复制到Payara即可。


更多回答

27 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com