public class XMLDBAccess extends DBAccess
Constructor and Description |
---|
XMLDBAccess() |
Modifier and Type | Method and Description |
---|---|
boolean |
createXMLTypeTable(java.sql.Connection con, java.lang.String tablename)
Create an XMLType table
|
java.sql.Clob |
getXMLTypeClob(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname)
Retrieve text file from an XMLType table
|
java.lang.String |
getXMLTypeData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname)
Retrieve text file from an XMLType table
|
java.lang.String[] |
getXMLTypeTableNames(java.sql.Connection con, java.lang.String tablePrefix)
Get all XML tables with names starting with a given string
|
java.sql.Clob |
getXMLTypeXPathCLOB(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xpathexp)
Retrieve the Clob data based on the XPATH expression from an XMLType table
|
java.lang.String |
getXMLTypeXPathTextData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xpathexp)
Retrieve the text data based on the XPATH expression from an XMLType table
|
boolean |
insertXMLTypeData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xmldata)
Inserts text file as a row in an XMLType table
|
boolean |
isXMLTypeTable(java.sql.Connection con, java.lang.String tablename)
Check if the table is an XMLType table.
|
boolean |
replaceXMLTypeData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xmldata)
Replace text file as a row in an XMLType table
|
createBLOBTable, createXMLTable, deleteBLOBName, deleteXMLName, dropBLOBTable, dropXMLTable, getBLOBData, getNameSize, getXMLData, getXMLNames, getXMLTableNames, insertBLOBData, insertXMLData, isXMLTable, replaceXMLData, xmlTableExists
public boolean isXMLTypeTable(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttableName
- - the table name to be testedjava.lang.Exception
public java.lang.String[] getXMLTypeTableNames(java.sql.Connection con, java.lang.String tablePrefix) throws java.lang.Exception
con
- - the Connection objecttablePrefix
- - table prefix stringjava.lang.Exception
public boolean createXMLTypeTable(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namejava.lang.Exception
public boolean insertXMLTypeData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xmldata) throws java.sql.SQLException, java.io.IOException, java.lang.NoClassDefFoundError
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namexmldata
- - string with the file datajava.sql.SQLException
java.io.IOException
java.lang.NoClassDefFoundError
public boolean replaceXMLTypeData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xmldata) throws java.lang.Exception, java.lang.NoClassDefFoundError
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namexmldata
- - string with the file datajava.lang.Exception
java.lang.NoClassDefFoundError
public java.lang.String getXMLTypeData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname) throws java.sql.SQLException
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namejava.sql.SQLException
public java.sql.Clob getXMLTypeClob(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname) throws java.sql.SQLException
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namejava.sql.SQLException
public java.lang.String getXMLTypeXPathTextData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xpathexp) throws java.sql.SQLException
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namexpathexp
- - XPATH expression to search the XML documentjava.sql.SQLException
public java.sql.Clob getXMLTypeXPathCLOB(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xpathexp) throws java.sql.SQLException
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namexpathexp
- - XPATH expression to search the XML documentjava.sql.SQLException