Jgroups JDBC_PING Error: Either the 4 configuration properties starting with 'connection_' or the datasource_jndi_name must be set

[hmundeepi]

Hi Infinispan team,

I am using JDBC_PING protocol in Jgroups

<JDBC_PING connection_url="jdbc:mysql://localhost:3306/database_name"

                connection_username="" connection_password=""

                connection_driver="com.mysql.jdbc.Driver"

.....

I've come with error:

Caused by:

java.lang.IllegalArgumentException: Either the 4 configuration properties starting with 'connection_' or the datasource_jndi_name must be set

        at org.jgroups.protocols.JDBC_PING.verifyconfigurationParameters(JDBC_PING.java:353)

        at org.jgroups.protocols.JDBC_PING.init(JDBC_PING.java:86)

        at org.jgroups.stack.ProtocolStack.initProtocolStack(ProtocolStack.java:847)

        at org.jgroups.stack.ProtocolStack.setup(ProtocolStack.java:467)

        at org.jgroups.JChannel.init(JChannel.java:824)

        at org.jgroups.JChannel.<init>(JChannel.java:158)

        at org.jgroups.JChannel.<init>(JChannel.java:128)

        at org.infinispan.remoting.transport.jgroups.JGroupsTransport.buildChannel(JGroupsTransport.java:368)

It' really great for me if I could have your advices for this problem.

Thanks a lot and Best regards.

[hmundeepi]

Sorry for the inconvenience to you all. I got my answer

This error came because I have passed empty string in connection_username and connection_password .
Remember that these field should not be left empty.

Also next I've come up with mysql error showing Select privileges not there for 'user'@'localhost'.

To remove this error run below commands:

>mysql -u root -p

>GRANT ALL PRIVILEGES ON *database_name* TO 'user'@'localhost' WITH GRANT OPTION;

>commit;

>FLUSH PRIVILEGES;

>commit;

>exit

Now it will run smoothly without any error.