com.basis.plugin

Class SQLPlugin

java.lang.Object

com.basis.plugin.SQLPlugin

public class SQLPlugin
extends java.lang.Object

This is the interface used to read, write, and get information about open SQL plugins. Instances are created by the open method of the SQLOpenPlugin interface. Methods that a particular plugin does not want to implement can just throw a BBjException, usually of type BBjException.ACCESS.

See Also:

SQLOpenPlugin.open(java.lang.String, java.util.Map, BaseBBjPluginEnv)

Method Summary

Modifier and Type	Method and Description
void	close() Close the file position.
int	extract(byte[] p_buffer, int p_size, byte[] p_key, int p_keylen, int p_keyNumber, int p_timeout) Extract from the key given.
int	extract(byte[] p_buffer, int p_size, int p_timeout) Extract from the current position.
int	extract(byte[] p_buffer, int p_size, int p_keyNumber, int p_timeout) Extract from the current position.
int	extract(byte[] p_buffer, int p_size, long p_index, int p_timeout) Extract from the index given.
byte[]	getFIN(int p_index) Base FIN function used by the interpreter to get the FIN byte array.
java.lang.String	getFINTemplate(int p_index) Get template string for base FIN function.
int	getFirstKey(byte[] p_buffer, int p_keylen) Get first key in current key number.
long	getIndex() Get current index -- this is not guaranteed to be useful for all file types.
int	getKey(byte[] p_buffer, int p_keylen) Get key at the current position.
int	getKey(byte[] p_buffer, int p_keylen, int p_keyNumber) Get key at the current position.
int	getKeySize() Get logical key size (if applicable).
int	getLastKey(byte[] p_buffer, int p_keylen) Get last key in current key number.
long	getLength() Get length of the file -- not valid for all file types.
int	getMaxReadSize() Maximum number of bytes that a user is able to read from the file in a single read.
int	getNextKey(byte[] p_buffer, int p_keylen) Get next key at the current position.
long	getNumberOfRecords() Get maximum number of records (if applicable).
int	getPreviousKey(byte[] p_buffer, int p_keylen) Get previous key at the current position.
long	getRecordCount() Get the number of records actually in the file.
int	getRecordSize() Get record size (if applicable).
byte[]	getXFIN(int p_index) Base XFIN function used by the interpreter to get the XFIN byte array.
java.lang.String	getXFINTemplate(int p_index) Get template string for base XFIN function.
boolean	isRecordOriented() Is the plugin file record oriented (i.e.
void	lock() Lock the file.
int	read(byte[] p_buffer, int p_size, byte[] p_key, int p_keylen, int p_keyNumber, boolean p_find, long p_move, int p_timeout) Read from the key given and change the position either forwards or backwards.
int	read(byte[] p_buffer, int p_size, int p_keyNumber, long p_move, int p_timeout) Read from the current position and change the position either forwards or backwards.
int	read(byte[] p_buffer, int p_size, long p_move, int p_timeout) Read from the current position and change the position either forwards or backwards.
int	read(byte[] p_buffer, int p_size, long p_index, long p_move, int p_timeout) Read from the index given and change the position either forwards or backwards.
void	remove(byte[] p_key, int p_keylen, boolean p_dom) Remove the record indicated by a key.
void	remove(long p_index) Remove the record indicated by an index.
void	unlock() Unlock the file.
void	write(byte[] p_buffer, int p_size, byte[] p_key, int p_keylen, long p_move, boolean p_dom, int p_timeout) Write a record at the position given by a key.
void	write(byte[] p_buffer, int p_size, long p_move, boolean p_dom, int p_timeout) Write a record at the current position except for multi keyed MKEYED files where the key will be derived from the record.
void	write(byte[] p_buffer, int p_size, long p_index, long p_move, boolean p_dom, int p_timeout) Write a record at the position given by an index.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

isRecordOriented

public boolean isRecordOriented()

Is the plugin file record oriented (i.e. records are read)?

Returns:

true if the file is read as records.

read

public int read(byte[] p_buffer,
                int p_size,
                long p_move,
                int p_timeout)
         throws BBjException

Read from the current position and change the position either forwards or backwards.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_move - Number of records (or bytes in STRING file) to move the position after the read. If this is negative the position will be moved backwards.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException

read

public int read(byte[] p_buffer,
                int p_size,
                int p_keyNumber,
                long p_move,
                int p_timeout)
         throws BBjException

Read from the current position and change the position either forwards or backwards. If the key number given is not the current key number then the current position will be the first key of the specified key number.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_keyNumber - Key number to use for iteration. If the key number is different than the one currently being used the iteration will start at the beginning of the key specified.

p_move - Number of records (or bytes in STRING file) to move the position after the read. If this is negative the position will be moved backwards.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException

read

public int read(byte[] p_buffer,
                int p_size,
                byte[] p_key,
                int p_keylen,
                int p_keyNumber,
                boolean p_find,
                long p_move,
                int p_timeout)
         throws BBjException

Read from the key given and change the position either forwards or backwards. File types without keys will give an error.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_key - Key value to search for on the read.

p_keylen - Length of the actual key in the key byte array.

p_keyNumber - Number of the key chain to search.

p_find - true if the position should not be changed if the key is not found.

p_move - Number of records (or bytes in STRING file) to move the position after the read. If this is negative the position will be moved backwards.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException

read

public int read(byte[] p_buffer,
                int p_size,
                long p_index,
                long p_move,
                int p_timeout)
         throws BBjException

Read from the index given and change the position either forwards or backwards. File types without indexes will give an error.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_index - Index to jump to for the read.

p_move - Number of records (or bytes in STRING file) to move the position after the read. If this is negative the position will be moved backwards.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException - If a problem occurs.

extract

public int extract(byte[] p_buffer,
                   int p_size,
                   int p_timeout)
            throws BBjException

Extract from the current position.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException - If a problem occurs.

extract

public int extract(byte[] p_buffer,
                   int p_size,
                   int p_keyNumber,
                   int p_timeout)
            throws BBjException

Extract from the current position. If the key number given is not the current key number then the current position will be the first key of the specified key number.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_keyNumber - Key number to use for iteration. If the key number is different than the one currently being used the iteration will start at the beginning of the key specified.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException - If a problem occurs.

extract

public int extract(byte[] p_buffer,
                   int p_size,
                   byte[] p_key,
                   int p_keylen,
                   int p_keyNumber,
                   int p_timeout)
            throws BBjException

Extract from the key given. File types without keys will give an error.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_key - Key value to search for on the read.

p_keylen - Length of the actual key in the key byte array.

p_keyNumber - Number of the key chain to search.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException - If a problem occurs.

extract

public int extract(byte[] p_buffer,
                   int p_size,
                   long p_index,
                   int p_timeout)
            throws BBjException

Extract from the index given. File types without indexes will give an error.

Parameters:

p_buffer - Buffer to fill with the bytes read.

p_size - Maximum number of bytes to read into the buffer.

p_index - Index to jump to for the read.

p_timeout - Timeout value in seconds for the read operation.

Returns:

Number of bytes actually read.

Throws:

BBjException - If a problem occurs.

write

public void write(byte[] p_buffer,
                  int p_size,
                  long p_move,
                  boolean p_dom,
                  int p_timeout)
           throws BBjException

Write a record at the current position except for multi keyed MKEYED files where the key will be derived from the record.

Parameters:

p_buffer - Record bytes.

p_size - Number of bytes to write from the buffer.

p_move - Number of records (or bytes in STRING file) to move the position after the write. If this is negative the position will be moved backwards. The move is relative to the location of the record written.

p_dom - true if an error should be given for a duplicate key.

p_timeout - Timeout value in seconds for the write operation.

Throws:

BBjException - If a problem occurs.

write

public void write(byte[] p_buffer,
                  int p_size,
                  byte[] p_key,
                  int p_keylen,
                  long p_move,
                  boolean p_dom,
                  int p_timeout)
           throws BBjException

Write a record at the position given by a key. File types without keys and multi-keyed MKEYED and XKEYED files will give an error.

Parameters:

p_buffer - Record bytes.

p_size - Number of bytes to write from the buffer.

p_key - Key to use in writing the record.

p_keylen - Length of the actual key in the key byte array.

p_move - Number of records (or bytes in STRING file) to move the position after the write. If this is negative the position will be moved backwards. The move is relative to the location of the record written.

p_dom - true if an error should be given for a duplicate key.

p_timeout - Timeout value in seconds for the write operation.

Throws:

BBjException - If a problem occurs.

write

public void write(byte[] p_buffer,
                  int p_size,
                  long p_index,
                  long p_move,
                  boolean p_dom,
                  int p_timeout)
           throws BBjException

Write a record at the position given by an index. File types without indexes will give an error.

Parameters:

p_buffer - Record bytes.

p_size - Number of bytes to write from the buffer.

p_index - Index to use in writing the record.

p_move - Number of records (or bytes in STRING file) to move the position after the write. If this is negative the position will be moved backwards. The move is relative to the location of the record written.

p_dom - true if an error should be given for a duplicate key.

p_timeout - Timeout value in seconds for the write operation.

Throws:

BBjException - If a problem occurs.

remove

public void remove(byte[] p_key,
                   int p_keylen,
                   boolean p_dom)
            throws BBjException

Remove the record indicated by a key. File types without keys will give an error.

Parameters:

p_key - Key of the record to remove.

p_keylen - Length of the actual key in the key byte array.

p_dom - true if an error should be given for a missing key.

Throws:

BBjException - If a problem occurs.

lock

public void lock()
          throws BBjException

Lock the file.

Throws:

BBjException - If a problem occurs.

unlock

public void unlock()
            throws BBjException

Unlock the file.

Throws:

BBjException - If a problem occurs.

close

public void close()
           throws BBjException

Close the file position.

Throws:

BBjException - If a problem occurs.

getKey

public int getKey(byte[] p_buffer,
                  int p_keylen)
           throws BBjException

Get key at the current position.

Parameters:

p_buffer - Buffer in which to place the key.

p_keylen - Length of the key buffer provided.

Returns:

Number of bytes in the key.

Throws:

BBjException - If a problem occurs.

getKey

public int getKey(byte[] p_buffer,
                  int p_keylen,
                  int p_keyNumber)
           throws BBjException

Get key at the current position.

Parameters:

p_buffer - Buffer in which to place the key.

p_keylen - Length of the key buffer provided.

p_keyNumber - Which key number to get the key for.

Returns:

Number of bytes in the key.

Throws:

BBjException - If a problem occurs.

getFirstKey

public int getFirstKey(byte[] p_buffer,
                       int p_keylen)
                throws BBjException

Get first key in current key number.

Parameters:

p_buffer - Buffer in which to place the key.

p_keylen - Length of key buffer provided.

Returns:

Number of bytes in the key.

Throws:

BBjException - If a problem occurs.

getLastKey

public int getLastKey(byte[] p_buffer,
                      int p_keylen)
               throws BBjException

Get last key in current key number.

Parameters:

p_buffer - Buffer in which to place the key.

p_keylen - Length of key buffer provided.

Returns:

Number of bytes in the key.

Throws:

BBjException - If a problem occurs.

getNextKey

public int getNextKey(byte[] p_buffer,
                      int p_keylen)
               throws BBjException

Get next key at the current position.

Parameters:

p_buffer - Buffer in which to place the key.

p_keylen - Length of key buffer provided.

Returns:

Number of bytes in the key.

Throws:

BBjException - If a problem occurs.

getPreviousKey

public int getPreviousKey(byte[] p_buffer,
                          int p_keylen)
                   throws BBjException

Get previous key at the current position.

Parameters:

p_buffer - Buffer in which to place the key.

p_keylen - Length of key buffer provided.

Returns:

Number of bytes in the key.

Throws:

BBjException - If a problem occurs.

getKeySize

public int getKeySize()
               throws BBjException

Get logical key size (if applicable).

Returns:

Logical key size for this file -- multi keyed MKEYED files return 0.

Throws:

BBjException - If a problem occurs.

getNumberOfRecords

public long getNumberOfRecords()
                        throws BBjException

Get maximum number of records (if applicable).

Returns:

Number of records or -1.

Throws:

BBjException - If a problem occurs.

getRecordSize

public int getRecordSize()
                  throws BBjException

Get record size (if applicable).

Returns:

Record size.

Throws:

BBjException - If a problem occurs.

getFIN

public byte[] getFIN(int p_index)
              throws BBjException

Base FIN function used by the interpreter to get the FIN byte array.

Parameters:

p_index - Index of FIN to retrieve.

Returns:

FIN byte array as expected by BBx.

Throws:

BBjException - If a problem occurs.

getFINTemplate

public java.lang.String getFINTemplate(int p_index)
                                throws BBjException

Get template string for base FIN function.

Parameters:

p_index - Index of FIN to get template for.

Returns:

Template for FIN index requested.

Throws:

BBjException - If a problem occurs.

getXFIN

public byte[] getXFIN(int p_index)
               throws BBjException

Base XFIN function used by the interpreter to get the XFIN byte array.

Parameters:

p_index - Index of FIN to retrieve.

Returns:

XFIN byte array as expected by BBj.

Throws:

BBjException - If a problem occurs.

getXFINTemplate

public java.lang.String getXFINTemplate(int p_index)
                                 throws BBjException

Get template string for base XFIN function.

Parameters:

p_index - Index of XFIN to get template for.

Returns:

Template for XFIN index requested.

Throws:

BBjException - If a problem occurs.

getLength

public long getLength()
               throws BBjException

Get length of the file -- not valid for all file types.

Returns:

Length of the file.

Throws:

BBjException - If a problem occurs.

getIndex

public long getIndex()
              throws BBjException

Get current index -- this is not guaranteed to be useful for all file types.

Returns:

Current index.

Throws:

BBjException - If a problem occurs.

getMaxReadSize

public int getMaxReadSize()
                   throws BBjException

Maximum number of bytes that a user is able to read from the file in a single read. For record files this is the record size (or maximum record size).

Returns:

Maximum number of bytes that can possibly be read at one time.

Throws:

BBjException - If a problem occurs.

getRecordCount

public long getRecordCount()
                    throws BBjException

Get the number of records actually in the file.

Returns:

The number of records actually in the file if available.

Throws:

BBjException - If a problem occurs.

remove

public void remove(long p_index)
            throws BBjException

Remove the record indicated by an index.

Parameters:

p_index - Index of the record to remove.

Throws:

BBjException - If a problem occurs.