Satheesh Bandaram wrote: > Could this possibly lead to dead-locks? If someone is trying to create a > table and another trying to create a synonym could possibly block each > other. I have a feeling you have a better way to do this, so what is it?
No i don't have a better way to do this, I'm trying to understand how you implemented SYNONYNs, your e-mail has the functionality descibed but not the implementation. To quote an extract from: http://incubator.apache.org/derby/derby_comm.html#Contribute+Code+or+Documentation [quote] Post the patch to the derby-dev mail list or attach it to the Jira issue. Include the following information with your post: [snip] - A description of the changes, e.g. how a feature is implemented or why the change fixes a bug. Hopefully this will be in comments in the code but sometimes an overview in the e-mail is useful, or have the e-mail point to an overview in the code comments. [snip] [end-quote] I imagine this functionality could possibly be implemented using SYSTABLES and TableDescriptor or SYSALIASES and AliasDescritpor. I'm sure there would be different problems in each approach, it would be interesting to see your approach explained. Dan.
