Re: User Defined Type as Table Column

2014-11-27 Thread kosurusekhar
Hi Rick, Thanks for the reply. Actually I have another column which we are using as foreign key, so index issue may not be occur. I will be do all kind of operations based this column. My doubt is I read in derby sites that, Blob columns will bit slower to delete. I hope these UDT's also kind of

Re: User Defined Type as Table Column

2014-11-27 Thread Rick Hillegas
On 11/27/14 3:56 AM, kosurusekhar wrote: Hi folks, We decided to create a table column with User Defined Type (A java class has big byte array& certain other properties), Is there any issues or any problems (performance side) while doing insert / update / delete into or from this table? If any

Re: Locks on crashed database

2014-11-27 Thread Peter Ondruška
Dear Knut, many thanks for the tip. For others who need something similar here is the complete code: package xarecovery; import java.sql.SQLException; import java.util.logging.Level; import javax.sql.XAConnection; import javax.sql.XADataSource; import javax.transaction.xa.XAException; import ja

User Defined Type as Table Column

2014-11-27 Thread kosurusekhar
Hi folks, We decided to create a table column with User Defined Type (A java class has big byte array & certain other properties), Is there any issues or any problems (performance side) while doing insert / update / delete into or from this table? If any body come across this kind of scenario mea