# Mapping Database Field Types to Java Types in the Database Control

When you are submitting or requesting data from a database using the Database control, you may need to understand how Java data types map to SQL data types, and vice versa, in order to handle the data in your code. The table below shows the most common data type mappings, although others are possible.

In some cases, there are multiple mapping possibilities for a single type. For example, if you return data from a column of type smallint in the Pointbase sample database, you can store that data in a Java variable of type byte or type short, depending on your needs.

The type mappings shown in the tables below are the most direct mappings and are shown as examples. Please consult the documentation for your database system to determine all possible database to Java mappings in the database system you are using.

## Type Mappings for PointBase

The following table lists the relationships between database types and Java types for the PointBase Version 4.4 database, which is installed with WebLogic Server. If you are using a different database, please consult the documentation for the JDBC driver of your database software.

Java Data Types | JDBC Data Types | PointBase SQL Data Types (Version 4.4)
--- | --- | ---
boolean | BIT | boolean
byte | TINYINT | smallint
short | SMALLINT | smallint
int | INTEGER | integer
long | BIGINT | numberic/decimal
double | FLOAT | real
float | REAL | float
double | DOUBLE | double
java.math.BigDecimal | NUMERIC | numeric
java.math.BigDecimal | DECIMAL | decimal
String | CHAR | char
String | VARCHAR | varchar
String | LONGVARCHAR | clob
java.sql.Date | DATE | date
java.sql.Time | TIME | time
java.sql.Timestamp | TIMESTAMP | timestamp
byte[] | BINARY | blob
byte[] | VARBINARY | blob
byte[] | LONGVARBINARYbyte[] | blob
java.sql.Blob | BLOB | blob
java.sql.Clob | CLOB | clob

##

## Type Mappings for Microsoft SQL Server

For table showing the relationships between JDBC types and Microsoft SQL Server types, see Data Types in the WebLogic Server 8.1 documentation.

## Type Mappings for Oracle 8i

The following table lists the relationships between database types and Java types for the Oracle 8i database.

Java Data Types | JDBC Data Types | Oracle SQL Data Types (Version 8i)
--- | --- | ---
boolean | BIT | NUMBER
byte | TINYINT | NUMBER
short | SMALLINT | NUMBER
int | INTEGER | NUMBER
long | BIGINT | NUMBER
double | FLOAT | NUMBER
float | REAL | NUMBER
double | DOUBLE | NUMBER
java.math.BigDecimal | NUMERIC | NUMBER
java.math.BigDecimal | DECIMAL | NUMBER
String | CHAR | CHAR
String | VARCHAR | VARCHAR2
String | LONGVARCHAR | LONG
java.sql.Date | DATE | DATE
java.sql.Time | TIME | DATE
java.sql.Timestamp | TIMESTAMP | DATE
byte[] | BINARY | NUMBER
byte[] | VARBINARY | RAW
byte[] | LONGVARBINARY | LONGRAW
java.sql.Blob | BLOB | BLOB
java.sql.Clob | CLOB | CLOB

Related Topics

Returning a Single Value from a Database Control Method

Returning a Single Row from a Database Control Method

Returning Multiple Rows from a Database Control Method

Parameter Substitution in @jc:sql Statements