|
Technical Fact Sheet
Dharma JDBCnet™
Supported Functions
JDBCnet supports an extensive set of scalar functions, including
the following:
Supported Numeric Functions:
| SQL_FN_NUM_ABS
| SQL_FN_NUM_ACOS
|
| SQL_FN_NUM_ASIN
| SQL_FN_NUM_ATAN
|
| SQL_FN_NUM_ATAN2
| SQL_FN_NUM_CEILING
|
| SQL_FN_NUM_COS
| SQL_FN_NUM_COT
|
| SQL_FN_NUM_DEGREES
| SQL_FN_NUM_EXP
|
| SQL_FN_NUM_FLOOR
| SQL_FN_NUM_LOG
|
| SQL_FN_NUM_LOG10
| SQL_FN_NUM_MOD
|
| SQL_FN_NUM_PI
| SQL_FN_NUM_POWER
|
| SQL_FN_NUM_RADIANS
| SQL_FN_NUM_RAND
|
| SQL_FN_NUM_ROUND
| SQL_FN_NUM_SIGN
|
| SQL_FN_NUM_SIN
| SQL_FN_NUM_SQRT
|
| SQL_FN_NUM_TAN
| SQL_FN_NUM_TRUNCATE
| |
Supported String Functions:
| SQL_FN_STR_ASCII
| SQL_FN_STR_LTRIM
|
| SQL_FN_STR_CHAR
| SQL_FN_STR_DIFFERENCE
|
| SQL_FN_STR_INSERT
| SQL_FN_STR_LCASE
|
| SQL_FN_STR_LEFT
| SQL_FN_STR_REPEAT
|
| SQL_FN_STR_REPLACE
| SQL_FN_STR_SOUNDEX
|
| SQL_FN_STR_SPACE
| SQL_FN_STR_SUBSTRING
|
| SQL_FN_STR_UCASE
| SQL_FN_STR_RTRIM
|
| SQL_FN_STR_CONCAT
| SQL_FN_STR_LENGTH
|
| SQL_FN_STR_LOCATE
|
Supported System Functions:
| SQL_FN_SYS_USERNAME
| SQL_FN_SYS_IFNULL
|
| SQL_FN_SYS_DBNAME
| |
Supported Configurations
JDBCnet supports both two-tier and three-tier configurations. In a two-tier configuration, the JDBC driver runs on the Web browser and communicates with the DBMS running on a server. In a three-tier configuration, the JDBC Driver runs on a middle tier (typically called the application server) and communicates with the DBMS running on the third tier.
Because Dharma’s JDBCnet is a pure-Java JDBC Driver, it can support either configuration with no modifications.
Supported Data Types
Dharma JDBCnet supports all JDBC data types, including LONG types
of arbitrary length and structure:
| JDBC type
| Java type
|
| CHAR
| String
|
| VARCHAR
| String
|
| LONGVARCHAR
| String
|
| NUMERIC
| java.math.BigDecimal
|
| DECIMAL
| java.math.BigDecimal
|
| BIT
| boolean
|
| TINYINT
| byte
|
| SMALLINT
| short
|
| INTEGER
| int
|
| BIGINT
| long
|
| REAL
| float
|
| FLOAT
| double
|
| DOUBLE
| double
|
| BINARY
| byte[]
|
| VARBINARY
| byte[]
|
| LONGVARBINARY
| byte[]
|
| DATE
| java.sql.Date
|
| TIME
| java.sql.Time
|
| TIMESTAMP
| java.sql.Timestamp
|
|
