Re: Derby Error message - explanation required
Bob M rgmatth...@orcon.net.nz writes: Hi It seems that I do NEED to delete this temporary folder before each opening of the database As I am very unsure of derby coding would somebody care to suggest what I need to add and where to add it? Hi Bob, Since Derby fails because it is not able to access the tmp directory, I think it's likely that your likely that your application will run into the same problems when trying to delete it, so it might be better to see if you can find out why it cannot be accessed and fix the underlying problem. I would first have checked the permissions of the tmp directory and the database directory to see if there's something there that prevents the application from accessing the directory. I'm assuming that if you add the following to your application File f = new File(C:/Program Files/Derby Database/us_copiosus/tmp); System.out.println(f.list()); it will print null (since that's essentially what Derby does when it gets the NPE). That doesn't tell us much about why the directory cannot be accessed, though. Using NIO to access the directory might provide you with an IOException that has more details. For example, you could add this line and see if/how it fails: java.nio.file.Files.newDirectoryStream(f.toPath()); Hopefully, that will give you some clues. -- Knut Anders
Another error to be explained
Hi Error Message:- SQLException: SQL State: XSDG3 Error Code: 45000 Message: Meta-data for unknown could not be accessed to read: C:\\us_copiosus\seg0\c510.dat SQLException: SQL State: XJ001 Error Code: 0 Message: Java exception: 'C:\...us_copiosus\seg0\c510.dat (Access is denied):java.io.FileNotFoundException'. What does this error mean? Bob M Dunedin New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: Derby Error message - explanation required
Hi Knut Thanks for your help With respect to my latest error (see new post) I have just spotted a derby.log file in my Derby Database folder but I am unable to open it - Access is denied. I will try your pieces of code when I get some traction again :) Bob M Dunedin New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Derby-Error-message-explanation-required-tp142183p142335.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: Another error to be explained
To me it is pretty self-explaining. One of the required files of your database directory is missing. c510.dat. On 22 September 2014 20:50, Bob M rgmatth...@orcon.net.nz wrote: Hi Error Message:- SQLException: SQL State: XSDG3 Error Code: 45000 Message: Meta-data for unknown could not be accessed to read: C:\\us_copiosus\seg0\c510.dat SQLException: SQL State: XJ001 Error Code: 0 Message: Java exception: 'C:\...us_copiosus\seg0\c510.dat (Access is denied):java.io.FileNotFoundException'. What does this error mean? Bob M Dunedin New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334.html Sent from the Apache Derby Users mailing list archive at Nabble.com. -- Peter Ondruška
Re: Another error to be explained
Access denied, could be antivirus or permission or attributes rendering file inaccessible. On Monday, 22 September 2014, Bob M rgmatth...@orcon.net.nz wrote: Sorry, but it is NOT missing! Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334p142338.html Sent from the Apache Derby Users mailing list archive at Nabble.com. -- Peter Ondruška
Re: Another error to be explained
Hi Peter Permission or attributes - maybe. Could you spell out how I check these? What puzzles me is that I did have my application working at an earlier stage and I am having difficulty understanding why I am now getting a series of error messages Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334p142340.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: Another error to be explained
Hi Bob, The Derby program relies on files that make up a Derby database to get created in a certain way, and for those files to remain untouched by other programs or actions. It seems something has interfered with your database. We have no way of telling what that is/was - only you can do this by diligently checking your system and your application. Did you recently change the funcionality? Did your system experience any kind of malfunction? (check the windows event logs). I can think of programs such as encryption tools, security programs, or manual efforts (accidental or not) that could mess with file permissions/ownership (which is what the error message seems to suggest). One thing you can do, is check on the permissions of each file. You can look up how to do this by a search for your OS in your favorite search engine. Judging by the c:/ reference you are on some MS-Windows OS. If you have a shell tool like cygwin you could do 'ls -al'. Otherwise, the only way I know is to check on each file using windows explorer - checking on 'properties' for each file and opening the 'security' tab. Perhaps your search engine finds a more efficient way. You're looking to compare the file ownership and permissions. They should all be the same for all the .dat files. Another check you can do is the consistency check ( http://wiki.apache.org/db-derby/DatabaseConsistencyCheck). Although I suspect this will pop the same file. For more information about corrupted databases, see: https://wiki.apache.org/db-derby/DatabaseCorruption. HTH, Myrna On Mon, Sep 22, 2014 at 1:23 PM, Bob M rgmatth...@orcon.net.nz wrote: Hi Peter Permission or attributes - maybe. Could you spell out how I check these? What puzzles me is that I did have my application working at an earlier stage and I am having difficulty understanding why I am now getting a series of error messages Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334p142340.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: Another error to be explained
Hi Myrna Thanks for your input.. I am running Windows 7, Home Edition on a HP Pavilion dv7 laptop Derby version is 10.11.1.1 Database name is us_copiosus Security Properties: Me - allow full control/modify/read execute/list/read/write Admin - no permissions listed - i.e. completely blank Sub-folder seg0:- similar to the above except the 'ticks' are gray - not solid black as above ?? sub-file c510.dat only Admin listed - not me Admin - all permissions ticked in black...OK I note that this file is 996KB - which is large c.f. many others which are 8KB Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334p142343.html Sent from the Apache Derby Users mailing list archive at Nabble.com.