Using CLOB in structure table

User dfeb81947d

07-01-2005 09:42:18

Hello everybody,





I'd like to use CLOB in structure table instead of LONG RAW.


So the only things I have to do is to replace LONG RAW by CLOB in create table SQL script?


Will JChemSearch and other Object will identify automatically the SQL.Type of the column or is there parameters I need to change.





Thanks a lot for your answer.


Regards,


Jacques





I'm using Jchem 3.0.4 with Oracle 9.2

ChemAxon 9c0afc9aaf

09-01-2005 16:04:29

Hi Jacques,





You can use both BLOB and CLOB for the type of the cd_structure column.





Yes, you only have to replace "LONG RAW" to "BLOB" or "CLOB" in the table creation dialog.





JChem classes will automatically recognize the column type, you do not have to worry about that.





The only potential problem with the CLOB type is a significant slowdown of the import process.


We still have to investigate this issue.


Until then I recommend using the BLOB type, which has no impact on import performance.





Szilard

User d1446528d1

14-01-2005 10:29:12

Thank you very much for your help, Szilard.


I will use BLOB instead of CLOB.


Kind regards.