|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--oracle.xml.transviewer.DBAccess
Maintains CLOB tables that can hold multiple XML and text documents. Each table is created using the statement: CREATE TABLE tablename FILENAME CHAR( 16) UNIQUE, FILEDATA CLOB) LOB(FILEDATA) STORE AS (DISABLE STORAGE IN ROW). Each XML (or text) document is stored as a row in the table and the FILENAME field holds a unique string that is used as a key to retrieve, update or delete the row. The document text is stored in the FILEDATA field that is a CLOB object. This CLOB tables are automatically maintained by the transviewer bean. The CLOB tables maintained by this class can be later used by the transviewer bean. The class creates and deletes CLOB tables, list a CLOB table content and also add, replace or delete text documents in this CLOB tables.
Field Summary | |
protected int |
nameSize
|
Constructor Summary | |
DBAccess()
|
Method Summary | |
boolean |
createBLOBTable(java.sql.Connection con,
java.lang.String tablename)
Create BLOB table |
boolean |
createXMLTable(java.sql.Connection con,
java.lang.String tablename)
Create XML table |
boolean |
deleteBLOBName(java.sql.Connection con,
java.lang.String tablename,
java.lang.String xmlname)
Delete binary file from BLOB table |
boolean |
deleteXMLName(java.sql.Connection con,
java.lang.String tablename,
java.lang.String xmlname)
Delete file from XML table |
boolean |
dropBLOBTable(java.sql.Connection con,
java.lang.String tablename)
Delete BLOB table |
boolean |
dropXMLTable(java.sql.Connection con,
java.lang.String tablename)
Delete XML table |
byte[] |
getBLOBData(java.sql.Connection con,
java.lang.String tablename,
java.lang.String xmlname)
Retrieve binary file from BLOB table |
int |
getNameSize()
Returns the size of the field where the filename is kept. |
java.lang.String |
getXMLData(java.sql.Connection con,
java.lang.String tablename,
java.lang.String xmlname)
Retrieve text file from XML table |
java.lang.String[] |
getXMLNames(java.sql.Connection con,
java.lang.String tablename)
Returns all file names in XML table |
java.lang.String[] |
getXMLTableNames(java.sql.Connection con,
java.lang.String tablePrefix)
Gets all XML tables with names starting with a given string |
boolean |
insertBLOBData(java.sql.Connection con,
java.lang.String tablename,
java.lang.String xmlname,
byte[] xmldata)
Inserts binary file as a row in BLOB table |
boolean |
insertXMLData(java.sql.Connection con,
java.lang.String tablename,
java.lang.String xmlname,
java.lang.String xmldata)
Inserts text file as a row in XML table |
boolean |
isXMLTable(java.sql.Connection con,
java.lang.String tablename)
Check if the table is XML table. |
boolean |
replaceXMLData(java.sql.Connection con,
java.lang.String tablename,
java.lang.String xmlname,
java.lang.String xmldata)
Replace text file as a row in XML table |
boolean |
xmlTableExists(java.sql.Connection con,
java.lang.String tablename)
Checks if the XML table exists |
Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Field Detail |
protected int nameSize
Constructor Detail |
public DBAccess()
Method Detail |
public int getNameSize()
public boolean isXMLTable(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttableName
- - the table name to testpublic java.lang.String[] getXMLTableNames(java.sql.Connection con, java.lang.String tablePrefix) throws java.lang.Exception
con
- - the Connection objecttablePrefix
- - table prefix stringpublic boolean insertXMLData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xmldata) throws java.sql.SQLException, java.io.IOException
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namexmldata
- - string with the file datapublic boolean insertBLOBData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, byte[] xmldata) throws java.sql.SQLException, java.io.IOException
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namexmldata
- - byte array with file datapublic boolean replaceXMLData(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname, java.lang.String xmldata) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namexmldata
- - string with the file datapublic boolean xmlTableExists(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namepublic boolean dropXMLTable(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namepublic boolean dropBLOBTable(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namepublic boolean createXMLTable(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namepublic boolean createBLOBTable(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namepublic java.lang.String[] getXMLNames(java.sql.Connection con, java.lang.String tablename) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namepublic java.lang.String getXMLData(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 namepublic byte[] getBLOBData(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 namepublic boolean deleteBLOBName(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namexmlname
- - the file namepublic boolean deleteXMLName(java.sql.Connection con, java.lang.String tablename, java.lang.String xmlname) throws java.lang.Exception
con
- - the Connection objecttablename
- - the table namexmlname
- - the file name
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |