I think what you are saying is that you have a list of keys with which to access the entry in table TIDBLOB via a Portal/J panel?
I’m unaware of a good method of driving Portal/J panels. I’ve not heard of anyone coming up with a low cost method of being able to open a P/J panel, via say an URL link and then drive the panel.
The best I’ve seen is a product called Mercury LoadRunner which intercepts communications at socket level. It’s a steep learning curve and expensive to maintain. It’s suitable for a software company.
=====
Suggest an approach of accessing the database and not using Portal/J.
Get the OLE_OBJECT_ID. Having the OLE_OBJECT_ID, it is possible to read the OLE from TIDBLOB using readBlob.java and write it to a file. Getting the OLE_OBJECT_ID from various panels is very different; you’ll end up with several different SQLs.
I’m going to assume the OLE is embedded (OLE_OBJECT_TYPE = ‘b’), otherwise you’d have the files. A hex editor can be used to add 2 bytes (1F 9D) at the beginning of the file and then use Unix uncompress to decompress the data. It’s also possible to modify (remove the check for the magic number of 1F 9D) and use UncompressInputStream.java to decompress the file.
After the data has been read from TIDBLOB.OLE_OBJECT_BLOB and decompressed, you should have a file containing an OLE that can be opened via the application accessed via Portal/J and the Windows registry given TIDOBLOK.OLE_OBJECT_CLASS (example Word.Document.8). That is, once you have an OLE in a file that contains a Word doc, it can be opened using Word. I don’t know if it’s possible to untangle Portal/J and it’s usage of Native (Windows) services.
=======
Is MS Word used as the application for accessing the OLE’s? I’d be interested in hearing if it’s not MS Word or Excel.
I think what you are saying
I think what you are saying is that you have a list of keys with which to access the entry in table TIDBLOB via a Portal/J panel?
I’m unaware of a good method of driving Portal/J panels. I’ve not heard of anyone coming up with a low cost method of being able to open a P/J panel, via say an URL link and then drive the panel.
The best I’ve seen is a product called Mercury LoadRunner which intercepts communications at socket level. It’s a steep learning curve and expensive to maintain. It’s suitable for a software company.
=====
Suggest an approach of accessing the database and not using Portal/J.
Get the OLE_OBJECT_ID. Having the OLE_OBJECT_ID, it is possible to read the OLE from TIDBLOB using readBlob.java and write it to a file. Getting the OLE_OBJECT_ID from various panels is very different; you’ll end up with several different SQLs.
I’m going to assume the OLE is embedded (OLE_OBJECT_TYPE = ‘b’), otherwise you’d have the files. A hex editor can be used to add 2 bytes (1F 9D) at the beginning of the file and then use Unix uncompress to decompress the data. It’s also possible to modify (remove the check for the magic number of 1F 9D) and use UncompressInputStream.java to decompress the file.
After the data has been read from TIDBLOB.OLE_OBJECT_BLOB and decompressed, you should have a file containing an OLE that can be opened via the application accessed via Portal/J and the Windows registry given TIDOBLOK.OLE_OBJECT_CLASS (example Word.Document.8). That is, once you have an OLE in a file that contains a Word doc, it can be opened using Word. I don’t know if it’s possible to untangle Portal/J and it’s usage of Native (Windows) services.
=======
Is MS Word used as the application for accessing the OLE’s? I’d be interested in hearing if it’s not MS Word or Excel.