Advertisement
Guest User

Untitled

a guest
Oct 5th, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.96 KB | None | 0 0
  1. Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
  2.  
  3. package com.ddg;
  4.  
  5. import java.sql.Connection;
  6. import java.sql.DriverManager;
  7. import java.sql.SQLException;
  8.  
  9.  
  10. public class SQLConnect
  11. {
  12. Connection Conn = null;
  13. String URL;
  14. String Username;
  15. String Password;
  16.  
  17. public SQLConnect()
  18. {
  19. try
  20. {
  21. Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
  22. }
  23. catch (ClassNotFoundException e)
  24. {
  25. System.out.println(e.toString());
  26. }
  27. URL = "jdbc:derby:*directory name*";
  28.  
  29. System.out.println("Created SQL Connect");
  30. }
  31.  
  32. public void CreateConnection()
  33. {
  34. try
  35. {
  36. Conn = DriverManager.getConnection(URL);
  37. System.out.println("Successfully Connected");
  38. }
  39. catch (SQLException e)
  40. {
  41. System.out.println(e.toString());
  42. }
  43. }
  44.  
  45. public void CloseConnection()
  46. {
  47. try
  48. {
  49. this.Conn.close();
  50. System.out.println("Connection successfully closed");
  51. }
  52. catch (SQLException e)
  53. {
  54. System.out.println(e.toString());
  55. }
  56. }
  57.  
  58. public static void main(String args[])
  59. {
  60. SQLConnect sql = new SQLConnect();
  61. sql.CreateConnection();
  62. sql.CloseConnection();
  63. }
  64. }
  65.  
  66. jdbc:derby://<path>/<databasename>;create=true
  67.  
  68. java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
  69.  
  70. org.apache.derby.jdbc.EmbeddedDriver
  71.  
  72. org.apache.derby.jdbc.ClientDriver
  73.  
  74. java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver
  75.  
  76. org.apache.derby.jdbc.EmbeddedDriver
  77. org.apache.derby.jdbc.ClientDriver
  78.  
  79. [JDK]db/lib/derby.jar (EmbeddedDriver)
  80. [JDK]db/lib/derbyclient.jar (ClientDriver)
  81.  
  82. C:> set DERBY_HOME=c:Program FilesJavajdk1.8.0_60db
  83. C:> set CLASSPATH=%DERBY_INSTALL%libderby.jar;%DERBY_INSTALL%libderbytools.jar;.
  84. C:> cd %DERBY_INSTALL%bin
  85. c:Program FilesJavajdk1.8.0_60dbbin> setEmbeddedCP.bat
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement