OurJava

To configure text to take multiple values as query you can either right a bean class for dialog or you can do this :- <textbox dataattribute="persongroup" id="PersongGroupId1" inputmode="query" label="Person Group"

Create Maxdomain :--------- insert into maxdomain ( domainid, description, domaintype, maxtype, length, scale, maxdomainid, internal, rowstamp) values ('APPSTATUS', 'App Status', 'SYNONYM', 'UPPER', 20, 0, maxdomainseq.nextval, 1, maxseq.nextval) ; Query for inserting values in domain insert into synonymdomain ( domainid, maxvalue, value, description, defaults, siteid, orgid, synonymdomainid, valueid, rowstamp) values ('APPSTATUS', 'WAPPR', 'WAPPR', 'Waiting on Approval', 1, null, null, synonymdomainseq.nextval, 'APPSTATUS|WAPPR', maxseq.nextval) ;

steps Open SQL PLUS and run below commands logon as sysdba/admin shutdown immediate startup recover database alter database open

Step 1. Create new databasource Give this details connection name : test SID : database name servername : localhost PORT : 1521 Define userid and password by checking signon check box. Click next Define descriptor like (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = oracledb)     )   ) Click text connection.

To connect with oracle database we may require tnsname.ora file present in this location %User%virtual\product\12.2.0\dbhome_1\network\admin....................... It has connection string like ORACLEDB =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = oracledb)     )   )