Connection c = null; Statement st = null; ResultSet rs; String query = "CREATE TABLE book ( NAME VARCHAR(20),ID INTEGER,RATE INTEGER)"; String query1 = "INSERT INTO book VALUES ( 'HFSJ',1,100)"; String query2= "INSERT INTO book VALUES ( 'JSPCOOKBOOK',2,90)";
i got the error as "com.ibm.db2.jcc.DB2Driver No suitable driver" but i have placed the jar files (C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar) in classpath environmental system variables.
can you kinldy provide me sollution. thanks in advance.
When you run a program from Eclipse, the classpath environment variable isn't used. Instead you need to add the jar file to the projects build path, or to the classpath of the launch configuration (in the Run... dialog).
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus