Drizzle database JDBC connect problem??

Jul 22, 2013 at 8:26 AM
Edited Aug 22, 2013 at 8:29 AM
How to insert query in drizzle using Drizzle protocol???
try{
    System.out.println("====== Welcome to drizzle========");        


        Class.forName("com.mysql.jdbc.DrizzleDriver");      
    }catch(Exception e){
        System.out.println(".........."+e.getStackTrace());
    }

    try
    {
        Connection connection = DriverManager.getConnection("jdbc:drizzle://192.168.0.92:4427/db1,"root","root"");      
        Statement stmt = connection.createStatement();          
        stmt.executeUpdate("INSERT INTO Emp1(Eno, Ename) VALUES (1007,'test1')");       
        System.out.println("Record is inserted into Emp1 table");


         // Get a statement from the connection
        //  Statement stmt2 = connection.createStatement() ;              
       //   ResultSet rs = stmt2.executeQuery( "SELECT * FROM Emp1" ) ;         
       //   while( rs.next() )
        //     System.out.println( rs.getString(1) ) ;           
        //  rs.close() ;
        //  stmt2.close() ;
       //   connection.close() ;


    }catch(Exception p){
        System.out.println(".....1....."+p.getStackTrace());
    }
Jul 22, 2013 at 8:26 AM
Please help me/>>
Aug 22, 2013 at 8:29 AM
Its working fine...using client drizzle_jdbc-1.2 jar