Can't set up the Database with code (from OCP study guide)

[Mike Savvy]

Hello there    Happy New Year    
So I'm trying to do the steps on page 509 in Boyarsky/Selikoff OCP study guide, but it is not working.
First I set up the path variable for .jar file (but I do not have any jar file, where should I take it?)
Second I wrote the class SetupDerbyDatabase in the file SetupDerbyDatabase.java and saved it just where should be .jar file, so:
C:\Program Files\Java\jdk1.8.0_251\db\lib
Third I've compiled it and the .class file is there
Fourth I try to execute this java -cp "C:\Program Files\Java\jdk1.8.0_251\db\lib\derby.jar;." SetupDerbyDatabase
but compiler return me that:

Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:derby:zoo;create=true
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:270)
        at SetupDerbyDatabase.main(SetupDerbyDatabase.java:6)

I also wrote the MyFirstDatabaseConnection class (page 513) in Eclipse and then I've tried to start it but have the same Exception.
Please help!

[Matthew Bendford]

Well, aside from I neither own the book nor know it - but putting some dev-code somewhere in C:\Program Files doesn't look right AT ALL.
Maybe share some instructions for those not having the book handy to know what the book tells you to do and then post what you actually have done. I'm sure the instructions of the book are well tested so when follow them in order it should work on the first try.
In addition, although this is a topic many already have debated about: I personal don't like the idea to use an IDE without knowing the basics to get something simple like this done on the terminal.

[Mike Savvy]

Well I know how does terminal works but I do not really understand the steps in the book. They speak about derby.jar file but I do not know where should I find it. I did not found it on the website selikoff.com/ocp.
Also they speak about adding a path variable and give the path but no name for this variable. I'll try to post the text abd the code

[Mike Savvy]

Before running the following code, you need to add a .jar file to your classpath. Add <JAVA_HOME>/db/lib/derby.jar to your classpath. Just make sure to replace <JAVA_ HOME> with the actual path on your file system. On Linux or Mac, you run the program like this:

java −cp "/my/jdk/home/db/lib/derby.jar:." SetupDerbyDatabase

And on Windows, you run the program like this:

java −cp "c:\program files\jdk\db\lib\derby.jar;." SetupDerbyDatabase

The code is as follows. You can also find this code along with more details on setup at http://selikoff.net/ocp.

import java.sql.*;
public class SetupDerbyDatabase {
   public static void main(String[] args) throws Exception { 
      String url = "jdbc:derby:zoo;create=true";
       try (Connection conn = DriverManager.getConnection(url); 
            Statement stmt = conn.createStatement()) {
   stmt.executeUpdate("CREATE TABLE species (" 
   + "id INTEGER PRIMARY KEY, "
   + "name VARCHAR(255), "
   + "num_acres DECIMAL)"); 
   stmt.executeUpdate(
   "CREATE TABLE animal ("
   + "id INTEGER PRIMARY KEY, "
   + "species_id integer, "
   + "name VARCHAR(255), "
   + "date_born TIMESTAMP)");
   stmt.executeUpdate("INSERT INTO species VALUES (1, 'African Elephant', 7.5)"); 
   stmt.executeUpdate("INSERT INTO species VALUES (2, 'Zebra', 1.2)");
   stmt.executeUpdate("INSERT INTO animal VALUES (1, 1, 'Elsa', '2001−05−06 02:15')"); 
   stmt.executeUpdate("INSERT INTO animal VALUES (2, 2, 'Zelda', '2002−08−15 09:12')"); 
   stmt.executeUpdate("INSERT INTO animal VALUES (3, 1, 'Ester', '2002−09−09 10:36')"); 
   stmt.executeUpdate("INSERT INTO animal VALUES (4, 1, 'Eddie', '2010−06−08 01:24')"); 
   stmt.executeUpdate("INSERT INTO animal VALUES (5, 2, 'Zoe', '2005−11−12 03:44')"); 
      }
   }
}

Here is example of using this DB:

package com.wiley.ocp.connection;
import java.sql.*;
public class MyFirstDatabaseConnection {
   public static void main(String[] args) throws SQLException { 
      String url = "jdbc:derby:zoo";
      try (Connection conn = DriverManager.getConnection(url); 
           Statement stmt = conn.createStatement();
           ResultSet rs = stmt.executeQuery("select name from animal")) {
           while (rs.next()) 
               System.out.println(rs.getString(1)); 
      }
   }
}

[Norm Radder]

Here is the console I get when I run the code:

D:\JavaDevelopment\Testing\DataBase\db-derby-10.14.2.0-bin>java -cp .;lib\derby.jar SetupDerbyDataBase
Exception in thread "main" java.sql.SQLDataException: The syntax of the string representation of a date/time value is incorrect.
       at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
       at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
       at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
       at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
       at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
       at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
       at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
       at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
       at org.apache.derby.impl.jdbc.EmbedStatement.executeLargeUpdate(Unknown Source)
       at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
       at SetupDerbyDataBase.main(SetupDerbyDataBase.java:21)
Caused by: ERROR 22007: The syntax of the string representation of a date/time value is incorrect.
       at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
       at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
       at org.apache.derby.iapi.types.DateTimeParser.parseInt(Unknown Source)
       at org.apache.derby.iapi.types.SQLTimestamp.parseDateOrTimestamp(Unknown Source)
       at org.apache.derby.iapi.types.SQLTimestamp.parseTimestamp(Unknown Source)
       at org.apache.derby.iapi.types.SQLTimestamp.<init>(Unknown Source)
       at org.apache.derby.iapi.types.SQLChar.getTimestamp(Unknown Source)
       at org.apache.derby.iapi.types.SQLChar.getTimestamp(Unknown Source)
       at org.apache.derby.iapi.types.SQLTimestamp.setFrom(Unknown Source)
       at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
       at org.apache.derby.iapi.types.DataType.normalize(Unknown Source)
       at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
       at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
       at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
       at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
       at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
       at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown Source)
       at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
       at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
       at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
       ... 5 more

D:\JavaDevelopment\Testing\DataBase\db-derby-10.14.2.0-bin>MORE

[Mike Savvy]

Norm Radder wrote:Here is the console I get when I run the code:

I do not know why you have this SQLDataException. I have no problem with it

[Mike Savvy]

Okay I have got the same Exception as Norm Radder  
I found derby.jar in an archive from apache website

[Norm Radder]

//  Derby supports the following formats for TIMESTAMP:       yyyy-mm-dd hh:mm:ss[.nnnnnn]

Works when :00 added for the :ss part of the TIMESTAMP

[Mike Savvy]

Adding :00 do not help me. I still have the problem. I have tried for 3 times

[Norm Radder]

I have no ideas why you get that error with the correction I suggested.  The only situation I can imagine is there are two copies of the source.  One was updated and the older one was executed.
One suggestion I have is to move all your code out of the  Program Files folder to your own personal folder.  

[Dave Tolls]

How old is that book?
Derby was removed from the JDK over 5 years ago.

As Norm says, do not do your development in the JDK folders.
Do them in your own user folders somewhere.
You should have no need to mess with the JDK itself.

[Mike Savvy]

Thank you guys for information. The book is from 2016, I bought it last year

[Jeanne Boyarsky]

For anyone following this, the setup code/example is here. We put that on the internet in case anything changed after distribution. Obviously, the example is only to be run with a Java 8 JDK.

For those of you who had to add :00, where are you based? I'm curious if this has to do with locales.

The example on the blog still works for me (using Java 1.8.151)