Hi Team
Restarting apache storm helped us here.thanks
-----Original Message-----
From: Pavan Jakati G
Sent: Fri 9/26/2014 12:45 PM
To: user@storm.incubator.apache.org
Subject: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/SOIMDB
Hi Team,
We are facing some weird issue when try running topology in remote mode
.For some reason apache storm is unable to find the class in the driver
. We have placed mysql-connector jar file under /lib directory of apache
storm and is getting identified when run storm classpath .
The code runs fine in local mode but fails in remote mode . Please help
us fix it . Thanks.
Code :
Class.forName("com.mysql.jdbc.Driver");
System.out.println("SUCCESSSSSS");
String connectionUrl =
"jdbc:mysql://192.168.10.7:3306/MYDB";
String connectionUser = "root";
String connectionPassword = "";
SOIMConnection =
DriverManager.getConnection(connectionUrl, connectionUser,
connectionPassword);
Error seen in worker file :
014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
2014-09-26 12:41:13 STDIO [INFO] ERRORRRRRRRRRRR
HEREEEEEEEEEEEEEEEEEjava.sql.SQLException: No suitable driver found for
jdbc:mysql://192.168.10.7:3306/MYDB
2014-09-26 12:41:13 STDIO [INFO] --------EMITTING FROM
SRIDHAR--------3283529
2014-09-26 12:41:13 STDIO [INFO] SUCCESSSSSS
Regards,
PaVan...
The information contained in this transmission may contain privileged and
confidential information of Microland Limited, including information protected
by privacy laws. It is intended only for the use of Microland Limited. If you
are not the intended recipient, you are hereby notified that any review,
dissemination, distribution, or duplication of this communication is strictly
prohibited. If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message. Although Microland
has taken reasonable precautions to ensure no viruses are present in this
email, Microland cannot accept responsibility for any loss or damage arising
from the use of this email or attachments. Computer viruses can be transmitted
via email. Recipient should check the email and any attachments for the
presence of viruses before using them. Any views or opinions are solely those
of the author and do not necessarily represent those of Microland.
This email may be monitored.
