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

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)
  • For model reference, it follows the type of the primary key of the referenced model.
  • Developers can also change the type.For details, refer to "Repository> Definition of model item> Database detailsPlease read.
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 countermeasure against this,Initial value - upon registrationIt is a good idea to make the following settings.

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

In addition, the item (TARGET_ITEM_NAME) "Input filter"From" character string (general) "to" character string (minimum) ".