,<=G(=G;9B9F5H98:FCA5IH<CF=H5H=J9CB@=B97CBH9BH5B8
=GDFCJ=898:CF7CBJ9B=9B79CB@M,<=G(75BBCH69IG98
:CF@9;5@DIFDCG9GCF5IH<CF=H5H=J9IB89FGH5B8=B;C:K<5H
=G5B8=GBCHGIDDCFH985@K5MGIG9H<9CB@=B97CBH9BH,C
7CDM7C89G5AD@9G5@K5MGIG9H<9CB@=B97CBH9BH
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D

Working with Database Blocks
Contents
O /CF?=B;K=H<5H565G9@C7?G
O  5H565G9CBB97H=CB(FCQ@9G
O  F95H=B;8=H=B;5CBB97H=CB(FCQ@9
O  (F9J=9KCBB97H=CB+HF=B;G
O  -G=B;H<9)I9FMI=@89F
O  +D97=:M=B;IGHCA)I9F=9G
O  +HCF98(FC798IF9 9@D9F
O  +9HH=B;ID5+HCF98(FC798IF95@@
O  (5GGKCF8B7FMDH=CB
O  $=A=H5H=CBG5B8/CF?5FCIB8G
O  'F57@9@=9BH+9HID:CF!!+
O  /CF?=B;K=H<'F57@97*:FCACADCG9F&,DFC>97HG
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
,<=GD5;97CBH5=BG;9B9F5@=B:CFA5H=CBCBKCF?=B;K=H<H<95H565G96@C7?G
Database Connection Pro-les
9:CF9MCI75B7CBB97HHC585H565G9=BMCIF5DD@=75H=CBMCIB998HC89QB9585H565G97CBB97H=CB
DFCQ@9H<5HK=@@A5=BH5=B5@@=B:CFA5H=CBB979GG5FMHC7CBB97HHC5D5FH=7I@5F=BGH5B79C:585H565G9
,<9 5H5 6@C7?F9EI=F9GH<5HMCIGD97=:MH<9B5A9C:57CBB97H=CBDFCQ@9=B=HGDFCD9FH=9GGCH<5H
=H75BIG9H<5H=B:CFA5H=CBHC7CBB97HHCH<985H565G95HFIBH=A9%I@H=D@97CBB97H=CBGDFCQ@9G75B
6989QB98=BCB9(FC>97H5B8H<9G9DFCQ@9G75B69G<5F986MAI@H=D@95H56@C7?G9J9B=:H<9M
5F9=B8=P9F9BH75@@RCKG7CBB97H=CBDFCQ@97CBG=GHGC:H<965G=7=B:CFA5H=CBF9EI=F98HC7CBB97HHC
585H565G9,<9=B:CFA5H=CBDFCJ=898=B57CBB97H=CBDFCQ@9=B7@I89GH<9:C@@CK=B;
O Pro4le Name,<9=BH9FB5@B5A9H<5HCADCG9FIG9GHC=89BH=:M7CBB97H=CBGIB=EI9@M
O Connection Pooling+9@97HHC9B56@97CBB97H=CBDCC@=B;K<=7<A5=BH5=BG5G9HC:85H565G9
7CBB97H=CBGH<5H75B69F9IG98:CFF9EI9GHGHC85H565G9G 1CI75BIG9H<=G:95HIF9HC9B<5B79
D9F:CFA5B796M5JC=8=B;H=A97CBGIA=B;F99GH56@=G<A9BHC:7CBB97H=CBGHC85H565G9G
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
O Connection Pool Name+D97=:M5"5J5&5A=B;5B8=F97HCFM!BH9F:579"&!B5A9:CFH<9DCC@98
85H5GCIF79CADCG9F5DD@=75H=CBG75BIG95BM"&!85H5GCIF799LDCG986MH<9K96G9FJ9F,<9 K5F
Q@9G 9LDCFH986MCADCG9F7CBH5=B7CBQ;IF5H=CBQ@9GHCGIDDCFH7CBB97H=CBDCC@=B;K=H<"CGG5B8
/96+D<9F9CH<9F7CBQ;IF5H=CB7<5B;9GHCH<9K965DD@=75H=CBA5M69F9EI=F98:CFCH<9FK96G9FJ9FG
O JNDI Namespace+H5FH=B;K=H<CADCG9F=BHFC8I79GH<9"&!&5A9GD579CDH=CB:CF"5J5
CADCG9F(FC>97HG,<989:5I@HJ5@I9=G>5J57CAD9BJ1CI75B98=HH<=GJ5@I9HCA5H7<MCIFK96
G9FJ9F85H565G9F9EI=F9A9BHGCF99L5AD@9MCI75BIG9"CGGCBB97H=CB(CC@=B;K=H<%++)$5B8
'F57@985H565G9G:CF6CH<75@@RCKG5B8KCF?RCKG
O Database Type,<9HMD9C:85H565G9:FCAH<9@=GHC:GIDDCFH9885H565G9G
O Hostname,<9<CGHCBK<=7<H<985H565G9G9FJ9F=GFIBB=B;!B75G9C:5H565G9@IGH9F.=FHI5@!(
@IGH9F@=5G+&&5A9=GGD97=Q98<9F9
O Port,<9,(DCFHCBK<=7<H<985H565G9G9FJ9F=G@=GH9B=B;:CF7CBB97H=CBG,<9ACGH7CAACB@MIG98
89:5I@HG:CFGIDDCFH9885H565G9HMD9G5F9DF9DCDI@5H986MCADCG9F!:MCIF85H565G9G9FJ9FIG9G
7IGHCADCFHGMCIK=@@B998HCGD97=:MH<9A<9F9
O Instance Name,<9%++)$!BGH5B79H<5HB998HC7CBB97H=B+)$+9FJ9F(CFHK=@@H5?9DF97989B79=:
GD97=Q98,<=GQ9@8=G8=G56@98K<9B5H565G9,MD9=GG9@97H985G'*$
O Database Name,<9B5A9C:H<985H565G975H5@C;:CF+)$+9FJ9F5B8H<9+!=B75G9C:'F57@9
O SID,<97<97?6CLHCGD97=:M=:J5@I9DFCJ=898=B5H565G9&5A9=G+!,<=G7<97?6CL=G8=G56@98
K<9B5H565G9,MD9=G%++)$
O Username,<9IG9FB5A9H<5HG<CI@869IG98HC5779GGH<985H565G9
O Password,<9D5GGKCF8H<5HG<CI@869IG98HC5779GGH<985H565G9
O Encrypt+9@97HH<99B7FMDHH<9D5GGKCF8
O Show+9@97HHCG<CKH<9D5GGKCF8
O Custom Parameters,<9GIDDCFH987IGHCAD5F5A9H9FG75B69=B7@I898=B7CBB97H=CBGHF=B;5@CB;
K=H<CH<9FD5F5A9H9FG,C89QB97IGHCAD5F5A9H9FG7@=7?H<9IGHCA(5F5A9H9FG6IHHCB!BH<9
8=5@C;CD9B98588H<9D5F5A9H9FB5A95B8J5@I9=BH<9CF89FH<5HB998HC695DD9B898HC
7CBB97H=CBGHF=B;
Note+H5FH=B;K=H<MCI75BIG9H<95H56@C7?CBB97H=CB+HF=B;DFCD9FHMHC
8MB5A=75@@M5779GGH<985H565G95HFIBH=A95B8CJ9FF=89H<9CBB97H=CB(FCQ@9G9HH=B;G=BH<96@C7?
!ADCFH5BH
,<95H565G96@C7?8C9GBCHGIDDCFH85H565G9F9EI9GHGIG=B;/=B8CKG
5IH<9BH=75H=CB
CBQ;IF5H=CB:CF5H565G9@IGH9F
O CF%++)$@IGH9F.=FHI5@!(@IGH9F@=5G=GGD97=Q98=B CGHB5A9Q9@8C:CBB97H=CB(FCQ@9,C
7CBB97HHCD5FH=7I@5FB5A98=BGH5B79=B7@IGH9F!BGH5B79D5F5A9H9F=G7CBQ;IF98
O CF'*$@IGH9F@IGH9F@=5G+&&5A9=GGD97=Q98=B CGHB5A9Q9@8C:CBB97H=CB(FCQ@9
88=H=CB5@@MHC9B56@9,:IB7H=CB5@=HM=B'*$7@IGH9FG7CBB97H=CBDCC@=G7F95H98G=A=@5FHC
DCC@=B;75D56=@=HM=BCH<9F5DD@=75H=CBG9FJ9FGCBB97H=CBDCC@75B697F95H985GH<99L5AD@969@CK
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
,<=GB998HC6958898=B,CA75HG9FJ9FLA@DF9G9BH=BCADCG9F=BGH5@@98D5H<*9GCIF79
B5A9>867CF57@9(CC@985IH<CBH5=B9F
type="com.mchange.v2.c3p0.ComboPooledDataSource"
factory="org.apache.naming.factory.BeanFactory"
driverClass="oracle.jdbc.driver.OracleDriver"
user="scott"
password="tiger" jdbcUrl="jdbc:oracle:oci:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.184.70)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)
(HOST=172.21.184.71)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=rac.genesyslab.com)
(FAILOVER_MODE=(TYPE=session)(METHOD=basic))))" />
B7FMDH=CB
(5F5A9H9FGIB89FB7FMDH=CBH565@@CKGMCIHC7CBQ;IF9++$9B7FMDH=CB5B8G9FJ9F5IH<9BH=75H=CB
:CF5H565G97CBB97H=CBGA5898IF=B;9G=;BH=A9)I9FMI=@89F+HCF98(FC798IF95B8*IBH=A9
/<9BG97IF=HM=G9B56@98++$9B7FMDH=CB=GIG98:CF5@@85H5G9BH69HK99B7CADCG9F5B8+)$+9FJ9F
=:H<9+)$G9FJ9F<5G579FH=Q75H9=BGH5@@98
,C9GH56@=G<5+97IF95H565G97CBB97H=CB:FCACADCG9F:C@@CK=B;D5F5A9H9FG5F9HC697CBQ;IF98
IB89F9B7FMDH=CBH56
O Secure ConnectionB56@=B;H<=G7<97?6CLK=@@A5?95@@7CBB97H=CBG:FCACADCG9FHC5H565G9
+9FJ9F9B7FMDH98K=H<57<C=79C:G9FJ9F5IH<9BH=75H=CB
O Trust Certi4cateB56@=B;+97IF9CBB97H=CB5B8,FIGH9FH=Q75H9K=@@69GIS7=9BHHC9GH56@=G<
++$CBB97H=CB/<9B,FIGH9FH=Q75H9=G8=G56@98CH<9FCDH=CB5@5HHF=6IH9G5F99B56@98HCJ5@=85H9
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
G9FJ9F79FH=Q75H9
O Match Certi4cate Subject,<=G=G9B56@98=BCF89FHC:CF79H<9A5H7<=B;C:H<979FH=Q75H9GI6>97H
5J5=@56@9=B+9FJ9F9FH=Q75H95B87@=9BHGHFIGH987CDM
O Certi4cate Hostname,<=GD5F5A9H9F=GGD97=Q98=B75G9H<97@=9BH79FH=Q75H975FF=9G58=P9F9BH
GI6>97HB5A9H<5BH<9G9FJ9F79FH=Q75H95B8IG9FK=G<9GHC=;BCF9H<98=P9F9B796MDFCJ=8=B;H<9
GI6>97HB5A99LD97H98=BH<9G9FJ9F79FH=Q75H99LD@=7=H@M
O Trust Store Location$C75H=CBK<9F9H<9,FIGH+HCF9Q@9=GDF9G9BH,<9HFIGHGHCF9Q@97CBH5=BG5@@H<9
79FH=Q75H9GHFIGH986MH<97@=9BH=B7@I8=B;H<979FH=Q75H9H<5HH<9G9FJ9FIG9GHC5IH<9H=75H9=HG9@:
O Trust Store Type"#+HFIGHGHCF9=GGIDDCFH98K<9B5H565G9,MD9=G'*$,<=GD5F5A9H9F=GBCH
98=H56@9,<=G=GBCH5DD@=756@9K<9B5H565G9,MD9=G%++)$
O Trust Store Password(5GGKCF8HC5779GGH<9HFIGHGHCF9
9FH=Q75H97CBQ;IF5H=CB:CF+97IF9CBB97H=CB
O CF"5J5CADCG9F(FC>97HGK<9B+97IF9CBB97H=CB=G9B56@985B8,FIGH9FH=Q75H9=G8=G56@98
79FH=Q75H9G5F9D@5798=B,FIGH+HCF9$C75H=CBGD97=Q98=B7CBB97H=CBDFCQ@9
O CF&,CADCG9F(FC>97HG9G=;BH=A9=9:CF)I9FMI=@89F5B8+HCF98(FC798IF9I=@89F
79FH=Q75H9G5F9D@5798=B,FIGH+HCF9$C75H=CBGD97=Q98=B7CBB97H=CBDFCQ@9
O CF&,CADCG9F(FC>97HG*IBH=A95B8%++)$85H565G979FH=Q75H9G5F9=BGH5@@98=B9FH=Q75H9
/=B8CKG+B5D!B5779GG98:FCA%%7CBGC@9=B/=B8CKG
O CF&,CADCG9F(FC>97HG*IBH=A95B8'*$85H565G979FH=Q75H9G5F9=BGH5@@98=B'F57@9K5@@9H
6CH<=B7@=9BH5B8G9FJ9FHBGB5A9GCF57CBQ;IF5H=CBK=@@<5J9G9FJ=79B5A9K=H<,(+DFCHC7C@
L5AD@9=G;=J9B69@CK
++$,+,
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = dev-rose.us.int.genesyslab.com)(PORT = 2484))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SSLTEST)
)
)
&CH9G
,C9GH56@=G<57CBB97H=CBDFCQ@9MCIAIGH69KCF?=B;K=H<5(FC>97HQ@9H<5HK5GID;F5898HC
CADCG9FCF<=;<9F:FCA5B95F@=9FCADCG9FF9@95G9CBB97H=CBDFCQ@9G5F9BCH5J5=@56@9=B
(FC>97HG7F95H98IG=B;CADCG9F,<9M697CA95J5=@56@95:H9FH<9(FC>97H=GID;F5898,<9
A9H<C8:CFGD97=:M=B;588=H=CB5@DCC@=B;D5F5A9H9FGJ5F=9G65G98CBH<985H565G969=B;IG985B8
H<9(FC>97HHMD9"5J5CADCG9F(FC>97HGIG9H<97D@=6F5FM:CF6CH<+)$+9FJ9F5B8'F57@9
85H565G9G 'H<9FK=G9=BH<975G9C:'F57@985H565G9GCADCG9FIG9GH<97D@=6F5FM5B8H<9
@=6F5FM9LDCG9G=HGCKB7CBQ;IF5H=CBD5F5A9H9FG:CFDCC@=B;J=55B0%$Q@9!B75G9C:+)$+9FJ9F
588=H=CB5@DCC@=B;D5F5A9H9FG75B69GD97=Q98=BH<97CBB97H=CBGHF=B;
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
Creating/Editing a Connection Pro-le
,C7F95H9CF98=H57CBB97H=CBDFCQ@9
 +9@97HH<9(FC>97H:CFK<=7<MCI5F97F95H=B;57CBB97H=CBDFCQ@9=BH<9(FC>97HLD@CF9F5B89LD5B8
MCIFDFC>97H:C@89FG9H
 LD5B8H<986:C@89F
 CI6@97@=7?H<97CBB97H=CBDFCD9FH=9GQ@9,<9CBB97H=CB(FCQ@9GJ=9KCD9BG
 ,C7F95H95B9KDFCQ@97@=7?H<9 Add Pro4le =7CB=BH<9(FCQ@9GD5B9!:MCIK=G<HC98=H5B
9L=GH=B;DFCQ@9MCI75BG9@97H5B9L=GH=B;DFCQ@9=BH<9(FCQ@9GD5B9
 !BH<99H5=@GD5B99BH9FCFID85H9H<95DDFCDF=5H9=B:CFA5H=CB=B957<Q9@8Q9@8G7CBH5=B=B;H<9
7<5F57H9F5F9F9EI=F98
 @=7?H<9 Save Pro4le =7CB=BH<9IDD9FF=;<HC:H<9CBB97H=CB(FCQ@9GK=B8CK 1CIAIGHG5J9H<9
DFCQ@9=BCF89F:CF=HHC695J5=@56@9:CFG9@97H=CB=BH<9+9@97HCBB97H=CB(FCQ@98=5@C;6CL
 ,9GHH<97CBB97H=CBDFCQ@96M7@=7?=B;H<9 Test Connection 6IHHCBHC7CBB97HHCH<985H565G9
O ,<9A9GG5;9 Database connection was successful =B8=75H9GMCIF7CBB97H=CBDFCQ@9
GI779GG:I@@M7CBB97H98HCH<9=BH9B89885H565G9
O ,<9A9GG5;9 Database connection failed :C@@CK986M588=H=CB5@89H5=@G=B8=75H9G5
DFC6@9AK=H<MCIF7CBB97H=CBDFCQ@9-D85H9H<9DFCQ@9G5J9=H5B8H9GH=H5;5=B
Note: CF=B:CFA5H=CBCB7F95H=B;H<97CBQ;IF5H=CB:CFH<97CBB97H=CBDCC@CBH<95DD@=75H=CBG9FJ9F
G=89G99 CBB97H=CB(CC@=B;
Preview Connection Strings
,<97CBB97H=CBHCH<985H565G9K=H<H<9GD97=Q98D5F5A9H9FG=BH<97CBB97H=CBDFCQ@975B69
DF9J=9K985B8H9GH98=BH<9CBB97H=CBDFCQ@998=HCF!B75G9C:"5J5DFC>97H5GH<989G=;B5B8
FIBH=A97CBB97H=CBGIG9"7CBB97H=CB"7CBB97H=CBGHF=B;=G5J5=@56@9HCDF9J=9K5B8H9GH!B
75G9C:CHB9HDFC>97HG5GH<989G=;BH=A9IG9G"7CBB97H=CB5B8FIBH=A9IG9G'$
7CBB97H=CB6CH<GHF=B;G5F95J5=@56@9HCDF9J=9K5B8H9GH Note: ,<9CHB9HDFC>97HAIGH69
89D@CM987CFF97H@M=B!!+HCDF9J=9KH<9'$7CBB97H=CBGHF=B;,<9D5F5A9H9FG5D5FH:FCACB9G
9LD@=7=H@M7C@@97H98=BH<998=HCF75B6958898IG=B;H<9 custom parameters 8=5@C;K<=7<H5?9GH<9
D5F5A9H9FG5G5B5A9J5@I9D5=F
Using the Query Builder
,<9CADCG9F)I9FMI=@89FDFCJ=89G5J=GI5@A9H<C8C:6I=@8=B;585H565G9EI9FMK=H<CIHH<9B998
HCHMD9+)$7C89,<9)I9FMI=@89F=G5779GG98H<FCI;<H<9 )I9FM,MD9DFCD9FHM =BH<95H5
6@C7?!H75B69IG98:CF6CH<JC=7975@@RCKG5B8FCIH=B;KCF?RCKG Note: ,<9)I9FMI=@89F75B
CB@M695779GG98K<9B5J5@=87CBB97H=CBDFCQ@9<5G699B7F95H985B8G9@97H98=BH<9 CBB97H=CB
(FCQ@9DFCD9FHM C:H<95H56@C7?,<9)I9FMI=@89FK=H<5B9L5AD@9EI9FM=GG<CKB69@CK
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
I=@8=B;55H565G9)I9FM
,<9)I9FMI=@89FCD9BGK<9BCADCG9F=GGI779GG:I@@M56@9HC7CBB97HHCH<985H565G9GD97=Q98=B
MCIF7CBB97H=CBDFCQ@9 BMG7<9A5GH56@9G5B8H56@9GMBCBMAG5B87C@IABGC:H<985H565G9
5779GG=6@9:FCAH<9GD97=Q98IG9F577CIBH5F9G<CKB=B<=9F5F7<=75@:CFA5H=BH<95H565G9+HFI7HIF9
D5B9C:H<9)I9FMI=@89F!BH<99L5AD@969@CK EMPLOYEESSYNONYM =G5H56@9GMBCBMA
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
,56@9+MB;=:
Note: %++)$+9FJ9FH56@9GMBCBMAG5F9F958:FCAH<9GMGH9AH56@9GMGGMBCBMAG'F57@9H56@9
GMBCBMAG5F9F958:FCAH<9GMGH9AH56@9IG9F4GMBCBMAG,C6I=@85EI9FM
 +D97=:MK<=7<H56@97C@IABG5F9F9HIFB985GEI9FMF9GI@HG
O +9@97HH<9H56@9G5B87C@IABGHC=B7@I89=BMCIFEI9FM6M7<97?=B;5DDFCDF=5H9=H9AG=BH<9
Database Structure D5B9LD5B8H56@99BHF=9GHCG99H<97C@IABG,CG9@97H5@@7C@IABG
=B5H56@9G9@97HH<95DDFCDF=5H9All columns7<97?6CLIB89FH<95DDFCDF=5H9H56@9
O +9@97H987C@IABG5B8H56@9G5DD95F=BH<9 Selected Columns D5B9,C5@H9FH<9CF89F=B
K<=7<G9@97H987C@IABG5F9F9HIFB98=BEI9FMF9GI@HGIG9H<9 Up 5B8 Down 6IHHCBGHC
F9CF89F7C@IABGK=H<=BH<9@=GH
O ,CGD97=:MH<9CF89F=BK<=7<EI9FMF9GI@HGG<CI@869GCFH987@=7?H<9 Sort Order Q9@8:CF5
7C@IAB5B8G9@97H5+CFHCDH=CBascending CF descending,<=GK=@@5IHCA5H=75@@MQ@@=B
H<9+CFH'F89FK<=7<=B8=75H9GH<9G9EI9B79=BK<=7<AI@H=D@9GCFH7F=H9F=5K=@@695DD@=98!H
=GDCGG=6@9HCGCFH6MAI@H=D@97C@IABG5B8MCI75B7<5B;9H<9GCFH=B;G9EI9B796M7@=7?=B;
CBH<9 Sort Priority 7C@IABCF9L5AD@9MCIA=;<HGCFH5EI9FMC:B5A9G6M@5GHB5A9
5B8H<9BGCFH6MQFGHB5A9:CFH<CG9D9CD@9K=H<H<9G5A9@5GHB5A9 !BH<5H75G9@5GH
B5A9<5G+CFH'F89F5B8QFGHB5A9<5G+CFH'F89F
Note: ,<9CF89F=BK<=7<7C@IABG5DD95F=BH<9+9@97H98C@IABG@=GH8C9GBCH5P97HH<9GCFHCF89F
O ,CGD97=:MH<9J5F=56@9G=BHCK<=7<H<97C@IABJ5@I9GB998HC697CD=987@=7?H<9 Variable
Mapping Q9@8:CF57C@IAB5B8G9@97H5J5F=56@9!:5J5F=56@9=GGD97=Q98:CF57C@IAB 
5H56@C7? 9L97IH=CBK=@@F9GI@H=BH<97C@IABJ5@I9GC:H<9QFGHF97CF869=B;7CD=98=BHCH<9
GD97=Q98J5F=56@9!:ACF9H<5BCB9F97CF8=GF9HIFB986MH<9EI9FMH<9BIG9H<9 $CCD=B;
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D
CAACB@C7? 5@CB;K=H<H<95H56@C7?HC=H9F5H9CJ9FF97CF8G5B8DCDI@5H9H<9
J5F=56@9GGD97=Q98:CFH<97C@IABG
 +D97=:MQ@H9F7F=H9F=5!BH<9 Conditions D5B9MCI6I=@8H<9G95F7<CFQ@H9F7F=H9F=5HC=89BH=:MH<985H5
MCIK5BHHCF9HF=9J9:FCAH<985H565G91CI75B75BGD97=:MAI@H=D@97CB8=H=CBG
O @=7? Add HC7F95H95B9K7CB8=H=CBB9KFCKK=@@6958898HCH<9CB8=H=CBG@=GH@=7?H<9
Condition 7C@IAB5B8H<9B7@=7?H<9 HCCD9BH<9CB8=H=CBI=@89F
O +9@97H57C@IAB:FCAH<9 Select Column 8FCD8CKB@=GHK<=7<H<9G95F7<7CB8=H=CBK=@@
CD9F5H9CB
O +9@97HH<9CD9F5HCF5B8GCCB:FCAH<9 Operator 8FCD8CKB@=GH,<=G
CD9F5HCFK=@@69IG98HC7CAD5F9H<9GD97=Q987C@IABK=H<H<9J5@I9GD97=Q98=BH<9B9LH
GH9D@=
O !BH<9 Value Q9@8HMD9CFG9@97HMCIFJ5@I9:CFH<97CB8=H=CB89D9B8=B;CBH<9J5@I9HMD9
CDH=CB
O Column Reference 5H56@97C@IABH<5HMCI75BG9@97H:FCA58FCD8CKB@=GH
,<=GCDH=CBK=@@7CAD5F9H<9HKCG9@97H987C@IABG65G98CBH<9GD97=Q98
CD9F5HCF
O Application Variable 5 J5F=56@9 89QB98=BMCIF5DD@=75H=CBH<5H75B69
G9@97H98:FCA58FCD8CKB@=GHHFIBH=A9H<97IFF9BHJ5@I9C:H<9G9@97H98
J5F=56@9K=@@69IG98:CF7CAD5F=B;H<97C@IABNGJ5@I965G98CBH<9GD97=Q98
CD9F5HCF
O Custom Value 5J5@I9H<5H=GBCHJ5@=85H986MH<9EI9FM6I=@89F5B8=G58898
8=F97H@MHCH<9EI9FM !H75B69IG98HCGD97=:M+)$:IB7H=CBGCFACF97CAD@9L
9LDF9GG=CB
O Literal 5J5@I9H<5H=G=BH9FDF9H985G5GHF=B;CF5BIA69F,MD9=BH<9@=H9F5@
J5@I9,<9J5@I9K=@@699B7@CG98=BEICH9G5IHCA5H=75@@M=:=H=G5GHF=B;!:H<9
@=H9F5@J5@I9F9DF9G9BHG5BIA69FMCIK=@@B998HC9B7@CG9=H=BEICH9G
89D9B8=B;CBH<985H5HMD9C:H<9G9@97H987C@IAB,<=GCDH=CBK=@@7CAD5F9
H<9G9@97H987C@IABNGJ5@I9HCH<9GD97=Q98@=H9F5@IG=B;H<9GD97=Q98CD9F5HCF
O @=7? OK HC7CAD@9H9H<97CB8=H=CB
O -G=B;H<956CJ9GH9DGMCI75B89QB9AI@H=D@97CB8=H=CBG,<9G97CB8=H=CBG75B69
7CA6=B98IG=B;@C;=75@CD9F5HCFGHC:IFH<9FF9QB9MCIFG95F7<7F=H9F=51CI75BG9@97H AND
CF OR =BH<9 Boolean Q9@8HCGD97=:MH<9@C;=75@CD9F5HCF
 ,9GHMCIFEI9FM
O ,CH9GHH<9EI9FMMCI75B7@=7?H<9 Preview Data 6IHHCB,<=G9L97IH9GH<9EI9FM5;5=BGH
H<95DDFCDF=5H985H565G9!:H<985H565G9H56@9G7CBH5=B85H55B8=:5BMF97CF8GA5H7<H<9
GD97=Q987CB8=H=CBGH<9MK=@@698=GD@5M98=BH<9)I9FM*9GI@HG(F9J=9KD5B9A9GG5;9
K=@@5@GCG<CKH<9BIA69FC:F97CF8GF9HIFB985G5F9GI@HC:H<9EI9FM
O !:MCI9LD97HH<5HH<9BIA69FC:A5H7<=B;F97CF8GK=@@69@5F;95B8K5BHHCDF9J=9K5GI6G9H
C:F9HIFB9885H57@=7?H<9 Limit Rows 7<97?6CL5B89BH9F5BIA9F=7J5@I9HC@=A=HH<9
BIA69FC:F9HIFB98F9GI@HG
Note,<9A9GG5;9K=@@BCKG<CKH<9BIA69FC:F97CF8G8=GD@5M98F5H<9FH<5BH<957HI5@BIA69FC:
A5H7<=B;F97CF8G,<9EI9FMF9GI@HGDF9J=9K=GG<CKB=BH<9)I9FM*9GI@HD5B9
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D 
 @=7? OK HCG5J9MCIFEI9FM5B8ID85H9H<9 5H5 6@C7?K=H<H<9B9KEI9FM!:MCI7@=7?5B79@5@@
7<5B;9G5F98=G75F8985B8BC7<5B;9G5F9A589HCH<95H56@C7?
Specifying Custom Queries
,<9 5H5 6@C7?75BIG9EI9F=9GGD97=Q98=B5+)$GE@Q@9=BMCIF(FC>97H=BGH958C:5EI9FM
7F95H98IG=B;H<9 )I9FMI=@89F,CIG957IGHCAEI9FM
O F95H95GE@Q@9=BMCIF86:C@89F5B8GD97=:MH<9Q@9B5A9=BH<9 )I9FM=@9 DFCD9FHMC:H<95H5
6@C7?%5?9GIF9H<5HH<9CD9F5H=CBHMD9=G SQLScriptFileCADCG9FK=@@F958H<=GQ@95HFIBH=A95B8
IG9=HHCEI9FMH<9GD97=Q9885H565G9
,<956=@=HMHCIG97IGHCAEI9F=9G=GIG9:I@=B75G9GK<9F9H<9+)$EI9FM=G5@F958M7F95H98IG=B;
CH<9FHCC@GCF=:H<9EI9FMIG9G:95HIF9GBCHGIDDCFH986MH<9.=GI5@)I9FMI=@89F,<9B9LHHCD=7
89G7F=69G @=A=H5H=CBG C:H<9EI9FM6I=@89F
!ADCFH5BH
!:MCI5F9GD97=:M=B;57IGHCAEI9FMCADCG9F7IFF9BH@MGIDDCFHG9L97IH=B;CB@M5
G=B;@9+)$GH5H9A9BH5HFIBH=A9H<CI;<AI@H=D@9GH5H9A9BHGA=;<HKCF?:CF79FH5=B
9B;=B9G
DD@=75H=CB.5F=56@9G
1CI75BIG9DD@=75H=CBJ5F=56@9G=B7IGHCAEI9FMQ@9G5GD5FHC:H<9+)$GH5H9A9BH,CIG95
J5F=56@9=B7@I89=HGB5A9K=H<=B7IF@M6F579GK=H<CIHH<9DD+H5H9DF9QLCF9L5AD@9H<9:C@@CK=B;
GH5H9A9BHIG9GJ5FB5A95B8J5FB5A9,<9=FJ5@I9GK=@@69GI6GH=HIH985HH<9H=A9H<95H5
6@C7?EI9F=9GH<985H565G9 SELECT name_of_function({varname1}, {varname2}) from dual
*9GI@HGC:H<9EI9FM5F9GHCF98=B5J5F=56@95G5HKC8=A9BG=CB5@"+'&5FF5M,<=G85H575BH<9B69
5779GG98J=55 $CCD=B;CAACB@C7? CFJ=5G7F=DH=B;=BH<9GG=;BCF %+7F=DH6@C7?CF
9L5AD@9=:H<985H565G9F9GI@HG9H@CC?G@=?9H<=G=BH56I@5F:CFA
Vegetables Animals
@9HHI79 7<=7?9B
6FC77C@= @=CB
,<9"+'&:CFH<9F9GI@HK=@@@CC?@=?9H<=G {"db_result":[["lettuce", "chicken"], ["broccoli",
"lion"]],"db_result_columns":["vegetables", "animals"]} Note: B9L5AD@9C:7IGHCA
EI9F=9G=G=BH<95H565G9+HC7?G,9AD@5H95DD@=75H=CB
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D 
Stored Procedure Helper
!:MCIG9@97H StoredProcedure :CFH<9 )I9FM,MD9 DFCD9FHM=BH<9 5H5@C7?MCI75B7@=7?H<9
6IHHCBCBH<9DFCD9FHMFCKHCCD9BH<9+HCF98(FC798IF9 9@D9F8=5@C;6CL 9F9MCI75B
G9@97H5GHCF98DFC798IF99L97IH9=H5B8;9HEI9FMF9GI@HG7CAD@9H989L5AD@9=GG<CKB69@CK
Setting up a Stored Procedure Call
,<9+HCF98(FC798IF9 9@D9FCD9BGK<9BCADCG9F=GGI779GG:I@@M56@9HC7CBB97HHCH<985H565G9
GD97=Q98=BMCIF7CBB97H=CBDFCQ@9BMGHCF98DFC798IF9G=BH<985H565G95779GG=6@9:FCAH<9
GD97=Q98IG9F577CIBH5F9G<CKB=B<=9F5F7<=75@:CFA5H=BH<95H565G9+HFI7HIF9D5B9C:H<9+HCF98
(FC798IF9 9@D9F ,CG9HID5GHCF98DFC798IF975@@
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D 
 +D97=:MK<=7<GHCF98DFC798IF9G<CI@8699L97IH98
 +9@97HH<9GHCF98DFC798IF9HC9L97IH96M7<97?=B;5DDFCDF=5H9=H9A=BH<95H565G9+HFI7HIF9D5B9
 (5F5A9H9FG5B8*9HIFB.5@I95DD95F=BH<9(5F5A9H9FGD5B9+D97=:MH<9J5@I95DD@=75H=CBJ5F=56@9:CF
957<C:H<9D5F5A9H9F=BHCK<=7<H<9CIHDIHJ5@I9=GGHCF985:H9FH<9GHCF98DFC798IF9<5G9L97IH98
 ,CH9GHH<9GHCF98DFC798IF97@=7?H<9 Execute 6IHHCB,<=G9L97IH9GH<9GHCF98DFC798IF9=BH<9
5DDFCDF=5H985H565G9!:H<9GHCF98DFC798IF9F9HIFBG5BMF97CF8GH<9M5F98=GD@5M98=BH<9)I9FM
*9GI@HG(F9J=9KD5B9BMCIHDIHJ5@I9G5F98=GD@5M98=BH<9)I9FM*9GI@H(5F5A9H9FGD5B9
A9GG5;9G<CKGH<9BIA69FC:F97CF8GF9HIFB985G5F9GI@HC:H<9EI9FM
 @=7? OK HCG5J9MCIFEI9FM5B8ID85H9H<95H56@C7?K=H<H<9B9KEI9FM!:MCI7@=7?5B79@5@@
7<5B;9G5F98=G75F8985B8BC7<5B;9G5F9A589HCH<95H56@C7?
Note: CADCG9F8C9GBCHGIDDCFHH<9*-*+'*F9HIFBHMD9=B5GHCF98DFC798IF9
Password Encryption
CADCG9F75BBCK9B7FMDHH<985H565G97CBB97H=CBDFCQ@9D5GGKCF8GGCH<5HH<9M5F9BCHKF=HH9B=B
H<97@95FHCH<97CBB97H=CBDFCD9FH=9GQ@9
B7FMDH=CB#9M
!BCF89FHC9B56@99B7FMDH=CBMCIAIGHQFGH7F95H95B9B7FMDH=CB?9MCADCG9FF9EI=F9G56=H
6MH9G?9M=B<9L9B7C898:CFA5H,<=G75B69F5B8CA@M;9B9F5H986MH<9'D9B++$HCC@IG=B;
H<9:C@@CK=B;7CAA5B8@=B9
$ openssl rand -hex 16 75b8ec9a3ce60a21c4f94236a1b55fb2
BMF5B8CAGCIF79K=@@8CBCH<9F9L5AD@9=G http://www.random.org/cgi-bin/
randbyte?nbytes=16&format=h /=H<H<=G9L5AD@9MCIK=@@<5J9HCF9ACJ9H<9GD579G=BH<9
CIHDIH
+5J9H<99B7FMDH=CB?9MHC5H9LHQ@9&CH9H<5HH<=GQ@9G<CI@869G97IF9@MGHCF98GCH<5H=H75BCB@M
69F9586MH<9CADCG9FDFC79GG5B8H<9657?9B8,CA75H!!+DFC79GG9G
CBQ;IF=B;CADCG9F(F9:9F9B79G
!BH<9 Composer Security DF9:9F9B79D5;9G9HH<9B7FMDH=CB#9M$C75H=CBDF9:9F9B79HCDC=BH
HCH<99B7FMDH=CB?9MQ@97F95H98=BH<9DF9J=CIGGH9D
B7FMDH=B;H<95H565G9CBB97H=CB(FCQ@9(5GGKCF8
!BH<9CBB97H=CB(FCQ@98=HCFB9LHHCH<9(5GGKCF8Q9@89B56@9H<9 Encrypt 7<97?6CL&CKK<9B
MCIG5J9H<9CBB97H=CB(FCQ@9H<9D5GGKCF8K=@@69G7F5A6@98=BH<97CBB97H=CBDFCD9FH=9GQ@9
B56@=B;97FMDH=CB=BH<957?9B8
/<9BH<95DD@=75H=CBFIBGH<95DD@=75H=CBG9FJ9FK=@@B998HC6956@9HC897FMDHH<9D5GGKCF8GCH<5H
=H75B7CBB97HHCH<985H565G9CFH<=GH<95DD@=75H=CBB998GHC697CBQ;IF98K=H<H<9@C75H=CBC:
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D 
H<99B7FMDH=CB?9MQ@9
"5J5CADCG9F(FC>97HG
!:=H8C9GBH5@F958M9L=GH7F95H9H<9Q@9/!&7CADCG9FDFCD9FH=9G=BG=89H<9DFC>97H!BG=89H<9
Q@99BH9FH<9:C@@CK=B;@=B9
composerEncryptionKey=C:\\secrets\\encryption-key.txt
&CH9H<5HH<9657?G@5G<9G<9F9AIGH699G75D98
&,CADCG9F(FC>97HG
8=HH<9K967CBQ;Q@9G5DD+9HH=B;G9BHFM
<appSettings>
<add key="composerEncryptionKey" value="C:\secrets\encryption-key.txt" />
...
</appSettings>
57?G@5G<9G<9F95F9QB9
Limitations and Workarounds
,<9)I9FMI=@89FGIDDCFHG7F95H=B;+$,GH5H9A9BHG,<9:C@@CK=B;=G5@=GHC:@=A=H5H=CBG5@CB;
K=H<GI;;9GH98KCF?5FCIB8G
O !&+*,-(,5B8$,GH5H9A9BHG75BBCH697F95H98IG=B;H<9)I9FMI=@89F8J5B798+)$
:95HIF9GGI7<5GCIH9F>C=BGGI6EI9F=9G5B8IB=CBG5F95@GCBCHGIDDCFH98 7IGHCAEI9FM 75B69
IG98HCCJ9F7CA9H<9G9@=A=H5H=CBG
O =:MCIF9B5A95 5H5 6@C7?=HG7CFF9GDCB8=B;+)$GH5H9A9BHQ@9=BH<986:C@89FK=@@BCH69ID85H98
5B8K=@@BCH69J5@=8IBH=@MCI;9B9F5H97C895;5=B
O CF89H5=@GCB+)$85H5HMD9GGIDDCFH986MCADCG9FG99 +IDDCFH98+)$5H5HMD9G
Oracle Client Setup for IIS
,CG9HID5B'F57@97@=9BH:CF!BH9FB9H!B:CFA5H=CB+9FJ=79G
 !BGH5@@H<9'F57@97@=9BH7CADCB9BHGCBH<95DD@=75H=CBG9FJ9F
 F95H95 tnsnames.ora Q@9=BH<9 C:\oracle\ora81\network\ADMIN :C@89FK<9F93CF57@9=GH<9
=BGH5@@5H=CB:C@89FC:'F57@97@=9BH7CADCB9BHG
 88H<9:C@@CK=B;@=B9GHC tnsnames.ora K<9F9'%(=G5BM5@=5GC:7<C=79012=GH<9'F57@9
G9FJ9F'%('+*=GH<9 Service Name 5G7CBQ;IF98CBH<9'F57@9@=GH9B9FG9FJ9F:H9F8C=B;H<=G
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D 
MCIG<CI@86956@9HC7CBB97HHC'F57@9IG=B; sqlplus user/pwd@COMPDB1 5GH<97CAA5B85HH<9
7CAA5B8DFCADH
'%( +*!(,!'& *++4$!+, *++(*',''$,( '+,
012IG=BH;9B9GMG@567CA('*, '&&,4, +*.!4&%
'%('+*
 F95H95+MGH9A+&IG=B;H<95H5+CIF79G'IB89F Administrative Tools
 %5?9GIF9H<5H Data Source Name GD97=Q9856CJ9=G9L57H@MG5A95GH<9 Database Name GD97=Q98
=BH<9CADCG9F85H565G97CBB97H=CBDFCQ@95B8 TNS Service Name =GH<9G5A95GH<95@=5G=BGH9D

 @=7? Test Connection =BH<985H565G97CBB97H=CBDFCQ@9 ,<97CBB97H=CBG<CI@869GI779GG:I@5B8
H<9CADCG9F.0%$5DD@=75H=CBG<CI@86956@9HC7CBB97HHCH<985H565G9
+H9DG5B875B695JC=898=:H<95@=5GIG98=BH<9 tnsnames.ora Q@9=GG5A95GH<985H565G9
B5A9GD97=Q98=BCADCG9F
Working with Oracle 12c R2 from Composer .NET projects
+H5FH=B;K=H<F9@95G9CADCG9FGIDDCFHG'F57@97*(9F:CFAH<9:C@@CK=B;GH9DGHC
KCF?K=H<'F57@97*:FCACADCG9F&,DFC>97HG
 CKB@C585B8=BGH5@@H<9'F57@977@=9BHB'F57@977@=9BH=GF9EI=F98HC7CBB97HHC5B'F57@97
85H565G9H<9'F57@977@=9BH75B699=H<9F6=HCF6=H
 *9;=GH9FH<9 ORAOLEDB.ORACLE $$Q@9CBH<97@=9BHA57<=B95G:C@@CKG
 'D9BH<9CAA5B8(FCADH=B administrator AC89CBH<97@=9BHA57<=B9
 FCKG9HCH<9'F57@9@=9BH=BGH5@@98D5H<5B8=89BH=:MH<9 OraOLEDB12.dll Q@9
 L97IH9H<97CAA5B8 C:\Windows\System32\regsvr32.exe OraOLEDB12.dllHCF9;=GH9FH<9
OraOLEDB12.dll Q@9
 'F57@977@=9BH6=HB9GG5B8!!+6=HB9GG7CBQ;IF5H=CBAIGHA5H7<CH<AIGH699=H<9F6=HCF6=H
 &5J=;5H9HC IIS Manager > Application Pools
 @=7?H<958J5B798G9HH=B;GC:H<9DCC@IG986MH<9DFC>97HIGI5@@M DefaultAppPool
 -G9H<9 Enable 32-bit Application CDH=CBHC58>IGH!!+6=HB9GG5GF9EI=F98
/CF?=B;K=H<5H565G9@C7?G
CADCG9F 9@D 