XSDB0Unexpected exception on in-memory page

Hello, When my derby database got out of memory, and when I restart the db. it got the exception like the following: any idea how to solve the problem? ERROR XJ040: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'mydb', see the next exception for details.::SQLST

Re: ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1313))

Hi Narayanan, Yes I have seen those links already. I have spent quite a bit of time confirming that my hardware is not at fault before posting here. I think you'll agree to see exactly the same page number failing on 3 separate machines lends itself more to being a software issue than a har

Update Substring of a field

Is it possible to update the substring of a field? I'm trying to do something like this: UPDATE tblIntervals SET SessionMouseID = 'ggg', substr(SessionID, 0, 3) = 'ggg' WHERE SessionMouseID = 'bbb'

Re: Updating a Substring in a Field

Hi, Derby does not have a built in function that would enable you to do that, but I think it should be simple enough to write one using the instructions and the samples provided here http://wiki.apache.org/db-derby/DerbySQLroutines Narayanan Reginald Johnson wrote: Hello, Does Derby have

Re: ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1313))

Hi David, You might find the following links containing earlier discussions on the similar issue useful, http://www.nabble.com/invalid-checksum-tt9528741.html#a9528741 http://www.nabble.com/Derby-crash-%28urgent%29-tt16217446.html#a16265491 https://issues.apache.org/jira/browse/DERBY-2475 N

Updating a Substring in a Field

Hello, Does Derby have a built in function that would allow me to do an SQL query to update a substring, something like this: UPDATE TABLE1 SET SUBSTRING(FieldName, original-substring, new-substring) WHERE FIELD1 = 'moose'

Re: Derby and Lucene

Mag Gam wrote: Has anyone been able to integrate Lucene with Derby? I know there was discussions about this several years ago, just wondering where it ended... There are two related DERBY issues: https://issues.apache.org/jira/browse/DERBY-590 https://issues.apache.org/jira/browse/DERBY-472 htt

Derby and Lucene

Has anyone been able to integrate Lucene with Derby? I know there was discussions about this several years ago, just wondering where it ended... TIA

Re: Derby get-together at Java One

Knut Anders Hatlen wrote: Rick Hillegas <[EMAIL PROTECTED]> writes: I suspect that a lot of Derby users and developers will be in San Francisco for Java One this year (May 6-9, http://java.sun.com/javaone/sf/). This would be a great opportunity to get together, connect faces with names, and ge