ページの先頭行へ戻る
Enterprise Postgres 10 アプリケーション開発ガイド
FUJITSU Software

F.1.2 PostgreSQL固有API

org.postgresql

インタフェース名

メソッド名

jdbc4/jdbc41

PGConnection

addDataType(java.lang.String type, java.lang.Class klass)

addDataType(java.lang.String type, java.lang.String name)

getBackendPID()

getCopyAPI()

getFastpathAPI()

getLargeObjectAPI()

getNotifications()

getPrepareThreshold()

setPrepareThreshold(int threshold)

PGNotification

getName()

getParameter()

getPID()

PGRefCursorResultSet

getRefCursor()

PGResultSetMetaData

getBaseColumnName(int column)

getBaseSchemaName(int column)

getBaseTableName(int column)

getFormat(int column)

PGStatement

getLastOID()

getPrepareThreshold()

isUseServerPrepare()

setPrepareThreshold(int threshold)

setUseServerPrepare(boolean flag)

○: サポート

org.postgresql.copy

インタフェース名

メソッド名

jdbc4/jdbc41

CopyIn

endCopy()

flushCopy()

writeToCopy(byte[] buf, int off, int siz)

CopyOperation

cancelCopy()

getFieldCount()

getFieldFormat(int field)

getFormat()

getHandledRowCount()

isActive()

CopyOut

readFromCopy()

CopyManager

copyIn(java.lang.String sql)

copyIn(java.lang.String sql, java.io.InputStream from)

copyIn(java.lang.String sql, java.io.InputStream from, int bufferSize)

copyIn(java.lang.String sql, java.io.Reader from)

copyIn(java.lang.String sql, java.io.Reader from, int bufferSize)

copyOut(java.lang.String sql)

copyOut(java.lang.String sql, java.io.OutputStream to)

copyOut(java.lang.String sql, java.io.Writer to)

PGCopyInputStream

available()

cancelCopy()

close()

getFieldCount()

getFieldFormat(int field)

getFormat()

getHandledRowCount()

isActive()

read()

read(byte[] buf)

read(byte[] buf, int off, int siz)

readFromCopy()

PGCopyOutputStream

cancelCopy()

close()

endCopy()

flush()

flushCopy()

getFieldCount()

getFieldFormat(int field)

getFormat()

getHandledRowCount()

isActive()

write(byte[] buf)

write(byte[] buf, int off, int siz)

write(int b)

writeToCopy(byte[] buf, int off, int siz)

○: サポート

org.postgresql.ds

インタフェース名

メソッド名

jdbc4/jdbc41

PGConnectionPoolDataSource

PGPooledConnection

createConnectionEvent(java.sql.SQLException sqle)

PGPoolingDataSource

addDataSource(java.lang.String dataSourceName)

PGSimpleDataSource

○: サポート

org.postgresql.ds.common

インタフェース名

メソッド名

jdbc4/jdbc41

BaseDataSource

createReference()

getApplicationName()

getBinaryTransfer()

getBinaryTransferDisable()

getBinaryTransferEnable()

getCompatible()

getConnection()

getConnection(java.lang.String user, java.lang.String password)

getDatabaseName()

getDescription()

getLoginTimeout()

getLogLevel()

getLogWriter()

getPassword()

getPortNumber()

getPrepareThreshold()

getProtocolVersion()

getReceiveBufferSize()

getReference()

getSendBufferSize()

getServerName()

getSocketTimeout()

getSsl()

getSslfactory()

getSslmode()

getSslrootcert()

getSslservercertcn()

getStringType()

getTargetServer()

getTcpKeepAlive()

getUnknownLength()

getUrl()

getUser()

initializeFrom(BaseDataSource source)

isColumnSanitiserDisabled()

readBaseObject(java.io.ObjectInputStream in)

setApplicationName(java.lang.String applicationName)

setBinaryTransfer(boolean enabled)

setBinaryTransferDisable(java.lang.String oidList)

setBinaryTransferEnable(java.lang.String oidList)

setCompatible(java.lang.String compatible)

setDatabaseName(java.lang.String databaseName)

setDisableColumnSanitiser(boolean disableColumnSanitiser)

setLoginTimeout(int i)

setLogLevel(int logLevel)

setLogWriter(java.io.PrintWriter printWriter)

setPassword(java.lang.String password)

setPortNumber(int portNumber)

setPrepareThreshold(int count)

setProtocolVersion(int protocolVersion)

setReceiveBufferSize(int nbytes)

setSendBufferSize(int nbytes)

setServerName(java.lang.String serverName)

setSocketTimeout(int seconds)

setSsl(boolean enabled)

setSslfactory(java.lang.String classname)

setSslmode(java.lang.String sslmode)

setSslrootcert(java.lang.String sslrootcert)

setSslservercertcn(java.lang.String sslservercertcn)

setStringType(java.lang.String stringType)

setTargetServer(java.lang.String targetServer)

setTcpKeepAlive(boolean enabled)

setUnknownLength(int unknownLength)

setUrl(String url)

setUser(java.lang.String user)

writeBaseObject(java.io.ObjectOutputStream out)

○: サポート

org.postgresql.fastpath

インタフェース名

メソッド名

jdbc4/jdbc41

Fastpath

addFunction(java.lang.String name, int fnid)

addFunctions(java.sql.ResultSet rs)

createOIDArg(long oid)

fastpath(int fnId, boolean resultType, FastpathArg[] args)

fastpath(java.lang.String name, boolean resulttype, FastpathArg[] args)

getData(java.lang.String name, FastpathArg[] args)

getID(java.lang.String name)

getInteger(java.lang.String name, FastpathArg[] args)

getOID(java.lang.String name, FastpathArg[] args)

FastpathArg

○: サポート

org.postgresql.geometric

インタフェース名

メソッド名

jdbc4/jdbc41

PGbox

clone()

equals(java.lang.Object obj)

getValue()

hashCode()

lengthInBytes()

setByteValue(byte[] b, int offset)

setValue(java.lang.String value)

toBytes(byte[] bytes, int offset)

PGcircle

clone()

equals(java.lang.Object obj)

getValue()

hashCode()

setValue(java.lang.String s)

PGline

clone()

equals(java.lang.Object obj)

getValue()

hashCode()

setValue(java.lang.String s)

PGlseg

clone()

equals(java.lang.Object obj)

getValue()

hashCode()

setValue(java.lang.String s)

PGpath

clone()

closePath()

equals(java.lang.Object obj)

getValue()

hashCode()

isClosed()

isOpen()

openPath()

setValue(java.lang.String s)

PGpoint

equals(java.lang.Object obj)

getValue()

hashCode()

lengthInBytes()

move(double x, double y)

move(int x, int y)

setByteValue(byte[] b, int offset)

setLocation(int x, int y)

setLocation(java.awt.Point p)

setValue(java.lang.String s)

toBytes(byte[] b, int offset)

translate(double x, double y)

translate(int x, int y)

PGpolygon

clone()

equals(java.lang.Object obj)

getValue()

hashCode()

setValue(java.lang.String s)

○: サポート

org.postgresql.largeobject

インタフェース名

メソッド名

jdbc4/jdbc41

BlobInputStream

close()

mark(int readlimit)

markSupported()

read()

reset()

BlobOutputStream

close()

flush()

write(byte[] buf, int off, int len)

write(int b)

LargeObject

close()

copy()

getInputStream()

getLongOID()

getOID()

getOutputStream()

read(byte[] buf, int off, int len)

read(int len)

seek(int pos)

seek(int pos, int ref)

size()

tell()

truncate(int len)

write(byte[] buf)

write(byte[] buf, int off, int len)

LargeObjectManager

create()

create(int mode)

createLO()

createLO(int mode)

delete(int oid)

delete(long oid)

open(int oid)

open(int oid, boolean commitOnClose)

open(int oid, int mode)

open(int oid, int mode, boolean commitOnClose)

open(long oid)

open(long oid, boolean commitOnClose)

open(long oid, int mode)

open(long oid, int mode, boolean commitOnClose)

unlink(int oid)

unlink(long oid)

○: サポート

org.postgresql.ssl

インタフェース名

メソッド名

jdbc4/jdbc41

DbKeyStoreSocketFactory

getKeyStorePassword()

getKeyStoreStream()

DbKeyStoreSocketFactory.DbKeyStoreSocketException

NonValidatingFactory

NonValidatingFactory.NonValidatingTM

checkClientTrusted(java.security.cert.X509Certificate[] certs, java.lang.String authType)

checkServerTrusted(java.security.cert.X509Certificate[] certs, java.lang.String authType)

getAcceptedIssuers()

WrappedFactory

createSocket(java.net.InetAddress host, int port)

createSocket(java.net.InetAddress address, int port, java.net.InetAddress localAddress, int localPort)

createSocket(java.net.Socket socket, java.lang.String host, int port, boolean autoClose)

createSocket(java.lang.String host, int port)

createSocket(java.lang.String host, int port, java.net.InetAddress localHost, int localPort)

getDefaultCipherSuites()

getSupportedCipherSuites()

○: サポート

org.postgresql.util

インタフェース名

メソッド名

jdbc4/jdbc41

PGInterval

add(java.util.Calendar cal)

add(java.util.Date date)

add(PGInterval interval)

equals(java.lang.Object obj)

getDays()

getHours()

getMinutes()

getMonths()

getSeconds()

getValue()

getYears()

hashCode()

scale(int factor)

setDays(int days)

setHours(int hours)

setMinutes(int minutes)

setMonths(int months)

setSeconds(double seconds)

setValue(int years, int months, int days, int hours, int minutes, double seconds)

setValue(java.lang.String value)

setYears(int years)

PGJDBCMain

main(java.lang.String[] args)

PGmoney

equals(java.lang.Object obj)

getValue()

setValue(java.lang.String s)

PGobject

clone()

equals(java.lang.Object obj)

getType()

getValue()

setType(java.lang.String type)

setValue(java.lang.String value)

toString()

ServerErrorMessage

getColumn()

getConstraint()

getDatatype()

getDetail()

getFile()

getHint()

getInternalPosition()

getInternalQuery()

getLine()

getMessage()

getPosition()

getRoutine()

getSchema()

getSeverity()

getSQLState()

getTable()

getWhere()

toString()

○: サポート

org.postgresql.xa

インタフェース名

メソッド名

jdbc4/jdbc41

PGXADataSource

○: サポート

ConnectionPoolDataSource

インタフェース名

メソッド名

jdbc4/jdbc41

ConnectionPoolDataSource

getLoginTimeout()

getLogWriter()

setLoginTimeout(int seconds)

setLogWriter(PrintWriter out)

○: サポート