SQLException - Column 'COLUMN2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification .....

Hello All, I am trying to import data from a csv file to a table using CALL SYSCS_UTIL.SYSCS_IMPORT_DATA with the following arguments - arg 1 - schema name (I tried using null as well but it gave me the same error message i.e. Column 'COLUMN2' is either not in any table in the FROM list or

Re: Upgrade from 10.6 to 10.7 failed

Hi again, sorry I got the wrong versions in my mind, the databases have been originally created using the 10.5.3 release of derby.. 2011/2/23 Andreas Weber senior.we...@gmail.com: Hi, I develop an application which used derby 10.6 and now I wanted to upgrade to 10.7.x - but I run into

Upgrade from 10.6 to 10.7 failed

Hi, I develop an application which used derby 10.6 and now I wanted to upgrade to 10.7.x - but I run into following error on startup of the database (no matter what application (my app, SQuirrel, OpenOffice base) I use, and with all databases I could find): Restore of a serializable or SQLData

Re: SQLException - Column 'COLUMN2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification .....

18 Feb 2011 18:17:35,218- Thread: 15 SEVERE [com.vontu.lookup.csv.CsvLookup] Failed to initialize Csv lookup. Cause: com.vontu.lookup.common.InitializationException: The exception 'java.sql.SQLException: Column 'COLUMN2' is either not in any table in the FROM list or appears within a join

Re: Upgrade from 10.6 to 10.7 failed

but I run into following error on startup of the database (no matter what application (my app, SQuirrel, OpenOffice base) I use, and with all databases I could find): Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored I'm not sure

Re: problem with timestampdiff

emchem emman...@chem.la writes: Hi, I needed to accomplish a simple task with Derby: computing an interval of days (like datedif in excel). I used the TIMESTAMPDIFF function, it seemed to work well, until I noticed a strange behaviour : sometimes the computation is OK, sometimes not. After

problems after could not listen on port xxx on host 0.0.0.0 / corrupting data base?

Hi, when trying to start-up the network server I am getting Could not listen on port 31540 on host 0.0.0.0: java.net.BindException: Address already in use (which is also the message store in derby.log). This is the last message in the log and I am not sure what state the server is in after

Re: problems after could not listen on port xxx on host 0.0.0.0 / corrupting data base?

Hi, This is a classic network exception. Someone else is using the port you are trying to bind derby to. You should use a tool suitable for determining who is already using that port on your operating system - probably something like netstat... /Morten On Wed, Feb 23, 2011 at 8:42 PM, Thomas Hill

Re: problems after could not listen on port xxx on host 0.0.0.0 / corrupting data base?

Hi Morten, thanks for your reply on the address already in user issue. The Network Server is hosted on the internet and my provider tells me that nothing else is using the port and their tests would indicate that - the normal (Linux) start/stop scripts coming with Derby are being used - when the

Re: problems after could not listen on port xxx on host 0.0.0.0 / corrupting data base?

Hi, I'm really no expert, but I would say there is not enough information here.. I know of no situations where you would get the 'address already in use' exception if the port is free. Perhaps the script used to start the network server occupies the port before starting the server, making the

Re: problem with timestampdiff

Knut Anders Hatlen-5 wrote: The problematic date seems to coincide with the switch to daylight saving time in Europe, so my guess would be that it's somehow related to that. Ok, with your hint, I've tried this workaround, successfully: In order to calculate correctly the difference