Uses of Class
com.mcpdbwizard.pub.CSException

  • Uses of CSException in com.mcpdbwizard.pub

    Subclasses of CSException in com.mcpdbwizard.pub
    Modifier and Type
    Class
    Description
    class 
    CSAttemptToGetNullException
    Thrown when a method which returns a native type such as int,long,double is called for a column whose value is null.
    class 
    CSColumnException
    Thrown by the rowValidate method when a non-null column is null or a number column's contents don't match the size of the corresponding database column.
    class 
    CSDBException
    Thrown when a SQLException is generated.
    class 
    CSDBInvalidDatatypeCastException
    Thrown when an attempt is made to retrieve a value in a form that it can not be converted to.
    class 
    CSDBNullObjectException
    Thrown when a null is found where an object is required
    class 
    CSDocumentChangedException
    Thrown when an etag-checked duality-view document update finds that the document has been changed or deleted by another session since it was read (optimistic locking failure).
    class 
    CSInvalidColumnIdException
    Thrown when an attempt is made to retrieve a value from a column that does not exist.
    class 
    CSInvalidDataTypeException
    Thrown when an we encounter a value whose data type is unsupported
    class 
    CSIOException
    Thrown when we encounter an IOException
    class 
    CSNoDataInRowSetException
    Thrown when an attempt is made to retrieve a value from an empty readOnlyRowset.
    class 
    CSNoNanosAllowedException
    Thrown when a Timestamp contains nanoseconds but the Oracle table/record it will be used against is DATA and doesn't support nanonseconds.
    class 
    CSNumberFormatException
    Thrown when an attempt to turn a String into a number fails
    class 
    CSPoolExhaustedException
    Thrown when DaoFactoryPool could not supply a factory within DAO_POOL_MAX_WAIT_MS: every factory is checked out and the pool is at DAO_POOL_MAX_SIZE.
    class 
    CSUnsupportedDatatypeException
    Thrown when an attempt is made to retrieve a value from a column has an unsupported datatype
    Methods in com.mcpdbwizard.pub that throw CSException
    Modifier and Type
    Method
    Description
    void
    CallableStatementParameters.bindParameters(CallableStatement theCallableStatement)
    Bind these parameters to a Prepared Statement.
    void
    StatementParameters2.bindParameters(PreparedStatement thePreparedStatement)
    Bind these parameter to a Prepared Statement.
    T
    DaoFactoryPool.borrow()
    Take a factory out of the pool, creating one if the pool is below its maximum and none is free.
    static void
    StatementParameters2.checkBuild(int pBuild)
    Return version of this class This menthod is used by generated code to make sure that it's using the right version of com.mcpdbwizard.pub.
    protected void
    StatementParameters2.checkRange(int paramId)
    Complain if param id is too high
    void
    CallableStatementParameters.checkSet()
    Complain if not all parameters set...
    void
    StatementParameters2.checkSet()
    Complain if not all parameters set...
    void
    PooledResourceUser.confirmConnection()
    Establish the database connection if there is not already a usable one.
    static void
    IOUtils.copyFile(File oldFile, File newFile)
    Copies a file.
    static oracle.sql.BFILE
    SqlUtils.createBfileLocator(String theOracleDirectory, String theFileName, Connection theConnection, LogInterface theLog, boolean debugMessages)
    Create and return a BFILE locator.
    ReadOnlyRowSet
    QueryStatement.execute()
    Execute the statement and return a ReadOnlyRowSet
    static McpOAuthPolicy
    McpOAuthPolicy.fromEnvironment()
    Build from the environment; fails closed if the required variables are absent.
    Array
    JavaArrayObject.getArray(Connection theConnection)
    Return a java.sql.Array which is composed of java.sql.Struct[]
    BigDecimal[]
    PlsqlIndexByTable.getArrayAsBigDecimal()
    Get the array data as java.math.BigDecimal[] This convenience method returns the contents of the array as an array of BigDecimal.
    Timestamp[]
    PlsqlIndexByTable2.getArrayAsTimestamp()
    Get the array data as java.sql.Timestamp This convenience method returns the contents of the array as an array of java.sql.Timestamp.
    File
    ReadOnlyRowSet.getFile(int columnId, File outputFile)
    Get a long text or binary column columnId as a File
    File
    ReadOnlyRowSet.getFile(String theColumnName, File outputFile)
    Get a long text or binary column columnId as a File
    Object
    StatementParameters2.getParam(int parameterId)
    Get a parameter
    static oracle.sql.BFILE
    LongObjectLoader.loadBFILE(oracle.sql.BFILE newBFILE, File theFile, int bufferSize)
    Attempts to upload a File to a BFILE This always fails as BFILES are read only.
    static oracle.sql.BLOB
    LongObjectLoader.loadBLOB(oracle.sql.BLOB newBLOB, byte[] theArray)
    Unloads a byte array to a BLOB
    static oracle.sql.BLOB
    LongObjectLoader.loadBLOB(oracle.sql.BLOB newBLOB, File theFile, int bufferSize)
    Loads a File into a BLOB
    static File
    IOUtils.loadByteArrayIntoFile(byte[] theBytes, File newFile, LogInterface theLog)
    Turn a byte array into a File.
    static File
    IOUtils.loadByteArrayIntoFile(byte[] theBytes, String tempFilePrefix, String tempFileSuffix, String tempFileDir, LogInterface theLog)
    Turn a byte array into a Temporary File.
    static File
    IOUtils.loadCharArrayIntoFile(char[] theChars, File newFile, LogInterface theLog)
    Turn a char array into a File.
    static File
    IOUtils.loadCharArrayIntoFile(char[] theChars, String tempFilePrefix, String tempFileSuffix, String tempFileDir, LogInterface theLog)
    Turn a char array into a Temporary File.
    static oracle.sql.CLOB
    LongObjectLoader.loadCLOB(oracle.sql.CLOB newCLOB, byte[] theArray)
    Loads a byte array into a CLOB
    static oracle.sql.CLOB
    LongObjectLoader.loadCLOB(oracle.sql.CLOB newCLOB, char[] theArray)
    Loads a char array into a CLOB
    static oracle.sql.CLOB
    LongObjectLoader.loadCLOB(oracle.sql.CLOB newCLOB, File theFile, int bufferSize)
    Loads a File into a CLOB
    static byte[]
    IOUtils.loadFileIntoByteArray(File inFile)
    Loads a file into a byte array.
    static char[]
    IOUtils.loadFileIntoCharArray(File inFile)
    Loads a file into a char array.
    static String
    IOUtils.loadFileIntoString(File inFile)
    Loads a file into a String.
    static File
    IOUtils.loadStringIntoFile(String theString, File newFile, LogInterface theLog)
    Turn a String into a File.
    static File
    IOUtils.loadStringIntoFile(String theString, String tempFilePrefix, String tempFileSuffix, String tempFileDir, LogInterface theLog)
    Turn a String into a File.
    void
    JavaArrayObject.setArray(Array theArray)
    Accept an array of java.sql.Struct
    void
    StatementParameters2.setNativeBooleanParam(int parameterId, Boolean parameterValue)
    A convenience method to set a native ISO-SQL BOOLEAN (23ai) parameter.
    void
    PlsqlArray.setNewValuesAsObject(Object[] newValues)
    Method to set the ArrayList by passing in an array of Object
    void
    PlsqlIndexByTable2.setNewValuesAsObject(Object[] newValues)
    Replace the contents from a generic Object[], as PlsqlArray requires.
    void
    CallableStatementParameters.setOutParam(int parameterId, int parameterType)
    Set an out parameter
    void
    CallableStatementParameters.setOutParam(int parameterId, int parameterType, String parameterOpaqueTypeName)
    Set an OPAQUE out parameter
    void
    StatementParameters2.setParam(int parameterId, boolean parameterValue)
    A convenience method to set a boolean parameter.
    void
    StatementParameters2.setParam(int parameterId, byte parameterValue)
    A convenience method to set an byte parameter.
    void
    StatementParameters2.setParam(int parameterId, byte[] parameterValue)
    A convenience method to set an byte[] parameter.
    void
    StatementParameters2.setParam(int parameterId, double parameterValue)
    A convenience method to set an double parameter.
    void
    StatementParameters2.setParam(int parameterId, double[] parameterValue)
    A convenience method to set a native Oracle VECTOR (23ai) parameter.
    void
    StatementParameters2.setParam(int parameterId, float parameterValue)
    A convenience method to set an float parameter.
    void
    StatementParameters2.setParam(int parameterId, int parameterValue)
    A convenience method to set an int parameter.
    void
    StatementParameters2.setParam(int parameterId, long parameterValue)
    A convenience method to set an long parameter.
    void
    StatementParameters2.setParam(int parameterId, short parameterValue)
    A convenience method to set an short parameter.
    void
    StatementParameters2.setParam(int parameterId, ReadOnlyRowSet parameterValue)
    A convenience method to set a ReadOnlyRowSet parameter.
    void
    StatementParameters2.setParam(int parameterId, BufferedInputStream parameterValue, int fileSize, int dataType)
    A convenience method to set a BufferedInputStream parameter.
    void
    StatementParameters2.setParam(int parameterId, File parameterValue)
    A convenience method to set an File parameter.
    void
    StatementParameters2.setParam(int parameterId, InputStream parameterValue, int fileSize, int dataType)
    A convenience method to set an InputStream parameter.
    void
    StatementParameters2.setParam(int parameterId, Boolean parameterValue)
    A convenience method to set a boolean parameter.
    void
    StatementParameters2.setParam(int parameterId, Byte parameterValue)
    A convenience method to set an byte parameter.
    void
    StatementParameters2.setParam(int parameterId, Double parameterValue)
    A convenience method to set an double parameter.
    void
    StatementParameters2.setParam(int parameterId, Float parameterValue)
    A convenience method to set an float parameter.
    void
    StatementParameters2.setParam(int parameterId, Integer parameterValue)
    A convenience method to set an int parameter.
    void
    StatementParameters2.setParam(int parameterId, Long parameterValue)
    A convenience method to set an long parameter.
    void
    StatementParameters2.setParam(int parameterId, Short parameterValue)
    A convenience method to set an short parameter.
    void
    StatementParameters2.setParam(int parameterId, String parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, String opaqueName, oracle.sql.OPAQUE parameterValue)
    Set an Opaque parameter
    void
    StatementParameters2.setParam(int parameterId, String structName, oracle.sql.STRUCT parameterValue)
    Set an STRUCT parameter
    void
    StatementParameters2.setParam(int parameterId, BigDecimal parameterValue)
    A convenience method to set an double parameter.
    void
    StatementParameters2.setParam(int parameterId, Date parameterValue)
    Set a parameter.
    void
    StatementParameters2.setParam(int parameterId, Timestamp parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, Date parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.BFILE parameterValue)
    A convenience method to set a BFILE parameter.
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.BLOB parameterValue)
    A convenience method to set a BLOB parameter.
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.CLOB parameterValue)
    A convenience method to set a CLOB parameter.
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.INTERVALDS parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.INTERVALYM parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.json.OracleJsonValue parameterValue)
    A convenience method to set a native Oracle JSON (21c+) parameter.
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.ROWID parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.TIMESTAMP parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.TIMESTAMPLTZ parameterValue)
    Set a parameter
    void
    StatementParameters2.setParam(int parameterId, oracle.sql.TIMESTAMPTZ parameterValue)
    Set a parameter
    void
    CallableStatementParameters.setPlSqlIndexArrayOutParam(int parameterId, PlsqlIndexByTable2 parameterValue)
    Set an out parameter for a PL/SQL Index By Table In order to retrieve a PL/SQL Index By Table you need to specify the data type you are expecting and how many records can be in the array.
    void
    StatementParameters2.setPlSqlIndexArrayParam(int parameterId, PlsqlIndexByTable2 parameterValue)
    Set a PL/SQL INDEX BY Array parameter
    void
    CallableStatementParameters.setPlSqlTableArrayOutParam(int parameterId, PlsqlArray parameterValue)
    Set an out parameter for a PL/SQL Array In order to retrieve a PL/SQL varray or table you need to specify the oracle collection name.
    void
    StatementParameters2.setPlSqlTableArrayParam(int parameterId, Object parameterValue)
    Set an Array parameter
    void
    QueryStatement.setTempDir(File tempFileDir)
    Set temporary directory
    void
    PooledResourceUser.settleTransaction(boolean commit)
    End the transaction opened by whoever just finished with this factory, so the next borrower starts clean.
    void
    StatementParameters2.setVectorBinaryParam(int parameterId, byte[] parameterValue)
    A convenience method to set a binary (bit-packed) Oracle VECTOR (23ai) parameter.
    void
    StatementParameters2.setVectorSparseParam(int parameterId, SparseVector parameterValue)
    A convenience method to set a sparse Oracle VECTOR (23ai) parameter.
    File
    LongObjectLoader.unloadBfile(File newFile, oracle.sql.BFILE tempBFILE)
    Unloads a BFILE column into a file
    byte[]
    LongObjectLoader.unloadBfileIntoByteArray(oracle.sql.BFILE tempBFILE)
    Unloads a BFILE column into a byte array
    File
    LongObjectLoader.unloadBinaryStream(File newFile, InputStream theInputStream, String columnDataType)
    Unloads a Binary Stream into a file
    File
    LongObjectLoader.unloadBinaryStream(File newFile, String theInputString, String columnDataType)
    Unloads a LONG column into a file
    byte[]
    LongObjectLoader.unloadBinaryStreamIntoByteArray(InputStream theInputStream, String columnDataType)
    Unloads a Binary Stream into a byte array.
    File
    LongObjectLoader.unloadBlob(File newFile, oracle.sql.BLOB tempBLOB)
    Unloads a BLOB column into a file
    byte[]
    LongObjectLoader.unloadBlobIntoByteArray(oracle.sql.BLOB tempBLOB)
    Unloads a BLOB column into a byte array
    File
    LongObjectLoader.unloadClob(File newFile, oracle.sql.CLOB tempCLOB)
    Unloads a CLOB column into a file
    byte[]
    LongObjectLoader.unloadClobIntoByteArray(oracle.sql.CLOB tempCLOB)
    Unloads a CLOB column into a byte array
    char[]
    LongObjectLoader.unloadClobIntoCharArray(Clob tempCLOB)
    Unloads a CLOB column into a char array
    char[]
    LongObjectLoader.unloadClobIntoCharArray(oracle.sql.CLOB tempCLOB)
    Unloads a CLOB column into a char array
    void
    CallableStatementParameters.unloadParameters(CallableStatement theCallableStatement)
    Unload these parameter from a Prepared Statement.
    Constructors in com.mcpdbwizard.pub that throw CSException
    Modifier
    Constructor
    Description
     
    ReadOnlyRowSet(ResultSet theResultSet, String theQuery, int maxRows, LogInterface theLog)
    Create a ReadOnlyRowSet that is based on a ResultSet.
     
    ReadOnlyRowSet(ResultSet theResultSet, String theQuery, int maxRows, LogInterface theLog, File downloadedFileDir, boolean keepFiles, String tempFilePrefix, String tempFileSuffix)
    Create a ReadOnlyRowSet that is based on a ResultSet.
     
    ReadOnlyRowSet(ResultSet theResultSet, String theQuery, int maxRows, LogInterface theLog, File downloadedFileDir, boolean keepFiles, String tempFilePrefix, String tempFileSuffix, boolean keepLobs)
    Create a ReadOnlyRowSet that is based on a ResultSet.
     
    ReadOnlyRowSet(ResultSet theResultSet, String theQuery, int maxRows, LogInterface theLog, File downloadedFileDir, boolean keepFiles, String tempFilePrefix, String tempFileSuffix, boolean keepLobs, boolean useByteArraysForLongsAndLOBS)
    Create a ReadOnlyRowSet that is based on a ResultSet.
     
    WriteableRowSet(ResultSet theResultSet, String theQuery, int maxRows, LogInterface theLog)
    Create a writableRowSet that is based on a ResultSet.