| Java Tutorial » Database » Java DB Derby |
| 20. 37. 4. JavaDB Drivers | |
Based on the environment in which JavaDB is running, Java SE 6 contains two drivers for accessing JavaDB. They are: | |
Embedded driver enables you to access JavaDB databases running in the embedded environment. | |
The org.apache.derby.jdbc.EmbeddedDriver class implements the embedded driver. | |
Network client driver enables you to access the JavaDB database running in the client/server environment. | |
The org.apache.derby.jdbc.ClientDriver class implements the network client driver. |
| 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 | |||