Connection failure when client thread name contains Japanese characters

2010-03-15 Thread Brett Wooldridge
Just a note to the list so that user's searching for this issue via google might find this post. I have opened a bug (#4584), which is probably a duplicate of bug#728 so that other's may find it and save the hours I spent chasing it down. However, while related, it may not be a true duplicate of 72

Re: how to cascade on update? Not possible?

2010-03-15 Thread Sylvain Leroux
Hi, Just passing by: http://issues.apache.org/jira/browse/DERBY-735 Regards, - Sylvain Gabriele Kahlout a écrit : ya. Also SQLite does. I tried to look where to submit feature requests (not bug reports), but failed. Any links? 2010/3/16, Rick Genter : On 3/15/10 6:46 PM, "Ronald Rudy" wrot

Re: how to cascade on update? Not possible?

2010-03-15 Thread Gabriele Kahlout
ya. Also SQLite does. I tried to look where to submit feature requests (not bug reports), but failed. Any links? 2010/3/16, Rick Genter : > On 3/15/10 6:46 PM, "Ronald Rudy" wrote: > >> I believe you want to look at this: >> http://db.apache.org/derby/manuals/reference/sqlj32.html >> >>

Re: how to cascade on update? Not possible?

2010-03-15 Thread Rick Genter
On 3/15/10 6:46 PM, "Ronald Rudy" wrote: > I believe you want to look at this: > http://db.apache.org/derby/manuals/reference/sqlj32.html > > Specifically the > referential ON UPDATE in constraints. The only "ON UPDATE" actions that ar

Re: how to cascade on update? Not possible?

2010-03-15 Thread Ronald Rudy
I believe you want to look at this: http://db.apache.org/derby/manuals/reference/sqlj32.html Specifically the referential ON UPDATE in constraints. The only "ON UPDATE" actions that are allowed are "NO ACTION" and "RESTRICT"; Derby does not appear to support cascading updates. You can log a f

Re: how to cascade on update? Not possible?

2010-03-15 Thread Rick Genter
I'm not aware of any database that does this. I know that MS SQL Server does not. On 3/15/10 3:35 PM, "Gabriele Kahlout" wrote: > I was pretty convinced, that in an update if the referenced column is > updated so is the refererring. How can one achieve this behavior > automatically? -- Rick G

Re: how to cascade on update? Not possible?

2010-03-15 Thread Gabriele Kahlout
I was pretty convinced, that in an update if the referenced column is updated so is the refererring. How can one achieve this behavior automatically? 2010/3/15, Gabriele Kahlout : > Hello, > > I've moved my database from SQLite into Java DB using SQLWrapper. > I expected the references integrity c

how to cascade on update? Not possible?

2010-03-15 Thread Gabriele Kahlout
Hello, I've moved my database from SQLite into Java DB using SQLWrapper. I expected the references integrity constraint, to cascade on update. I.e. wColumn in refTable, references expColumn in expTable. Updating expColumn should update wColumn. However I get: java.sql.SQLIntegrityConstraintViolati

Re: How to set alg. used by BUILTIN auth..

2010-03-15 Thread Rick Hillegas
Hi Joe, This feature will be introduced in the upcoming feature release, 10.6. See the last item in the list of 10.6 features here: http://wiki.apache.org/db-derby/DerbyTenSixOneRelease Hope this helps, -Rick Joe Siebenmann wrote: Hi All, I read that Derby now allows you to set the alg. u

How to set alg. used by BUILTIN auth..

2010-03-15 Thread Joe Siebenmann
Hi All, I read that Derby now allows you to set the alg. used by the BUILTIN authentication, but I can't find details on how to use it anywhere. I'm using Embedded, Derby 10.5.30, and I need to know how to use it using: java -Dderby. type statements, and I'd like to use "SHA-256" or "SHA-512".

Re: Getting an attribute (the rid) of the affected tuples in an update

2010-03-15 Thread Knut Anders Hatlen
Gabriele Kahlout writes: > Hello, > > In my code, I often need to add a tuple to another relation, so that > I update another in another relation. Examine this code: > > private static int rescheduleObject(final String[] expDef, int batch, > final Statement st, ResultSet rs) throws SQLException,

Getting an attribute (the rid) of the affected tuples in an update

2010-03-15 Thread Gabriele Kahlout
Hello, In my code, I often need to add a tuple to another relation, so that I update another in another relation. Examine this code: private static int rescheduleObject(final String[] expDef, int batch, final Statement st, ResultSet rs) throws SQLException, Exception { final int