OPTUS_CallDataFeed: Call data script throws exception - :java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Call data script throws exception - :java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

1.Start calldata process

tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties

2012-02-16 12:19:45.669 (3) [main]: Debug Level set to 3

2012-02-16 12:19:45.679 (3) [main]: Observing directory: /var/local/tsa/calldata/

2.Place datafeed file "call_data_2012-01-25_s1.csv" to directory- /var/local/tsa/calldata/

[tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties

2012-02-16 12:19:45.669 (3) [main]: Debug Level set to 3

2012-02-16 12:19:45.679 (3) [main]: Observing directory: /var/local/tsa/calldata/

2012-02-16 12:20:39.952 (3) [Thread-1]: Processing [/var/local/tsa/calldata/call_data_2012-01-25_s1.csv]

2012-02-16 12:20:39.955 (3) [pool-1-thread-1]: Waiting for done file [/var/local/tsa/calldata/call_data_2012-01-25_s1.csv.done]

3.Now touch the file as done

[gsingh@optus-qa-agency1 calldata]$ sudo touch /var/local/tsa/calldata/call_data_2012-01-25_s1.csv.done

4. Script throws exception

[tsaapp@optus-qa-agency1 ~]$ cd /usr/local/tsa/bidmgr/

[tsaapp@optus-qa-agency1 bidmgr]$ ./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties

2012-02-16 12:19:45.669 (3) [main]: Debug Level set to 3

2012-02-16 12:19:45.679 (3) [main]: Observing directory: /var/local/tsa/calldata/

2012-02-16 12:20:39.952 (3) [Thread-1]: Processing [/var/local/tsa/calldata/call_data_2012-01-25_s1.csv]

2012-02-16 12:20:39.955 (3) [pool-1-thread-1]: Waiting for done file [/var/local/tsa/calldata/call_data_2012-01-25_s1.csv.done]

2012-02-16 12:20:53.984 (3) [pool-1-thread-1]: ======== Starting Call Data Load ========

2012-02-16 12:20:53.984 (3) [pool-1-thread-1]: Loading filename: /var/local/tsa/calldata/call_data_2012-01-25_s1.csv

2012-02-16 12:20:53.996 (3) [pool-1-thread-1]: DatabasePool with a limit of 80 created

2012-02-16 12:20:54.004 (1) [pool-1-thread-1]: Exception [loading database driver]:java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at java.net.URLClassLoader$1.run(URLClassLoader.java:202)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:190)

at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)

at java.lang.ClassLoader.loadClass(ClassLoader.java:247)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:169)

at com.carldunham.jst.db.Database.init(Database.java:198)

at com.carldunham.jst.db.Database.<init>(Database.java:188)

at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:171)

at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35)

at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88)