recovering JavaDB sample database

[Natalya Portnov]

Accidentally deleted JavaDB Sample database. 

Tried to reinstall NetBeans with JavaEE modules and reinstalled glassfish but cannot get it back.

Now I manually create tables & data for each exercise but it makes it slow to move through the Java EE programming Labs.

Please help with detailed instructions on how to recover the sample database.

Thank you,

Natalya

[Sang Shin]

Can you tell us which JavaDB sample database are you referring to?

-Sang

Thank you,

Natalya

--
You received this message because you are subscribed to the Google Groups "JPassion.com: Java EE 6 and 7 Programming" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jpassion_javae...@googlegroups.com.
Visit this group at https://groups.google.com/group/jpassion_javaee6.
For more options, visit https://groups.google.com/d/optout.

-- 
-------------------------------------------------------------------
             Sang Shin, sangshi...@gmail.com
  President and Chief Instructor of JPassion.com (JavaPassion.com)
         http://www.linkedin.com/in/javapassion (Linkedin)
          http://twitter.com/javapassion (Tweeter)
            Life is worth living... with Passion!
    
   Practically Free 3 to 5 days Live, Hands-on, Online Codecamps on
 Java,Spring,Hadoop,HTML5,Ruby/Rails,Grails,JavaScript/jQuery,Android
             http://jpassion.com/codecamps       
----------------------------------------------------------------------

[Richard Grin]

Hi Natalya,

Perhaps this link http://code.metager.de/source/xref/netbeans/derby/etc/sample.sql will help you (temporarily out of order at this time): it contains a script to create a new sample database.

Another way: when you install NetBeans again, you delete first (before the installation) the directory of the database in .netbeans.derby.

This link can be helpful too: https://netbeans.org/bugzilla/show_bug.cgi?id=248822.

Richard

[Natalya Portnov]

Still no answer. Maybe because I Replied instead of Replying to All.

Trying again:

It is used through exercises in Java EEProgramming/JPA Query Lab.

There is a note copied/pasted below in Java EEProgramming/JPA Query Lab but that did NOT work for me.

 Trouble-shooting:  If you don't see the MANUFACTURER nor PRODUCT_CODE tables, it is beause the samples database has not been installed with the Java DB. (If you have downloaded and installed "NetBeans with Java EE modules", the samples database should have been installed automatically.)  Now, what you can do is to install "Database" module to the NetBeans and it should install "samples" database.

[Sang Shin]

On 2/23/2016 7:53 AM, Natalya Portnov wrote:

Still no answer. Maybe because I Replied instead of Replying to All.

Trying again:

Did you see the response from Richard on this?  He mentioned
the following link

  http://code.metager.de/source/xref/netbeans/derby/etc/sample.sql

You can run samples.sql mentioned above to create sample tables.

-S

[Natalya Portnov]

Great! Thank you for your help!