Derby-134, indexes and sorting locale-sensitive / case insensitive

2005-04-22 Thread Joerg von Frantzius
Hi, there had been a long discussion of Derby-134 (Sorted string columns are sorted in a case sensitive way), which in the end looked to me as being solved, i.e. someone has supplied a good-looking patch. Now is there any chance of a binary build coming up in the near future, where this patch

Automatic database and schema creation

2005-04-22 Thread Peter Nabbefeld
Hello, I just want to create a database, if it does not yet exist. Database creation works, schema creation does not. I'm using the following syntax (in Java): Statement stmt = con.createStatement(); stmt.execute(CREATE SCHEMA USER); The result is an SQLException with SQLState = 42X01

Re: Automatic database and schema creation

2005-04-22 Thread Øystein Grøvlen - Sun Norway
Peter Nabbefeld wrote: Hello, I just want to create a database, if it does not yet exist. Database creation works, schema creation does not. I'm using the following syntax (in Java): Statement stmt = con.createStatement(); stmt.execute(CREATE SCHEMA USER); The result is an SQLException

Re: Automatic database and schema creation

2005-04-22 Thread Peter Nabbefeld
Thank You, it works now. Peter Øystein Grøvlen - Sun Norway schrieb: Peter Nabbefeld wrote: Hello, I just want to create a database, if it does not yet exist. Database creation works, schema creation does not. I'm using the following syntax (in Java): Statement stmt = con.createStatement();

Re: Derby-134, indexes and sorting locale-sensitive / case insensitive

2005-04-22 Thread TomohitoNakayama
Hello. I have implemented the patch for Derby-134, which you mentioned. The solution for Derby-134 in that patch was just only enabling use of expression like as UPPER(text_val) in order clause. As in next URL mentioned, index with expression is not supported yet, and I did'nt make it support

Re: Automatic database and schema creation

2005-04-22 Thread Jean T. Anderson
Jonathan Eric Miller wrote: snip / It's set to false by default. Supposedly, this will be changed when IBM releases the source code to the JDBC driver. Any word on when that's going to happen? There's activity on the derby-dev@db.apache.org list :