This project has the objective to read any Blob file of a database.
It extracts the blob object, deserializes it and saves it into the file system.
It is developed using Java 7 and maven.
1a. Once the blob is read from database it needs to be cast to some object. So put all necessary jars in /src/main/resources/jars/. Then execute: mvn eclipse:eclipse.
1b. Another option is to do a maven build (mvn clean install), which will generate a BlobReader-dist.zip. Unzip it and put all needed jars in /jars/
-
Update the files:
- /src/main/resources/config/db.properties - set your database connection details
- /src/main/resources/config/sql_statement.properties - set the query used to retrieve the blob file as described in the file itself
-
Execute the project throught the IDE (Eclipse for example) if step 1a was followed or trough the .CMD/.SH generated if you used step 1b.
- It extracts the blob and saves it to the filesystem successfully.
- The blob is saved in two files. One in XML format and other in JSON format.