DBCP连不上数据库，报错java.lang.NullPointerException

最新推荐文章于 2022-08-26 22:17:05 发布
原创 最新推荐文章于 2022-08-26 22:17:05 发布 · 1.7k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java

本文详细讲述了在使用Druid连接池时遇到的空指针异常，并提供了解决步骤，包括检查数据库版本、驱动配置和修正后的连接成功案例。特别关注了mysql-connector-java版本与数据库版本的匹配和驱动选择的重要性。

使用druid连接池报错：java.lang.NullPointerException com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1105) - 遍唱阳春 - 博客园

使用DBCP无法连接数据库

1.检查数据库版本

在mysql中执行SELECT VERSION()

mysql-connector-java版本需与mysql版本一致

2.检查配置文件

com.mysql.jdbc.Driver 是 mysql-connector-java 5及5之前的，

com.mysql.cj.jdbc.Driver 是 mysql-connector-java 6及6之后的的。

在配置文件内需正确对应

3.修改后能够正常连接

java中连接数据库出现NullPointerException
Shifu_w的博客
04-06 2823
javaWeb避坑之连接数据库NullPointerException 初次学习javaweb，利用的是idea2020.3版本 错误描述： java.lang.NullPointerException at java.util.Properties$LineReader.readLine(Properties.java:434) at java.util.Properties.load0(Properties.java:353) at java.util.Properties.load(Proper
mysql jdbc charset_MySQL数据库之mysql 8.0 Druid连接时调用getServerCharset报空指针异常解决方法...
weixin_34266692的博客
01-21 739
本文主要向大家介绍了MySQL数据库之mysql 8.0 Druid连接时调用getServerCharset报空指针异常解决方法 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。类似错误信息如下：16:52:01.163[Druid-ConnectionPool-Create-1641320886]ERRORcom.alibaba.druid.pool.DruidDat...
java中数据库连接得到NULL,MySQLNonTransientConnectionException无法创建与数据库服务器的连接.造成原因:java.lang.NullPointerExcept...
weixin_31004409的博客
02-25 580
I have a local MySQL Community server (8.0.11) running on a local host at 127.0.0.1:3306.(I created a database and registered a user for it). I can use the following terminal query to access the datab...
关于dbcp数据库连接池相关报错原因
c_xiaomaotou的博客
03-28 1414
1. 连接超时错误 系统启动一段时间后，突然报出来的错误； 启动报错 原因： 1.有可能是mysql数据库默认的关闭8小时无活动连接，而dbcp连接池不知道，调用关闭的链接导致报错 解决办法：连接池增加(validationQuery=select 1;testOnBorrow=true) 2.启动时报错，一般是不能访问远程数据库，或账号密码错误；还用一种情况，能够通过工具连接，...
MySQL数据库连接时报错Exception in thread “main“ java.lang.NullPointerException
yan的秘密基地
01-03 2794
在用java连接数据库时候报错了： Exception in thread “main” java.lang.NullPointerException 我在网上看到也有不少人遇到这个问题，但是试遍了网上的解决方法，对我都不管用，记录一下我最终解决的办法，给大家一个参考 一、Exception in thread “main” java.lang.NullPointerException 这个报错表面的意思就是有空指针嘛，我看有一位老兄就的确是因为定义的数组没有new，然后他new一下就解决了，但是我的.
Could not create connection to database server getServerCharset NullPointerException
gitcat的博客
04-09 717
今天在开发时遇到如下一个错误，原因是数据库版本问题。mysql数据库驱动用的是5.1.34，本来一直连的线上数据库也是mysql5，这样是没问题。今天想连一下本地数据库做一些测试，由于我本地数据库安装的是mysql8，所以启动的时候报了如下错误，把本地数据库也安装为mysql5就可以了。 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database
jdbcTemplateM.queryForList(sql)，报错Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause。java.lang.NullPointerException: nul
03-29
数据库中的列名与 Java 实体类属性不匹配也可能导致此问题。特别是当数据库中某列为 NULL 值且未指定默认值（如 Double 类型），则会触发空指针异常[^2]。 4. **方法参数传递不当** 若传入的方法参数有误（比如 ...
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "conn" is null org.apache.jsp.loginProcess_jsp._jspService(loginProcess_jsp.java:161) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67) jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:456) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:377) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:325) jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
05-04
好的，我现在需要帮助用户解决Java中由于数据库连接conn为null导致的NullPointerException问题。首先，我得回顾用户提供的引用内容，看看有没有相关的线索。 用户提到的引用[3]提到在Servlet中使用数据库连接类时...
[root@yfw ~]# cd /etc/systemd/system [root@yfw system]# su -s /bin/sh -c " > export OPENFIRE_HOME='$OPENFIRE_HOME'; > export JAVA_HOME='$JAVA_HOME'; > export PATH='$JAVA_HOME/bin:\$PATH'; > cd '$OPENFIRE_HOME'; > > echo 'DEBUG: User = $(whoami)'; > echo 'DEBUG: Current dir = $(pwd)'; > echo 'DEBUG: OPENFIRE_HOME = \$OPENFIRE_HOME'; > echo 'DEBUG: Java executable = $(which java)'; > '\$JAVA' -version; > > echo 'DEBUG: Launching with explicit -DopenfireHome...'; > exec '\$JAVA' \ > -server \ > -Xms64m \ > -Xmx512m \ > -DopenfireHome='\$OPENFIRE_HOME' \ > -Dopenfire.lib.dir='\$OPENFIRE_HOME/lib' \ > -Dlog4j.configurationFile='file://\$OPENFIRE_HOME/lib/log4j2.xml' \ > -classpath '\$CP' \ > org.jivesoftware.openfire.starter.ServerStarter > " openfire >> "$LOG_FILE" 2>&1 & [1] 1101325 [root@yfw system]# -bash: : No such file or directory [1]+ Exit 1 su -s /bin/sh -c " export OPENFIRE_HOME='$OPENFIRE_HOME'; export JAVA_HOME='$JAVA_HOME'; export PATH='$JAVA_HOME/bin:\$PATH'; cd '$OPENFIRE_HOME'; echo 'DEBUG: User = $(whoami)'; echo 'DEBUG: Current dir = $(pwd)'; echo 'DEBUG: OPENFIRE_HOME = \$OPENFIRE_HOME'; echo 'DEBUG: Java executable = $(which java)'; '\$JAVA' -version; echo 'DEBUG: Launching with explicit -DopenfireHome...'; exec '\$JAVA' -server -Xms64m -Xmx512m -DopenfireHome='\$OPENFIRE_HOME' -Dopenfire.lib.dir='\$OPENFIRE_HOME/lib' -Dlog4j.configurationFile='file://\$OPENFIRE_HOME/lib/log4j2.xml' -classpath '\$CP' org.jivesoftware.openfire.starter.ServerStarter " openfire >> "$LOG_FILE" 2>&1 [root@yfw system]# cat > /tmp/CheckHome.java << 'EOF' > public class CheckHome { > public static void main(String[] args) { > String home = System.getProperty("openfireHome"); > if (home == null || home.trim().isEmpty()) { > System.err.println("❌ FAIL: -DopenfireHome is NOT set!"); > System.exit(1); > } else { > System.out.println("✅ SUCCESS: -DopenfireHome = " + home); > System.out.println("👉 File exists: " + new java.io.File(home).exists()); > System.out.println("👉 Is Directory: " + new java.io.File(home).isDirectory()); > System.out.println("👉 Can Read: " + new java.io.File(home).canRead()); > System.out.println("👉 Can Write: " + new java.io.File(home).canWrite()); > } > } > } > EOF [root@yfw system]# javac /tmp/CheckHome.java [root@yfw system]# sudo -u openfire java -cp /tmp -DopenfireHome=/opt/openfire CheckHome ✅ SUCCESS: -DopenfireHome = /opt/openfire 👉 File exists: true 👉 Is Directory: true 👉 Can Read: true 👉 Can Write: true [root@yfw system]# sudo mkdir -p /opt/openfire/conf [root@yfw system]# sudo chown openfire:openfire /opt/openfire/conf [root@yfw system]# sudo chmod 755 /opt/openfire/conf [root@yfw system]# sudo -u openfire touch /opt/openfire/conf/test && echo OK || echo FAIL OK [root@yfw system]# sudo -u openfire rm /opt/openfire/conf/test [root@yfw system]# sudo cat > /opt/openfire/bin/start.sh << 'EOF' > #!/bin/bash > > export OPENFIRE_HOME="/opt/openfire" > export JAVA_HOME="/usr/lib/jvm/java-17-openjdk" > export JAVA="$JAVA_HOME/bin/java" > export LOG_FILE="$OPENFIRE_HOME/logs/nohup.out" > > # 构建 classpath > CP="" > for jar in "$OPENFIRE_HOME/lib"/*.jar; do > if [ -f "$jar" ]; then > CP="$CP:$jar" > fi > done > CP="${CP#:}" > > cd "$OPENFIRE_HOME" || { echo "Cannot access $OPENFIRE_HOME"; exit 1; } > > > "$LOG_FILE" > > echo "Using Java: $JAVA" > echo "Java Version:" > "$JAVA" -version 2>&1 | sed 's/^/ /' > > echo "Classpath: $CP" > echo "Starting OpenFire..." > > su -s /bin/sh -c " > export OPENFIRE_HOME='$OPENFIRE_HOME'; > export JAVA_HOME='$JAVA_HOME'; > export PATH='$JAVA_HOME/bin:\$PATH'; > cd '\$OPENFIRE_HOME'; > > echo 'DEBUG: User = \$(whoami)'; > echo 'DEBUG: Current dir = \$(pwd)'; > echo 'DEBUG: OPENFIRE_HOME = \$OPENFIRE_HOME'; > echo 'DEBUG: Testing -DopenfireHome visibility...'; > '\$JAVA' -cp '/tmp' -DopenfireHome='\$OPENFIRE_HOME' CheckHome; > > echo 'Starting OpenFire正式启动...'; > exec '\$JAVA' \ > -server \ > -Xms64m \ > -Xmx512m \ > -DopenfireHome='\$OPENFIRE_HOME' \ > -Dopenfire.lib.dir='\$OPENFIRE_HOME/lib' \ > -Dopenfire.config.file='\$OPENFIRE_HOME/conf/openfire.xml' \ > -Dlog4j.configurationFile='file://\$OPENFIRE_HOME/lib/log4j2.xml' \ > -classpath '\$CP' \ > org.jivesoftware.openfire.starter.ServerStarter > " openfire >> "$LOG_FILE" 2>&1 & > > echo $! > "$OPENFIRE_HOME/logs/openfire.pid" > echo "OpenFire started (PID $!)" > echo "Check logs: tail -f $LOG_FILE" > EOF [root@yfw system]# sudo -u openfire tee /opt/openfire/conf/openfire.xml > /dev/null << 'EOF' > <?xml version="1.0" encoding="UTF-8"?> > <jive> > <adminConsole> > <port>9090</port> > <securePort>9091</securePort> > </adminConsole> > <locale>en</locale> > <setup>true</setup> > </jive> > EOF [root@yfw system]# # 给 start.sh 添加可执行权限 [root@yfw system]# sudo chmod +x /opt/openfire/bin/start.sh [root@yfw system]# [root@yfw system]# # 启动服务 [root@yfw system]# /opt/openfire/bin/start.sh Using Java: /usr/lib/jvm/java-17-openjdk/bin/java Java Version: openjdk version "17.0.1" 2021-10-19 LTS OpenJDK Runtime Environment 21.9 (build 17.0.1+12-LTS) OpenJDK 64-Bit Server VM 21.9 (build 17.0.1+12-LTS, mixed mode, sharing) Classpath: /opt/openfire/lib/activation-1.1.jar:/opt/openfire/lib/apache-el-9.0.107.jar:/opt/openfire/lib/apache-jsp-9.0.107.jar:/opt/openfire/lib/asm-9.8.jar:/opt/openfire/lib/asm-commons-9.8.jar:/opt/openfire/lib/asm-tree-9.8.jar:/opt/openfire/lib/bcpg-jdk18on-1.78.1.jar:/opt/openfire/lib/bcpkix-jdk18on-1.78.1.jar:/opt/openfire/lib/bcprov-jdk18on-1.78.1.jar:/opt/openfire/lib/bcutil-jdk18on-1.78.1.jar:/opt/openfire/lib/caffeine-3.2.0.jar:/opt/openfire/lib/checker-qual-3.33.0.jar:/opt/openfire/lib/common-image-3.9.4.jar:/opt/openfire/lib/common-io-3.9.4.jar:/opt/openfire/lib/common-lang-3.9.4.jar:/opt/openfire/lib/commons-codec-1.15.jar:/opt/openfire/lib/commons-dbcp2-2.9.0.jar:/opt/openfire/lib/commons-ip-math-1.32.jar:/opt/openfire/lib/commons-lang3-3.18.0.jar:/opt/openfire/lib/commons-logging-1.2.jar:/opt/openfire/lib/commons-pool2-2.9.0.jar:/opt/openfire/lib/commons-text-1.10.0.jar:/opt/openfire/lib/dom4j-2.1.4.jar:/opt/openfire/lib/dwr-3.0.2-RELEASE.jar:/opt/openfire/lib/ecj-3.33.0.jar:/opt/openfire/lib/error_prone_annotations-2.18.0.jar:/opt/openfire/lib/failureaccess-1.0.1.jar:/opt/openfire/lib/guava-32.0.1-jre.jar:/opt/openfire/lib/hsqldb-2.7.1.jar:/opt/openfire/lib/httpclient-4.5.13.jar:/opt/openfire/lib/httpcore-4.4.13.jar:/opt/openfire/lib/i18n-5.0.2.jar:/opt/openfire/lib/imageio-bmp-3.9.4.jar:/opt/openfire/lib/imageio-core-3.9.4.jar:/opt/openfire/lib/istack-commons-runtime-3.0.11.jar:/opt/openfire/lib/j2objc-annotations-2.8.jar:/opt/openfire/lib/jakarta.activation-1.2.2.jar:/opt/openfire/lib/jakarta.annotation-api-1.3.5.jar:/opt/openfire/lib/jakarta.transaction-api-1.3.3.jar:/opt/openfire/lib/jakarta.xml.bind-api-2.3.3.jar:/opt/openfire/lib/jansi-1.18.jar:/opt/openfire/lib/javax.activation-api-1.2.0.jar:/opt/openfire/lib/javax.mail-1.6.2.jar:/opt/openfire/lib/jaxb-api-2.3.1.jar:/opt/openfire/lib/jaxb-runtime-2.3.3.jar:/opt/openfire/lib/jaxen-1.2.0.jar:/opt/openfire/lib/jcip-annotations-1.0.jar:/opt/openfire/lib/jcl-over-slf4j-2.0.9.jar:/opt/openfire/lib/jetty-ee-12.0.24.jar:/opt/openfire/lib/jetty-ee8-annotations-12.0.24.jar:/opt/openfire/lib/jetty-ee8-apache-jsp-12.0.24.jar:/opt/openfire/lib/jetty-ee8-nested-12.0.24.jar:/opt/openfire/lib/jetty-ee8-plus-12.0.24.jar:/opt/openfire/lib/jetty-ee8-security-12.0.24.jar:/opt/openfire/lib/jetty-ee8-servlet-12.0.24.jar:/opt/openfire/lib/jetty-ee8-webapp-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-jetty-api-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-jetty-common-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-jetty-server-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-servlet-12.0.24.jar:/opt/openfire/lib/jetty-http-12.0.24.jar:/opt/openfire/lib/jetty-io-12.0.24.jar:/opt/openfire/lib/jetty-jmx-12.0.24.jar:/opt/openfire/lib/jetty-jndi-12.0.24.jar:/opt/openfire/lib/jetty-plus-12.0.24.jar:/opt/openfire/lib/jetty-security-12.0.24.jar:/opt/openfire/lib/jetty-server-12.0.24.jar:/opt/openfire/lib/jetty-servlet-api-4.0.6.jar:/opt/openfire/lib/jetty-session-12.0.24.jar:/opt/openfire/lib/jetty-util-12.0.24.jar:/opt/openfire/lib/jetty-websocket-core-common-12.0.24.jar:/opt/openfire/lib/jetty-websocket-core-server-12.0.24.jar:/opt/openfire/lib/jetty-xml-12.0.24.jar:/opt/openfire/lib/jmdns-1.0.jar:/opt/openfire/lib/jsmpp-2.3.10.jar:/opt/openfire/lib/json-20231013.jar:/opt/openfire/lib/jspecify-1.0.0.jar:/opt/openfire/lib/jsr305-3.0.2.jar:/opt/openfire/lib/jtds-1.3.1.jar:/opt/openfire/lib/jzlib-1.1.3.jar:/opt/openfire/lib/libidn-1.35.jar:/opt/openfire/lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar:/opt/openfire/lib/log4j-api-2.20.0.jar:/opt/openfire/lib/log4j-core-2.20.0.jar:/opt/openfire/lib/log4j-slf4j2-impl-2.20.0.jar:/opt/openfire/lib/mssql-jdbc-9.4.1.jre11.jar:/opt/openfire/lib/mysql-connector-j-8.2.0.jar:/opt/openfire/lib/netty-all-4.1.118.Final.jar:/opt/openfire/lib/netty-buffer-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-dns-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-haproxy-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-http2-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-http-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-memcache-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-mqtt-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-redis-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-smtp-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-socks-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-stomp-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-xml-4.1.118.Final.jar:/opt/openfire/lib/netty-common-4.1.118.Final.jar:/opt/openfire/lib/netty-handler-4.1.118.Final.jar:/opt/openfire/lib/netty-handler-proxy-4.1.118.Final.jar:/opt/openfire/lib/netty-handler-ssl-ocsp-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-dns-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-dns-classes-macos-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-dns-native-macos-4.1.118.Final-osx-aarch_64.jar:/opt/openfire/lib/netty-resolver-dns-native-macos-4.1.118.Final-osx-x86_64.jar:/opt/openfire/lib/netty-transport-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-classes-epoll-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-classes-kqueue-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-native-epoll-4.1.118.Final-linux-aarch_64.jar:/opt/openfire/lib/netty-transport-native-epoll-4.1.118.Final-linux-riscv64.jar:/opt/openfire/lib/netty-transport-native-epoll-4.1.118.Final-linux-x86_64.jar:/opt/openfire/lib/netty-transport-native-kqueue-4.1.118.Final-osx-aarch_64.jar:/opt/openfire/lib/netty-transport-native-kqueue-4.1.118.Final-osx-x86_64.jar:/opt/openfire/lib/netty-transport-native-unix-common-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-rxtx-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-sctp-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-udt-4.1.118.Final.jar:/opt/openfire/lib/ojdbc11-23.7.0.25.01.jar:/opt/openfire/lib/ons-23.7.0.25.01.jar:/opt/openfire/lib/oraclepki-23.7.0.25.01.jar:/opt/openfire/lib/orai18n-23.7.0.25.01.jar:/opt/openfire/lib/postgresql-42.7.7.jar:/opt/openfire/lib/rsi-23.7.0.25.01.jar:/opt/openfire/lib/shaj-0.5.jar:/opt/openfire/lib/simplefan-23.7.0.25.01.jar:/opt/openfire/lib/sitemesh-2.5.0.jar:/opt/openfire/lib/slf4j-api-2.0.9.jar:/opt/openfire/lib/startup.jar:/opt/openfire/lib/taglibs-standard-impl-1.2.5.jar:/opt/openfire/lib/taglibs-standard-spec-1.2.5.jar:/opt/openfire/lib/tinder-2.1.0.jar:/opt/openfire/lib/txw2-2.3.3.jar:/opt/openfire/lib/ucp-23.7.0.25.01.jar:/opt/openfire/lib/xdb-23.7.0.25.01.jar:/opt/openfire/lib/xmppserver-5.0.2.jar:/opt/openfire/lib/xpp3-1.1.4c.0.jar Starting OpenFire... OpenFire started (PID 1102358) Check logs: tail -f /opt/openfire/logs/nohup.out [root@yfw system]# tail -f /opt/openfire/logs/nohup.out sh: line 4: cd: $OPENFIRE_HOME: No such file or directory DEBUG: User = $(whoami) DEBUG: Current dir = $(pwd) DEBUG: OPENFIRE_HOME = $OPENFIRE_HOME DEBUG: Testing -DopenfireHome visibility... sh: line 10: $JAVA: command not found Starting OpenFire正式启动... sh: line 13: exec: $JAVA: not found ^C [root@yfw system]# sudo cat > /opt/openfire/bin/start.sh << 'EOF' > #!/bin/bash > > export OPENFIRE_HOME="/opt/openfire" > export JAVA_HOME="/usr/lib/jvm/java-17-openjdk" > export JAVA="$JAVA_HOME/bin/java" > export LOG_FILE="$OPENFIRE_HOME/logs/nohup.out" > > # 构建 classpath > CP="" > for jar in "$OPENFIRE_HOME/lib"/*.jar; do > if [ -f "$jar" ]; then > CP="$CP:$jar" > fi > done > CP="${CP#:}" > > cd "$OPENFIRE_HOME" || { echo "Cannot access $OPENFIRE_HOME"; exit 1; } > > > "$LOG_FILE" > > echo "Using Java: $JAVA" > echo "Java Version:" > "$JAVA" -version 2>&1 | sed 's/^/ /' > > echo "Classpath: $CP" > echo "Starting OpenFire..." > > # 注意：这里我们用的是双引号拼接命令字符串，使得 $JAVA 等能在父 shell 展开 > su -s /bin/sh -c " > export OPENFIRE_HOME=$OPENFIRE_HOME; > export JAVA_HOME=$JAVA_HOME; > export PATH=\$JAVA_HOME/bin:\$PATH; > cd \$OPENFIRE_HOME; > > echo 'DEBUG: User = \$(whoami)'; > echo 'DEBUG: Current dir = \$(pwd)'; > echo 'DEBUG: OPENFIRE_HOME = \$OPENFIRE_HOME'; > echo 'DEBUG: Java executable = \$(which java)'; > \$JAVA -version; > > echo 'DEBUG: Launching OpenFire...'; > exec \$JAVA \ > -server \ > -Xms64m \ > -Xmx512m \ > -DopenfireHome=\$OPENFIRE_HOME \ > -Dopenfire.lib.dir=\$OPENFIRE_HOME/lib \ > -Dlog4j.configurationFile=file://\$OPENFIRE_HOME/lib/log4j2.xml \ > -classpath \"\$CLASSPATH\" \ > org.jivesoftware.openfire.starter.ServerStarter > " openfire >> "$LOG_FILE" 2>&1 & > > echo $! > "$OPENFIRE_HOME/logs/openfire.pid" > echo "OpenFire started (PID $!)" > echo "Check logs: tail -f $LOG_FILE" > EOF [root@yfw system]# sudo chmod +x /opt/openfire/bin/start.sh [root@yfw system]# /opt/openfire/bin/start.sh Using Java: /usr/lib/jvm/java-17-openjdk/bin/java Java Version: openjdk version "17.0.1" 2021-10-19 LTS OpenJDK Runtime Environment 21.9 (build 17.0.1+12-LTS) OpenJDK 64-Bit Server VM 21.9 (build 17.0.1+12-LTS, mixed mode, sharing) Classpath: /opt/openfire/lib/activation-1.1.jar:/opt/openfire/lib/apache-el-9.0.107.jar:/opt/openfire/lib/apache-jsp-9.0.107.jar:/opt/openfire/lib/asm-9.8.jar:/opt/openfire/lib/asm-commons-9.8.jar:/opt/openfire/lib/asm-tree-9.8.jar:/opt/openfire/lib/bcpg-jdk18on-1.78.1.jar:/opt/openfire/lib/bcpkix-jdk18on-1.78.1.jar:/opt/openfire/lib/bcprov-jdk18on-1.78.1.jar:/opt/openfire/lib/bcutil-jdk18on-1.78.1.jar:/opt/openfire/lib/caffeine-3.2.0.jar:/opt/openfire/lib/checker-qual-3.33.0.jar:/opt/openfire/lib/common-image-3.9.4.jar:/opt/openfire/lib/common-io-3.9.4.jar:/opt/openfire/lib/common-lang-3.9.4.jar:/opt/openfire/lib/commons-codec-1.15.jar:/opt/openfire/lib/commons-dbcp2-2.9.0.jar:/opt/openfire/lib/commons-ip-math-1.32.jar:/opt/openfire/lib/commons-lang3-3.18.0.jar:/opt/openfire/lib/commons-logging-1.2.jar:/opt/openfire/lib/commons-pool2-2.9.0.jar:/opt/openfire/lib/commons-text-1.10.0.jar:/opt/openfire/lib/dom4j-2.1.4.jar:/opt/openfire/lib/dwr-3.0.2-RELEASE.jar:/opt/openfire/lib/ecj-3.33.0.jar:/opt/openfire/lib/error_prone_annotations-2.18.0.jar:/opt/openfire/lib/failureaccess-1.0.1.jar:/opt/openfire/lib/guava-32.0.1-jre.jar:/opt/openfire/lib/hsqldb-2.7.1.jar:/opt/openfire/lib/httpclient-4.5.13.jar:/opt/openfire/lib/httpcore-4.4.13.jar:/opt/openfire/lib/i18n-5.0.2.jar:/opt/openfire/lib/imageio-bmp-3.9.4.jar:/opt/openfire/lib/imageio-core-3.9.4.jar:/opt/openfire/lib/istack-commons-runtime-3.0.11.jar:/opt/openfire/lib/j2objc-annotations-2.8.jar:/opt/openfire/lib/jakarta.activation-1.2.2.jar:/opt/openfire/lib/jakarta.annotation-api-1.3.5.jar:/opt/openfire/lib/jakarta.transaction-api-1.3.3.jar:/opt/openfire/lib/jakarta.xml.bind-api-2.3.3.jar:/opt/openfire/lib/jansi-1.18.jar:/opt/openfire/lib/javax.activation-api-1.2.0.jar:/opt/openfire/lib/javax.mail-1.6.2.jar:/opt/openfire/lib/jaxb-api-2.3.1.jar:/opt/openfire/lib/jaxb-runtime-2.3.3.jar:/opt/openfire/lib/jaxen-1.2.0.jar:/opt/openfire/lib/jcip-annotations-1.0.jar:/opt/openfire/lib/jcl-over-slf4j-2.0.9.jar:/opt/openfire/lib/jetty-ee-12.0.24.jar:/opt/openfire/lib/jetty-ee8-annotations-12.0.24.jar:/opt/openfire/lib/jetty-ee8-apache-jsp-12.0.24.jar:/opt/openfire/lib/jetty-ee8-nested-12.0.24.jar:/opt/openfire/lib/jetty-ee8-plus-12.0.24.jar:/opt/openfire/lib/jetty-ee8-security-12.0.24.jar:/opt/openfire/lib/jetty-ee8-servlet-12.0.24.jar:/opt/openfire/lib/jetty-ee8-webapp-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-jetty-api-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-jetty-common-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-jetty-server-12.0.24.jar:/opt/openfire/lib/jetty-ee8-websocket-servlet-12.0.24.jar:/opt/openfire/lib/jetty-http-12.0.24.jar:/opt/openfire/lib/jetty-io-12.0.24.jar:/opt/openfire/lib/jetty-jmx-12.0.24.jar:/opt/openfire/lib/jetty-jndi-12.0.24.jar:/opt/openfire/lib/jetty-plus-12.0.24.jar:/opt/openfire/lib/jetty-security-12.0.24.jar:/opt/openfire/lib/jetty-server-12.0.24.jar:/opt/openfire/lib/jetty-servlet-api-4.0.6.jar:/opt/openfire/lib/jetty-session-12.0.24.jar:/opt/openfire/lib/jetty-util-12.0.24.jar:/opt/openfire/lib/jetty-websocket-core-common-12.0.24.jar:/opt/openfire/lib/jetty-websocket-core-server-12.0.24.jar:/opt/openfire/lib/jetty-xml-12.0.24.jar:/opt/openfire/lib/jmdns-1.0.jar:/opt/openfire/lib/jsmpp-2.3.10.jar:/opt/openfire/lib/json-20231013.jar:/opt/openfire/lib/jspecify-1.0.0.jar:/opt/openfire/lib/jsr305-3.0.2.jar:/opt/openfire/lib/jtds-1.3.1.jar:/opt/openfire/lib/jzlib-1.1.3.jar:/opt/openfire/lib/libidn-1.35.jar:/opt/openfire/lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar:/opt/openfire/lib/log4j-api-2.20.0.jar:/opt/openfire/lib/log4j-core-2.20.0.jar:/opt/openfire/lib/log4j-slf4j2-impl-2.20.0.jar:/opt/openfire/lib/mssql-jdbc-9.4.1.jre11.jar:/opt/openfire/lib/mysql-connector-j-8.2.0.jar:/opt/openfire/lib/netty-all-4.1.118.Final.jar:/opt/openfire/lib/netty-buffer-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-dns-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-haproxy-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-http2-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-http-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-memcache-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-mqtt-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-redis-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-smtp-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-socks-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-stomp-4.1.118.Final.jar:/opt/openfire/lib/netty-codec-xml-4.1.118.Final.jar:/opt/openfire/lib/netty-common-4.1.118.Final.jar:/opt/openfire/lib/netty-handler-4.1.118.Final.jar:/opt/openfire/lib/netty-handler-proxy-4.1.118.Final.jar:/opt/openfire/lib/netty-handler-ssl-ocsp-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-dns-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-dns-classes-macos-4.1.118.Final.jar:/opt/openfire/lib/netty-resolver-dns-native-macos-4.1.118.Final-osx-aarch_64.jar:/opt/openfire/lib/netty-resolver-dns-native-macos-4.1.118.Final-osx-x86_64.jar:/opt/openfire/lib/netty-transport-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-classes-epoll-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-classes-kqueue-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-native-epoll-4.1.118.Final-linux-aarch_64.jar:/opt/openfire/lib/netty-transport-native-epoll-4.1.118.Final-linux-riscv64.jar:/opt/openfire/lib/netty-transport-native-epoll-4.1.118.Final-linux-x86_64.jar:/opt/openfire/lib/netty-transport-native-kqueue-4.1.118.Final-osx-aarch_64.jar:/opt/openfire/lib/netty-transport-native-kqueue-4.1.118.Final-osx-x86_64.jar:/opt/openfire/lib/netty-transport-native-unix-common-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-rxtx-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-sctp-4.1.118.Final.jar:/opt/openfire/lib/netty-transport-udt-4.1.118.Final.jar:/opt/openfire/lib/ojdbc11-23.7.0.25.01.jar:/opt/openfire/lib/ons-23.7.0.25.01.jar:/opt/openfire/lib/oraclepki-23.7.0.25.01.jar:/opt/openfire/lib/orai18n-23.7.0.25.01.jar:/opt/openfire/lib/postgresql-42.7.7.jar:/opt/openfire/lib/rsi-23.7.0.25.01.jar:/opt/openfire/lib/shaj-0.5.jar:/opt/openfire/lib/simplefan-23.7.0.25.01.jar:/opt/openfire/lib/sitemesh-2.5.0.jar:/opt/openfire/lib/slf4j-api-2.0.9.jar:/opt/openfire/lib/startup.jar:/opt/openfire/lib/taglibs-standard-impl-1.2.5.jar:/opt/openfire/lib/taglibs-standard-spec-1.2.5.jar:/opt/openfire/lib/tinder-2.1.0.jar:/opt/openfire/lib/txw2-2.3.3.jar:/opt/openfire/lib/ucp-23.7.0.25.01.jar:/opt/openfire/lib/xdb-23.7.0.25.01.jar:/opt/openfire/lib/xmppserver-5.0.2.jar:/opt/openfire/lib/xpp3-1.1.4c.0.jar Starting OpenFire... OpenFire started (PID 1103016) Check logs: tail -f /opt/openfire/logs/nohup.out [root@yfw system]# tail -f /opt/openfire/logs/nohup.out DEBUG: User = $(whoami) DEBUG: Current dir = $(pwd) DEBUG: OPENFIRE_HOME = $OPENFIRE_HOME DEBUG: Java executable = $(which java) openjdk version "17.0.1" 2021-10-19 LTS OpenJDK Runtime Environment 21.9 (build 17.0.1+12-LTS) OpenJDK 64-Bit Server VM 21.9 (build 17.0.1+12-LTS, mixed mode, sharing) DEBUG: Launching OpenFire... Error: Could not find or load main class org.jivesoftware.openfire.starter.ServerStarter Caused by: java.lang.ClassNotFoundException: org.jivesoftware.openfire.starter.ServerStarter Halting server... Server halted 12:05:02.526 [main] ERROR org.jivesoftware.util.JiveProperties - null java.lang.NullPointerException: null at java.lang.Class.forName0(Native Method) ~[?:?] at java.lang.Class.forName(Class.java:375) ~[?:?] at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvider.java:99) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:652) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.ensureConnectionProvider(DbConnectionManager.java:109) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:162) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:472) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:108) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:84) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:547) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.cache.CacheFactory.<clinit>(CacheFactory.java:102) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:381) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:658) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] Database setup or configuration error: Please verify your database settings and check the logs/openfire.log file for detailed error messages. 12:05:05.175 [main] ERROR org.jivesoftware.openfire.XMPPServer - Database could not be accessed java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1020) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) at java.base/java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) at java.base/jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) at java.base/java.lang.Class.newInstance(Class.java:645) at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) ... 11 more 12:05:05.176 [main] ERROR org.jivesoftware.openfire.XMPPServer - java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1020) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) ~[xmppserver-5.0.2.jar:5.0.2] ... 11 more 启动服务器时出错。有关详细信息，请查看日志文件。 Halting server... Server halted 12:05:20.591 [main] ERROR org.jivesoftware.util.JiveProperties - null java.lang.NullPointerException: null at java.lang.Class.forName0(Native Method) ~[?:?] at java.lang.Class.forName(Class.java:375) ~[?:?] at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvider.java:99) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:652) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.ensureConnectionProvider(DbConnectionManager.java:109) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:162) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:472) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:108) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:84) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:547) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.util.cache.CacheFactory.<clinit>(CacheFactory.java:102) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:381) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:658) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] Database setup or configuration error: Please verify your database settings and check the logs/openfire.log file for detailed error messages. 12:05:23.235 [main] ERROR org.jivesoftware.openfire.XMPPServer - Database could not be accessed java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1020) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) at java.base/java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) at java.base/jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) at java.base/java.lang.Class.newInstance(Class.java:645) at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) ... 11 more 12:05:23.236 [main] ERROR org.jivesoftware.openfire.XMPPServer - java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1020) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:666) [xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:221) [xmppserver-5.0.2.jar:5.0.2] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) [?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) [?:?] at java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) [?:?] at jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:347) [?:?] at java.lang.Class.newInstance(Class.java:645) [?:?] at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:5.0.2] at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:5.0.2] Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 attempts. The exception from the last attempt is as follows: java.sql.SQLException: Check JDBC properties; data source was not be initialised at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-5.0.2.jar:5.0.2] at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1010) ~[xmppserver-5.0.2.jar:5.0.2] ... 11 more 启动服务器时出错。有关详细信息，请查看日志文件。 Halting server... Server halted 12:05:38.669 [
最新发布
11-16
Caused by: java.lang.ClassNotFoundException: org.jivesoftware.openfire.starter.ServerStarter ``` 然后后续又出现： ```log java.sql.SQLException: Check JDBC properties; data source was not be ...
【原】was的一次数据库连接不了的处理记录
热门推荐
活在当下 乐在其中
01-05 1万+
环境：WAS 7.0.0.0 Jdk ：自带1.6 Linux环境：Linux, version 2.6.18-194.1.AXS3 Database 产品版本：Oracle Database 11g Release 11.1.0.0.0 - Production 数据源配置驱动：11.1.0.1.0  (后来更换 11.2.0.1.0 版本) 遇到的几个棘手问题： 1. 写道 引用 Erro
java.lang.NullPointerException的解决方法
10-30
启动Tomcat时出现了下面的这种错误，找了很久的原因终于知道是因为tomcat和jdk要放在任意一个盘的根目录下面，而不能是放在 而不能放在某个盘根目录下的子目录里面，最好是放在C盘的根目录下面（比如C:\tomcat-6.0.20、C:\jdk1.6）！
Could not create connection to database server，java连接数据库失败，使用的MYsql版本为8.0
weixin_42460949的博客
12-13 1136
这是我连接数据库时出现的错误，三步改正： 第一步：无法连接的原因是我使用的MYSQL SEVER是8.0版本的，但是在java中导入的JAR包与版本不匹配，建议直接用Mysql提供的JAR包。 我使用mysql-connector-java-8.0.13.jar后，在连接数据库时又出现了以下的情况： 第二步：这是因为该版本连接注册驱动是应写为：Class.forName(“com.mysql....
alibaba.druid.pool.DruidDataSource : {dataSource-1} init error java.lang.NullPointerException: nul
qq_31451471的博客
03-29 8225
. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, |...
com.alibaba.druid.pool.DruidDataSourc:{dataSource-1} init error java.lang.NullPointerException: null
ZhangJunQi的博客
08-12 3276
工作中遇到的小问题，记录一下子。 网上看了很多帖子，也实验了很多办法，下面举几个栗子： 1，缺少ojdbc和数据库驱动的包（可以自己在maven自己检查一下）或者版本太老，更换版本试试。（不符合本人情况） 2，在pom.xml中缺少resource 无法读取配置文件(下面添加自己的哈！) <resources> <resource> <directory>src/main/resources<
maven项目测试数据连接出现java.lang.NullPointerException的解决方法
抛弃幻想，准备斗争
01-02 1575
配置文件都没有出错，毫无头绪的一个异常。 最终发现是没有为数据源DataSource进行装配（@Autowired）
springboot+mybatis 查询报错java.lang.NullPointerException: null
strom_xu
03-01 6945
java.lang.NullPointerException: null 场景： 查询的时候总是空指针，以为是自己的bean的错误改了半天，发现是自己的yml文件问题 java.lang.NullPointerException: null at java.util.concurrent.ConcurrentHashMap.putVal(ConcurrentHashMap.java:1011) ...
druid和JDBCTemplate遇到错误：java.lang.NullPointerException
Aron's Blog
03-24 571
本来以为是配置文件druid.properties 不应该放在src下。处理了半天。 InputStream为null，说明是配置文件获取出现了问题。 反复检查代码和配置文件均没问题 解决方案： Maven 项目下的配置文件需要将其收录到 resource 目录下才解决问题。 ...
druid java.lang.NullPointerException
漠上尘的博客
12-18 928
,java.lang.NullPointerException 是因为这一行被注释了导致的
mysql驱动版本异常java.lang.NullPointerException
khmff的博客
08-26 2667
com.mysql.cj.jdbc.Driver 是 mysql-connector-java 6及6之后的的。com.mysql.jdbc.Driver 是 mysql-connector-java 5及5之前的，mysql-connector-java版本需与mysql版本一致。在mysql中执行SELECT VERSION()原因：版本不一致出现。使用的是5.x.x的。原因：版本不一致出现。使用的是5.x.x的。解决：改了就可以了（之前是5.x.x）注意：检查数据库版本。...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值