persistence@glassfish.java.net

Re: Java2DB error message

From: Marina Vatkina <Marina.Vatkina_at_Sun.COM>
Date: Sun, 26 Feb 2006 12:23:19 -0800

Hi Sahoo,

Please file a bug.

thanks,
-marina

Sanjeeb Kumar Sahoo wrote:
> Pramod & the team,
>
> I have started to see that we are just printing the error code and not
> the error text. e.g. I got the following message in my console while
> trying to deploy with --dropandcreatetables=true:
>
> JDO76614: Deployment encountered SQL Exceptions:
> JDO76609: Got SQLException executing statement "DROP TABLE
> USERCREDENTIAL": org.apache.derby.client.am.SqlException: DERBY SQL
> error: SQLCODE: -1, SQLSTATE: XSAI2, SQLERRMC: 10560XSAI2.S
> JDO76614: Deployment encountered SQL Exceptions:
> JDO76609: Got SQLException executing statement "CREATE TABLE
> USERCREDENTIAL (NAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(255),
> PRIMARY KEY (NAME))": org.apache.derby.client.am.SqlException: DERBY SQL
> error: SQLCODE: -1, SQLSTATE: X0Y32, SQLERRMC:
> Table/ViewUSERCREDENTIALSchemaAPPX0Y32.S
>
>
> 1. I don't understand what this error means. If I were a SQL expert, I
> probably would not use Java Persistence. So for users like me, it is a
> bit unfriendly to refer to database manual.
>
> 2. I was able to use my application successfully. Now I see them not
> working. Is anything broken in Java2DB recently? If, is there a bug?
>
> Thanks,
> Sahoo