This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 187500 - Java DB Database not getting connected from command prompt
Summary: Java DB Database not getting connected from command prompt
Status: RESOLVED INCOMPLETE
Alias: None
Product: serverplugins
Classification: Unclassified
Component: GlassFish (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 normal (vote)
Assignee: Vince Kraemer
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-11 23:35 UTC by runa
Modified: 2010-12-21 20:38 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description runa 2010-06-11 23:35:22 UTC 
Entering this for external customer from the Sun Developer Expert Assistance
program:


Trying to create a database in Javadb. Created a database and table using Netbeans 6.5.1

Now wanted to connect glassfish v2ur2 and javadb database from command prompt

Tried the following commands:

Start Glassfish v2ur2 server:
D:\Program Files\glassfish-v2ur2\bin>asadmin.bat start-domain domain1

Start Java DB database:
D:\Program Files\glassfish-v2ur2\bin>asadmin

asadmin> start-database --dbhome "D:\Documents and Settings\Runa\.netbeans-derby"

I get a message:
Starting database in the background.
Log redirected to D:\Documents and Settings\Runa\.netbeans-derby\derby.log.
Command start-database executed successfully.

But when I go admin console and ping JNDI name I get the following error:

Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'WEB', see the next exception for details.
        at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
        at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown Source)
        at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
        at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
        at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
This happens when a new database is created and not for bundled database.

But if I use Glassfish v2.1 then the database is getting connected.
Comment 1 Vince Kraemer 2010-06-12 05:28:13 UTC 
This reads like a server side issue... why do you think it should be logged against the IDE?

What is the 'next exception' in the log?  I think it will have important details for analysis and resolution.

You should probably open a server issue and work through this from that angle.
Comment 2 Vince Kraemer 2010-12-21 20:38:35 UTC 
it looks like this is a dead incomplete issue.

please reopen with more details if you are still running into a problem