Re: Why close ResultSet PreparedStatement?

2008-11-29 Thread Mark Thornton
Amir Michail wrote: Hi, Is there any point in calling the close method on ResultSet and the close method of PreparedStatement? Amir You might later change the database to one where it matters much more. Mark Thornton

Re: out of memory even though process size is small

2008-11-29 Thread Amir Michail
On Sat, Nov 29, 2008 at 2:03 AM, Amir Michail [EMAIL PROTECTED] wrote: Hi, jsvc virt size is only 339m even though I specified it to be 1800m: export CATALINA_OPTS=-Xms1800m -Xmx1800m Please ignore. I fixed the memory problem by modifying the /etc/init.d/tomcat5.5 script. Amir Could

ORDER BY and greek characters

2008-11-29 Thread tom_
I'm using ORDER BY and a database with collation territory based de_DE. Strings starting with greek characters are at the end of the resultset. Users would expect them near the respective latin character, e.g. greek alpha near a. Is there a possiblity to sort in this way? -- View this message

RE: Why close ResultSet PreparedStatement?

2008-11-29 Thread derby
Amir Michail wrote: Hi, Is there any point in calling the close method on ResultSet and the close method of PreparedStatement? Amir You might later change the database to one where it matters much more. Mark Thornton Huh? I'm sorry but your answer doesn't make any sense.