|
From: Jerry L. <ja...@sd...> - 2013-09-24 21:43:09
|
On 9/24/2013 12:22 PM, John Hardin wrote: > On Tue, 24 Sep 2013, Jerry Lampi wrote: > >> Hello. I have tried to create a backup sql script in SQuirrel SQL >> client version 3.5.0 by highlighting the table I want to backup and then >> right-clicking and choosing Scripts->Create Data Script, but I get his >> error in the console: >> >> Error: An unexpected exception was thrown >> SQLState: XSDA4 >> ErrorCode: -20001 >> Error: Java exception: >> '/sds/vftp/sdsdata/databases/LIVEDB/tmp/T1379953333954.tmp (Read-only >> file system): java.io.FileNotFoundException'. >> SQLState: XJ001 >> ErrorCode: 99999 >> >> The DB is not on my local PC. I am in session with it (of course). >> >> Any ideas on how to proceed? > > This doesn't sound like a problem in Squirrel. It's surprising that > your temporary directory appears to be on a read-only filesystem... > > I'm also assuming from the forward slashes in the path that this is a > POSIX platform, rather than Windows. > > What is your $TEMP environment variable set to? Does it match what's > in the error message above? > > If so, can you create a file there from the command line? Do you get > the same read-only filesystem warning? > > Does changing $TEMP (either set it to a different directory you know > you can write to then launch Squirrel from that command prompt, or set > $TEMP in the script that launches squirrel before it starts java) make > it work? > > the "vftp" in the path suggests to me a virtual remote filesystem. > That's probably not a greate idea for temporary files. > > I'm assuming a certain level of skill here; you may need to get a > local IT resource involved if what I'm saying doesn't make sense to > you. I'm also not too familiar with Java internals, I'm just taking a > stab in the dark based on what the error message suggests to a sysadmin. > > HTH. > I understand. To rule out file sharing and read-only access permissions, I have moved testing to my local PC. If I get it working locally, I will modify the remote system. Running locally, I get a different error. I right-click the table I want, choose Scripts->Create Data Script, and I get this error: Error: Invalid operation: wasNull() called with no data retrieved. SQLState: XJ088 ErrorCode: 20000 And only this much SQL generated: INSERT INTO "SDS_SFM"."FTP_TRANSFER" (REC_VERSION XJ088 seems to be a Derby error ( http://dba.fyicenter.com/guide/Derby-Reference-Manual/293_XJ088_Invalid_operation.html ). Since this is a Derby error, I suspect there is nothing that can be done in SQuirrel. Oh -- I have several tables. If the first column is defined as CHAR () FOR BIT DATA, then the Scripts->Create Data Script fails. If the first column in the table is not Scripts->Create Data Script, it succeeds. CHAR () FOR BIT DATA is okay, band gets output, but not if it is the first column in the table. Jerry --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 130924-1, 09/24/2013 Tested on: 9/24/2013 4:42:49 PM avast! - copyright (c) 1988-2013 AVAST Software. http://www.avast.com |
