Thanks Janos. It did help me. I copied extracted mysql jar file under /tinyos/support/sdk/java/ which was added in my classpath. It worked.
Jenis ________________________________________ From: [email protected] [[email protected]] on behalf of Janos Sallai [[email protected]] Sent: 26 October 2012 06:27 To: Modi, Jenis Ashokkumar Subject: Re: [Tinyos-help] Java TestSerial database error You need to add the mysql connector jar file to the class path. Just copying the jar file to the same directory has no effect, whatsoever. Janos On Thu, Oct 25, 2012 at 9:19 PM, Modi, Jenis Ashokkumar <[email protected]> wrote: > Hi All, > > I am trying to store the data in mysql database for TestSerial application, > but when I run my application, I get bunch of errors, > > Here is what I get as errors: > > Sending packet 0 > ClassNotFoundException: com.mysql.jdbc.Driver > SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test > Exception thrown when sending packets. Exiting. > java.lang.NullPointerException > > > Here is my code: > > import java.io.IOException; > import net.tinyos.message.*; > import net.tinyos.packet.*; > import net.tinyos.util.*; > import java.sql.Connection; > import java.sql.DriverManager; > import java.sql.PreparedStatement; > import java.sql.ResultSet; > import java.sql.SQLException; > import java.sql.Statement; > import java.util.Date; > > public class TestSerial implements MessageListener { > > private MoteIF moteIF; > > public TestSerial(MoteIF moteIF) { > this.moteIF = moteIF; > this.moteIF.registerListener(new TestSerialMsg(), this); > } > > > static String userid="root", password="ashokkumar"; > > static String url = "jdbc:mysql://localhost:3306/test"; > static Connection con = null; > static Statement stmt = null; > private PreparedStatement preparedStatement = null; > > > public static Connection getJDBCConnection(){ > try { > > Class.forName("com.mysql.jdbc.Driver"); > > } catch(java.lang.ClassNotFoundException e) { > System.err.print("ClassNotFoundException: "); > System.err.println(e.getMessage()); > } > > try { > con = DriverManager.getConnection(url, userid, password); > } catch(SQLException ex) { > > System.err.println("SQLException: " + ex.getMessage()); > } > return con; > } > public void sendPackets() { > int counter = 0; > TestSerialMsg payload = new TestSerialMsg(); > > try { > while (true) { > System.out.println("Sending packet " + counter); > Connection con = getJDBCConnection(); > preparedStatement = con.prepareStatement("insert into > test.TestSerialData (counter,dummyName) values (?,?)"); > preparedStatement.setString(1,Integer.toString(counter)); > preparedStatement.setString(2,"Jenis"); > preparedStatement.executeUpdate(); > con.close(); > > payload.set_counter(counter); > moteIF.send(0, payload); > counter++; > try {Thread.sleep(1000);} > catch (InterruptedException exception) {} > } > } > catch (Exception exception) { > System.err.println("Exception thrown when sending packets. Exiting."); > System.err.println(exception); > } > } > > public void messageReceived(int to, Message message) { > TestSerialMsg msg = (TestSerialMsg)message; > System.out.println("Received packet sequence number " + > msg.get_counter()); > } > > private static void usage() { > System.err.println("usage: TestSerial [-comm <source>]"); > } > > public static void main(String[] args) throws Exception { > String source = null; > if (args.length == 2) { > if (!args[0].equals("-comm")) { > usage(); > System.exit(1); > } > source = args[1]; > } > else if (args.length != 0) { > usage(); > System.exit(1); > } > > PhoenixSource phoenix; > > if (source == null) { > phoenix = BuildSource.makePhoenix(PrintStreamMessenger.err); > } > else { > phoenix = BuildSource.makePhoenix(source, PrintStreamMessenger.err); > } > > MoteIF mif = new MoteIF(phoenix); > TestSerial serial = new TestSerial(mif); > serial.sendPackets(); > } > > > } > > > I have copied mysql-connector jar in TestSerial folder as well as > /tinyos/support/sdk/java/ folder. In the later folder, I have even extracted > the jar file. I am not able to understand why I am getting this error. Please > help. > > Thanks. > Jenis > > > _______________________________________________ > Tinyos-help mailing list > [email protected] > https://www.millennium.berkeley.edu/cgi-bin/mailman/listinfo/tinyos-help > _______________________________________________ Tinyos-help mailing list [email protected] https://www.millennium.berkeley.edu/cgi-bin/mailman/listinfo/tinyos-help
