bea.com | products | dev2dev | support | askBEA |
![]() |
![]() |
|
![]() |
e-docs > Liquid Data for WebLogic > Building Queries and Data Views > Supported Data Types |
Building Queries and Data Views
|
Supported Data Types
This section provides information about the data types supported in BEA Liquid Data for WebLogicTM and the Data View Builder. The following topics are included:
Overview
In relational databases, data types are described using two methods. The conventional way is to use a JDBC number. For example, an integer is 4, varchar is 12, a date is 91, an so on. These numbers are represented by constants in the java.sql.Types class, such as Types.INTEGER = 4 and Types.VARCHAR = 12. This numbering system describes all the JDBC standardized types. However, there are many vendor-specific types, and most of them use the default JDBC number 1111, meaning "other." For this method, there is a name instead of a number associated with each type.
The query generation engine first looks at the JDBC number for a match. If no match occurs, then it uses the name. For example, if the number is 1111, then the query generation engine looks for a name. If there is no match found for either one, the query generation engine treats the column as a string.
Depending on the type of database you access, you need to map external database fields with a compatible data type when you invoke Liquid Data functions. You will notice that some external data types are not supported by Liquid Data. You may need to transform these data types to a supported type before you access that data in a query. The following tables can help you make these decisions.
JDBC Types
The following table maps the JDBC type to the appropriate data type that you should use with Liquid Data.
JDBC Names
The following table maps the JDBC name to Liquid Data data types.
Oracle Names
The following table maps Oracle names to Liquid Data data types.
Microsoft SQL Server Names
The following table maps Microsoft SQL Server names to Liquid Data data types.
DB2 Names
The following table maps DB2 data types to Liquid Data data types.
Sybase Names
The following table maps Sybase data types to Liquid Data data types.
![]() |
![]() |
![]() |
![]() |
||
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |