NetBeans Forums
| View previous topic :: View next topic |
| Author |
Message |
theunsheydenrych
Joined: 02 Feb 2009 Posts: 31 Location: South Africa
|
Posted: Fri Feb 05, 2010 1:56 pm Post subject: Derby: Unable to connect. Cannot establish connection to <derby databas url> |
|
|
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 |
|
 |
|
|
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
|
|