Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
test project of DBMS Oracle, using Spring, with multiple DB
Fetching latest commit…
Cannot retrieve the latest commit at this time.
|Failed to load latest commit information.|
# ======================================================================================== # Overview # ======== The example project for Oracle and DBFlute. # ======================================================================================== # Environment # =========== [Maven2] This project needs maven2 for compile. [JDBC] Put ojdbc6.jar to both 'lib' and 'dbflute_maihamadb/extlib' and 'dbflute_newurayasudb/extlib'. [Oracle] /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = This example requires three schemas 'maihamadb' and 'newurayasudb' and 'resortlinedb'. = = = = = = = = = =/ The schemas will be created by ReplaceSchema task. (contains creating user) But if a password of your 'system' user is different from 'orcl', make "system-password.txt" (will be git-ignored) in dfprop directory with your system password. (then both maihamadb's and resortlinedb's dfprop directory) Are you ready? OK, execute the ReplaceSchema task! First, manage.sh|bat in resortlinedb and selecting replace-schema(0). Second, nextschema-renewal.sh|bat in maihamadb (for newurayasudb). Last, manage.sh|bat in maihamadb and selecting replace-schema(0). -- _/_/_/_/_/_/_/_/_/_/_/ -- If ORA-01536 occurred -- _/_/_/_/_/_/_/_/_/_/_/ -- [By system user] alter user maihamadb quota unlimited on users; alter user newurayasudb quota unlimited on users; alter user resortlinedb quota unlimited on users; # ======================================================================================== # Memo # ==== -- Synonym for Package Procedure has several problems: -- o Cannot specify a schema name for a package procedure. Why? -- CREATE SYNONYM VD_SYNONYM_NEXT_PKG_PROCEDURE FOR NEXTEXAMPLE.NEXTPKG.SP_NEXT_PKG_NO_PARAMETER; -- ==> ORA-00933 -- o Cannot execute the synonym. Why? -- call VD_SYNONYM_NEXT_PKG_PROCEDURE(); -- ==> ORA-04045