Indicates caveats when using Oracle (9i / 10g / 11g).
The type specified by Wagby is handled as follows in the database.
|String type||varchar2(255 char)|
|String type (text area)||varchar2(4000)|
|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)|
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.
In addition, the item (TARGET_ITEM_NAME) "Input filter"From" character string (general) "to" character string (minimum) ".