[JDBC] Unity Mongo JDBC Driver Properties

Unity Mongo JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
debug	The debug property will cause the driver to print out debug information to the console during its operation.	false	true false	false
user	User name for connection.	true		bizteco
password	Password for connection.	false		btc7btc
cursor	For scrollable ResultSets, should the cursor be on the client or server.	false	client server	client
encoding	Character encoding used.	false	utf-8	utf-8
dbname	Database name to use.	false		admin
validation	Schema validation performed. Strict validation ensures all identifiers are in schema. Flex validation will perform best effort validation against a schema (if present) but attempt to execute query in all cases. None will never generate or use any schema information.	false	strict flex none	flex
schema	Location of schema. Either a file URI or location in MongoDB.	false		mongo:192.168.0.13:8989/db/_schema
rebuildschema	If true, rebuilds schema for connection. If false, uses existing cached schema if available. Uses location provided in schema property.	false	true false	false
readpref	Specifies a MongoDB ReadPreference such as primary, secondary, or nearest.	false	primary primarypref secondary secondarypref nearest	primary
readparam	Used to pass parameters to configure ReadPreference in the form of JSON strings which are converted to DBObjects.	false	JSON string that will be converted into DBObject as ReadPreference parameters.
writeconcern	Write concern controls how writing and updated are handled. Settings such as unacknowledged or acknowledged are possible.	false	unack ack replicaAck journaled	ack
writeparam	Used to configure a write concern based on a tag name. Calls WriteConcern(String w) constructor with value as w parameter.	false
ssl	Use SSL connections to Mongo instance.	false	true false	false
samplesize	When building schemas fraction of collection to sample in the range of 0 to 1. Default is 0.001.	false	0 1
log	File location of log file to store debugging information if debug is true.	false

[JDBC] Vertica JDBC Driver Properties

Vertica JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
autocommit	If false, the connection will start with autocommit disabled	false	false true	null
backupservernode	A comma separated list of host:port pairs to use if primary server is unavailable	false	?	null
connectionloadbalance	If true, use native load balancing	false	false true	null
connsettings	SQL to run after a connection is established to change session properties on the server	false	?	null
directbatchinsert	If true, batch insert data is written directly to the ROS	false	false true	null
enableroutablequeries	If true, connections returned will implement VerticaRoutableConnection and provide access to the VGet API	false	false true	null
failonmultinodeplans	If true, VGet operations that require more than a single node's resources are disallowed	false	false true	null
jaasconfigname	The name of a JAAS configuration that the driver should use when performing GSS authentication	false	?	null
kerberoshostname	The host name portion of the kerberos service principal that identifies the Vertica server	false	?	null
kerberosservicename	The service name portion of the kerberos service principal that identifies the Vertica server	false	?	null
logintimeout	The amount of time to spend establishing a connection before giving up	false	?	null
loglevel	The amount of detail to include in log messages	false	error trace off debug warning info	null
lognamespace	A package name to restrict logging to	false	?	null
logpath	The directory to store the log file in	false	?	null
maxpooledconnections	The maximum number of connections allowed in the VerticaRoutableConnection's connection pool	false	?	null
maxpooledconnectionspernode	The maximum number of connections allowed to a single node in the VerticaRoutableConnection's connection pool	false	?	null
maxpooledconnectionuses	The maximum number of times to use a pooled connection before closing it	false	?	null
metadatacachelifetime	Time in seconds to cache table and projection metadata used during VGet operations	false	?	null
nodedownwaittime	Time in seconds to wait before attemptng a new connection to a node after a connection failure occurs	false	?	null
preferredaddressfamily	The address family type to prefer when resolving hostnames	false	ipv6 ipv4 none	null
readonly	If true, commands that modify the database in any way will result in an error	false	false true	null
resultbuffersize	The size in bytes of the client side result cache (one per ResultSet)	false	?	null
sessionlabel	A string to identify the JDBC connection's session on the server	false	?	null
ssl	If true, connect using SSL	false	false true	null
streamingbatchinsert	If true, send PreparedStatement batch insert data to the server as it arrives via addBatch() instead of holding in memory until executeBatch(). Streaming is faster and uses less memory, but while a streaming batch insert is in progress PreparedStatement.clearBatch() is disabled and other connection operations are not allowed	false	false true	null
threepartnaming	If true, use the database name as the catalog name when reporting metadata	false	false true	null
transactionisolation	The default transaction isolation level to use	false	2 0 8	null

[JDBC] PostgreSQL JDBC Driver Properties

PostgreSQL JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
PGDBNAME	Database name to connect to; may be specified directly in the JDBC URL.	true		null
user	Username to connect to the database as.	true		bizteco
PGHOST	Hostname of the PostgreSQL server; may be specified directly in the JDBC URL.	false		null
PGPORT	Port number to connect to the PostgreSQL server on; may be specified directly in the JDBC URL.	false		null
password	Password to use when authenticating.	false		btc7btc
protocolVersion	Force use of a particular protocol version when connecting; if set, disables protocol version fallback.	false		null
ssl	Control use of SSL; any nonnull value causes SSL to be required.	false		null
sslfactory	Provide a SSLSocketFactory class when using SSL.	false		null
sslfactoryarg	Argument forwarded to constructor of SSLSocketFactory class.	false		null
loglevel	Control the driver's log verbosity: 0 is off, 1 is INFO, 2 is DEBUG.	false	0 1 2	null
allowEncodingChanges	Allow the user to change the client_encoding variable.	false		null
logUnclosedConnections	When connections that are not explicitly closed are garbage collected, log the stacktrace from the opening of the connection to trace the leak source.	false		null
prepareThreshold	Default statement prepare threshold (numeric).	false		null
binaryTransfer	Use binary format for sending and receiving data if possible.	false		null
binaryTransferEnable	Comma separated list of types to enable binary transfer. Either OID numbers or names.	false		null
binaryTransferDisable	Comma separated list of types to disable binary transfer. Either OID numbers or names. Overrides values in the driver default set and values set with binaryTransferEnable.	false		null
charSet	When connecting to a pre-7.3 server, the database encoding to assume is in use.	false		null
compatible	Force compatibility of some features with an older version of the driver.	false	7.1 7.2 7.3 7.4 8.0 8.1 8.2	null
loginTimeout	The login timeout, in seconds; 0 means no timeout beyond the normal TCP connection timout.	false		null
socketTimeout	The timeout value for socket read operations, in seconds; 0 means no timeout.	false		null
tcpKeepAlive	Enable or disable TCP keep-alive probe.	false		null
stringtype	The type to bind String parameters as (usually 'varchar'; 'unspecified' allows implicit casting to other types)	false	varchar unspecified	null
kerberosServerName	The Kerberos service name to use when authenticating with GSSAPI. This is equivalent to libpq's PGKRBSRVNAME environment variable.	false		null
jaasApplicationName	Specifies the name of the JAAS system or application login configuration.	false		null

[JDBC] DerbyDB JDBC Driver Properties

DerbyDB JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
user	접속에 대한 사용자 이름	true		scott
password	접속에 대한 사용자의 비밀번호	false		tiger

[JDBC] Altibase5 JDBC Driver Properties

Altibase5 JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
user	null	false		SYS
password	null	false		MANAGER
auto_commit	null	false		1
FETCH_ENOUGH	null	false		1024
CM_PATCH_VERSION	null	false		2
encoding	null	false	KSC5601 US7ASCII KOI8-R CP1251 GB2312 BIG5 UTF-8	KSC5601
CONNTYPE	null	false		1

[JDBC] jTDS SQL Server JDBC Driver Properties

jTDS SQL Server JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
PREPARESQL	Use stored procedures for prepared statements.	false	0 1 2 3	3
SERVERTYPE	The type of database (1 is SQL Server, 2 is Sybase).	true	1 2	1
DATABASENAME	The database name.	false		master
XAEMULATION	Set to false to use the Microsoft Distributed Transaction Coordinator.	false	true false	true
PROGNAME	The program name advertised by the driver.	false		jTDS
LOGINTIMEOUT	The time to wait for a successful login before timing out.	false		0
MACADDRESS	Hex-encoded client MAC address.	false		000000000000
USEJCIFS	Force use of jCIFS library on Windows for connecting via named pipes.	false		false
SSL	Set the SSL level.	false	off request require authenticate	off
PASSWORD	The database password.	false		btc0btc
LOBBUFFER	The amount of LOB data to buffer in memory before caching to disk.	false		32768
TCPNODELAY	Enable/disable TCP_NODELAY	false	true false	true
LASTUPDATECOUNT	Return only the last update count on executeUpdate.	false	true false	true
CACHEMETADATA	Set to true to enable the caching of column meta data for prepared statements.	false	true false	false
SENDSTRINGPARAMETERSASUNICODE	If strings should be sent as unicode values.	false	true false	true
bufferMinPackets	The minimum number of packets per statement to buffer to memory.	false		8
SOCKETKEEPALIVE	Use TCP/IP socket keep alive feature.	false		false
BUFFERDIR	The directory to buffer data to.	false		C:\Users\ADMINI~1\AppData\Local\Temp
DOMAIN	The domain used for authentication.	false
INSTANCE	The database server instance.	false
TDS	The database server protocol.	false	4.2 5.0 7.0 8.0	8.0
WSID	Workstation ID or client host name override. Will be stored in master.dbo.sysprocesses, column hostname.	false
LOGFILE	Set the name of a file for the capture of logging information.	false
bufferMaxMemory	The global buffer memory limit for all connections (in kilobytes).	false		1024
BATCHSIZE	The number of statements to submit at once. Batches are broken up in pieces this large.	false		0
CHARSET	Server character set for non-Unicode character values.	false
SERVERNAME	The database server hostname.	true		192.168.0.88
USECURSORS	Use SQL Server fast forward only result sets for forward only result sets.	false	true false	false
BINDADDRESS	The IP address of the local interface that jTDS should bind to when connecting to a database via TCP/IP.	false
PORTNUMBER	The database server port number.	false		1433
MAXSTATEMENTS	The maximum number of statements to keep open. This is only a target for the cache.	false		500
USELOBS	Map large types (IMAGE and TEXT/NTEXT) to LOBs vs. String/byte[].	false	true false	true
APPNAME	The application name advertised by the driver.	false		jTDS
SOCKETTIMEOUT	The TCP/IP socket timeout value in seconds or 0 for no timeout.	false		0
USENTLMV2	Set to true to send LMv2/NTLMv2 responses when using Windows authentication	false		null
LANGUAGE	The language for server messages.	false
USER	The database user.	false		sa
PACKETSIZE	The network packet size (a multiple of 512).	false		0
NAMEDPIPE	Use named pipes to connect instead of TCP/IP sockets.	false	true false	false
PROCESSID	The process ID reported by the driver.	false		123

[JDBC] MySQL JDBC Driver Properties

MySQL DBC Driver

Property Name	Description	Reqired	Choices	Sample Value
HOST	Hostname of MySQL Server	true		192.168.0.88
PORT	Port number of MySQL Server	false		3306
DBNAME	Database name	false		win_mys
user	Username to authenticate as	true		bizteco
password	Password to use for authentication	true		btc7btc
allowLoadLocalInfile	Should the driver allow use of 'LOAD DATA LOCAL INFILE...' (defaults to 'true').	false	true false yes no	true
allowMultiQueries	Allow the use of ';' to delimit multiple queries during one statement (true/false), defaults to 'false', and does not affect the addBatch() and executeBatch() methods, which instead rely on rewriteBatchStatements.	false	true false yes no	false
allowNanAndInf	Should the driver allow NaN or +/- INF values in PreparedStatement.setDouble()?	false	true false yes no	false
allowUrlInLocalInfile	Should the driver allow URLs in 'LOAD DATA LOCAL INFILE' statements?	false	true false yes no	false
alwaysSendSetIsolation	Should the driver always communicate with the database when Connection.setTransactionIsolation() is called? If set to false, the driver will only communicate with the database when the requested transaction isolation is different than the whichever is newer, the last value that was set via Connection.setTransactionIsolation(), or the value that was read from the server when the connection was established. Note that useLocalSessionState=true will force the same behavior as alwaysSendSetIsolation=false, regardless of how alwaysSendSetIsolation is set.	false	true false yes no	true
autoClosePStmtStreams	Should the driver automatically call .close() on streams/readers passed as arguments via set*() methods?	false	true false yes no	false
autoDeserialize	Should the driver automatically detect and de-serialize objects stored in BLOB fields?	false	true false yes no	false
autoGenerateTestcaseScript	Should the driver dump the SQL it is executing, including server-side prepared statements to STDERR?	false	true false yes no	false
autoReconnect	Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new transaction. The use of this feature is not recommended, because it has side effects related to session state and data consistency when applications don't handle SQLExceptions properly, and is only designed to be used when you are unable to configure your application to handle SQLExceptions resulting from dead and stale connections properly. Alternatively, as a last option, investigate setting the MySQL server variable "wait_timeout" to a high value, rather than the default of 8 hours.	false	true false yes no	false
autoReconnectForPools	Use a reconnection strategy appropriate for connection pools (defaults to 'false')	false	true false yes no	false
blobSendChunkSize	Chunk to use when sending BLOB/CLOBs via ServerPreparedStatements	false		1048576
autoSlowLog	Instead of using slowQueryThreshold* to determine if a query is slow enough to be logged, maintain statistics that allow the driver to determine queries that are outside the 99th percentile?	false	true false yes no	true
blobsAreStrings	Should the driver always treat BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?	false	true false yes no	false
functionsNeverReturnBlobs	Should the driver always treat data from functions returning BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?	false	true false yes no	false
cacheCallableStmts	Should the driver cache the parsing stage of CallableStatements	false	true false yes no	false
cachePrepStmts	Should the driver cache the parsing stage of PreparedStatements of client-side prepared statements, the "check" for suitability of server-side prepared and server-side prepared statements themselves?	false	true false yes no	false
cacheResultSetMetadata	Should the driver cache ResultSetMetaData for Statements and PreparedStatements? (Req. JDK-1.4+, true/false, default 'false')	false	true false yes no	false
cacheServerConfiguration	Should the driver cache the results of 'SHOW VARIABLES' and 'SHOW COLLATION' on a per-URL basis?	false	true false yes no	false
callableStmtCacheSize	If 'cacheCallableStmts' is enabled, how many callable statements should be cached?	false		100
capitalizeTypeNames	Capitalize type names in DatabaseMetaData? (usually only useful when using WebObjects, true/false, defaults to 'false')	false	true false yes no	true
characterEncoding	If 'useUnicode' is set to true, what character encoding should the driver use when dealing with strings? (defaults is to 'autodetect')	false		null
characterSetResults	Character set to tell the server to return results as.	false		null
clientInfoProvider	The name of a class that implements the com.mysql.jdbc.JDBC4ClientInfoProvider interface in order to support JDBC-4.0's Connection.get/setClientInfo() methods	false		com.mysql.jdbc.JDBC4CommentClientInfoProvider
clobberStreamingResults	This will cause a 'streaming' ResultSet to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.	false	true false yes no	false
clobCharacterEncoding	The character encoding to use for sending and retrieving TEXT, MEDIUMTEXT and LONGTEXT values instead of the configured connection characterEncoding	false		null
compensateOnDuplicateKeyUpdateCounts	Should the driver compensate for the update counts of "ON DUPLICATE KEY" INSERT statements (2 = 1, 0 = 1) when using prepared statements?	false	true false yes no	false
connectionCollation	If set, tells the server to use this collation via 'set collation_connection'	false		null
connectionLifecycleInterceptors	A comma-delimited list of classes that implement "com.mysql.jdbc.ConnectionLifecycleInterceptor" that should notified of connection lifecycle events (creation, destruction, commit, rollback, setCatalog and setAutoCommit) and potentially alter the execution of these commands. ConnectionLifecycleInterceptors are "stackable", more than one interceptor may be specified via the configuration property as a comma-delimited list, with the interceptors executed in order from left to right.	false		null
connectTimeout	Timeout for socket connect (in milliseconds), with 0 being no timeout. Only works on JDK-1.4 or newer. Defaults to '0'.	false		0
continueBatchOnError	Should the driver continue processing batch commands if one statement fails. The JDBC spec allows either way (defaults to 'true').	false	true false yes no	true
createDatabaseIfNotExist	Creates the database given in the URL if it doesn't yet exist. Assumes the configured user has permissions to create databases.	false	true false yes no	false
defaultFetchSize	The driver will call setFetchSize(n) with this value on all newly-created Statements	false		0
useServerPrepStmts	Use server-side prepared statements if the server supports them?	false	true false yes no	false
dontTrackOpenResources	The JDBC specification requires the driver to automatically track and close resources, however if your application doesn't do a good job of explicitly calling close() on statements or result sets, this can cause memory leakage. Setting this property to true relaxes this constraint, and can be more memory efficient for some applications.	false	true false yes no	false
dumpQueriesOnException	Should the driver dump the contents of the query sent to the server in the message for SQLExceptions?	false	true false yes no	false
dynamicCalendars	Should the driver retrieve the default calendar when required, or cache it per connection/session?	false	true false yes no	false
elideSetAutoCommits	If using MySQL-4.1 or newer, should the driver only issue 'set autocommit=n' queries when the server's state doesn't match the requested state by Connection.setAutoCommit(boolean)?	false	true false yes no	false
emptyStringsConvertToZero	Should the driver allow conversions from empty string fields to numeric values of '0'?	false	true false yes no	true
emulateLocators	Should the driver emulate java.sql.Blobs with locators? With this feature enabled, the driver will delay loading the actual Blob data until the one of the retrieval methods (getInputStream(), getBytes(), and so forth) on the blob data stream has been accessed. For this to work, you must use a column alias with the value of the column to the actual name of the Blob. The feature also has the following restrictions: The SELECT that created the result set must reference only one table, the table must have a primary key; the SELECT must alias the original blob column name, specified as a string, to an alternate name; the SELECT must cover all columns that make up the primary key.	false	true false yes no	false
emulateUnsupportedPstmts	Should the driver detect prepared statements that are not supported by the server, and replace them with client-side emulated versions?	false	true false yes no	true
enablePacketDebug	When enabled, a ring-buffer of 'packetDebugBufferSize' packets will be kept, and dumped when exceptions are thrown in key areas in the driver's code	false	true false yes no	false
enableQueryTimeouts	When enabled, query timeouts set via Statement.setQueryTimeout() use a shared java.util.Timer instance for scheduling. Even if the timeout doesn't expire before the query is processed, there will be memory used by the TimerTask for the given timeout which won't be reclaimed until the time the timeout would have expired if it hadn't been cancelled by the driver. High-load environments might want to consider disabling this functionality.	false	true false yes no	true
explainSlowQueries	If 'logSlowQueries' is enabled, should the driver automatically issue an 'EXPLAIN' on the server and send the results to the configured log at a WARN level?	false	true false yes no	false
exceptionInterceptors	Comma-delimited list of classes that implement com.mysql.jdbc.ExceptionInterceptor. These classes will be instantiated one per Connection instance, and all SQLExceptions thrown by the driver will be allowed to be intercepted by these interceptors, in a chained fashion, with the first class listed as the head of the chain.	false		null
failOverReadOnly	When failing over in autoReconnect mode, should the connection be set to 'read-only'?	false	true false yes no	true
gatherPerfMetrics	Should the driver gather performance metrics, and report them via the configured logger every 'reportMetricsIntervalMillis' milliseconds?	false	true false yes no	false
generateSimpleParameterMetadata	Should the driver generate simplified parameter metadata for PreparedStatements when no metadata is available either because the server couldn't support preparing the statement, or server-side prepared statements are disabled?	false	true false yes no	false
holdResultsOpenOverStatementClose	Should the driver close result sets on Statement.close() as required by the JDBC specification?	false	true false yes no	false
includeInnodbStatusInDeadlockExceptions	Include the output of "SHOW ENGINE INNODB STATUS" in exception messages when deadlock exceptions are detected?	false	true false yes no	false
includeThreadDumpInDeadlockExceptions	Include a current Java thread dump in exception messages when deadlock exceptions are detected?	false	true false yes no	false
includeThreadNamesAsStatementComment	Include the name of the current thread as a comment visible in "SHOW PROCESSLIST", or in Innodb deadlock dumps, useful in correlation with "includeInnodbStatusInDeadlockExceptions=true" and "includeThreadDumpInDeadlockExceptions=true".	false	true false yes no	false
ignoreNonTxTables	Ignore non-transactional table warning for rollback? (defaults to 'false').	false	true false yes no	false
initialTimeout	If autoReconnect is enabled, the initial time to wait between re-connect attempts (in seconds, defaults to '2').	false		2
interactiveClient	Set the CLIENT_INTERACTIVE flag, which tells MySQL to timeout connections based on INTERACTIVE_TIMEOUT instead of WAIT_TIMEOUT	false	true false yes no	false
jdbcCompliantTruncation	Should the driver throw java.sql.DataTruncation exceptions when data is truncated as is required by the JDBC specification when connected to a server that supports warnings (MySQL 4.1.0 and newer)? This property has no effect if the server sql-mode includes STRICT_TRANS_TABLES.	false	true false yes no	true
largeRowSizeThreshold	What size result set row should the JDBC driver consider "large", and thus use a more memory-efficient way of representing the row internally?	false		2048
loadBalanceStrategy	If using a load-balanced connection to connect to SQL nodes in a MySQL Cluster/NDB configuration (by using the URL prefix "jdbc:mysql:loadbalance://"), which load balancing algorithm should the driver use: (1) "random" - the driver will pick a random host for each request. This tends to work better than round-robin, as the randomness will somewhat account for spreading loads where requests vary in response time, while round-robin can sometimes lead to overloaded nodes if there are variations in response times across the workload. (2) "bestResponseTime" - the driver will route the request to the host that had the best response time for the previous transaction.	false		random
loadBalanceBlacklistTimeout	Time in milliseconds between checks of servers which are unavailable, by controlling how long a server lives in the global blacklist.	false		0
loadBalancePingTimeout	Time in milliseconds to wait for ping response from each of load-balanced physical connections when using load-balanced Connection.	false		0
loadBalanceValidateConnectionOnSwapServer	Should the load-balanced Connection explicitly check whether the connection is live when swapping to a new physical connection at commit/rollback?	false	true false yes no	false
loadBalanceConnectionGroup	Logical group of load-balanced connections within a classloader, used to manage different groups independently. If not specified, live management of load-balanced connections is disabled.	false		null
loadBalanceExceptionChecker	Fully-qualified class name of custom exception checker. The class must implement com.mysql.jdbc.LoadBalanceExceptionChecker interface, and is used to inspect SQLExceptions and determine whether they should trigger fail-over to another host in a load-balanced deployment.	false		com.mysql.jdbc.StandardLoadBalanceExceptionChecker
loadBalanceSQLStateFailover	Comma-delimited list of SQLState codes used by default load-balanced exception checker to determine whether a given SQLException should trigger failover. The SQLState of a given SQLException is evaluated to determine whether it begins with any value in the comma-delimited list.	false		null
loadBalanceSQLExceptionSubclassFailover	Comma-delimited list of classes/interfaces used by default load-balanced exception checker to determine whether a given SQLException should trigger failover. The comparison is done using Class.isInstance(SQLException) using the thrown SQLException.	false		null
loadBalanceEnableJMX	Enables JMX-based management of load-balanced connection groups, including live addition/removal of hosts from load-balancing pool.	false	true false yes no	false
loadBalanceAutoCommitStatementRegex	When load-balancing is enabled for auto-commit statements (via loadBalanceAutoCommitStatementThreshold), the statement counter will only increment when the SQL matches the regular expression. By default, every statement issued matches.	false		null
loadBalanceAutoCommitStatementThreshold	When auto-commit is enabled, the number of statements which should be executed before triggering load-balancing to rebalance. Default value of 0 causes load-balanced connections to only rebalance when exceptions are encountered, or auto-commit is disabled and transactions are explicitly committed or rolled back.	false		0
localSocketAddress	Hostname or IP address given to explicitly configure the interface that the driver will bind the client side of the TCP/IP connection to when connecting.	false		null
locatorFetchBufferSize	If 'emulateLocators' is configured to 'true', what size buffer should be used when fetching BLOB data for getBinaryInputStream?	false		1048576
logger	The name of a class that implements "com.mysql.jdbc.log.Log" that will be used to log messages to. (default is "com.mysql.jdbc.log.StandardLogger", which logs to STDERR)	false		com.mysql.jdbc.log.StandardLogger
logSlowQueries	Should queries that take longer than 'slowQueryThresholdMillis' be logged?	false	true false yes no	false
logXaCommands	Should the driver log XA commands sent by MysqlXaConnection to the server, at the DEBUG level of logging?	false	true false yes no	false
maintainTimeStats	Should the driver maintain various internal timers to enable idle time calculations as well as more verbose error messages when the connection to the server fails? Setting this property to false removes at least two calls to System.getCurrentTimeMillis() per query.	false	true false yes no	true
maxQuerySizeToLog	Controls the maximum length/size of a query that will get logged when profiling or tracing	false		2048
maxReconnects	Maximum number of reconnects to attempt if autoReconnect is true, default is '3'.	false		3
retriesAllDown	When using loadbalancing, the number of times the driver should cycle through available hosts, attempting to connect. Between cycles, the driver will pause for 250ms if no servers are available.	false		120
maxRows	The maximum number of rows to return (0, the default means return all rows).	false		-1
metadataCacheSize	The number of queries to cache ResultSetMetadata for if cacheResultSetMetaData is set to 'true' (default 50)	false		50
netTimeoutForStreamingResults	What value should the driver automatically set the server setting 'net_write_timeout' to when the streaming result sets feature is in use? (value has unit of seconds, the value '0' means the driver will not try and adjust this value)	false		600
noAccessToProcedureBodies	When determining procedure parameter types for CallableStatements, and the connected user can't access procedure bodies through "SHOW CREATE PROCEDURE" or select on mysql.proc should the driver instead create basic metadata (all parameters reported as IN VARCHARs, but allowing registerOutParameter() to be called on them anyway) instead of throwing an exception?	false	true false yes no	false
noDatetimeStringSync	Don't ensure that ResultSet.getDatetimeType().toString().equals(ResultSet.getString())	false	true false yes no	false
noTimezoneConversionForTimeType	Don't convert TIME values using the server timezone if 'useTimezone'='true'	false	true false yes no	false
nullCatalogMeansCurrent	When DatabaseMetadataMethods ask for a 'catalog' parameter, does the value null mean use the current catalog? (this is not JDBC-compliant, but follows legacy behavior from earlier versions of the driver)	false	true false yes no	true
nullNamePatternMatchesAll	Should DatabaseMetaData methods that accept *pattern parameters treat null the same as '%' (this is not JDBC-compliant, however older versions of the driver accepted this departure from the specification)	false	true false yes no	true
packetDebugBufferSize	The maximum number of packets to retain when 'enablePacketDebug' is true	false		20
padCharsWithSpace	If a result set column has the CHAR type and the value does not fill the amount of characters specified in the DDL for the column, should the driver pad the remaining characters with space (for ANSI compliance)?	false	true false yes no	false
paranoid	Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? (defaults to 'false')	false	true false yes no	false
pedantic	Follow the JDBC spec to the letter.	false	true false yes no	false
pinGlobalTxToPhysicalConnection	When using XAConnections, should the driver ensure that operations on a given XID are always routed to the same physical connection? This allows the XAConnection to support "XA START ... JOIN" after "XA END" has been called	false	true false yes no	false
populateInsertRowWithDefaultValues	When using ResultSets that are CONCUR_UPDATABLE, should the driver pre-populate the "insert" row with default values from the DDL for the table used in the query so those values are immediately available for ResultSet accessors? This functionality requires a call to the database for metadata each time a result set of this type is created. If disabled (the default), the default values will be populated by the an internal call to refreshRow() which pulls back default values and/or values changed by triggers.	false	true false yes no	false
prepStmtCacheSize	If prepared statement caching is enabled, how many prepared statements should be cached?	false		25
prepStmtCacheSqlLimit	If prepared statement caching is enabled, what's the largest SQL the driver will cache the parsing for?	false		256
parseInfoCacheFactory	Name of a class implementing com.mysql.jdbc.CacheAdapterFactory, which will be used to create caches for the parsed representation of client-side prepared statements.	false		com.mysql.jdbc.PerConnectionLRUFactory
processEscapeCodesForPrepStmts	Should the driver process escape codes in queries that are prepared?	false	true false yes no	true
profilerEventHandler	Name of a class that implements the interface com.mysql.jdbc.profiler.ProfilerEventHandler that will be used to handle profiling/tracing events.	false		com.mysql.jdbc.profiler.LoggingProfilerEventHandler
profileSql	Deprecated, use 'profileSQL' instead. Trace queries and their execution/fetch times on STDERR (true/false) defaults to 'false'	false		null
profileSQL	Trace queries and their execution/fetch times to the configured logger (true/false) defaults to 'false'	false	true false yes no	false
propertiesTransform	An implementation of com.mysql.jdbc.ConnectionPropertiesTransform that the driver will use to modify URL properties passed to the driver before attempting a connection	false		null
queriesBeforeRetryMaster	Number of queries to issue before falling back to master when failed over (when using multi-host failover). Whichever condition is met first, 'queriesBeforeRetryMaster' or 'secondsBeforeRetryMaster' will cause an attempt to be made to reconnect to the master. Defaults to 50.	false		50
queryTimeoutKillsConnection	If the timeout given in Statement.setQueryTimeout() expires, should the driver forcibly abort the Connection instead of attempting to abort the query?	false	true false yes no	false
reconnectAtTxEnd	If autoReconnect is set to true, should the driver attempt reconnections at the end of every transaction?	false	true false yes no	false
relaxAutoCommit	If the version of MySQL the driver connects to does not support transactions, still allow calls to commit(), rollback() and setAutoCommit() (true/false, defaults to 'false')?	false	true false yes no	false
reportMetricsIntervalMillis	If 'gatherPerfMetrics' is enabled, how often should they be logged (in ms)?	false		30000
requireSSL	Require SSL connection if useSSL=true? (defaults to 'false').	false	true false yes no	false
resourceId	A globally unique name that identifies the resource that this datasource or connection is connected to, used for XAResource.isSameRM() when the driver can't determine this value based on hostnames used in the URL	false		null
resultSetSizeThreshold	If the usage advisor is enabled, how many rows should a result set contain before the driver warns that it is suspiciously large?	false		100
retainStatementAfterResultSetClose	Should the driver retain the Statement reference in a ResultSet after ResultSet.close() has been called. This is not JDBC-compliant after JDBC-4.0.	false	true false yes no	false
rewriteBatchedStatements	Should the driver use multiqueries (irregardless of the setting of "allowMultiQueries") as well as rewriting of prepared statements for INSERT into multi-value inserts when executeBatch() is called? Notice that this has the potential for SQL injection if using plain java.sql.Statements and your code doesn't sanitize input correctly. Notice that for prepared statements, server-side prepared statements can not currently take advantage of this rewrite option, and that if you don't specify stream lengths when using PreparedStatement.set*Stream(), the driver won't be able to determine the optimum number of parameters per batch and you might receive an error from the driver that the resultant packet is too large. Statement.getGeneratedKeys() for these rewritten statements only works when the entire batch includes INSERT statements.	false	true false yes no	false
rollbackOnPooledClose	Should the driver issue a rollback() when the logical connection in a pool is closed?	false	true false yes no	true
roundRobinLoadBalance	When autoReconnect is enabled, and failoverReadonly is false, should we pick hosts to connect to on a round-robin basis?	false	true false yes no	false
runningCTS13	Enables workarounds for bugs in Sun's JDBC compliance testsuite version 1.3	false	true false yes no	false
secondsBeforeRetryMaster	How long should the driver wait, when failed over, before attempting	false		30
selfDestructOnPingSecondsLifetime	If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connnection's lifetime exceeds this value.	false		0
selfDestructOnPingMaxOperations	=If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connnection's count of commands sent to the server exceeds this value.	false		0
serverTimezone	Override detection/mapping of timezone. Used when timezone from server doesn't map to Java timezone	false		null
sessionVariables	A comma-separated list of name/value pairs to be sent as SET SESSION ... to the server when the driver connects.	false		null
slowQueryThresholdMillis	If 'logSlowQueries' is enabled, how long should a query (in ms) before it is logged as 'slow'?	false		2000
slowQueryThresholdNanos	If 'useNanosForElapsedTime' is set to true, and this property is set to a non-zero value, the driver will use this threshold (in nanosecond units) to determine if a query was slow.	false		0
socketFactory	The name of the class that the driver should use for creating socket connections to the server. This class must implement the interface 'com.mysql.jdbc.SocketFactory' and have public no-args constructor.	false		com.mysql.jdbc.StandardSocketFactory
socketTimeout	Timeout on network socket operations (0, the default means no timeout).	false		0
statementInterceptors	A comma-delimited list of classes that implement "com.mysql.jdbc.StatementInterceptor" that should be placed "in between" query execution to influence the results. StatementInterceptors are "chainable", the results returned by the "current" interceptor will be passed on to the next in in the chain, from left-to-right order, as specified in this property.	false		null
strictFloatingPoint	Used only in older versions of compliance test	false	true false yes no	false
strictUpdates	Should the driver do strict checking (all primary keys selected) of updatable result sets (true, false, defaults to 'true')?	false	true false yes no	true
overrideSupportsIntegrityEnhancementFacility	Should the driver return "true" for DatabaseMetaData.supportsIntegrityEnhancementFacility() even if the database doesn't support it to workaround applications that require this method to return "true" to signal support of foreign keys, even though the SQL specification states that this facility contains much more than just foreign key support (one such application being OpenOffice)?	false	true false yes no	false
tcpNoDelay	If connecting using TCP/IP, should the driver set SO_TCP_NODELAY (disabling the Nagle Algorithm)?	false	true false yes no	true
tcpKeepAlive	If connecting using TCP/IP, should the driver set SO_KEEPALIVE?	false	true false yes no	true
tcpRcvBuf	If connecting using TCP/IP, should the driver set SO_RCV_BUF to the given value? The default value of '0', means use the platform default value for this property)	false		0
tcpSndBuf	If connecting using TCP/IP, should the driver set SO_SND_BUF to the given value? The default value of '0', means use the platform default value for this property)	false		0
tcpTrafficClass	If connecting using TCP/IP, should the driver set traffic class or type-of-service fields ?See the documentation for java.net.Socket.setTrafficClass() for more information.	false		0
tinyInt1isBit	Should the driver treat the datatype TINYINT(1) as the BIT type (because the server silently converts BIT -> TINYINT(1) when creating tables)?	false	true false yes no	true
traceProtocol	Should trace-level network protocol be logged?	false	true false yes no	false
treatUtilDateAsTimestamp	Should the driver treat java.util.Date as a TIMESTAMP for the purposes of PreparedStatement.setObject()?	false	true false yes no	true
transformedBitIsBoolean	If the driver converts TINYINT(1) to a different type, should it use BOOLEAN instead of BIT for future compatibility with MySQL-5.0, as MySQL-5.0 has a BIT type?	false	true false yes no	false
useBlobToStoreUTF8OutsideBMP	Tells the driver to treat [MEDIUM/LONG]BLOB columns as [LONG]VARCHAR columns holding text encoded in UTF-8 that has characters outside the BMP (4-byte encodings), which MySQL server can't handle natively.	false	true false yes no	false
utf8OutsideBmpExcludedColumnNamePattern	When "useBlobToStoreUTF8OutsideBMP" is set to "true", column names matching the given regex will still be treated as BLOBs unless they match the regex specified for "utf8OutsideBmpIncludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.	false		null
utf8OutsideBmpIncludedColumnNamePattern	Used to specify exclusion rules to "utf8OutsideBmpExcludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.	false		null
useCompression	Use zlib compression when communicating with the server (true/false)? Defaults to 'false'.	false	true false yes no	false
useColumnNamesInFindColumn	Prior to JDBC-4.0, the JDBC specification had a bug related to what could be given as a "column name" to ResultSet methods like findColumn(), or getters that took a String property. JDBC-4.0 clarified "column name" to mean the label, as given in an "AS" clause and returned by ResultSetMetaData.getColumnLabel(), and if no AS clause, the column name. Setting this property to "true" will give behavior that is congruent to JDBC-3.0 and earlier versions of the JDBC specification, but which because of the specification bug could give unexpected results. This property is preferred over "useOldAliasMetadataBehavior" unless you need the specific behavior that it provides with respect to ResultSetMetadata.	false	true false yes no	false
useConfigs	Load the comma-delimited list of configuration properties before parsing the URL or applying user-specified properties. These configurations are explained in the 'Configurations' of the documentation.	false		null
useCursorFetch	If connected to MySQL > 5.0.2, and setFetchSize() > 0 on a statement, should that statement use cursor-based fetching to retrieve rows?	false	true false yes no	false
useDynamicCharsetInfo	Should the driver use a per-connection cache of character set information queried from the server when necessary, or use a built-in static mapping that is more efficient, but isn't aware of custom character sets or character sets implemented after the release of the JDBC driver?	false	true false yes no	true
useDirectRowUnpack	Use newer result set row unpacking code that skips a copy from network buffers to a MySQL packet instance and instead reads directly into the result set row data buffers.	false	true false yes no	true
useFastIntParsing	Use internal String->Integer conversion routines to avoid excessive object creation?	false	true false yes no	true
useFastDateParsing	Use internal String->Date/Time/Timestamp conversion routines to avoid excessive object creation?	false	true false yes no	true
useHostsInPrivileges	Add '@hostname' to users in DatabaseMetaData.getColumn/TablePrivileges() (true/false), defaults to 'true'.	false	true false yes no	true
useInformationSchema	When connected to MySQL-5.0.7 or newer, should the driver use the INFORMATION_SCHEMA to derive information used by DatabaseMetaData?	false	true false yes no	false
useJDBCCompliantTimezoneShift	Should the driver use JDBC-compliant rules when converting TIME/TIMESTAMP/DATETIME values' timezone information for those JDBC arguments which take a java.util.Calendar argument? (Notice that this option is exclusive of the "useTimezone=true" configuration option.)	false	true false yes no	false
useLocalSessionState	Should the driver refer to the internal values of autocommit and transaction isolation that are set by Connection.setAutoCommit() and Connection.setTransactionIsolation() and transaction state as maintained by the protocol, rather than querying the database or blindly sending commands to the database for commit() or rollback() method calls?	false	true false yes no	false
useLocalTransactionState	Should the driver use the in-transaction state provided by the MySQL protocol to determine if a commit() or rollback() should actually be sent to the database?	false	true false yes no	false
useLegacyDatetimeCode	Use code for DATE/TIME/DATETIME/TIMESTAMP handling in result sets and statements that consistently handles timezone conversions from client to server and back again, or use the legacy code for these datatypes that has been in the driver for backwards-compatibility?	false	true false yes no	true
useNanosForElapsedTime	For profiling/debugging functionality that measures elapsed time, should the driver try to use nanoseconds resolution if available (JDK >= 1.5)?	false	true false yes no	false
useOldAliasMetadataBehavior	Should the driver use the legacy behavior for "AS" clauses on columns and tables, and only return aliases (if any) for ResultSetMetaData.getColumnName() or ResultSetMetaData.getTableName() rather than the original column/table name? In 5.0.x, the default value was true.	false	true false yes no	false
useOldUTF8Behavior	Use the UTF-8 behavior the driver did when communicating with 4.0 and older servers	false	true false yes no	false
useOnlyServerErrorMessages	Don't prepend 'standard' SQLState error messages to error messages returned by the server.	false	true false yes no	true
useReadAheadInput	Use newer, optimized non-blocking, buffered input stream when reading from the server?	false	true false yes no	true
useSqlStateCodes	Use SQL Standard state codes instead of 'legacy' X/Open/SQL state codes (true/false), default is 'true'	false	true false yes no	true
useSSL	Use SSL when communicating with the server (true/false), defaults to 'false'	false	true false yes no	false
useSSPSCompatibleTimezoneShift	If migrating from an environment that was using server-side prepared statements, and the configuration property "useJDBCCompliantTimeZoneShift" set to "true", use compatible behavior when not using server-side prepared statements when sending TIMESTAMP values to the MySQL server.	false	true false yes no	false
useStreamLengthsInPrepStmts	Honor stream length parameter in PreparedStatement/ResultSet.setXXXStream() method calls (true/false, defaults to 'true')?	false	true false yes no	true
useTimezone	Convert time/date types between client and server timezones (true/false, defaults to 'false')?	false	true false yes no	false
ultraDevHack	Create PreparedStatements for prepareCall() when required, because UltraDev is broken and issues a prepareCall() for _all_ statements? (true/false, defaults to 'false')	false	true false yes no	false
useUnbufferedInput	Don't use BufferedInputStream for reading data from the server	false	true false yes no	true
useUnicode	Should the driver use Unicode character encodings when handling strings? Should only be used when the driver can't determine the character set mapping, or you are trying to 'force' the driver to use a character set that MySQL either doesn't natively support (such as UTF-8), true/false, defaults to 'true'	false	true false yes no	true
useUsageAdvisor	Should the driver issue 'usage' warnings advising proper and efficient usage of JDBC and MySQL Connector/J to the log (true/false, defaults to 'false')?	false	true false yes no	false
yearIsDateType	Should the JDBC driver treat the MySQL type "YEAR" as a java.sql.Date, or as a SHORT?	false	true false yes no	true
zeroDateTimeBehavior	What should happen when the driver encounters DATETIME values that are composed entirely of zeros (used by MySQL to represent invalid dates)? Valid values are "exception", "round" and "convertToNull".	false	exception round convertToNull	exception
useJvmCharsetConverters	Always use the character encoding routines built into the JVM, rather than using lookup tables for single-byte character sets?	false	true false yes no	false
useGmtMillisForDatetimes	Convert between session timezone and GMT before creating Date and Timestamp instances (value of "false" is legacy behavior, "true" leads to more JDBC-compliant behavior.	false	true false yes no	false
dumpMetadataOnColumnNotFound	Should the driver dump the field-level metadata of a result set into the exception message when ResultSet.findColumn() fails?	false	true false yes no	false
clientCertificateKeyStoreUrl	URL to the client certificate KeyStore (if not specified, use defaults)	false		null
trustCertificateKeyStoreUrl	URL to the trusted root certificate KeyStore (if not specified, use defaults)	false		null
clientCertificateKeyStoreType	KeyStore type for client certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.	false		JKS
clientCertificateKeyStorePassword	Password for the client certificates KeyStore	false		null
trustCertificateKeyStoreType	KeyStore type for trusted root certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.	false		JKS
trustCertificateKeyStorePassword	Password for the trusted root certificates KeyStore	false		null
verifyServerCertificate	If "useSSL" is set to "true", should the driver verify the server's certificate? When using this feature, the keystore parameters should be specified by the "clientCertificateKeyStore*" properties, rather than system properties.	false	true false yes no	true
useAffectedRows	Don't set the CLIENT_FOUND_ROWS flag when connecting to the server (not JDBC-compliant, will break most applications that rely on "found" rows vs. "affected rows" for DML statements), but does cause "correct" update counts from "INSERT ... ON DUPLICATE KEY UPDATE" statements to be returned by the server.	false	true false yes no	false
passwordCharacterEncoding	What character encoding is used for passwords? Leaving this set to the default value (null), uses the platform character set, which works for ISO8859_1 (i.e. "latin1") passwords. For passwords in other character encodings, the encoding will have to be specified with this property, as it's not possible for the driver to auto-detect this.	false		null
maxAllowedPacket	Maximum allowed packet size to send to server. If not set, the value of system variable 'max_allowed_packet' will be used to initialize this upon connecting. This value will not take effect if set larger than the value of 'max_allowed_packet'.	false		-1
authenticationPlugins	Comma-delimited list of classes that implement com.mysql.jdbc.AuthenticationPlugin and which will be used for authentication unless disabled by "disabledAuthenticationPlugins" property.	false		null
disabledAuthenticationPlugins	Comma-delimited list of classes implementing com.mysql.jdbc.AuthenticationPlugin or mechanisms, i.e. "mysql_native_password". The authentication plugins or mechanisms listed will not be used for authentication which will fail if it requires one of them. It is an error to disable the default authentication plugin (either the one named by "defaultAuthenticationPlugin" property or the hard-coded one if "defaultAuthenticationPlugin" propery is not set).	false		null
defaultAuthenticationPlugin	Name of a class implementing com.mysql.jdbc.AuthenticationPlugin which will be used as the default authentication plugin (see below). It is an error to use a class which is not listed in "authenticationPlugins" nor it is one of the built-in plugins. It is an error to set as default a plugin which was disabled with "disabledAuthenticationPlugins" property. It is an error to set this value to null or the empty string (i.e. there must be at least a valid default authentication plugin specified for the connection, meeting all constraints listed above).	false		com.mysql.jdbc.authentication.MysqlNativePasswordPlugin

[JDBC] Apache Hive JDBC Driver Properties

Apache Hive JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
HOST	Hostname of Hive Server2	false		192.168.0.61
PORT	Port number of Hive Server2	false		10000
DBNAME	Database name	false		default

[JDBC] Microsoft SQL Server JDBC Driver Properties

Microsoft SQL Server JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
applicationName	SQL Server 프로파일링 및 로깅 도구에 대한 응용 프로그램 이름입니다.	false		Microsoft SQL Server JDBC Driver
databaseName	연결되는 데이터베이스의 이름입니다.	false		master
disableStatementPooling	문 풀링 기능을 해제합니다.	false	true	true
encrypt	SSL(Secure Sockets Layer) 암호화를 클라이언트와 서버 사이에서 사용해야 할지 여부를 결정합니다.	false	true false	false
failoverPartner	데이터베이스 미러링 구성에 사용되는 장애 조치 서버의 이름입니다.	false
hostNameInCertificate	SQL Server SSL(Secure Sockets Layer) 인증서 유효성을 검사하는 데 사용될 호스트 이름입니다.	false
instanceName	SQL Server가 연결되는 인스턴스의 이름입니다.	false
integratedSecurity	SQL Server 연결에 Windows 인증을 사용할지 여부를 나타냅니다.	false	true false	false
lastUpdateCount	서버에 전달되는 SQL 문에서 마지막 업데이트 횟수만 반환되도록 합니다.	false	true false	true
lockTimeout	데이터베이스에서 잠김 제한 시간을 보고하기 전에 대기해야 하는 시간(밀리초)입니다.	false		-1
loginTimeout	실패한 연결 제한 시간이 초과되기 전에 드라이버에서 대기해야 하는 시간(초)입니다.	false		15
packetSize	SQL Server와 통신하는 데 사용되는 네트워크 패킷 크기입니다.	false		8000
password	데이터베이스 암호입니다.	true
portNumber	SQL Server의 인스턴스가 수신되고 있는 TCP 포트입니다.	false		1433
responseBuffering	적응 버퍼링 동작을 제어하여 응용 프로그램에서 서버 커서를 요구하지 않고 대형 결과 집합을 처리할 수 있도록 합니다.	false	adaptive full	adaptive
selectMethod	서버 커서를 사용하도록 응용 프로그램을 설정하여 정방향 전용, 읽기 전용 결과 집합을 처리합니다.	false	direct cursor	direct
sendStringParametersAsUnicode	문자열 매개 변수를 유니코드로 서버에 보낼지 또는 데이터베이스의 문자 집합에 보낼지 여부를 결정합니다.	false	true false	true
serverName	SQL Server를 실행하는 컴퓨터입니다.	false		192.168.0.88
trustServerCertificate	드라이버에서 SQL Server SSL(Secure Sockets Layer) 인증서의 유효성을 확인해야 할지 여부를 결정합니다.	false	true false	false
trustStore	인증서 신뢰 저장 파일에 대한 경로입니다.	false
trustStorePassword	신뢰 저장 데이터의 무결성을 확인하는 데 사용되는 암호입니다.	false
sendTimeAsDatetime	SQL Server datetime 데이터 형식을 사용하여 java.sql.Time 값을 데이터베이스로 보낼지 여부를 결정합니다.	false	true false	true
user	데이터베이스 사용자입니다.	true		sa
workstationID	워크스테이션의 호스트 이름입니다.	false
xopenStates	드라이버가 예외에서 XOPEN 규격 SQL 상태 코드를 반환할지 여부를 결정합니다.	false	true false	false

[JDBC] Oracle JDBC Driver Properties

Oracle JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
oracle.jdbc.RetainV9LongBindBehavior	null	false		false
user	null	false		null
database	null	false		null
autoCommit	null	false		true
protocol	null	false		null
oracle.jdbc.StreamChunkSize	null	false		16384
SetFloatAndDoubleUseBinary	null	false		false
oracle.jdbc.ocinativelibrary	null	false		null
v$session.terminal	null	false		unknown
v$session.machine	null	false		null
v$session.osuser	null	false		null
v$session.program	null	false		JDBC Thin Client
v$session.process	null	false		1234
v$session.iname	null	false		jdbc_ttc_impl
v$session.ename	null	false		null
oracle.net.profile	null	false		null
oracle.net.authentication_services	null	false		null
oracle.net.kerberos5_mutual_authentication	null	false		null
oracle.net.kerberos5_cc_name	null	false		null
oracle.net.encryption_client	null	false		null
oracle.net.encryption_types_client	null	false		null
oracle.net.crypto_checksum_client	null	false		null
oracle.net.crypto_checksum_types_client	null	false		null
oracle.net.crypto_seed	null	false		null
oracle.jdbc.TcpNoDelay	null	false		false
oracle.jdbc.ReadTimeout	null	false		null
oracle.net.CONNECT_TIMEOUT	null	false		null
oracle.net.disableOob	null	false		false
oracle.net.useZeroCopyIO	null	false		true
oracle.jdbc.use1900AsYearForTime	null	false		false
oracle.jdbc.timestampTzInGmt	null	false		true
oracle.jdbc.timezoneAsRegion	null	false		true
oracle.net.ssl_server_dn_match	null	false		null
oracle.net.ssl_version	null	false		null
oracle.net.ssl_cipher_suites	null	false		null
javax.net.ssl.keyStore	null	false		null
javax.net.ssl.keyStoreType	null	false		null
javax.net.ssl.keyStorePassword	null	false		null
javax.net.ssl.trustStore	null	false		null
javax.net.ssl.trustStoreType	null	false		null
javax.net.ssl.trustStorePassword	null	false		null
ssl.keyManagerFactory.algorithm	null	false		null
ssl.trustManagerFactory.algorithm	null	false		null
oracle.net.oldSyntax	null	false		null
java.naming.factory.initial	null	false		null
java.naming.provider.url	null	false		null
java.naming.security.authentication	null	false		null
java.naming.security.principal	null	false		null
java.naming.security.credentials	null	false		null
oracle.net.wallet_location	null	false		null
oracle.net.wallet_password	null	false		null
oracle.jdbc.proxyClientName	null	false		null
oracle.jdbc.useNio	null	false		false
JDBCDriverCharSetId	null	false		null
oracle.jdbc.editionName	null	false		null
internal_logon	null	false		null
oracle.jdbc.createDescriptorUseCurrentSchemaForSchemaName	null	false		false
OCISvcCtxHandle	null	false		0
OCIEnvHandle	null	false		0
OCIErrHandle	null	false		0
prelim_auth	null	false		false
OCINewPassword	null	false		null
defaultExecuteBatch	null	false		1
defaultRowPrefetch	null	false		10
oracle.jdbc.defaultLobPrefetchSize	null	false		4000
remarksReporting	null	false		false
includeSynonyms	null	false		false
restrictGetTables	null	false		false
AccumulateBatchResult	null	false		true
useFetchSizeWithLongColumn	null	false		false
processEscapes	null	false		true
fixedString	null	false		false
defaultNChar	null	false		false
RessourceManagerId	null	false		0000
disableDefineColumnType	null	false		false
oracle.jdbc.convertNcharLiterals	null	false		false
oracle.jdbc.J2EE13Compliant	null	false		false
oracle.jdbc.mapDateToTimestamp	null	false		true
oracle.jdbc.useThreadLocalBufferCache	null	false		false
oracle.jdbc.driverNameAttribute	null	false		null
oracle.jdbc.maxCachedBufferSize	null	false		30
oracle.jdbc.implicitStatementCacheSize	null	false		0
oracle.jdbc.LobStreamPosStandardCompliant	null	false		true
password	null	false		null
server	null	false		null
oracle.jdbc.commitOption	null	false		null