Big Java, Binder Ready Version: Early Objects
Big Java, Binder Ready Version: Early Objects
6th Edition
ISBN: 9781119056447
Author: Cay S. Horstmann
Publisher: WILEY
Expert Solution & Answer
Book Icon
Chapter 24, Problem 20RE

Explanation of Solution

Matching the given error messages:

Consider the below command:

  java -classpath derby.jar;. TestDB database.properties

When executing the above command, the possible error messages are matched with its corresponding error conditions as follows:

Usage: java [-options] class [args...]

The above error message can occur when the “derby.jar” and “.” does not contain a colon “:” when running the command on the operating systems such as Linus, UNIX, or Mac OSX.

  • Suppose if we run Linux, UNIX, or Mac OSX, then it should have been separated by a colon (:) but not a semicolon as a path separator, so that the above error can be avoided.

Therefore, the given error message is matches with the error condition “derby.jar and . should have been separated by a colon on this operating system.”

Exception in thread “main” java.sql.SQLException: No suitable driver found for jdbc:derby:BigJavaDB;create=true

The above error message can occur when there is no suitable driver found for the connection.

  • When we run a java database program, the “bin” folder should contain all the required “JAR” files, so that, the above error can be avoided.

Therefore, the given error message matches with the error condition “The derby.jar file was not present in the current directory.”

Exception in thread “main” java.lang. NoClassDefFoundError: TestDB

The above error message can occur when there is no class definition found for the program.

  • When we run a Java database program the required class files should be present in the JDK bin directory so that the above error can be avoided.

Therefore, the given error message matches with the error condition “The TestDB.class file was not present in the current directory”

Exception in thread “main” java...

Blurred answer
Students have asked these similar questions
Consider the following database for some store: Customers (cid, cname, city, discount)Agents (aid, aname, city, percent)Products (pid, pname, city, quantity, price)Orders (ordno, mon, cid, aid, pid, qty, dollars) The relation Customers records the ID (cid), name (cname), location (city) of each customer and a discount percentage (discount) for this customer. The relation Agents records the ID (aid), name (aname), location (city) of each agent and a transaction fee (percent) charged by this agent. The relation Products lists the ID (pid), name (pname), location (city), quantity and price of available products. And finally, the relation Orders contains a unique order number (ordno), the month (mon), customer (cid), agent (aid), product (pid), quantity (qty) of each order as well as the total value (dollars) of the transaction.   1. Express the following query in SQL (a) List customers (names) who do not have discounts but purchased at least one product of price greater than $50. (b) Find…
Consider the following relational schema and briefly answer the questions that follow:   Emp(eid: integer, ename: string, age: integer, salary: real)  Works(eid: integer, did: integer, pct_time: integer)  Dept(did: integer, budget: real, managerid: integer)      a. Define a table constraint on Dept that will ensure that all managers have age > 30. b. Write SQL statements to delete all information about employees whose salaries exceed that of the manager of one or more departments that they work in. Be sure to ensure that all the relevant integrity constraints are satisfied after your updates.
Consider the following relations:     Student(snum: integer, sname: string, rmajor: string,          level: string, age: integer)   Class(cname: string, meets_at: time, room: string, fid: integer)   Enrolled(snum: integer, cname: string)   Faculty(fid: integer, fname: string, deptid: integer)     The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class.     2. Express each of the following integrity constraints in SQL unless it is implied by the primary and foreign key constraint; if so, explain how it is implied. If the constraint cannot be expressed in SQL, say so. For each constraint, state what operations (inserts, deletes, and updates on specific relations) must be monitored to enforce the constraint.   (a) Every faculty member must teach at least two courses. (b) Every student must be enrolled in the course called 'Math101'. (c) A student cannot add more than two courses at a time…
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education