2 Replies Latest reply: Mar 8, 2007 7:40 PM by 807606 RSS

    com.mysql.jdbc.driver and jdbc:odbc bridge driver

    807606
      Hi All,

      I want to update mysql database from data in hashtable. My application already uses JDBC:OBDC bridge driver for retrieving data from excel sheet and putting in hashtable.
      For connecting to mysql i need to use com.mysql.jdbc.driver too in the same code.
      How to do that?
      my code uses.
      Read(String strFilePath,String strFileName) 
           {    
                 filepath = strFilePath;
                 filename = strFileName; 
                  strDriver= "jdbc:odbc:Driver={MicroSoft Excel Driver (*.xls)}";
      Thanks