#13 Copy failed - NULL

[cleversoft]

I've tried to copy from a sybase ASE 15 Server (source) to a second ASE 15 Server (destination) both being JDBC connected using the database owner's account. Squirrel was running on a third client being different from both RDBMS servers.

On the destination host I created an empty database ant then tried to copy the tables from the source host. After ~ half an houre everything nearly completed and the copy process died with a message like "Copy failed - NULL".

Involved Systems: All thre hosts running fedora core Linux. The Host running squirrel has:

[root@ejbsvn ~]# uname -a
Linux ejbsvn.mi.hdm-stuttgart.de 2.6.18-1.2849.fc6 #1 SMP Fri Nov 10 12:45:28 EST 2006 i686 athlon i386 GNU/Linux
[root@ejbsvn ~]# java -version
java version "1.5.0_08"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_08-b03)
Java HotSpot(TM) Client VM (build 1.5.0_08-b03, mixed mode, sharing)

I just installed the current Squirrel release with DB copy plugin selected. The starting messages in the logfile somewhat scare me but I didn't find any hint to install additional libraries (like hibernate) myself.

[cleversoft]

bzip'ed squirrel logfile

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Thank you for reporting this and providing the log. The stack trace indicates that it was attempting to create a table when it encountered a NullPointerException. It's not immediately apparent to me why the ResultSet it is dereferencing would be null at this point. I need to be able to reproduce this to discover why. My test cases don't yield the same issue with 2.3.2 for my local Sybase (AES 15). So if you would indulge me with a bit more info, I would be happy to spend additional time investigating this. If you look at the target database (refresh the object tree list under the catalog or schema(dbo)), you will see the tables that were copied successfully. They are copied in the order that they are listed in the tree in the source database, so the table that failed will most likely be the one after the last table copied successfully in the target database tree. Can you provide for me the create statement for that table definition? Alternatively, could you turn on debugging and perform the same copy operation (just the first table that failed should be fine)? To turn on debugging you need to edit the file log4j.properties and replace "info" with "debug" in the last line:

log4j.rootLogger=info, SquirrelAppender

becomes:

log4j.rootLogger=debug, SquirrelAppender

Rob