Schema "DB" Doesn't exist

Question

I use the following code to create db connection

public final static String driver = "org.apache.derby.jdbc.ClientDriver";
public final static String connectionURL = "jdbc:derby:projectDB;create=true;user=user1;password=psssword";

public CreateConnectionDOA(String driver, String connectionURL) throws ClassNotFoundException,SQLException
    {
            Class.forName(driver);
            conn = DriverManager.getConnection(connectionURL);
            conn.setAutoCommit(false);
    }

The project was created in Netbeans-Platform-Application-Module. When i run the project through netbeans platform 7.4.. it works properly.

But when i try to create a installer using netbeans and run.. the project opens but it also gives an exception

"ERROR 42Y07: Schema 'projectDB' does not exist

score 3 · Accepted Answer · answered Mar 11 '14 at 06:08

3

try fully pathing your DB in your url

public final static String connectionURL = 
"jdbc:derby:d:/myproject/projectDB;create=true;user=user1;password=psssword";

answered Mar 11 '14 at 06:08

Scary Wombat

44,617
6
35
64

it works.. Thanks.. do u have any idea how to get the path while installing the s/w which is created using the Netbeans 7.4 – Alex Michael Raj Mar 11 '14 at 07:29

score 0 · Answer 2 · answered Nov 19 '20 at 11:40

Full path works because your relative path was probably wrong. With a correct relative path, it should work. Keep in mind that current directory is your project directory; write the relative path (../dataBase if necessary works as expected) and it will work.

Schema "DB" Doesn't exist

2 Answers2