<model name="file"> <source name="file" translator-name="file-override" connection-jndi-name="java:/file"/> </model> <translator name="file-override" type="file"> <property name="Encoding" value="ISO-8859-1"/> <property name="ExceptionIfFileNotFound" value="false"/> </translator>
The file translator, known by the type name file, exposes stored procedures to leverage file system resources exposed by the File Data Source and the FTP Data Source. It will commonly be used with the TEXTTABLE or XMLTABLE table functions to use CSV or XML formatted data.
The encoding that should be used for CLOBs returned by the getTextFiles procedure. The value should match an encoding known to the JRE.
The system default encoding
Throw an exception in getFiles or getTextFiles if the specified file/directory does not exist.
true (false prior to 8.2)
|See override an execution property and the example below to set the properties.|
VDB XML Override Example
getFiles(String pathAndPattern) returns TABLE(file blob, filePath string, lastModified timestamp, created timestamp, size long)
Retrieve all files as BLOBs matching the given path and pattern.
If the path is a directory, then all files in the directory will be returned. If the path matches a single file, it will be returned.
The '*' character will be treated as a wildcard to match any number of characters in the path name - 0 or matching files will be returned.
If '*' is not used and the path doesn’t exist and ExceptionIfFileNotFound is true, then an exception will be raised.
getTextFiles(String pathAndPattern) returns TABLE(file clob, filePath string, lastModified timestamp, created timestamp, size long)
|the size reports the number of bytes|
Retrieve all files as CLOB(s) matching the given path and pattern.
All the same files a getFiles will be retrieved, the only difference is that the results will be CLOB values using the encoding execution property as the character set.
Save the CLOB, BLOB, or XML value to given path
call saveFile('path', value)
Delete the file at the given path
The path should reference an existing file. If the file does not exist and ExceptionIfFileNotFound is true, then an exception will be thrown. Or if the file cannot be deleted an exception will be thrown.
NOTE： Native queries - Native or direct query execution is not supported on the File Translator.
JCA Resource Adapter
The resource adapter for this translator provided through "File Data Source", Refer to Admin Guide for configuration information.