After doing some research, I edited my code like below:
I have also taken reference: http://blog.csdn.net/tt2sdz/article/details/5484474
** **
** **
** 9090 **
** 9091 **
** **
** en **
** **
** org.jivesoftware.database.DefaultConnectionProvider**
** **
** **
** com.mysql.jdbc.Driver **
** jdbc:mysql://localhost:3306/mydb?user=root&password=passw ord **
** **
** **
** **
** org.jivesoftware.openfire.auth.JDBCAuthProvider **
** **
** **
** **
** SELECT password_hash FROM user WHERE username=? **
** plain **
** **
** **
** SELECT username FROM user WHERE username=? **
__ SELECT COUNT(*) FROM user __
** SELECT username FROM user **
** SELECT username FROM user WHERE **
** username **
** username **
** **
** **
** joe, jane **
** **
** true**
Getting error like this now:
Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: Couldn’t load class null
** at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:786)**
** at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:499)**
** at org.jivesoftware.openfire.XMPPServer.(XMPPSerEver.java:216)**
** tarr sor starting the server. Please cehunr.c kftelect.NativeConstructorAcche logfe iles for more information.**
s
sorImpl.newInstance0(Native Method)
** at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)**
** at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)**
** at java.lang.reflect.Constructor.newInstance(Unknown Source)**
** at java.lang.Class.newInstance(Unknown Source)**
** at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)**
** at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56)**
** at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)**
** at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)**
** at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)**
** at java.lang.reflect.Method.invoke(Unknown Source)**
** at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)**
** at com.exe4j.runtime.WinLauncher.main(Unknown Source)**
** at com.install4j.runtime.launcher.WinLauncher.main(Unknown Source)**
Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: Couldn’t load class null
** at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:152)**
** at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:776)**
** … 16 more**
Server halted