test project of DBMS DB2, using Seasar
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.settings
dbflute_maihamadb
etc/license
lib
mydbflute
src
.classpath
.gitignore
.project
LICENSE
NOTICE
README.txt
pom.xml

README.txt

# ========================================================================================
#                                                                                 Overview
#                                                                                 ========
The example project for DB2 and DBFlute.


# ========================================================================================
#                                                                              Environment
#                                                                              ===========
[Maven2]
This project needs maven2 for compile.

[JDBC]
Put db2jcc.jar to both 'lib' and 'dbflute_maihamadb/extlib'.

[DB2]
create database dfexdb using codeset UTF-8 territory JP

[DBFlute]
prepare local-url.txt, local-user.txt, local-url.txt if it needs.
(see databaseInfoMap.dfprop for the detail)


# ========================================================================================
#                                                                                     Memo
#                                                                                     ====
SQLState Dictionary
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql0400.htm


# ========================================================================================
#                                                                            Demo Resource
#                                                                            =============
alter table MEMBER_ADDRESS alter ADDRESS set data type VARCHAR(400);  

drop procedure SP_IN_OUT_RETURN;
-- #df:begin#
create procedure SP_IN_OUT_RETURN(
  in v_in_varchar varchar(200)
  , out v_out_varchar varchar(200)
  , inout v_inout_varchar varchar(200)
) language sql
begin
  set v_out_varchar = 'clubdb2';
  set v_inout_varchar = 'quux';
  return 1;
end
-- #df:end#