| Java Tutorial » Database » Java DB Derby |
| 20. 37. 3. The JavaDB Environments | |
Embedded: Allows only a single application to access a database at one time. | |
In the embedded environment, no network access occurs. | |
When you load a JDBC driver from a Java program, JavaDB automatically starts in the embedded environment. | |
Client/server: Allows multiple applications to connect to JavaDB over the network. | |
To start JavaDB in the client/server environment, you need to use the server command line tool of JavaDB. |
| 20. 37. Java DB Derby | ||||
| 20. 37. 1. | New to Java 6 is a lightweight database called Derby. | |||
| 20. 37. 2. | The JavaDB Directory Structure | |||
| 20. 37. 3. | The JavaDB Environments | |||
| 20. 37. 4. | JavaDB Drivers | |||
| 20. 37. 5. | JavaDB URLs | |||
| 20. 37. 6. | JavaDB Tools | |||
| 20. 37. 7. | You can use the server tool to start JavaDB in a network client environment. | |||
| 20. 37. 8. | Ping JavaDB. | |||
| 20. 37. 9. | To view run time information for JavaDB, you can use the following command: | |||
| 20. 37. 10. | To stop JavaDB, you can use the following command: | |||
| 20. 37. 11. | Using the ij Tool | |||
| 20. 37. 12. | You can use the connect command of ij to establish a connection with a database | |||
| 20. 37. 13. | Viewing and Switching Connections | |||
| 20. 37. 14. | Working with Tables | |||
| 20. 37. 15. | To view the structure of the Employee table | |||
| 20. 37. 16. | Using the sysinfo Tool | |||
| 20. 37. 17. | Connect to Java DB (Derby) with org.apache.derby.jdbc.EmbeddedDriver | |||
| 20. 37. 18. | Connect to Derby database | |||
| 20. 37. 19. | The SQL script for creating the Employee Table | |||