Exporting Derby database in Netbeans

java database netbeans derby
Steven picture Steven · Mar 29, 2013 · Viewed 23.6k times · Source

I have a project with a derby database in it.

I want to be able to make a backup or export the database so I can give it with the project files to my lecturer.

Answer

Alvin Thompson picture Alvin Thompson · Jun 24, 2014

By default, the database resides in your home folder under .netbeans-derby (this folder may be hidden under Windows). Copying this folder will work, but your lecturer will have to "register" this copied location with his IDE. To do this:

  • Under Services, open the Databases node.
  • Right-click on Java DB and select properties.
  • In the Database Location field, enter the path to the copied folder.

Related questions

Class [org.apache.derby.jdbc.ClientDriver] not found. When trying to connect to db

I have set up a project in Netbeans, created a script, made a new database with javadb. I can connect to it by gui - display the tables contents etc, but when i run an application with: EntityManager em = Persistence.…

Read More
How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. …

Read More
What is the easiest way to ignore a JPA field during persistence?

I'm essentially looking for a "@Ignore" type annotation with which I can stop a particular field from being persisted. How can this be achieved?

Read More