NetBeans Forums

 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
  

Derby: Unable to connect. Cannot establish connection to <derby databas url>

 
Post new topic   Reply to topic    NetBeans Forums -> NetBeans Users
View previous topic :: View next topic  
Author Message
theunsheydenrych



Joined: 02 Feb 2009
Posts: 31
Location: South Africa

PostPosted: Fri Feb 05, 2010 1:56 pm    Post subject: Derby: Unable to connect. Cannot establish connection to <derby databas url> Reply with quote

I would appreciate it if somebody can give me explanation of what
happend with my derby database.

The database was operational for sometime without any troubles, and was
behaving. Today i removed a record from a table by using the "Delete
Selected Record(s)" button from the SQL Command page in Netbeans.
I may had finger trouble and used the "Truncate Table" button.

But all of a sudden the table disappeared from the list, i decided then
to close everything and try to connect again, where i get the following
message:

"Unable to connect. Cannot establish a connection to <derbydb url> using
org.apache.derby.jdbc.Clientdriver(DERBY SQL Error: SQLCODE: -1,
SQLSTATE XJ040, XSQLERRMC: Failed to start database <derbydb url>. see
the next exception for more details"

While playing around trying to get the database back online again, i
noticed that when setting up a jdbc:derby network connection, that when
the wizard ask to select a schema from the database, it by default
choose the "APP" schema and my schema is not available in the list.

I then renamed the database folder, of the database, set a new
jdbc:derby connection up to the database and all of a sudden my schema
is available, and everything is back to normal again.

What happened?
1. After a truncate of a table, the schema is gone?
2. After renaming the database folder, the schema is back?

Regards
Theuns Heydenrych
Back to top
Display posts from previous:   
Post new topic   Reply to topic    NetBeans Forums -> NetBeans Users All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB
By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo