#14 CMap v0.16 Saving Links with Oracle

[Ben Faga]

NOTE: This patch is only needed if running CMap on an Oracle database.
Otherwise, don't bother.

This patch solves a problem where the session object that is saved when "saving a link" becomes corrupted. The solution is to change the column session_step_object to type blob in the table cmap_saved_link.

Files:

freeze_thaw_test.pl
- A test script to determine if your system is effected. It inserts a made up saved link into the database then retrieves it and checks if the object has been changed. (It deletes the saved link at the end so it won't pollute your db).

perl freeze_thaw_test2.pl -d CMAP_DATASOURCE

- If it prints "ok 1 - Extracted the same object as entered" then the system does NOT need this patch.

Oracle.080211.v0.16.sql
- Included as a warning that a column will have to be changed in the database. This is not a simple process and you may have to contact your database administrator for help.

Oracle.080211.v0.16.patch

- Patches Bio::GMOD::CMap::Data::Oracle to handle inserting of type blob.
Apply to .../CMap/Data/Oracle.pm

Thanks:

Baohua Wang for finding the problem, being patient and ultimately coming up the with the solution.

Greg Brown for help testing.

[Ben Faga]

Patch that fixes a problem saving links in Oracle