Guest User

Untitled

a guest
Aug 9th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. connect DB2 with Java
  2. import java.sql.PreparedStatement;
  3. import java.sql.ResultSet;
  4. import java.sql.DriverManager;
  5. import java.sql.Connection;
  6. import java.sql.SQLException;
  7.  
  8. public class connection {
  9. public static void main(String[] argv) {
  10. try {
  11. Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
  12. }
  13. catch (ClassNotFoundException e) {
  14. System.out.println("Please include Classpath Where your DB2 Driver is located");
  15. e.printStackTrace();
  16. return;
  17. }
  18. System.out.println("DB2 driver is loaded successfully");
  19. Connection conn = null;
  20. PreparedStatement pstmt = null;
  21. ResultSet rset=null;
  22. boolean found=false;
  23. try {
  24. conn = DriverManager.getConnection("jdbc:db2:sabarish","db2admin","Murugasaranam");
  25. if (conn != null)
  26. {
  27. System.out.println("DB2 Database Connected");
  28. }
  29. else
  30. {
  31. System.out.println("Db2 connection Failed ");
  32. }
  33. pstmt=conn.prepareStatement("Select * from bo");
  34. rset=pstmt.executeQuery();
  35. if(rset!=null)
  36. {
  37.  
  38. while(rset.next())
  39. {
  40. found=true;
  41. System.out.println("Class Code: "+rset.getString("clcode"));
  42. System.out.println("Name: "+rset.getString("name"));
  43. }
  44. }
  45. if (found ==false)
  46. {
  47. System.out.println("No Information Found");
  48. }
  49. } catch (SQLException e) {
  50. System.out.println("DB2 Database connection Failed");
  51. e.printStackTrace();
  52. return;
  53. }
  54. }
  55.  
  56. }
  57.  
  58. java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver
  59. at java.net.URLClassLoader$1.run(Unknown Source)
  60. at java.security.AccessController.doPrivileged(Native Method)
  61. at java.net.URLClassLoader.findClass(Unknown Source)
  62. at java.lang.ClassLoader.loadClass(Unknown Source)
  63. at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
  64. at java.lang.ClassLoader.loadClass(Unknown Source)
  65. at java.lang.Class.forName0(Native Method)
  66. at java.lang.Class.forName(Unknown Source)
  67. at connection.main(connection.java:11)
  68.  
  69. Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
  70.  
  71. Class.forName("com.ibm.db2.jcc.DB2Driver");
Add Comment
Please, Sign In to add comment