top / index / prev / next / target / source
2021-05-16 diary: [Oiyokan] OData Edm to JDBC Types mapping of Oiyokan v1.14
日記形式でつづる いがぴょんコラム ウェブページです。
[Oiyokan] OData Edm to JDBC Types mapping of Oiyokan v1.14
Supported types mapping
Type mapping of Oiyokan v1.14 is like below:
| Edm type | JDBC type | h2 type | PostgreSQL | MySQL | SQLSV2008 | ORCL18 |
|---|---|---|---|---|---|---|
| Edm.SByte | Types.TINYINT | TINYINT | (N/A) | TINYINT | TINYINT | (N/A) |
| Edm.Int16 | Types.SMALLINT | SMALLINT | smallint (int2) | SMALLINT | SMALLINT | SMALLINT |
| Edm.Int32 | Types.INTEGER | INTEGER | int (int4) | INTEGER | INT | INT |
| Edm.Int64 | Types.BIGINT | BIGINT | bigint (int8) | BIGINT | BIGINT | (N/A) |
| Edm.Decimal | Types.DECIMAL | DECIMAL | decimal(numeric) | DECIMAL | DECIMAL | DECIMAL |
| Edm.String | Types.CHAR | CHAR | char (bpchar) | CHAR | CHAR | CHAR |
| Edm.String | Types.VARCHAR | VARCHAR | varchar | VARCHAR | VARCHAR | VARCHAR |
| Edm.String | Types.CLOB | CLOB | text | TEXT | TEXT | CLOB |
| Edm.Boolean | Types.BOOLEAN | BOOLEAN | bool (Types.BIT) | BOOLEAN | BIT(Types.BIT) | (N/A) |
| Edm.Single | Types.REAL | REAL | real (flort4) | REAL | REAL | REAL |
| Edm.Double | Types.DOUBLE | DOUBLE | double precision | DOUBLE | FLOAT(53) | FLOAT |
| Edm.Date | Types.DATE | DATE | date | DATE | DATE | DATE |
| Edm.DateTimeOffset | Types.TIMESTAMP | TIMESTAMP | timestamp | TIMESTAMP | DATETIME2 | TIMESTAMP |
| Edm.TimeOfDay | Types.TIME | TIME | time | TIME | TIME | (N/A) |
| Edm.Binary | Types.VARBINARY | VARBINARY | bytea | VARBINARY | VARBINARY | RAW |
| Edm.Binary | Types.BLOB | BLOB | bytea | BLOB | VARBINARY | BLOB |
- Edm.Guid is not supported by Oiyokan v1.14
from: github v1.14.20210510 OiyoMapJdbcEdmUtil.java
Related Diary
- 2021-06-06 diary: [Oiyokan] Spring Boot プロジェクトに Oiyokan SDK を組み込む方法
- 2021-05-16 diary: [Oiyokan] OData Edm to JDBC Types mapping of Oiyokan v1.14
- 2021-05-15 diary: [Oiyokan] Message list of Oiyokan v1.14
- 2021-05-13 diary: [Oiyokan] Supported HTTP method by Oiyokan v1.14
- 2021-05-12 diary: [Oiyokan] Unsupported features in Oiyokan v1.14
- 2021-05-11 diary: [Oiyokan] Getting Started Oiyokan Initializr (v0.5)
- 2021-05-09 diary: [Oiyokan] RDB用の REST API Server をローコードですばやく生成
- 2021-05-04 diary: [Oiyokan] Salesforce Connect - OData 4.0 から Oiyokan を利用する
- 2021-04-26 diary: [Oiyokan] oiyokan-settings.json spec
- 2021-04-25 diary: [Oiyokan] OData v4 server (provider) SDK
Last modified: $Date: 2021-05-04 $
登場キーワード
この日記について
- ホームページ更新者: 伊賀 敏樹 / Tosiki Iga
- Diary / Facebook / LinkedIn / GitHub / Qiita / Mastodon / X(Twitter) / Amazon / Share on Twitter / top / いがぴょんについて / Powered by Igapyonv3
- 本サイトの見解は、私 個人のものであり、株式会社レザボア・コンサルティング は当個人的見解に一切責任を持ちません。