Indicates caveats when using Oracle (9i / 10g / 11g).

  • The maximum length of table name (Wagby's model name) is 30 characters.
  • The maximum length of column name (Wagby's model item name) is 30 characters.
  • You can not define a model of "time type" primary key.
  • "Time type" item can not be used as a search condition.
  • It does not support XML types provided by Oracle.
  • It does not support the TIMESTAMP WITH LOCAL TIME ZONE type provided by Oracle.
  • In Oracle, there is a limit on the number of bytes in the table name created, so when you decide the model name (English) or item name (English), you need to be aware of the number of characters.
  • To use UTF - 8 for database character encoding, please use version 10.1.0 or later.You can register surrogate pair characters adopted in Windows Vista.
  • When using "order" as the primary key, we will use the ordering function provided by Oracle.This is a standard specification that causes missing numbers.To suppress this, Wagby gives the nocache specification when issuing the create sequence instruction.

The type specified by Wagby is handled as follows in the database.

Integer type number(10,0)
String type varchar2(255 char)
String type (text area) varchar2(4000)
Date type date
Time type date
Date Time Type timestamp
File type (file name) varchar2(255 char)
1 byte integer number(3,0)
2 byte integer number(5,0)
4 byte integer number(10,0)
8 byte integer number(19,0)
4 byte floating point number float
8 byte floating point number double precision
Fixed value (creation date/update date) timestamp
Other (URL type/mail address type etc.) varchar2(255 char)
The number specified by varchar2 type is "byte" or "character" unit.When "255" is specified, it becomes byte unit, and when "255 char" is specified, it becomes character unit.For details, refer to the Oracle manual.
If you specify varchar2 (4000), it is in bytes.When UTF - 8 is used for character encoding, assuming 1 character 3 bytes, the shortest is 1,333 characters.(If everything is a surrogate pair character it will be 1,000 characters.)

With Oracle development, trouble will arise if the version of the JDBC driver and the version of the Oracle body do not match exactly.

Please be careful when developing so that both versions are the same.(Even if you change slight minor version number, it may not operate properly.)

> 'ABC ')

That is, the value of the primary key entered from the screen of the Web application and the value actually registered in the database are different. Therefore, there is an effect such as a failure to transition to the detail screen after registration processing.

As a response to this, it is a good idea to make the following settings in "Initial value - When registering" for this item.

  • Type: Arithmetic operation
  • Values: LEFT (CONCAT ($ {TARGET_ITEM_NAME}, ""), 4)

In addition, change "input filter" of the item (TARGET_ITEM_NAME) from "character string (general)" to "character string (minimum)".