Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
- package com.ddg;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class SQLConnect
- {
- Connection Conn = null;
- String URL;
- String Username;
- String Password;
- public SQLConnect()
- {
- try
- {
- Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
- }
- catch (ClassNotFoundException e)
- {
- System.out.println(e.toString());
- }
- URL = "jdbc:derby:*directory name*";
- System.out.println("Created SQL Connect");
- }
- public void CreateConnection()
- {
- try
- {
- Conn = DriverManager.getConnection(URL);
- System.out.println("Successfully Connected");
- }
- catch (SQLException e)
- {
- System.out.println(e.toString());
- }
- }
- public void CloseConnection()
- {
- try
- {
- this.Conn.close();
- System.out.println("Connection successfully closed");
- }
- catch (SQLException e)
- {
- System.out.println(e.toString());
- }
- }
- public static void main(String args[])
- {
- SQLConnect sql = new SQLConnect();
- sql.CreateConnection();
- sql.CloseConnection();
- }
- }
- jdbc:derby://<path>/<databasename>;create=true
- java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
- org.apache.derby.jdbc.EmbeddedDriver
- org.apache.derby.jdbc.ClientDriver
- java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver
- org.apache.derby.jdbc.EmbeddedDriver
- org.apache.derby.jdbc.ClientDriver
- [JDK]db/lib/derby.jar (EmbeddedDriver)
- [JDK]db/lib/derbyclient.jar (ClientDriver)
- C:> set DERBY_HOME=c:Program FilesJavajdk1.8.0_60db
- C:> set CLASSPATH=%DERBY_INSTALL%libderby.jar;%DERBY_INSTALL%libderbytools.jar;.
- C:> cd %DERBY_INSTALL%bin
- c:Program FilesJavajdk1.8.0_60dbbin> setEmbeddedCP.bat
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement