error 42Y55

[sridhar devatha]

hi,

I set up network derby server on my local machine(win xp pro sp3).
I started the server in one command window.
I started accessing the data base from another command window using ij.
I  am not using embedded mode.
I have few tables in my schema.
I am unable to drop only one user table.
But, i am able to drop all other user tables.
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'currentassets' because it does not exist.

How can I create a database in a different directory other than home directoy.
i am unable to start the network server using derbyrun.jar and derbynet.jar
I am only able to start the database using batch file.

I am unable to retain the responses in my inbox.
Please help.
--

Yours Sincerely,
Sridhar

[Bryan Pendleton]

> I started accessing the data base from another command window using ij.
> *I am unable to drop only one user table.*
> /_But, i am able to drop all other user tables._/

What does "show tables" say?

bryan

[devathasridhar]

Hi kathey marsden,

Thank you very much. You are absolutely correct. As a new derby user, I may have accidentally created the table in the default schema(APP). Please add these issues and solutions in a common  place. So that we prevent the traffic to derby user.

Hi Bryan Pendleton,
That command only lead me to the above solutions.  Thank you very much Bryan.

Regards,
Sridhar


--- On Sat, 4/7/09, Kathey Marsden <kmarsdenderby@...> wrote:

> From: Kathey Marsden <kmarsdenderby@...>
> Subject: Re: Error 42Y55
> To: "Derby Discussion" <derby-user@...>
> Date: Saturday, 4 July, 2009, 7:43 PM
> Peter Ondruška wrote:
> > Perhaps you want to use:
> >
> > drop table "tableName"
> >
> > On Sat, Jul 4, 2009 at 8:10 AM, sridhar devatha <devatha.sridhar@...
> <mailto:devatha.sridhar@...>>
> wrote:
> >
> >     Hi,
> >
> >     I am getting the
> >     ij> drop table tableName;
> >     ERROR 42Y55: 'DROP TABLE'
> cannot be performed on 'tableName'
> >     because it
> >     does not exist.
> >
> The default schema corresponds to the name of the user that
> connected (or APP if there is no user). Perhaps your table
> is in a different schema. If you created the table as USER1
> and are now connected as USER2, you may want to try ij>
> drop table USER1.TABLENAME;
>
> Kathey
>
>

      See the Web's breaking stories, chosen by people like you. Check out Yahoo! Buzz. http://in.buzz.yahoo.com/

[devathasridhar]

peter, thanks for trying to help me.

--- On Sat, 4/7/09, Peter Ondruška <peter.ondruska@...> wrote:

> From: Peter Ondruška <peter.ondruska@...>
> Subject: Re: Error 42Y55
> To: "Derby Discussion" <derby-user@...>
> Date: Saturday, 4 July, 2009, 11:51 AM
> Perhaps you want to use:
> drop table "tableName"
>
> On Sat, Jul 4, 2009 at 8:10 AM,
> sridhar devatha <devatha.sridhar@...>
> wrote:
>
> Hi,
>
> I am getting the
> ij> drop table tableName;
> ERROR 42Y55: 'DROP TABLE' cannot be performed on
> 'tableName' because it
>
> does not exist.
> ij> exit
>
> But, the table exists.
>
> I verified using sys.systables.
> what could be the reason.
> I am using netbeans to generate hibernate mappings.
> I also open command windows for server and another for
> connecting through ij  apart from netbeans.
>
>
> I closed netbeans. I restarted the server. Tried to drop
> the table. Still I am getting the same error.
> any body please help.
> --
>
> Yours Sincerely,
> Sridhar
>
>
>
>

      Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com