[OFBiz] Users - Derby adding a primary-key field

[David E. Jones]

You need to drop and recreate the primary key constraint (and  
possibly the pk index as well). There is functionality to do this for  
all tables in the Check/Update Datasource page in WebTools. This is  
for all databases, not just Derby.

For Derby you can connect to it through any JDBC-aware database GUI  
tool, and there are lots of them. Just make sure you have the path to  
the database files correct...

-David


On May 24, 2005, at 11:18 AM, Si Chen wrote:

> Hello everyone.
>
> This morning I had a problem with Derby when I added a new primary  
> key field to a table.  The entity engine recognized the additional  
> primary key, but Derby apparently did not change its table  
> definition, so attempts to add data to the table all failed.  I had  
> to create a new Derby database and re-install all the data, which I  
> know is not a good practice. :-)
>
> Is there a way to go into Derby manually somehow and change the  
> table definitions mark the additional field as a primary key field?
>
> Si
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2363 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/users/attachments/20050524/99c55a70/smime.bin