Be the first to post a text review of oracle-jutils. Rate and review a project by clicking thumbs up or thumbs down in the right column.

View all reviews

• Project Information Updated

  adriens changed the public information on the oracle-jutils project

  posted by adriens 156 days ago

• oracle-jutils birthday with first 100 downloads

  After some months, we finally reach 100 downloads. It's modest but it does indeed mean that some people wanted to give ti a try. I don't know if you did like it. But if you did, i would very pleased t...

  posted by adriens 171 days ago

• oracle-jutils 13072009 file released: oracle-jutils_13072009.zip

  Mainly, in this release, i've added the LIST_FILES (to list directory contents in a relational way) pipelinded table function. So from now, we are able to list directory like : select * from table(LIST_FILES(iDirectory => 'H:\Incoming', ... And get in return the list of files with their properties (Last Modified Date, privileges, hash, mime types, ... and all the properties i could grap from Java) in a relational way. Have a look at the JDBMS_FILESYSTEM screenshots as the output is really cool : you can now make crossed reports between your os files and relational content thanks to a simple join. I've also started to implement JDBMS_FILESYSTEM package to interact with the filesystem from Oracle. Added LIST_FILES to list files in a directory in a relational way Added JDBMS_FILESYSTEM.get_file_name(file_absolute_path in NVARCHAR2) to extract the file name from the absolute path. Notice that it uses local OS file separator but does not require any directory read privilege. Added JDBMS_FILESYSTEM.get_file_path(file_absolute_path in NVARCHAR2) to extract the file name from the absolute path. Notice that it uses local OS file separator but does not require any directory read privilege.

  posted 176 days ago

• Screenshot Added

  adriens added a screenshot of JDBMS_FILESYSTEM : List directory contents from sql, ...

  posted by adriens 176 days ago

• New Release around JDBMS_FILESYSTEM

  This is it, we now can list OS directory contents from a pure SQL Table, in a relational way. You can then filter directory contents (based on regular exepression), to see files size, Last Modif Date, etc... but also, if requested, the hash you want (crc,...), and also the mimetype (based on file contents). This is the main feature, around the function list_files. Here is the function prototype : CREATE or replace FUNCTION LIST_FILES ( iDirectory IN NVARCHAR2, -- The full path to the directory you want to list iMatchStrIngRegExp IN NVARCHAR2 := NULL, -- The regular expression (NOT A WILDCARD) used to get the requested subset of files (NULL means all files). iJackSumAlgorithm IN NVARCHAR2 := NULL, -- The checksum algorithm (NULL means no hash computing) if you want to compute the hash on the fly (for example crc32), see VW_JACKSUM_ALGOS for complete supported list iJacksumEncodIng IN NUMBER := 8, -- The checksum (Jacksum separator). See ENCODINGs constants in JDBMS_JACKSUM package. iJacksumSeparator IN NVARCHAR2 := NULL, -- The checksum separator in case you want specific output format iJacksumFormat IN NVARCHAR2 := '#CHECKSUM', -- The checkum formatting, eg #CHECKSUM is the one people want (pure checskum in text string), have a look at test_JDBMS_JACKSUM.sql for advanced examples iJacksumGroupingIndex IN NUMBER := -1, -- See JDBMS_JACKSUM for more informations iJacksumGroupingSymbol IN NVARCHAR2 := NULL, -- See JDBMS_JACKSUM for more informations igetMimeType IN NUMBER := 0 -- Tells wether to get or not the Mime Type if the file (from its contents). 1 => Compute MimeType 0 => Do Not compute MimeType ) RETURN FILES_TYPE_SET PIPELINED USING FILES_TABLE_IMPL; / As always, examples are provided, but the use is very very easy. I've also added JDBMS_FILESYSTEM functions to extract file name (and path) from an absolute filename (no OS dir privilege required). All details are provided in documentation as well as screenshots and script examples. Have fun. Adrien

  posted by adriens 176 days ago

• File released: /oracle-jutils/13072009/oracle-jutils_13072009.zip

  posted 176 days ago

• New Release around zip(BLOB,..) and checksum

  JDBMS_COMPRESS : Added function that zips up to 10 BLOBS into a new BLOB. Have a look at test_JDBMS_COMPRESS.sql for more details. Completed the magic file with application/msoutlook mime type. Now Outlook messages will be recognized Changed JDBMS_CHECKSUM.get_CRC32(BLOB) beahviour : now JDBMS_CHECKSUM.get_CRC32(EMPTY_BLOB()) (same on a NULL types BLOB parameter) returns NULL instead of throwing an Exception (behaviour asked by developer as it finally makes more sense to get a null CRC than making a try/catch in client code). For each new release, since now, will add the method to patch oracle-jutils within a minimal number of steps (script is as generic as possible so you should be able to patch easily on linux, windows and other 'nix OS).

  posted by adriens 185 days ago

• File released: /oracle-jutils/05072009/oracle-jutils_05072009.zip

  posted 185 days ago

• oracle-jutils 30052009 file released: oracle-jutils_30052009.zip

  JDBMS_CHECKSUM : Added CRC32 computation on multiple input BLOBs (up to 10). So you are now able to compute CRC32 in single shot on multiple BLOBS (the CRC32 is sequentally updated with BLOB's bytes, null BLOBs are skipped during computation). I have implemented this feature because of a specific need in my job. I'll try to implement the same overload in JDBMS_JACKUSM package, it may be useful and more homegeneous. Updated test_JDBMS_COMPRESS with the grant to be able to test the LZMA compression function Updated JDBMS_JACKSUM with overloaded functions to make standard checkum computations simpler : now you can just provide the algorithm. The overload is available for BLOBs, filesystem file and text. The TEST_JDBMS_JACKSUM has been updated with code samples. Updated JDBMS_JACKSUM with checksum computation on up to 10 BLOBS in a single time (like in JDBMS_CHECKSUM in this same release). Overload for light version also provided (you can only provide the algorithm for shorter PL/SQL calls). You can compare the JDBMS_CHECKSUM and JDBMS_JACKSUM for crc32 algorithm, althouh the JDBMS_JACKSUM is much more complete but a bit slower (around 2 times slower). Completed the jmimemagic magic.xml file with chm mimetype. Hence, since now, JDBMS_JACKSUM will be able to detect chm files (from file or BLOB). Just reload the library to have this new mime type enabled, therefore just : loadjava -u OJUTILS/OJUTILS -resolve lib/jmimemagic-0.1.0.jar On this specific topic, help is welcome to enhance the magic.xml file with new mime types, such a donation would be greatly appreciated.

  posted 220 days ago

• Help wanted for magic mime type

  If you want to donate some time around magic's you are welcome. The donation would to help me improving the mime types detected thanks to mimemagic library to match more types in the JDBMS_MIMETYPES package. For more precisions, feel free to contact me.

  posted by adriens 220 days ago