diff options
| author | Lorry Tar Creator <lorry-tar-importer@baserock.org> | 2015-02-17 17:25:57 +0000 |
|---|---|---|
| committer | <> | 2015-03-17 16:26:24 +0000 |
| commit | 780b92ada9afcf1d58085a83a0b9e6bc982203d1 (patch) | |
| tree | 598f8b9fa431b228d29897e798de4ac0c1d3d970 /examples/sql | |
| parent | 7a2660ba9cc2dc03a69ddfcfd95369395cc87444 (diff) | |
| download | berkeleydb-master.tar.gz | |
Diffstat (limited to 'examples/sql')
47 files changed, 2584 insertions, 19 deletions
diff --git a/examples/sql/adf/EX_ADF/.adf/META-INF/adf-config.xml b/examples/sql/adf/EX_ADF/.adf/META-INF/adf-config.xml new file mode 100644 index 00000000..809182b2 --- /dev/null +++ b/examples/sql/adf/EX_ADF/.adf/META-INF/adf-config.xml @@ -0,0 +1,20 @@ +<?xml version="1.0" encoding="GBK" ?> +<adf-config xmlns="http://xmlns.oracle.com/adf/config" xmlns:config="http://xmlns.oracle.com/bc4j/configuration" + xmlns:adf="http://xmlns.oracle.com/adf/config/properties" + xmlns:sec="http://xmlns.oracle.com/adf/security/config"> + <adf-adfm-config xmlns="http://xmlns.oracle.com/adfm/config"> + <defaults changeEventPolicy="ppr" useBindVarsForViewCriteriaLiterals="true"/> + <startup> + <amconfig-overrides> + <config:Database jbo.locking.mode="optimistic"/> + </amconfig-overrides> + </startup> + </adf-adfm-config> + <adf:adf-properties-child xmlns="http://xmlns.oracle.com/adf/config/properties"> + <adf-property name="adfAppUID" value="EX_ADF-1027"/> + </adf:adf-properties-child> + <sec:adf-security-child xmlns="http://xmlns.oracle.com/adf/security/config"> + <CredentialStoreContext credentialStoreClass="oracle.adf.share.security.providers.jps.CSFCredentialStore" + credentialStoreLocation="../../src/META-INF/jps-config.xml"/> + </sec:adf-security-child> +</adf-config> diff --git a/examples/sql/adf/EX_ADF/.adf/META-INF/connections.xml b/examples/sql/adf/EX_ADF/.adf/META-INF/connections.xml new file mode 100644 index 00000000..8469d4f5 --- /dev/null +++ b/examples/sql/adf/EX_ADF/.adf/META-INF/connections.xml @@ -0,0 +1,21 @@ +<?xml version = '1.0' encoding = 'UTF-8'?> +<References xmlns="http://xmlns.oracle.com/adf/jndi"> + <Reference name="BDBConnection" className="oracle.jdeveloper.db.adapter.DatabaseProvider" credentialStoreKey="BDBConnection" xmlns=""> + <Factory className="oracle.jdeveloper.db.adapter.DatabaseProviderFactory"/> + <RefAddresses> + <StringRefAddr addrType="subtype"> + <Contents>thirdParty</Contents> + </StringRefAddr> + <StringRefAddr addrType="user"> + <Contents>myLogin</Contents> + </StringRefAddr> + <SecureRefAddr addrType="password"/> + <StringRefAddr addrType="driver"> + <Contents>SQLite.JDBCDriver</Contents> + </StringRefAddr> + <StringRefAddr addrType="customUrl"> + <Contents>jdbc:sqlite:/absolute_path_to_db</Contents> + </StringRefAddr> + </RefAddresses> + </Reference> +</References> diff --git a/examples/sql/adf/EX_ADF/EX_ADF.jws b/examples/sql/adf/EX_ADF/EX_ADF.jws new file mode 100644 index 00000000..a1369404 --- /dev/null +++ b/examples/sql/adf/EX_ADF/EX_ADF.jws @@ -0,0 +1,87 @@ +<?xml version = '1.0' encoding = 'UTF-8'?> +<jws:workspace xmlns:jws="http://xmlns.oracle.com/ide/project"> + <value n="appTemplateId" v="adfWebappApplicationTemplate"/> + <hash n="component-versions"> + <value n="oracle.adf.share.dt.migration.jps.JaznCredStoreMigratorHelper" v="11.1.1.1.0"/> + <value n="oracle.adfdtinternal.model.ide.security.extension.AdfSecurityMigrator" v="11.1.1.1.0.13"/> + <value n="oracle.ide.model.Project" v="11.1.1.1.0;11.1.2.0.0"/> + <value n="oracle.jbo.dt.jdevx.deployment.JbdProjectMigrator" v="11.1.2.0.0"/> + <value n="oracle.jdevimpl.appresources.ApplicationSrcDirMigrator" v="11.1.2.0.0"/> + <value n="oracle.jdevimpl.xml.oc4j.jps.JpsConfigMigratorHelper" v="11.1.1.1.0.1"/> + <value n="oracle.jdevimpl.xml.wl.WeblogicMigratorHelper" v="11.1.1.1.0"/> + <value n="oracle.mds.internal.dt.deploy.base.MarMigratorHelper" v="11.1.1.1.0"/> + <value n="oracle.mds.internal.dt.ide.migrator.MDSConfigMigratorHelper" v="11.1.1.0.5313"/> + </hash> + <list n="contentSets"> + <string v="oracle.mds.internal.dt.ide.appresources.MDSAppResourceCSProvider/MDSAppContentSet"/> + <string v="oracle.jdeveloper.model.PathsConfiguration/ADFContentSet"/> + <string v="oracle.jdeveloper.model.PathsConfiguration/ApplicationSrcContentSet"/> + <string v="oracle.jdeveloper.model.PathsConfiguration/ApplicationLevelMavenPOMContentSet"/> + </list> + <list n="listOfChildren"> + <hash><url n="URL" path="Model/Model.jpr"/></hash> + <hash><url n="URL" path="ViewController/ViewController.jpr"/></hash> + </list> + <hash n="oracle.jdeveloper.deploy.dt.DeploymentProfiles"> + <hash n="profileDefinitions"> + <hash n="EX_ADF_Project1_EX_ADF"> + <hash n="archiveOptions"> + <value n="hasManifest" v="false"/> + </hash> + <hash n="dependencies"> + <list n="dependencyList"> + <hash> + <value n="adapterClass" v="oracle.jdevimpl.deploy.common.ArchiveProfileDependable"/> + <url n="ownerURL" path="ViewController/ViewController.jpr"/> + <value n="profileName" v="EX_ADF_Project1_webapp"/> + </hash> + </list> + </hash> + <url n="earURL" path="deploy/EX_ADF_Project1_EX_ADF.ear"/> + <value n="enterpriseAppName" v="EX_ADF_Project1_EX_ADF"/> + <hash n="fileGroups"> + <list n="groups"> + <hash> + <list n="contributors"> + <hash> + <value n="type" v="9"/> + </hash> + </list> + <value n="displayName" v="Application Descriptors"/> + <hash n="filters"> + <list n="rules"> + <hash> + <value n="DefaultFilters" v=""/> + </hash> + </list> + </hash> + <value n="internalName" v="ear-metainf"/> + <value n="type" v="1"/> + </hash> + <hash> + <value n="displayName" v="Application Libraries"/> + <hash n="filters"> + <list n="rules"> + <hash> + <value n="pattern" v="**"/> + </hash> + </list> + </hash> + <value n="internalName" v="libraries"/> + <value n="targetWithinJar" v="lib"/> + <value n="type" v="3"/> + </hash> + </list> + </hash> + <hash n="libraryDependencies"> + <value n="IncludeLibrariesFromOtherContainers" v="true"/> + </hash> + <value n="profileClass" v="oracle.jdeveloper.deploy.ear.EarProfile"/> + <value n="profileName" v="EX_ADF_Project1_EX_ADF"/> + </hash> + </hash> + <list n="profileList"> + <string v="EX_ADF_Project1_EX_ADF"/> + </list> + </hash> +</jws:workspace> diff --git a/examples/sql/adf/EX_ADF/Model/Model.jpr b/examples/sql/adf/EX_ADF/Model/Model.jpr new file mode 100644 index 00000000..cf734170 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/Model.jpr @@ -0,0 +1,212 @@ +<?xml version = '1.0' encoding = 'UTF-8'?> +<jpr:project xmlns:jpr="http://xmlns.oracle.com/ide/project"> + <hash n="component-versions"> + <value n="oracle.adfdt.controller.adfc.source.migration.AdfControllerSchemaMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdt.controller.common.migrator.ProjectMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdt.controller.migrate.TrinidadDatabindingsProjectMigrator" v="11.1.2.0.0"/> + <value n="oracle.adfdtinternal.dvt.datapresdt.migration.DVTDataMapMigrator" v="11.1.1.1.0.3"/> + <value n="oracle.adfdtinternal.model.ide.migration.ProjectMigrator" v="11.1.1.1.0.11.1.1"/> + <value n="oracle.adfdtinternal.model.ide.security.wizard.FormPageMigrator" v="11.1.1.0.0"/> + <value n="oracle.adfdtinternal.model.ide.security.wizard.JpsFilterMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdtinternal.model.ide.xmled.migration.ADFNodeMigrator" v="11.1.1.1.0.5"/> + <value n="oracle.adfdtinternal.model.ide.xmled.migration.PageDefinitionParameterValueMigrator" v="11.1.1.1.0.5"/> + <value n="oracle.adfdtinternal.model.ide.xmled.migration.WebXmlMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdtinternal.view.common.migration.wizards.MigrationHelper" v="11.1.1.1.0.3"/> + <value n="oracle.adfdtinternal.view.rich.binding.migration.JarResourceMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdtinternal.view.rich.migration.ComponentIdNodeMigratorHelper" v="11.1.1.1.0.01"/> + <value n="oracle.adfdtinternal.view.rich.migration.LibraryVersionMigrator" v="11.1.1.1.0.1"/> + <value n="oracle.ide.model.Project" v="11.1.2.0.0"/> + <value n="oracle.ide.model.ResourcePathsMigrator" v="11.1.1.1.0"/> + <value n="oracle.ideimpl.model.TechnologyScopeUpdateMigrator" v="11.1.2.0.0.4"/> + <value n="oracle.jbo.dt.jdevx.deployment.JbdProjectMigrator" v="11.1.2.0.0"/> + <value n="oracle.jbo.dt.jdevx.ui.appnav.APProjectMigrator" v="11.1.1.0.1.5"/> + <value n="oracle.jbo.dt.migrate.ResourceBundlePathMigrator" v="11.1.1.0.1.5"/> + <value n="oracle.jbo.dt.migration.ServiceInterfaceMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdeveloper.library.ProjectLibraryMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdeveloper.model.OutputDirectoryMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.deploy.DeploymentProfilesMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.deploy.jps.JpsDataMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.jsp.JspMigrator" v="11.1.1"/> + <value n="oracle.jdevimpl.offlinedb.migration.OfflineDBProjectMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.offlinedb.migration.OfflinePlSqlMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.resourcebundle.XliffAddin$XliffMigratorHelper" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.webapp.jsp.libraries.JspLibraryMigrator" v="11.1.1.1.4"/> + <value n="oracle.jdevimpl.webapp.WebAppContentSetNodeMigratorHelper" v="11.1.1"/> + <value n="oracle.jdevimpl.webapp.WebAppProjectNodeMigratorHelper" v="11.1.2.0.0"/> + <value n="oracle.jdevimpl.webservices.rest.migration.RestPathMigrator" v="11.1.2.0.0"/> + <value n="oracle.jdevimpl.xml.wl.WeblogicMigratorHelper" v="11.1.1.1.0"/> + <value n="oracle.modeler.bmmigrate.management.Migration" v="11.1.1.1.0"/> + <value n="oracle.toplink.workbench.addin.migration.PersistenceProjectMigrator" v="11.1.1.1.0"/> + <value n="oracle.toplink.workbench.addin.migration.TopLinkProjectMigrator" v="11.1.1.1.0"/> + </hash> + <list n="contentSets"> + <string v="oracle.jdeveloper.model.J2eeSettings/webContentSet"/> + <string v="oracle.mds.internal.dt.ide.MDSLibraryCustCSProvider/mdsContentSet"/> + <string v="oracle.mds.internal.dt.ide.MDSADFLibVirtualNodeCSProvider/mdsLibVirtualNodeContentSet"/> + <string v="oracle.jdeveloper.model.PathsConfiguration/javaContentSet"/> + <string v="oracle.ide.model.ResourcePaths/resourcesContentSet"/> + <string v="oracle.jdeveloper.offlinedb.model.OfflineDBProjectSettings/offlineDBContentSet"/> + <string v="oracle.bm.commonIde.data.project.ModelerProjectSettings/modelersContentSet"/> + <string v="oracle.adfdtinternal.model.ide.settings.ADFMSettings/adfmContentSet"/> + <string v="oracle.toplink.workbench.addin/toplinkContentSet"/> + </list> + <value n="defaultPackage" v="model"/> + <value n="jbo.JpxName" v="model.Model"/> + <value n="JboProject" v="true"/> + <hash n="oracle.ide.model.TechnologyScopeConfiguration"> + <list n="technologyScope"> + <string v="ADFbc"/> + <string v="Java"/> + </list> + </hash> + <value n="oracle.jbo.SavedPreferences" v="true"/> + <hash n="oracle.jdeveloper.compiler.OjcConfiguration"> + <list n="copyRes"> + <string v=".cpx"/> + <string v=".dcx"/> + <string v=".ejx"/> + <string v=".gif"/> + <string v=".ini"/> + <string v=".jpeg"/> + <string v=".jpg"/> + <string v=".png"/> + <string v=".properties"/> + <string v=".sva"/> + <string v=".tag"/> + <string v=".tld"/> + <string v=".wsdl"/> + <string v=".xcfg"/> + <string v=".xlf"/> + <string v=".xml"/> + <string v=".xsd"/> + <string v=".xsl"/> + <string v=".jpx"/> + </list> + <value n="internalEncoding" v="GBK"/> + <list n="Javac.commandline.optionlist"> + <string v="-g"/> + <string v="-Xlint:all"/> + <string v="-Xlint:-cast"/> + <string v="-Xlint:-empty"/> + <string v="-Xlint:-fallthrough"/> + <string v="-Xlint:-path"/> + <string v="-Xlint:-processing"/> + <string v="-Xlint:-serial"/> + <string v="-Xlint:-unchecked"/> + </list> + <value n="webIANAEncoding" v="GBK"/> + </hash> + <hash n="oracle.jdeveloper.deploy.dt.DeploymentProfiles"> + <hash n="profileDefinitions"> + <hash n="EX_ADF_Project1_adflib"> + <value n="adflib-connectionDetails" v="true"/> + <value n="adflib-nonReusablesError" v="false"/> + <hash n="archiveOptions"> + <value n="hasManifest" v="true"/> + </hash> + <hash n="fileGroups"> + <list n="groups"> + <hash> + <list n="contributors"> + <hash> + <value n="type" v="2"/> + </hash> + <hash> + <value n="type" v="5"/> + </hash> + </list> + <value n="displayName" v="Project Output"/> + <hash n="filters"> + <list n="rules"> + <hash> + <value n="pattern" v="WEB-INF/classes/**"/> + <value n="type" v="1"/> + </hash> + <hash> + <value n="DefaultFilters" v=""/> + </hash> + </list> + </hash> + <value n="internalName" v="project-output"/> + <value n="type" v="1"/> + </hash> + </list> + </hash> + <url n="jarURL" path="deploy/EX_ADF_Project1_adflib.jar"/> + <hash n="libraryDependencies"> + <value n="IncludeLibrariesFromOtherContainers" v="true"/> + </hash> + <hash n="LibraryDependencies"/> + <value n="profileClass" v="oracle.adfdt.common.deploy.impl.AdfLibraryProfile"/> + <value n="profileName" v="EX_ADF_Project1_adflib"/> + </hash> + </hash> + <list n="profileList"> + <string v="EX_ADF_Project1_adflib"/> + </list> + </hash> + <hash n="oracle.jdeveloper.model.J2eeSettings"> + <value n="j2eeWebAppName" v="EX_ADF-Model-webapp"/> + <value n="j2eeWebContextRoot" v="EX_ADF-Model-context-root"/> + </hash> + <hash n="oracle.jdevimpl.config.JProjectLibraries"> + <list n="exportedReferences"> + <hash> + <value n="id" v="ADF Model Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="BC4J Oracle Domains"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="BC4J Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="BC4J Security"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime Dependencies"/> + <value n="isJDK" v="false"/> + </hash> + </list> + <hash n="internalDefinitions"> + <list n="libraryDefinitions"/> + </hash> + <list n="libraryReferences"> + <hash> + <value n="id" v="ADF Model Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="BC4J Oracle Domains"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="BC4J Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="BC4J Security"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime Dependencies"/> + <value n="isJDK" v="false"/> + </hash> + </list> + </hash> + <hash n="oracle.jdevimpl.config.JProjectPaths"> + <url n="outputDirectory" path="classes/"/> + </hash> +</jpr:project> diff --git a/examples/sql/adf/EX_ADF/Model/src/dbschema/ForeignKeysCoffees.java b/examples/sql/adf/EX_ADF/Model/src/dbschema/ForeignKeysCoffees.java new file mode 100644 index 00000000..92508208 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/dbschema/ForeignKeysCoffees.java @@ -0,0 +1,90 @@ +/*- + * See the file LICENSE for redistribution information. + * + * Copyright (c) 2013, 2015 Oracle and/or its affiliates. All rights reserved. + * + */ + +import java.sql.*; + +public class ForeignKeysCoffees { + + public static void main(String args[]) { + + String url = "jdbc:sqlite:/path_to_db"; + Connection con; + String createString = "create table COFFEESFK " + + "(COF_NAME varchar(32) NOT NULL, " + "SUP_ID int, " + + "PRICE float, " + "SALES int, " + "TOTAL int, " + + "primary key(COF_NAME), " + + "foreign key(SUP_ID) references SUPPLIERSPK(SUP_ID))"; + Statement stmt; + + try { + Class.forName("SQLite.JDBCDriver"); + } catch(java.lang.ClassNotFoundException e) { + System.err.print("ClassNotFoundException: "); + System.err.println(e.getMessage()); + } + + try { + con = DriverManager.getConnection(url, + "myLogin", "myPassword"); + + stmt = con.createStatement(); + stmt.execute("PRAGMA foreign_keys = ON;"); + stmt.executeUpdate("drop table if exists COFFEESFK"); + stmt.executeUpdate(createString); + + DatabaseMetaData dbmd = con.getMetaData(); + ResultSet rs = dbmd.getImportedKeys(null, null, "COFFEESFK"); + while (rs.next()) { + System.out.println("primary key table name: " + + rs.getString("PKTABLE_NAME")); + System.out.println("primary key column name: " + + rs.getString("PKCOLUMN_NAME")); + System.out.println("foreign key table name: " + + rs.getString("FKTABLE_NAME")); + System.out.println("foreign key column name: " + + rs.getString("FKCOLUMN_NAME")); + } + + stmt.executeUpdate("insert into COFFEESFK " + + "values('Colombian', 00101, 7.99, 0, 0)"); + + stmt.executeUpdate("insert into COFFEESFK " + + "values('French_Roast', 00049, 8.99, 0, 0)"); + + stmt.executeUpdate("insert into COFFEESFK " + + "values('Espresso', 00150, 9.99, 0, 0)"); + + stmt.executeUpdate("insert into COFFEESFK " + + "values('Colombian_Decaf', 00101, 8.99, 0, 0)"); + + stmt.executeUpdate("insert into COFFEESFK " + + "values('French_Roast_Decaf', 00150, 9.99, 0, 0)"); + + rs = stmt.executeQuery("select * from COFFEESFK"); + + System.out.println("select * from COFFEESFK:"); + while (rs.next()) { + String name = rs.getString("COF_NAME"); + int id = rs.getInt("SUP_ID"); + float price = rs.getFloat("PRICE"); + int sales = rs.getInt("Sales"); + int total = rs.getInt("Total"); + System.out.println(name + ", " + id + ", " + + price + ", " + sales + ", " + total); + } + + rs.close(); + stmt.close(); + con.close(); + + } catch(SQLException ex) { + System.err.print("SQLException: "); + System.err.println(ex.getMessage()); + } + } +} + diff --git a/examples/sql/adf/EX_ADF/Model/src/dbschema/PrimaryKeysSuppliers.java b/examples/sql/adf/EX_ADF/Model/src/dbschema/PrimaryKeysSuppliers.java new file mode 100644 index 00000000..069299c3 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/dbschema/PrimaryKeysSuppliers.java @@ -0,0 +1,74 @@ +/*- + * See the file LICENSE for redistribution information. + * + * Copyright (c) 2013, 2015 Oracle and/or its affiliates. All rights reserved. + * + */ + +import java.sql.*; + +public class PrimaryKeysSuppliers { + + public static void main(String args[]) { + + String url = "jdbc:sqlite:/path_to_db"; + Connection con; + String createString = "create table SUPPLIERSPK " + + "(SUP_ID INTEGER NOT NULL, " + "SUP_NAME VARCHAR(40), " + + "STREET VARCHAR(40), " + "CITY VARCHAR(20), " + + "STATE CHAR(2), " + "ZIP CHAR(5), " + + "primary key(SUP_ID))"; + Statement stmt; + + try { + Class.forName("SQLite.JDBCDriver"); + } catch(java.lang.ClassNotFoundException e) { + System.err.print("ClassNotFoundException: "); + System.err.println(e.getMessage()); + } + + try { + con = DriverManager.getConnection(url, + "myLogin", "myPassword"); + + stmt = con.createStatement(); + stmt.executeUpdate("drop table if exists SUPPLIERSPK"); + stmt.executeUpdate(createString); + + stmt.executeUpdate("insert into SUPPLIERSPK " + + "values(49, 'Superior Coffee', '1 Party Place', " + + "'Mendocino', 'CA', '95460')"); + + stmt.executeUpdate("insert into SUPPLIERSPK " + + "values(101, 'Acme, Inc.', '99 Market Street', " + + "'Groundsville', 'CA', '95199')"); + + stmt.executeUpdate("insert into SUPPLIERSPK " + + "values(150, 'The High Ground', '100 Coffee Lane', " + + "'Meadows', 'CA', '93966')"); + + ResultSet rs = stmt.executeQuery("select * from SUPPLIERSPK"); + + System.out.println("select * from SUPPLIERSPK:"); + while (rs.next()) { + int id = rs.getInt("SUP_ID"); + String name = rs.getString("SUP_NAME"); + String street = rs.getString("STREET"); + String city = rs.getString("CITY"); + String state = rs.getString("STATE"); + String zip = rs.getString("ZIP"); + System.out.println(id + ", " + name + ", " + + street + ", " + city + ", " + state + ", " + zip); + } + + rs.close(); + stmt.close(); + con.close(); + + } catch(SQLException ex) { + System.err.print("SQLException: "); + System.err.println(ex.getMessage()); + } + } +} + diff --git a/examples/sql/adf/EX_ADF/Model/src/model/Model.jpx b/examples/sql/adf/EX_ADF/Model/src/model/Model.jpx new file mode 100644 index 00000000..9b0ab3d3 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/model/Model.jpx @@ -0,0 +1,51 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE JboProject SYSTEM "jbo_03_01.dtd"> +<!----> +<JboProject + xmlns="http://xmlns.oracle.com/bc4j" + Name="Model" + Version="11.1.2.64.36" + SeparateXMLFiles="true" + PackageName="model"> + <DesignTime> + <Attr Name="_useAnsiJoinSyntax" Value="true"/> + <Attr Name="_jprName" Value="../../Model.jpr"/> + <Attr Name="_jbo.SQLBuilder" Value="SQL92"/> + <Attr Name="_jbo.TypeMapEntries" Value="Java"/> + <Attr Name="_NamedConnection" Value="BDBConnection"/> + <Attr Name="_appModuleNames0" Value="uimodel.am.AppModule"/> + </DesignTime> + <Containee + Name="association" + PackageName="model.entity.association" + ObjectType="JboPackage"> + <DesignTime> + <Attr Name="_AS" Value="true"/> + </DesignTime> + </Containee> + <Containee + Name="entity" + PackageName="model.entity" + ObjectType="JboPackage"> + <DesignTime> + <Attr Name="_EO" Value="true"/> + </DesignTime> + </Containee> + <Containee + Name="am" + PackageName="uimodel.am" + ObjectType="JboPackage"> + <DesignTime> + <Attr Name="_AM" Value="true"/> + </DesignTime> + </Containee> + <Containee + Name="view" + PackageName="uimodel.view" + ObjectType="JboPackage"> + <DesignTime> + <Attr Name="_VO" Value="true"/> + <Attr Name="_VL" Value="true"/> + </DesignTime> + </Containee> +</JboProject> diff --git a/examples/sql/adf/EX_ADF/Model/src/model/ModelBundle.properties b/examples/sql/adf/EX_ADF/Model/src/model/ModelBundle.properties new file mode 100644 index 00000000..a5910d8c --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/model/ModelBundle.properties @@ -0,0 +1,6 @@ +# +uimodel.view.CoffeesVO_LABEL=Coffees Vo +uimodel.am.AppModule_LABEL=App Module Client +uimodel.view.SuppliersVO_LABEL=Suppliers Vo +uimodel.view.SuppliersVOToCoffeesVOLink_LABEL=Suppliers Vo To Coffees Vo Link +LOV_SupId_LOVUIHints_NullValueId=<No Selection> diff --git a/examples/sql/adf/EX_ADF/Model/src/model/entity/CoffeesEO.xml b/examples/sql/adf/EX_ADF/Model/src/model/entity/CoffeesEO.xml new file mode 100644 index 00000000..fef443b4 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/model/entity/CoffeesEO.xml @@ -0,0 +1,84 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE Entity SYSTEM "jbo_03_01.dtd"> +<!----> +<Entity + xmlns="http://xmlns.oracle.com/bc4j" + Name="CoffeesEO" + Version="11.1.2.64.36" + DBObjectType="TABLE" + DBObjectName="COFFEESFK" + AliasName="CoffeesEO" + BindingStyle="JDBC" + UseGlueCode="false" + RowClass="model.entity.CoffeesEOImpl"> + <DesignTime> + <Attr Name="_codeGenFlag2" Value="Access"/> + <Attr Name="_isCodegen" Value="true"/> + </DesignTime> + <Attribute + Name="CofName" + IsNotNull="true" + ColumnName="COF_NAME" + SQLType="VARCHAR" + Type="java.lang.String" + ColumnType="VARCHAR" + TableName="COFFEESFK" + PrimaryKey="true"/> + <Attribute + Name="SupId" + ColumnName="SUP_ID" + SQLType="INTEGER" + Type="java.lang.Integer" + ColumnType="INTEGER" + TableName="COFFEESFK"/> + <Attribute + Name="Price" + ColumnName="PRICE" + SQLType="FLOAT" + Type="java.lang.Float" + ColumnType="FLOAT" + TableName="COFFEESFK"/> + <Attribute + Name="Sales" + ColumnName="SALES" + SQLType="INTEGER" + Type="java.lang.Integer" + ColumnType="INTEGER" + TableName="COFFEESFK"/> + <Attribute + Name="Total" + ColumnName="TOTAL" + SQLType="INTEGER" + Type="java.lang.Integer" + ColumnType="INTEGER" + TableName="COFFEESFK"/> + <AccessorAttribute + Name="SuppliersEO" + Association="model.entity.association.SuppliersEOToCoffeesEOAssoc" + AssociationEnd="model.entity.association.SuppliersEOToCoffeesEOAssoc.SuppliersEO" + AssociationOtherEnd="model.entity.association.SuppliersEOToCoffeesEOAssoc.CoffeesEO" + Type="model.entity.SuppliersEOImpl" + IsUpdateable="true"/> + <Key + Name="SqliteAutoindexCoffeesfk1" + PrimaryKey="true"> + <DesignTime> + <Attr Name="_DBObjectName" Value="sqlite_autoindex_COFFEESFK_1"/> + </DesignTime> + <AttrArray Name="Attributes"> + <Item Value="model.entity.CoffeesEO.CofName"/> + </AttrArray> + </Key> + <Key + Name="fk_CoffeesEO"> + <DesignTime> + <Attr Name="_referencedKey" Value="SUPPLIERSPK_PK"/> + <Attr Name="_isForeign" Value="true"/> + <Attr Name="_DBObjectName" Value="FK_COFFEES_EO"/> + <Attr Name="_isCascadeDelete" Value="true"/> + </DesignTime> + <AttrArray Name="Attributes"> + <Item Value="model.entity.CoffeesEO.SupId"/> + </AttrArray> + </Key> +</Entity> diff --git a/examples/sql/adf/EX_ADF/Model/src/model/entity/CoffeesEOImpl.java b/examples/sql/adf/EX_ADF/Model/src/model/entity/CoffeesEOImpl.java new file mode 100644 index 00000000..6f84c250 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/model/entity/CoffeesEOImpl.java @@ -0,0 +1,281 @@ +package model.entity; + +import oracle.jbo.Key; +import oracle.jbo.server.AttributeDefImpl; +import oracle.jbo.server.EntityDefImpl; +import oracle.jbo.server.EntityImpl; +// --------------------------------------------------------------------- +// --- File generated by Oracle ADF Business Components Design Time. +// --- Mon Aug 19 12:01:47 CST 2013 +// --- Custom code may be added to this class. +// --- Warning: Do not modify method signatures of generated methods. +// --------------------------------------------------------------------- +public class CoffeesEOImpl extends EntityImpl { + public void lock() { + //super.lock(); + } + + protected StringBuffer buildDMLStatement(int i, AttributeDefImpl[] attributeDefImpl, + AttributeDefImpl[] attributeDefImpl2, + AttributeDefImpl[] attributeDefImpl3, boolean b) { + StringBuffer stmt = super.buildDMLStatement(i, attributeDefImpl, attributeDefImpl2, attributeDefImpl3, b); + if (i == DML_UPDATE) { + // Get the alias name (it is equal to the entity definition name) + String alias = this.getEntityDef().getDefName(); + // Remove the alias from the UPDATE statement + int index = stmt.indexOf( " " + alias + " SET "); + if (index != -1) + stmt = stmt.replace( index, index + alias.length() + 1, ""); + } + return stmt; + } + + /** + * AttributesEnum: generated enum for identifying attributes and accessors. Do not modify. + */ + public enum AttributesEnum { + CofName { + public Object get(CoffeesEOImpl obj) { + return obj.getCofName(); + } + + public void put(CoffeesEOImpl obj, Object value) { + obj.setCofName((String)value); + } + } + , + SupId { + public Object get(CoffeesEOImpl obj) { + return obj.getSupId(); + } + + public void put(CoffeesEOImpl obj, Object value) { + obj.setSupId((Integer)value); + } + } + , + Price { + public Object get(CoffeesEOImpl obj) { + return obj.getPrice(); + } + + public void put(CoffeesEOImpl obj, Object value) { + obj.setPrice((Float)value); + } + } + , + Sales { + public Object get(CoffeesEOImpl obj) { + return obj.getSales(); + } + + public void put(CoffeesEOImpl obj, Object value) { + obj.setSales((Integer)value); + } + } + , + Total { + public Object get(CoffeesEOImpl obj) { + return obj.getTotal(); + } + + public void put(CoffeesEOImpl obj, Object value) { + obj.setTotal((Integer)value); + } + } + , + SuppliersEO { + public Object get(CoffeesEOImpl obj) { + return obj.getSuppliersEO(); + } + + public void put(CoffeesEOImpl obj, Object value) { + obj.setSuppliersEO((SuppliersEOImpl)value); + } + } + ; + private static AttributesEnum[] vals = null; + private static int firstIndex = 0; + + public abstract Object get(CoffeesEOImpl object); + + public abstract void put(CoffeesEOImpl object, Object value); + + public int index() { + return AttributesEnum.firstIndex() + ordinal(); + } + + public static int firstIndex() { + return firstIndex; + } + + public static int count() { + return AttributesEnum.firstIndex() + AttributesEnum.staticValues().length; + } + + public static AttributesEnum[] staticValues() { + if (vals == null) { + vals = AttributesEnum.values(); + } + return vals; + } + } + + + public static final int COFNAME = AttributesEnum.CofName.index(); + public static final int SUPID = AttributesEnum.SupId.index(); + public static final int PRICE = AttributesEnum.Price.index(); + public static final int SALES = AttributesEnum.Sales.index(); + public static final int TOTAL = AttributesEnum.Total.index(); + public static final int SUPPLIERSEO = AttributesEnum.SuppliersEO.index(); + + /** + * This is the default constructor (do not remove). + */ + public CoffeesEOImpl() { + } + + + /** + * @return the definition object for this instance class. + */ + public static synchronized EntityDefImpl getDefinitionObject() { + return EntityDefImpl.findDefObject("model.entity.CoffeesEO"); + } + + /** + * Gets the attribute value for CofName, using the alias name CofName. + * @return the value of CofName + */ + public String getCofName() { + return (String)getAttributeInternal(COFNAME); + } + + /** + * Sets <code>value</code> as the attribute value for CofName. + * @param value value to set the CofName + */ + public void setCofName(String value) { + setAttributeInternal(COFNAME, value); + } + + /** + * Gets the attribute value for SupId, using the alias name SupId. + * @return the value of SupId + */ + public Integer getSupId() { + return (Integer)getAttributeInternal(SUPID); + } + + /** + * Sets <code>value</code> as the attribute value for SupId. + * @param value value to set the SupId + */ + public void setSupId(Integer value) { + setAttributeInternal(SUPID, value); + } + + /** + * Gets the attribute value for Price, using the alias name Price. + * @return the value of Price + */ + public Float getPrice() { + return (Float)getAttributeInternal(PRICE); + } + + /** + * Sets <code>value</code> as the attribute value for Price. + * @param value value to set the Price + */ + public void setPrice(Float value) { + setAttributeInternal(PRICE, value); + } + + /** + * Gets the attribute value for Sales, using the alias name Sales. + * @return the value of Sales + */ + public Integer getSales() { + return (Integer)getAttributeInternal(SALES); + } + + /** + * Sets <code>value</code> as the attribute value for Sales. + * @param value value to set the Sales + */ + public void setSales(Integer value) { + setAttributeInternal(SALES, value); + } + + /** + * Gets the attribute value for Total, using the alias name Total. + * @return the value of Total + */ + public Integer getTotal() { + return (Integer)getAttributeInternal(TOTAL); + } + + /** + * Sets <code>value</code> as the attribute value for Total. + * @param value value to set the Total + */ + public void setTotal(Integer value) { + setAttributeInternal(TOTAL, value); + } + + /** + * getAttrInvokeAccessor: generated method. Do not modify. + * @param index the index identifying the attribute + * @param attrDef the attribute + + * @return the attribute value + * @throws Exception + */ + protected Object getAttrInvokeAccessor(int index, AttributeDefImpl attrDef) throws Exception { + if ((index >= AttributesEnum.firstIndex()) && (index < AttributesEnum.count())) { + return AttributesEnum.staticValues()[index - AttributesEnum.firstIndex()].get(this); + } + return super.getAttrInvokeAccessor(index, attrDef); + } + + /** + * setAttrInvokeAccessor: generated method. Do not modify. + * @param index the index identifying the attribute + * @param value the value to assign to the attribute + * @param attrDef the attribute + + * @throws Exception + */ + protected void setAttrInvokeAccessor(int index, Object value, AttributeDefImpl attrDef) throws Exception { + if ((index >= AttributesEnum.firstIndex()) && (index < AttributesEnum.count())) { + AttributesEnum.staticValues()[index - AttributesEnum.firstIndex()].put(this, value); + return; + } + super.setAttrInvokeAccessor(index, value, attrDef); + } + + /** + * @return the associated entity SuppliersEOImpl. + */ + public SuppliersEOImpl getSuppliersEO() { + return (SuppliersEOImpl)getAttributeInternal(SUPPLIERSEO); + } + + /** + * Sets <code>value</code> as the associated entity SuppliersEOImpl. + */ + public void setSuppliersEO(SuppliersEOImpl value) { + setAttributeInternal(SUPPLIERSEO, value); + } + + /** + * @param cofName key constituent + + * @return a Key object based on given key constituents. + */ + public static Key createPrimaryKey(String cofName) { + return new Key(new Object[]{cofName}); + } + + +} diff --git a/examples/sql/adf/EX_ADF/Model/src/model/entity/SuppliersEO.xml b/examples/sql/adf/EX_ADF/Model/src/model/entity/SuppliersEO.xml new file mode 100644 index 00000000..3ad0b5f9 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/model/entity/SuppliersEO.xml @@ -0,0 +1,79 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE Entity SYSTEM "jbo_03_01.dtd"> +<!----> +<Entity + xmlns="http://xmlns.oracle.com/bc4j" + Name="SuppliersEO" + Version="11.1.2.64.36" + DBObjectType="TABLE" + DBObjectName="SUPPLIERSPK" + AliasName="SuppliersEO" + BindingStyle="JDBC" + UseGlueCode="false" + RowClass="model.entity.SuppliersEOImpl"> + <DesignTime> + <Attr Name="_codeGenFlag2" Value="Access"/> + <Attr Name="_isCodegen" Value="true"/> + </DesignTime> + <Attribute + Name="SupId" + IsNotNull="true" + ColumnName="SUP_ID" + SQLType="INTEGER" + Type="java.lang.Integer" + ColumnType="INTEGER" + TableName="SUPPLIERSPK" + PrimaryKey="true"/> + <Attribute + Name="SupName" + ColumnName="SUP_NAME" + SQLType="VARCHAR" + Type="java.lang.String" + ColumnType="VARCHAR" + TableName="SUPPLIERSPK"/> + <Attribute + Name="Street" + ColumnName="STREET" + SQLType="VARCHAR" + Type="java.lang.String" + ColumnType="VARCHAR" + TableName="SUPPLIERSPK"/> + <Attribute + Name="City" + ColumnName="CITY" + SQLType="VARCHAR" + Type="java.lang.String" + ColumnType="VARCHAR" + TableName="SUPPLIERSPK"/> + <Attribute + Name="State" + ColumnName="STATE" + SQLType="VARCHAR" + Type="java.lang.String" + ColumnType="VARCHAR" + TableName="SUPPLIERSPK"/> + <Attribute + Name="Zip" + ColumnName="ZIP" + SQLType="VARCHAR" + Type="java.lang.String" + ColumnType="VARCHAR" + TableName="SUPPLIERSPK"/> + <AccessorAttribute + Name="CoffeesEO" + Association="model.entity.association.SuppliersEOToCoffeesEOAssoc" + AssociationEnd="model.entity.association.SuppliersEOToCoffeesEOAssoc.CoffeesEO" + AssociationOtherEnd="model.entity.association.SuppliersEOToCoffeesEOAssoc.SuppliersEO" + Type="oracle.jbo.RowIterator" + IsUpdateable="false"/> + <Key + Name="SupplierspkPk" + PrimaryKey="true"> + <DesignTime> + <Attr Name="_DBObjectName" Value="SUPPLIERSPK_PK"/> + </DesignTime> + <AttrArray Name="Attributes"> + <Item Value="model.entity.SuppliersEO.SupId"/> + </AttrArray> + </Key> +</Entity> diff --git a/examples/sql/adf/EX_ADF/Model/src/model/entity/SuppliersEOImpl.java b/examples/sql/adf/EX_ADF/Model/src/model/entity/SuppliersEOImpl.java new file mode 100644 index 00000000..92449faa --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/model/entity/SuppliersEOImpl.java @@ -0,0 +1,302 @@ +package model.entity; + +import oracle.jbo.Key; +import oracle.jbo.RowIterator; +import oracle.jbo.server.AttributeDefImpl; +import oracle.jbo.server.EntityDefImpl; +import oracle.jbo.server.EntityImpl; +// --------------------------------------------------------------------- +// --- File generated by Oracle ADF Business Components Design Time. +// --- Mon Aug 19 12:03:06 CST 2013 +// --- Custom code may be added to this class. +// --- Warning: Do not modify method signatures of generated methods. +// --------------------------------------------------------------------- +public class SuppliersEOImpl extends EntityImpl { + public void lock() { + //super.lock(); + } + + protected StringBuffer buildDMLStatement(int i, AttributeDefImpl[] attributeDefImpl, + AttributeDefImpl[] attributeDefImpl2, + AttributeDefImpl[] attributeDefImpl3, boolean b) { + StringBuffer stmt = super.buildDMLStatement(i, attributeDefImpl, attributeDefImpl2, attributeDefImpl3, b); + if (i == DML_UPDATE) { + // Get the alias name (it is equal to the entity definition name) + String alias = this.getEntityDef().getDefName(); + // Remove the alias from the UPDATE statement + int index = stmt.indexOf( " " + alias + " SET "); + if (index != -1) + stmt = stmt.replace( index, index + alias.length() + 1, ""); + } + return stmt; + } + + /** + * AttributesEnum: generated enum for identifying attributes and accessors. Do not modify. + */ + public enum AttributesEnum { + SupId { + public Object get(SuppliersEOImpl obj) { + return obj.getSupId(); + } + + public void put(SuppliersEOImpl obj, Object value) { + obj.setSupId((Integer)value); + } + } + , + SupName { + public Object get(SuppliersEOImpl obj) { + return obj.getSupName(); + } + + public void put(SuppliersEOImpl obj, Object value) { + obj.setSupName((String)value); + } + } + , + Street { + public Object get(SuppliersEOImpl obj) { + return obj.getStreet(); + } + + public void put(SuppliersEOImpl obj, Object value) { + obj.setStreet((String)value); + } + } + , + City { + public Object get(SuppliersEOImpl obj) { + return obj.getCity(); + } + + public void put(SuppliersEOImpl obj, Object value) { + obj.setCity((String)value); + } + } + , + State { + public Object get(SuppliersEOImpl obj) { + return obj.getState(); + } + + public void put(SuppliersEOImpl obj, Object value) { + obj.setState((String)value); + } + } + , + Zip { + public Object get(SuppliersEOImpl obj) { + return obj.getZip(); + } + + public void put(SuppliersEOImpl obj, Object value) { + obj.setZip((String)value); + } + } + , + CoffeesEO { + public Object get(SuppliersEOImpl obj) { + return obj.getCoffeesEO(); + } + + public void put(SuppliersEOImpl obj, Object value) { + obj.setAttributeInternal(index(), value); + } + } + ; + private static AttributesEnum[] vals = null; + private static int firstIndex = 0; + + public abstract Object get(SuppliersEOImpl object); + + public abstract void put(SuppliersEOImpl object, Object value); + + public int index() { + return AttributesEnum.firstIndex() + ordinal(); + } + + public static int firstIndex() { + return firstIndex; + } + + public static int count() { + return AttributesEnum.firstIndex() + AttributesEnum.staticValues().length; + } + + public static AttributesEnum[] staticValues() { + if (vals == null) { + vals = AttributesEnum.values(); + } + return vals; + } + } + + + public static final int SUPID = AttributesEnum.SupId.index(); + public static final int SUPNAME = AttributesEnum.SupName.index(); + public static final int STREET = AttributesEnum.Street.index(); + public static final int CITY = AttributesEnum.City.index(); + public static final int STATE = AttributesEnum.State.index(); + public static final int ZIP = AttributesEnum.Zip.index(); + public static final int COFFEESEO = AttributesEnum.CoffeesEO.index(); + + /** + * This is the default constructor (do not remove). + */ + public SuppliersEOImpl() { + } + + + /** + * @return the definition object for this instance class. + */ + public static synchronized EntityDefImpl getDefinitionObject() { + return EntityDefImpl.findDefObject("model.entity.SuppliersEO"); + } + + /** + * Gets the attribute value for SupId, using the alias name SupId. + * @return the value of SupId + */ + public Integer getSupId() { + return (Integer)getAttributeInternal(SUPID); + } + + /** + * Sets <code>value</code> as the attribute value for SupId. + * @param value value to set the SupId + */ + public void setSupId(Integer value) { + setAttributeInternal(SUPID, value); + } + + /** + * Gets the attribute value for SupName, using the alias name SupName. + * @return the value of SupName + */ + public String getSupName() { + return (String)getAttributeInternal(SUPNAME); + } + + /** + * Sets <code>value</code> as the attribute value for SupName. + * @param value value to set the SupName + */ + public void setSupName(String value) { + setAttributeInternal(SUPNAME, value); + } + + /** + * Gets the attribute value for Street, using the alias name Street. + * @return the value of Street + */ + public String getStreet() { + return (String)getAttributeInternal(STREET); + } + + /** + * Sets <code>value</code> as the attribute value for Street. + * @param value value to set the Street + */ + public void setStreet(String value) { + setAttributeInternal(STREET, value); + } + + /** + * Gets the attribute value for City, using the alias name City. + * @return the value of City + */ + public String getCity() { + return (String)getAttributeInternal(CITY); + } + + /** + * Sets <code>value</code> as the attribute value for City. + * @param value value to set the City + */ + public void setCity(String value) { + setAttributeInternal(CITY, value); + } + + /** + * Gets the attribute value for State, using the alias name State. + * @return the value of State + */ + public String getState() { + return (String)getAttributeInternal(STATE); + } + + /** + * Sets <code>value</code> as the attribute value for State. + * @param value value to set the State + */ + public void setState(String value) { + setAttributeInternal(STATE, value); + } + + /** + * Gets the attribute value for Zip, using the alias name Zip. + * @return the value of Zip + */ + public String getZip() { + return (String)getAttributeInternal(ZIP); + } + + /** + * Sets <code>value</code> as the attribute value for Zip. + * @param value value to set the Zip + */ + public void setZip(String value) { + setAttributeInternal(ZIP, value); + } + + /** + * getAttrInvokeAccessor: generated method. Do not modify. + * @param index the index identifying the attribute + * @param attrDef the attribute + + * @return the attribute value + * @throws Exception + */ + protected Object getAttrInvokeAccessor(int index, AttributeDefImpl attrDef) throws Exception { + if ((index >= AttributesEnum.firstIndex()) && (index < AttributesEnum.count())) { + return AttributesEnum.staticValues()[index - AttributesEnum.firstIndex()].get(this); + } + return super.getAttrInvokeAccessor(index, attrDef); + } + + /** + * setAttrInvokeAccessor: generated method. Do not modify. + * @param index the index identifying the attribute + * @param value the value to assign to the attribute + * @param attrDef the attribute + + * @throws Exception + */ + protected void setAttrInvokeAccessor(int index, Object value, AttributeDefImpl attrDef) throws Exception { + if ((index >= AttributesEnum.firstIndex()) && (index < AttributesEnum.count())) { + AttributesEnum.staticValues()[index - AttributesEnum.firstIndex()].put(this, value); + return; + } + super.setAttrInvokeAccessor(index, value, attrDef); + } + + /** + * @return the associated entity oracle.jbo.RowIterator. + */ + public RowIterator getCoffeesEO() { + return (RowIterator)getAttributeInternal(COFFEESEO); + } + + /** + * @param supId key constituent + + * @return a Key object based on given key constituents. + */ + public static Key createPrimaryKey(Integer supId) { + return new Key(new Object[]{supId}); + } + + +} diff --git a/examples/sql/adf/EX_ADF/Model/src/model/entity/association/SuppliersEOToCoffeesEOAssoc.xml b/examples/sql/adf/EX_ADF/Model/src/model/entity/association/SuppliersEOToCoffeesEOAssoc.xml new file mode 100644 index 00000000..19550461 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/model/entity/association/SuppliersEOToCoffeesEOAssoc.xml @@ -0,0 +1,45 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE Association SYSTEM "jbo_03_01.dtd"> +<!----> +<Association + xmlns="http://xmlns.oracle.com/bc4j" + Name="SuppliersEOToCoffeesEOAssoc" + Version="11.1.2.64.36"> + <DesignTime> + <Attr Name="_isCodegen" Value="true"/> + </DesignTime> + <AssociationEnd + Name="SuppliersEO" + Cardinality="1" + Source="true" + Owner="model.entity.SuppliersEO" + CascadeDelete="true" + DeleteContainee="true" + CascadeUpdate="true"> + <DesignTime> + <Attr Name="_aggregation" Value="0"/> + <Attr Name="_finderName" Value="SuppliersEO"/> + <Attr Name="_foreignKey" Value="model.entity.SuppliersEO.SupplierspkPk"/> + <Attr Name="_isUpdateable" Value="true"/> + <Attr Name="_minCardinality" Value="1"/> + </DesignTime> + <AttrArray Name="Attributes"> + <Item Value="model.entity.SuppliersEO.SupId"/> + </AttrArray> + </AssociationEnd> + <AssociationEnd + Name="CoffeesEO" + Cardinality="-1" + Owner="model.entity.CoffeesEO" + HasOwner="true"> + <DesignTime> + <Attr Name="_aggregation" Value="0"/> + <Attr Name="_finderName" Value="CoffeesEO"/> + <Attr Name="_foreignKey" Value="model.entity.CoffeesEO.fk_CoffeesEO"/> + <Attr Name="_isUpdateable" Value="true"/> + </DesignTime> + <AttrArray Name="Attributes"> + <Item Value="model.entity.CoffeesEO.SupId"/> + </AttrArray> + </AssociationEnd> +</Association> diff --git a/examples/sql/adf/EX_ADF/Model/src/uimodel/am/AppModule.xml b/examples/sql/adf/EX_ADF/Model/src/uimodel/am/AppModule.xml new file mode 100644 index 00000000..de3eb6b9 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/uimodel/am/AppModule.xml @@ -0,0 +1,34 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE AppModule SYSTEM "jbo_03_01.dtd"> +<!----> +<AppModule + xmlns="http://xmlns.oracle.com/bc4j" + Name="AppModule" + Version="11.1.2.64.36" + ClearCacheOnRollback="true"> + <Properties> + <SchemaBasedProperties> + <LABEL + ResId="uimodel.am.AppModule_LABEL"/> + </SchemaBasedProperties> + </Properties> + <ViewUsage + Name="Coffees" + ViewObjectName="uimodel.view.CoffeesVO"/> + <ViewUsage + Name="Suppliers" + ViewObjectName="uimodel.view.SuppliersVO"/> + <ViewUsage + Name="CoffeesForSuppliers" + ViewObjectName="uimodel.view.CoffeesVO"/> + <ViewLinkUsage + Name="SuppliersVOToCoffeesVOLink1" + ViewLinkObjectName="uimodel.view.SuppliersVOToCoffeesVOLink" + SrcViewUsageName="uimodel.am.AppModule.Suppliers" + DstViewUsageName="uimodel.am.AppModule.CoffeesForSuppliers" + Reversed="false"/> + <ResourceBundle> + <PropertiesBundle + PropertiesFile="model.ModelBundle"/> + </ResourceBundle> +</AppModule> diff --git a/examples/sql/adf/EX_ADF/Model/src/uimodel/am/TestClient.java b/examples/sql/adf/EX_ADF/Model/src/uimodel/am/TestClient.java new file mode 100644 index 00000000..dc8df900 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/uimodel/am/TestClient.java @@ -0,0 +1,179 @@ +/*- + * See the file LICENSE for redistribution information. + * + * Copyright (c) 2013, 2015 Oracle and/or its affiliates. All rights reserved. + * + */ + +package uimodel.am; + +import oracle.jbo.ApplicationModule; +import oracle.jbo.Key; +import oracle.jbo.Row; +import oracle.jbo.RowMatch; +import oracle.jbo.ViewCriteria; +import oracle.jbo.ViewCriteriaRow; +import oracle.jbo.ViewObject; +import oracle.jbo.client.Configuration; + +public class TestClient { + public static void main(String[] args) { + + String amDef = "uimodel.am.AppModule"; + String config = "AppModuleLocal"; + ApplicationModule am = + Configuration.createRootApplicationModule(amDef, config); + + ViewObject cofVO = am.findViewObject("Coffees"); + ViewObject supVO = am.findViewObject("Suppliers"); + cofVO.executeQuery(); + supVO.executeQuery(); + showRows(cofVO, "Initial database results - Coffees"); + showRows(supVO, "Initial database results - Suppliers"); + + // Test sorting rows. + System.out.println("\n=== " + " Test sorting rows " + " ===\n"); + cofVO.setSortBy("Price desc"); + cofVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_VIEW_ROWS); + cofVO.executeQuery(); + showRows(cofVO, "Sorting Coffees by Price desc"); + + supVO.setSortBy("Zip asc"); + supVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_VIEW_ROWS); + supVO.executeQuery(); + showRows(supVO, "Sorting Suppliers by Zip asc"); + System.out.println("\n=== " + " End " + " ===\n"); + + // Test matching rows. + System.out.println("\n=== " + " Test matching rows " + " ===\n"); + cofVO.setSortBy(""); + supVO.setSortBy(""); + + RowMatch rm = new RowMatch("CofName like 'C%'"); + cofVO.setRowMatch(rm); + cofVO.executeQuery(); + showRows(cofVO, "Coffee Name begins with 'C'"); + + rm = new RowMatch("Zip like '95%'"); + supVO.setRowMatch(rm); + supVO.executeQuery(); + showRows(supVO, "Supplier Zip begins with '95'"); + System.out.println("\n=== " + " End " + " ===\n"); + + // Test filtering rows by view criteria. + System.out.println("\n=== " + + " Test filtering rows by view criteria " + " ===\n"); + cofVO.setRowMatch(null); + + ViewCriteria vc = cofVO.createViewCriteria(); + ViewCriteriaRow vcr = vc.createViewCriteriaRow(); + vcr.setAttribute("SupId", "= 150"); + vc.add(vcr); + cofVO.applyViewCriteria(vc); + vc.setCriteriaMode(ViewCriteria.CRITERIA_MODE_CACHE); + cofVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_ENTITY_ROWS); + cofVO.executeQuery(); + showRows(cofVO, "Supplier ID = 150"); + System.out.println("\n=== " + " End " + " ===\n"); + + // Test inserting a row with the foreign key. + System.out.println("\n=== " + + " Test insert with a foreign key " + " ===\n"); + cofVO.applyViewCriteria(null); + + cofVO.setSortBy("SupId"); + cofVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_VIEW_ROWS); + cofVO.executeQuery(); + showRows(cofVO, "Before insert and clear cache, query over VO cache"); + cofVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_ENTITY_ROWS); + cofVO.executeQuery(); + showRows(cofVO, "Before insert and clear cache, query over EO cache"); + + cofVO.setAssociationConsistent(true); + Row newCof = cofVO.createRow(); + newCof.setAttribute("CofName", "Java_Chips_Mocha"); + newCof.setAttribute("Price", "5.99"); + newCof.setAttribute("Sales", "5"); + newCof.setAttribute("Total", "9"); + try { + newCof.setAttribute("SupId", "10"); + System.out.println("Setting an invalid foreign key should fail."); + return; + } catch (Exception e) { + } + newCof.setAttribute("SupId", "101"); + cofVO.insertRow(newCof); + cofVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_VIEW_ROWS); + cofVO.clearCache(); + showRows(cofVO, "After insert and clear cache, query over VO cache"); + + cofVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_ENTITY_ROWS); + cofVO.executeQuery(); + showRows(cofVO, "After insert and clear cache, query over EO cache"); + System.out.println("\n=== " + " End " + " ===\n"); + + // Test updating a row. + System.out.println("\n=== " + " Test updating a row " + " ===\n"); + showRows(cofVO, "Before update"); + + newCof.setAttribute("Price", "15.99"); + cofVO.clearCache(); + showRows(cofVO, "After update"); + System.out.println("\n=== " + " End " + " ===\n"); + + // Test deleting a row in SUPPLIERSPK and all rows referencing + // the same SupId in COFFEESFK will be deleted automactially. + System.out.println("\n=== " + " Test deleting rows " + " ===\n"); + supVO.setRowMatch(null); + supVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_ENTITY_ROWS); + supVO.executeQuery(); + showRows(supVO, "Before delete in SUPPLIERS - Suppliers"); + showRows(cofVO, "Before delete in SUPPLIERS - Coffees"); + + supVO.setAssociationConsistent(true); + Object[] keyValues = new Object[6]; + keyValues[0] = new Integer(49); + for (int i = 1; i < keyValues.length; i++) + keyValues[i] = null; + Row[] rows = supVO.findByKey(new Key(keyValues), 1); + rows[0].remove(); + supVO.setQueryMode(ViewObject.QUERY_MODE_SCAN_ENTITY_ROWS); + supVO.executeQuery(); + showRows(supVO, "After delete in SUPPLIERS - Suppliers"); + showRows(cofVO, "After delete in SUPPLIERS - Coffees"); + System.out.println("\n=== " + " End " + " ===\n"); + + Configuration.releaseRootApplicationModule(am, true); + } + + private static void showRows(ViewObject vo, String msg) { + System.out.println("\n--- " + msg + " ---\n"); + boolean prtCof = false; + if (vo.getFullName().contains("Coffees") == true) + prtCof = true; + String prtStr; + vo.reset(); + while (vo.hasNext()) { + Row r = vo.next(); + if (prtCof == true) { + String name = (String)r.getAttribute("CofName"); + Integer id = (Integer)r.getAttribute("SupId"); + Float price = (Float)r.getAttribute("Price"); + Integer sales = (Integer)r.getAttribute("Sales"); + Integer total = (Integer)r.getAttribute("Total"); + prtStr = name + ", " + id + ", " + + price + ", " + sales + ", " + total; + } else { + Integer id = (Integer)r.getAttribute("SupId"); + String name = (String)r.getAttribute("SupName"); + String street = (String)r.getAttribute("Street"); + String city = (String)r.getAttribute("City"); + String state = (String)r.getAttribute("State"); + String zip = (String)r.getAttribute("Zip"); + prtStr = id + ", " + name + ", " + + street + ", " + city + ", " + state + ", " + zip; + } + System.out.println(prtStr); + } + } +} diff --git a/examples/sql/adf/EX_ADF/Model/src/uimodel/am/common/bc4j.xcfg b/examples/sql/adf/EX_ADF/Model/src/uimodel/am/common/bc4j.xcfg new file mode 100644 index 00000000..0a352109 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/uimodel/am/common/bc4j.xcfg @@ -0,0 +1,15 @@ +<?xml version = '1.0' encoding = 'UTF-8'?> +<BC4JConfig version="11.1" xmlns="http://xmlns.oracle.com/bc4j/configuration"> + <AppModuleConfigBag ApplicationName="uimodel.am.AppModule"> + <AppModuleConfig name="AppModuleShared" jbo.project="model.Model" DeployPlatform="LOCAL" ApplicationName="uimodel.am.AppModule"> + <AM-Pooling jbo.ampool.maxpoolsize="1" jbo.ampool.dynamicjdbccredentials="false" jbo.ampool.isuseexclusive="false" jbo.ampool.resetnontransactionalstate="false"/> + <Database jbo.locking.mode="optimistic" jbo.TypeMapEntries="Java" jbo.sql92.JdbcDriverClass="SQLite.JDBCDriver" jbo.SQLBuilder="SQL92"/> + <Security AppModuleJndiName="uimodel.am.AppModule"/> + <Custom JDBCDataSource="java:comp/env/jdbc/BDBConnectionDS"/> + </AppModuleConfig> + <AppModuleConfig name="AppModuleLocal" DeployPlatform="LOCAL" JDBCName="BDBConnection" jbo.project="model.Model" ApplicationName="uimodel.am.AppModule"> + <Database jbo.sql92.JdbcDriverClass="SQLite.JDBCDriver" jbo.TypeMapEntries="Java" jbo.locking.mode="optimistic" jbo.SQLBuilder="SQL92"/> + <Security AppModuleJndiName="uimodel.am.AppModule"/> + </AppModuleConfig> + </AppModuleConfigBag> +</BC4JConfig> diff --git a/examples/sql/adf/EX_ADF/Model/src/uimodel/view/CoffeesVO.xml b/examples/sql/adf/EX_ADF/Model/src/uimodel/view/CoffeesVO.xml new file mode 100644 index 00000000..b25195b2 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/uimodel/view/CoffeesVO.xml @@ -0,0 +1,94 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE ViewObject SYSTEM "jbo_03_01.dtd"> +<!----> +<ViewObject + xmlns="http://xmlns.oracle.com/bc4j" + Name="CoffeesVO" + Version="11.1.2.64.36" + SelectList="CoffeesEO.COF_NAME, + CoffeesEO.SUP_ID, + CoffeesEO.PRICE, + CoffeesEO.SALES, + CoffeesEO.TOTAL" + FromList="COFFEESFK CoffeesEO" + BindingStyle="JDBC" + CustomQuery="false" + PageIterMode="Full" + UseGlueCode="false"> + <Properties> + <SchemaBasedProperties> + <LABEL + ResId="uimodel.view.CoffeesVO_LABEL"/> + </SchemaBasedProperties> + </Properties> + <ViewAccessor + Name="SuppliersVOAccessor" + ViewObjectName="uimodel.view.SuppliersVO" + RowLevelBinds="true"/> + <ListBinding + Name="LOV_SupId" + ListVOName="SuppliersVOAccessor" + ListRangeSize="-1" + NullValueFlag="start" + NullValueId="LOV_SupId_LOVUIHints_NullValueId" + MRUCount="0"> + <AttrArray Name="AttrNames"> + <Item Value="SupId"/> + </AttrArray> + <AttrArray Name="ListAttrNames"> + <Item Value="SupId"/> + </AttrArray> + <AttrArray Name="ListDisplayAttrNames"> + <Item Value="SupId"/> + </AttrArray> + <DisplayCriteria/> + </ListBinding> + <EntityUsage + Name="CoffeesEO" + Entity="model.entity.CoffeesEO"/> + <ViewAttribute + Name="CofName" + IsNotNull="true" + PrecisionRule="true" + EntityAttrName="CofName" + EntityUsage="CoffeesEO" + AliasName="COF_NAME"/> + <ViewAttribute + Name="SupId" + PrecisionRule="true" + EntityAttrName="SupId" + EntityUsage="CoffeesEO" + AliasName="SUP_ID" + LOVName="LOV_SupId" + DefaultValue="49"> + <RecalcCondition><![CDATA[true]]></RecalcCondition> + <Properties> + <SchemaBasedProperties> + <CONTROLTYPE + Value="choice"/> + </SchemaBasedProperties> + </Properties> + </ViewAttribute> + <ViewAttribute + Name="Price" + PrecisionRule="true" + EntityAttrName="Price" + EntityUsage="CoffeesEO" + AliasName="PRICE"/> + <ViewAttribute + Name="Sales" + PrecisionRule="true" + EntityAttrName="Sales" + EntityUsage="CoffeesEO" + AliasName="SALES"/> + <ViewAttribute + Name="Total" + PrecisionRule="true" + EntityAttrName="Total" + EntityUsage="CoffeesEO" + AliasName="TOTAL"/> + <ResourceBundle> + <PropertiesBundle + PropertiesFile="model.ModelBundle"/> + </ResourceBundle> +</ViewObject> diff --git a/examples/sql/adf/EX_ADF/Model/src/uimodel/view/SuppliersVO.xml b/examples/sql/adf/EX_ADF/Model/src/uimodel/view/SuppliersVO.xml new file mode 100644 index 00000000..68a383c6 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/uimodel/view/SuppliersVO.xml @@ -0,0 +1,74 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE ViewObject SYSTEM "jbo_03_01.dtd"> +<!----> +<ViewObject + xmlns="http://xmlns.oracle.com/bc4j" + Name="SuppliersVO" + Version="11.1.2.64.36" + SelectList="SuppliersEO.SUP_ID, + SuppliersEO.SUP_NAME, + SuppliersEO.STREET, + SuppliersEO.CITY, + SuppliersEO.STATE, + SuppliersEO.ZIP" + FromList="SUPPLIERSPK SuppliersEO" + BindingStyle="JDBC" + CustomQuery="false" + PageIterMode="Full" + UseGlueCode="false"> + <Properties> + <SchemaBasedProperties> + <LABEL + ResId="uimodel.view.SuppliersVO_LABEL"/> + </SchemaBasedProperties> + </Properties> + <EntityUsage + Name="SuppliersEO" + Entity="model.entity.SuppliersEO"/> + <ViewAttribute + Name="SupId" + IsNotNull="true" + PrecisionRule="true" + EntityAttrName="SupId" + EntityUsage="SuppliersEO" + AliasName="SUP_ID"/> + <ViewAttribute + Name="SupName" + PrecisionRule="true" + EntityAttrName="SupName" + EntityUsage="SuppliersEO" + AliasName="SUP_NAME"/> + <ViewAttribute + Name="Street" + PrecisionRule="true" + EntityAttrName="Street" + EntityUsage="SuppliersEO" + AliasName="STREET"/> + <ViewAttribute + Name="City" + PrecisionRule="true" + EntityAttrName="City" + EntityUsage="SuppliersEO" + AliasName="CITY"/> + <ViewAttribute + Name="State" + PrecisionRule="true" + EntityAttrName="State" + EntityUsage="SuppliersEO" + AliasName="STATE"/> + <ViewAttribute + Name="Zip" + PrecisionRule="true" + EntityAttrName="Zip" + EntityUsage="SuppliersEO" + AliasName="ZIP"/> + <ViewLinkAccessor + Name="CoffeesVO" + ViewLink="uimodel.view.SuppliersVOToCoffeesVOLink" + Type="oracle.jbo.RowIterator" + IsUpdateable="false"/> + <ResourceBundle> + <PropertiesBundle + PropertiesFile="model.ModelBundle"/> + </ResourceBundle> +</ViewObject> diff --git a/examples/sql/adf/EX_ADF/Model/src/uimodel/view/SuppliersVOToCoffeesVOLink.xml b/examples/sql/adf/EX_ADF/Model/src/uimodel/view/SuppliersVOToCoffeesVOLink.xml new file mode 100644 index 00000000..f4907aa7 --- /dev/null +++ b/examples/sql/adf/EX_ADF/Model/src/uimodel/view/SuppliersVOToCoffeesVOLink.xml @@ -0,0 +1,44 @@ +<?xml version="1.0" encoding="GBK" ?> +<!DOCTYPE ViewLink SYSTEM "jbo_03_01.dtd"> +<!----> +<ViewLink + xmlns="http://xmlns.oracle.com/bc4j" + Name="SuppliersVOToCoffeesVOLink" + Version="11.1.2.64.36"> + <Properties> + <SchemaBasedProperties> + <LABEL + ResId="uimodel.view.SuppliersVOToCoffeesVOLink_LABEL"/> + </SchemaBasedProperties> + </Properties> + <ViewLinkDefEnd + Name="SuppliersVO" + Cardinality="1" + Source="true" + Owner="uimodel.view.SuppliersVO"> + <DesignTime> + <Attr Name="_finderName" Value="SuppliersVO"/> + <Attr Name="_isUpdateable" Value="true"/> + <Attr Name="_minCardinality" Value="1"/> + </DesignTime> + <AttrArray Name="Attributes"> + <Item Value="uimodel.view.SuppliersVO.SupId"/> + </AttrArray> + </ViewLinkDefEnd> + <ViewLinkDefEnd + Name="CoffeesVO" + Cardinality="-1" + Owner="uimodel.view.CoffeesVO"> + <DesignTime> + <Attr Name="_finderName" Value="CoffeesVO"/> + <Attr Name="_isUpdateable" Value="true"/> + </DesignTime> + <AttrArray Name="Attributes"> + <Item Value="uimodel.view.CoffeesVO.SupId"/> + </AttrArray> + </ViewLinkDefEnd> + <ResourceBundle> + <PropertiesBundle + PropertiesFile="model.ModelBundle"/> + </ResourceBundle> +</ViewLink> diff --git a/examples/sql/adf/EX_ADF/ViewController/ViewController.jpr b/examples/sql/adf/EX_ADF/ViewController/ViewController.jpr new file mode 100644 index 00000000..e058e18b --- /dev/null +++ b/examples/sql/adf/EX_ADF/ViewController/ViewController.jpr @@ -0,0 +1,472 @@ +<?xml version = '1.0' encoding = 'UTF-8'?> +<jpr:project xmlns:jpr="http://xmlns.oracle.com/ide/project"> + <hash n="component-versions"> + <value n="oracle.adfdt.controller.adfc.source.migration.AdfControllerSchemaMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdt.controller.common.migrator.ProjectMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdt.controller.migrate.TrinidadDatabindingsProjectMigrator" v="11.1.2.0.0"/> + <value n="oracle.adfdtinternal.dvt.datapresdt.migration.DVTDataMapMigrator" v="11.1.1.1.0.3"/> + <value n="oracle.adfdtinternal.model.ide.migration.ProjectMigrator" v="11.1.1.1.0.11.1.1"/> + <value n="oracle.adfdtinternal.model.ide.security.wizard.FormPageMigrator" v="11.1.1.0.0"/> + <value n="oracle.adfdtinternal.model.ide.security.wizard.JpsFilterMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdtinternal.model.ide.xmled.migration.ADFNodeMigrator" v="11.1.1.1.0.5"/> + <value n="oracle.adfdtinternal.model.ide.xmled.migration.PageDefinitionParameterValueMigrator" v="11.1.1.1.0.5"/> + <value n="oracle.adfdtinternal.model.ide.xmled.migration.WebXmlMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdtinternal.view.common.migration.wizards.MigrationHelper" v="11.1.1.1.0.3"/> + <value n="oracle.adfdtinternal.view.rich.binding.migration.JarResourceMigrator" v="11.1.1.1.0"/> + <value n="oracle.adfdtinternal.view.rich.migration.ComponentIdNodeMigratorHelper" v="11.1.1.1.0.01"/> + <value n="oracle.adfdtinternal.view.rich.migration.LibraryVersionMigrator" v="11.1.1.1.0.1"/> + <value n="oracle.ide.model.Project" v="11.1.2.0.0"/> + <value n="oracle.ide.model.ResourcePathsMigrator" v="11.1.1.1.0"/> + <value n="oracle.ideimpl.model.TechnologyScopeUpdateMigrator" v="11.1.2.0.0.4"/> + <value n="oracle.jbo.dt.jdevx.deployment.JbdProjectMigrator" v="11.1.2.0.0"/> + <value n="oracle.jbo.dt.jdevx.ui.appnav.APProjectMigrator" v="11.1.1.0.1.5"/> + <value n="oracle.jbo.dt.migrate.ResourceBundlePathMigrator" v="11.1.1.0.1.5"/> + <value n="oracle.jbo.dt.migration.ServiceInterfaceMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdeveloper.library.ProjectLibraryMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdeveloper.model.OutputDirectoryMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.deploy.DeploymentProfilesMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.deploy.jps.JpsDataMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.jsp.JspMigrator" v="11.1.1"/> + <value n="oracle.jdevimpl.offlinedb.migration.OfflineDBProjectMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.offlinedb.migration.OfflinePlSqlMigrator" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.resourcebundle.XliffAddin$XliffMigratorHelper" v="11.1.1.1.0"/> + <value n="oracle.jdevimpl.webapp.jsp.libraries.JspLibraryMigrator" v="11.1.1.1.4"/> + <value n="oracle.jdevimpl.webapp.WebAppContentSetNodeMigratorHelper" v="11.1.1"/> + <value n="oracle.jdevimpl.webapp.WebAppProjectNodeMigratorHelper" v="11.1.2.0.0"/> + <value n="oracle.jdevimpl.webservices.rest.migration.RestPathMigrator" v="11.1.2.0.0"/> + <value n="oracle.jdevimpl.xml.wl.WeblogicMigratorHelper" v="11.1.1.1.0"/> + <value n="oracle.modeler.bmmigrate.management.Migration" v="11.1.1.1.0"/> + <value n="oracle.toplink.workbench.addin.migration.PersistenceProjectMigrator" v="11.1.1.1.0"/> + <value n="oracle.toplink.workbench.addin.migration.TopLinkProjectMigrator" v="11.1.1.1.0"/> + </hash> + <list n="contentSets"> + <string v="oracle.jdeveloper.model.J2eeSettings/webContentSet"/> + <string v="oracle.mds.internal.dt.ide.MDSLibraryCustCSProvider/mdsContentSet"/> + <string v="oracle.mds.internal.dt.ide.MDSADFLibVirtualNodeCSProvider/mdsLibVirtualNodeContentSet"/> + <string v="oracle.jdeveloper.model.PathsConfiguration/javaContentSet"/> + <string v="oracle.ide.model.ResourcePaths/resourcesContentSet"/> + <string v="oracle.jdeveloper.offlinedb.model.OfflineDBProjectSettings/offlineDBContentSet"/> + <string v="oracle.bm.commonIde.data.project.ModelerProjectSettings/modelersContentSet"/> + <string v="oracle.adfdtinternal.model.ide.settings.ADFMSettings/adfmContentSet"/> + <string v="oracle.toplink.workbench.addin/toplinkContentSet"/> + </list> + <value n="defaultPackage" v="view"/> + <hash n="oracle.ide.model.DependencyConfiguration"> + <list n="dependencyList"> + <hash> + <hash n="dependable"> + <url n="sourceOwnerURL" path="../EX_ADF.jws"/> + <url n="sourceURL" path="../Model/Model.jpr"/> + </hash> + <value n="recognizerId" v="oracle.jdeveloper.library"/> + </hash> + </list> + </hash> + <hash n="oracle.ide.model.TechnologyScopeConfiguration"> + <list n="technologyScope"> + <string v="ADF_FACES"/> + <string v="ADFc"/> + <string v="HTML"/> + <string v="JAVASCRIPT"/> + <string v="JSF"/> + <string v="JSP"/> + <string v="Java"/> + <string v="TRINIDAD"/> + <string v="XML"/> + </list> + </hash> + <hash n="oracle.jdeveloper.compiler.OjcConfiguration"> + <value n="internalEncoding" v="GBK"/> + <list n="Javac.commandline.optionlist"> + <string v="-g"/> + <string v="-Xlint:all"/> + <string v="-Xlint:-cast"/> + <string v="-Xlint:-empty"/> + <string v="-Xlint:-fallthrough"/> + <string v="-Xlint:-path"/> + <string v="-Xlint:-processing"/> + <string v="-Xlint:-serial"/> + <string v="-Xlint:-unchecked"/> + </list> + <value n="webIANAEncoding" v="UTF-8"/> + </hash> + <hash n="oracle.jdeveloper.deploy.dt.DeploymentProfiles"> + <hash n="profileDefinitions"> + <hash n="EX_ADF_Project1_webapp"> + <hash n="appletArchives"/> + <hash n="appletFiles"> + <value n="autoInclude" v="true"/> + <list n="selectionFilters"> + <string v="oracle.jdevimpl.deploy.common.JavaSelectionFilter"/> + </list> + </hash> + <hash n="archiveOptions"> + <value n="hasManifest" v="false"/> + </hash> + <value n="enterpriseAppName" v="EX_ADF_Project1_webapp"/> + <hash n="fileGroups"> + <list n="groups"> + <hash> + <list n="contributors"> + <hash> + <value n="type" v="5"/> + </hash> + </list> + <value n="displayName" v="Web Files"/> + <hash n="filters"> + <list n="rules"> + <hash> + <value n="DefaultFilters" v=""/> + </hash> + </list> + </hash> + <value n="internalName" v="web-files"/> + <value n="type" v="1"/> + </hash> + <hash> + <list n="contributors"> + <hash> + <value n="type" v="2"/> + </hash> + <hash> + <value n="type" v="7"/> + </hash> + </list> + <value n="displayName" v="WEB-INF/classes"/> + <hash n="filters"> + <list n="rules"> + <hash> + <value n="DefaultFilters" v=""/> + </hash> + </list> + </hash> + <value n="internalName" v="project-output"/> + <value n="targetWithinJar" v="WEB-INF/classes"/> + <value n="type" v="1"/> + </hash> + <hash> + <value n="displayName" v="WEB-INF/lib"/> + <hash n="filters"> + <list n="rules"> + <hash> + <value n="pattern" v="**"/> + </hash> + </list> + </hash> + <value n="internalName" v="libraries"/> + <value n="targetWithinJar" v="WEB-INF/lib"/> + <value n="type" v="3"/> + </hash> + </list> + </hash> + <url n="jarURL" path="deploy/EX_ADF_Project1_webapp.war"/> + <hash n="libraryDependencies"> + <value n="IncludeLibrariesFromOtherContainers" v="true"/> + </hash> + <value n="profileClass" v="oracle.jdeveloper.deploy.war.WarProfile"/> + <value n="profileName" v="EX_ADF_Project1_webapp"/> + </hash> + </hash> + <list n="profileList"> + <string v="EX_ADF_Project1_webapp"/> + </list> + </hash> + <hash n="oracle.jdeveloper.model.J2eeSettings"> + <value n="j2eeWebAppName" v="EX_ADF-ViewController-webapp"/> + <value n="j2eeWebContextRoot" v="EX_ADF-ViewController-context-root"/> + </hash> + <hash n="oracle.jdevimpl.config.JProjectLibraries"> + <list n="exportedReferences"> + <hash> + <value n="id" v="JSP Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="JSF 2.0"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="JSTL 1.2"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Page Flow Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Controller Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Controller Schema"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Faces Runtime 11"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Common Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Web Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime Dependencies"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="Commons Beanutils 1.6"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="Commons Logging 1.0.4"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="Commons Collections 3.1"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF DVT Faces Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF DVT Faces Databinding Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF DVT Faces Databinding MDS Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="JPS Designtime"/> + <value n="isJDK" v="false"/> + </hash> + </list> + <list n="libraryReferences"> + <hash> + <value n="id" v="JSP Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="JSF 2.0"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="JSTL 1.2"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Page Flow Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Controller Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Controller Schema"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Faces Runtime 11"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Common Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF Web Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="MDS Runtime Dependencies"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="Commons Beanutils 1.6"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="Commons Logging 1.0.4"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="Commons Collections 3.1"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF DVT Faces Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF DVT Faces Databinding Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="ADF DVT Faces Databinding MDS Runtime"/> + <value n="isJDK" v="false"/> + </hash> + <hash> + <value n="id" v="JPS Designtime"/> + <value n="isJDK" v="false"/> + </hash> + </list> + </hash> + <hash n="oracle.jdevimpl.config.JProjectPaths"> + <url n="outputDirectory" path="classes/"/> + </hash> + <hash n="oracle.jdevimpl.webapp.facelets.libraries.ProjectFaceletsTagLibraries"> + <list n="facelets-tag-libraries"> + <hash> + <hash n="baseLibrary"> + <value n="name" v="JSF Core"/> + <value n="version" v="2.0"/> + </hash> + <value n="name" v="JSF Core"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/com/sun/faces/metadata/taglib/facelets_jsf_core.taglib.xml"/> + <value n="URI" v="http://java.sun.com/jsf/core"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="JSF HTML"/> + <value n="version" v="2.0"/> + </hash> + <value n="name" v="JSF HTML"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/com/sun/faces/metadata/taglib/html_basic.taglib.xml"/> + <value n="URI" v="http://java.sun.com/jsf/html"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="Facelets Composite"/> + <value n="version" v="2.0"/> + </hash> + <value n="name" v="Facelets Composite"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/com/sun/faces/metadata/taglib/composite.taglib.xml"/> + <value n="URI" v="http://java.sun.com/jsf/composite"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="Facelets"/> + <value n="version" v="2.0"/> + </hash> + <value n="name" v="Facelets"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/com/sun/faces/metadata/taglib/ui.taglib.xml"/> + <value n="URI" v="http://java.sun.com/jsf/facelets"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="Mojarra Ext Utils"/> + <value n="version" v="2.0"/> + </hash> + <value n="name" v="Mojarra Ext Utils"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/META-INF/mojarra_ext.taglib.xml"/> + <value n="URI" v="http://mojarra.dev.java.net/mojarra_ext"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="JSTL"/> + <value n="version" v="2.0"/> + </hash> + <value n="name" v="JSTL"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/com/sun/faces/metadata/taglib/jstl-core.taglib.xml"/> + <value n="URI" v="http://java.sun.com/jsp/jstl/core"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="JSTL Functions"/> + <value n="version" v="2.0"/> + </hash> + <value n="name" v="JSTL Functions"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/com/sun/faces/metadata/taglib/jstl-fn.taglib.xml"/> + <value n="URI" v="http://java.sun.com/jsp/jstl/functions"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="ADF Faces Components"/> + <value n="version" v="11"/> + </hash> + <value n="name" v="ADF Faces Components"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.adf.view_11.1.1/adf-richclient-impl-11.jar!/META-INF/afu.taglib.xml"/> + <value n="URI" v="http://xmlns.oracle.com/adf/faces/rich"/> + <value n="version" v="11"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="JSF Compatibility Tags for Facelets"/> + <value n="version" v="11"/> + </hash> + <value n="name" v="JSF Compatibility Tags for Facelets"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.adf.view_11.1.1/adf-richclient-impl-11.jar!/META-INF/jsp.taglib.xml"/> + <value n="URI" v="http://java.sun.com/JSP/Page"/> + <value n="version" v="11"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="ADF Faces Component Tags"/> + <value n="version" v="11"/> + </hash> + <value n="name" v="ADF Faces Component Tags"/> + <value n="taglibURL" v="@oracle.home@../oracle_common/modules/oracle.adf.view_11.1.1/adf-richclient-impl-11.jar!/META-INF/component.taglib.xml"/> + <value n="URI" v="http://xmlns.oracle.com/adf/faces/rich/component"/> + <value n="version" v="11"/> + </hash> + </list> + </hash> + <hash n="oracle.jdevimpl.webapp.jsp.libraries.model.ProjectTagLibraries"> + <list n="tag-libraries"> + <hash> + <hash n="baseLibrary"> + <value n="name" v="JSF Core"/> + <value n="version" v="2.0"/> + </hash> + <value n="jspVersion" v="2.1"/> + <value n="name" v="JSF Core"/> + <value n="tldURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/META-INF/jsf_core.tld"/> + <value n="URI" v="http://java.sun.com/jsf/core"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="JSF HTML"/> + <value n="version" v="2.0"/> + </hash> + <value n="jspVersion" v="2.1"/> + <value n="name" v="JSF HTML"/> + <value n="tldURL" v="@oracle.home@../oracle_common/modules/oracle.jsf_2.0/jsf-impl.jar!/META-INF/html_basic.tld"/> + <value n="URI" v="http://java.sun.com/jsf/html"/> + <value n="version" v="2.0"/> + </hash> + <hash> + <hash n="baseLibrary"> + <value n="name" v="ADF Faces Components"/> + <value n="version" v="11"/> + </hash> + <value n="jspVersion" v="1.2"/> + <value n="name" v="ADF Faces Components"/> + <value n="tldURL" v="@oracle.home@../oracle_common/modules/oracle.adf.view_11.1.1/adf-richclient-impl-11.jar!/META-INF/afu.tld"/> + <value n="URI" v="http://xmlns.oracle.com/adf/faces/rich"/> + <value n="version" v="11"/> + </hash> + </list> + </hash> +</jpr:project> diff --git a/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/adfc-config.xml b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/adfc-config.xml new file mode 100644 index 00000000..5d5c05bf --- /dev/null +++ b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/adfc-config.xml @@ -0,0 +1,2 @@ +<?xml version="1.0" encoding="GBK" ?> +<adfc-config xmlns="http://xmlns.oracle.com/adf/controller" version="1.2"></adfc-config> diff --git a/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/faces-config.xml b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/faces-config.xml new file mode 100644 index 00000000..17e93a16 --- /dev/null +++ b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/faces-config.xml @@ -0,0 +1,6 @@ +<?xml version="1.0" encoding="GBK"?> +<faces-config version="2.0" xmlns="http://java.sun.com/xml/ns/javaee"> + <application> + <default-render-kit-id>oracle.adf.rich</default-render-kit-id> + </application> +</faces-config>
\ No newline at end of file diff --git a/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/trinidad-config.xml b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/trinidad-config.xml new file mode 100644 index 00000000..1fa16dba --- /dev/null +++ b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/trinidad-config.xml @@ -0,0 +1,5 @@ +<?xml version="1.0" encoding="GBK"?> +<trinidad-config xmlns="http://myfaces.apache.org/trinidad/config"> + <skin-family>fusionFx</skin-family> + <skin-version>v2.1</skin-version> +</trinidad-config>
\ No newline at end of file diff --git a/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/web.xml b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/web.xml new file mode 100644 index 00000000..49e4ebcd --- /dev/null +++ b/examples/sql/adf/EX_ADF/ViewController/public_html/WEB-INF/web.xml @@ -0,0 +1,137 @@ +<?xml version = '1.0' encoding = 'GBK'?> +<web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" + version="2.5"> + <context-param> + <param-name>javax.faces.STATE_SAVING_METHOD</param-name> + <param-value>client</param-value> + </context-param> + <context-param> + <param-name>javax.faces.PARTIAL_STATE_SAVING</param-name> + <param-value>false</param-value> + </context-param> + <context-param> + <description>If this parameter is true, there will be an automatic check of the modification date of your JSPs, and saved state will be discarded when JSP's change. It will also automatically check if your skinning css files have changed without you having to restart the server. This makes development easier, but adds overhead. For this reason this parameter should be set to false when your application is deployed.</description> + <param-name>org.apache.myfaces.trinidad.CHECK_FILE_MODIFICATION</param-name> + <param-value>false</param-value> + </context-param> + <context-param> + <description>Whether the 'Generated by...' comment at the bottom of ADF Faces HTML pages should contain version number information.</description> + <param-name>oracle.adf.view.rich.versionString.HIDDEN</param-name> + <param-value>false</param-value> + </context-param> + <context-param> + <description>Security precaution to prevent clickjacking: bust frames if the ancestor window domain(protocol, host, and port) and the frame domain are different. Another options for this parameter are always and never.</description> + <param-name>org.apache.myfaces.trinidad.security.FRAME_BUSTING</param-name> + <param-value>differentOrigin</param-value> + </context-param> + <context-param> + <param-name>javax.faces.FACELETS_SKIP_XML_INSTRUCTIONS</param-name> + <param-value>true</param-value> + </context-param> + <context-param> + <param-name>javax.faces.FACELETS_SKIP_COMMENTS</param-name> + <param-value>true</param-value> + </context-param> + <context-param> + <param-name>javax.faces.FACELETS_DECORATORS</param-name> + <param-value>oracle.adfinternal.view.faces.facelets.rich.AdfTagDecorator</param-value> + </context-param> + <context-param> + <param-name>javax.faces.FACELETS_RESOURCE_RESOLVER</param-name> + <param-value>oracle.adfinternal.view.faces.facelets.rich.AdfFaceletsResourceResolver</param-value> + </context-param> + <filter> + <filter-name>JpsFilter</filter-name> + <filter-class>oracle.security.jps.ee.http.JpsFilter</filter-class> + <init-param> + <param-name>enable.anonymous</param-name> + <param-value>true</param-value> + </init-param> + </filter> + <filter> + <filter-name>trinidad</filter-name> + <filter-class>org.apache.myfaces.trinidad.webapp.TrinidadFilter</filter-class> + </filter> + <filter> + <filter-name>ServletADFFilter</filter-name> + <filter-class>oracle.adf.share.http.ServletADFFilter</filter-class> + </filter> + <filter-mapping> + <filter-name>JpsFilter</filter-name> + <url-pattern>/*</url-pattern> + <dispatcher>FORWARD</dispatcher> + <dispatcher>REQUEST</dispatcher> + <dispatcher>INCLUDE</dispatcher> + </filter-mapping> + <filter-mapping> + <filter-name>trinidad</filter-name> + <servlet-name>Faces Servlet</servlet-name> + <dispatcher>FORWARD</dispatcher> + <dispatcher>REQUEST</dispatcher> + <dispatcher>ERROR</dispatcher> + </filter-mapping> + <filter-mapping> + <filter-name>ServletADFFilter</filter-name> + <servlet-name>Faces Servlet</servlet-name> + <dispatcher>FORWARD</dispatcher> + <dispatcher>REQUEST</dispatcher> + </filter-mapping> + <servlet> + <servlet-name>Faces Servlet</servlet-name> + <servlet-class>javax.faces.webapp.FacesServlet</servlet-class> + <load-on-startup>1</load-on-startup> + </servlet> + <servlet> + <servlet-name>resources</servlet-name> + <servlet-class>org.apache.myfaces.trinidad.webapp.ResourceServlet</servlet-class> + </servlet> + <servlet> + <servlet-name>BIGRAPHSERVLET</servlet-name> + <servlet-class>oracle.adf.view.faces.bi.webapp.GraphServlet</servlet-class> + </servlet> + <servlet> + <servlet-name>BIGAUGESERVLET</servlet-name> + <servlet-class>oracle.adf.view.faces.bi.webapp.GaugeServlet</servlet-class> + </servlet> + <servlet> + <servlet-name>MapProxyServlet</servlet-name> + <servlet-class>oracle.adf.view.faces.bi.webapp.MapProxyServlet</servlet-class> + </servlet> + <servlet-mapping> + <servlet-name>Faces Servlet</servlet-name> + <url-pattern>/faces/*</url-pattern> + </servlet-mapping> + <servlet-mapping> + <servlet-name>resources</servlet-name> + <url-pattern>/adf/*</url-pattern> + </servlet-mapping> + <servlet-mapping> + <servlet-name>resources</servlet-name> + <url-pattern>/afr/*</url-pattern> + </servlet-mapping> + <servlet-mapping> + <servlet-name>BIGRAPHSERVLET</servlet-name> + <url-pattern>/servlet/GraphServlet/*</url-pattern> + </servlet-mapping> + <servlet-mapping> + <servlet-name>BIGAUGESERVLET</servlet-name> + <url-pattern>/servlet/GaugeServlet/*</url-pattern> + </servlet-mapping> + <servlet-mapping> + <servlet-name>MapProxyServlet</servlet-name> + <url-pattern>/mapproxy/*</url-pattern> + </servlet-mapping> + <servlet-mapping> + <servlet-name>resources</servlet-name> + <url-pattern>/bi/*</url-pattern> + </servlet-mapping> + <mime-mapping> + <extension>swf</extension> + <mime-type>application/x-shockwave-flash</mime-type> + </mime-mapping> + <mime-mapping> + <extension>amf</extension> + <mime-type>application/x-amf</mime-type> + </mime-mapping> +</web-app> diff --git a/examples/sql/adf/EX_ADF/ViewController/src/META-INF/adf-settings.xml b/examples/sql/adf/EX_ADF/ViewController/src/META-INF/adf-settings.xml new file mode 100644 index 00000000..7209ca20 --- /dev/null +++ b/examples/sql/adf/EX_ADF/ViewController/src/META-INF/adf-settings.xml @@ -0,0 +1,2 @@ +<?xml version="1.0" encoding="GBK" ?> +<adf-settings xmlns="http://xmlns.oracle.com/adf/settings"></adf-settings> diff --git a/examples/sql/adf/EX_ADF/src/META-INF/jps-config.xml b/examples/sql/adf/EX_ADF/src/META-INF/jps-config.xml new file mode 100644 index 00000000..12fa6cfa --- /dev/null +++ b/examples/sql/adf/EX_ADF/src/META-INF/jps-config.xml @@ -0,0 +1,18 @@ +<?xml version = '1.0' encoding = 'GBK'?> +<jpsConfig xmlns="http://xmlns.oracle.com/oracleas/schema/11/jps-config-11_1.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/oracleas/schema/11/jps-config-11_1.xsd jps-config-11_1.xsd"> + <serviceProviders> + <serviceProvider class="oracle.security.jps.internal.credstore.ssp.SspCredentialStoreProvider" name="credstore.provider" type="CREDENTIAL_STORE"> + <description>Credential Store Service Provider</description> + </serviceProvider> + </serviceProviders> + <serviceInstances> + <serviceInstance provider="credstore.provider" name="credstore"> + <property value="./" name="location"/> + </serviceInstance> + </serviceInstances> + <jpsContexts default="EX_ADF"> + <jpsContext name="EX_ADF"> + <serviceInstanceRef ref="credstore"/> + </jpsContext> + </jpsContexts> +</jpsConfig>
\ No newline at end of file diff --git a/examples/sql/adf/EX_ADF/src/META-INF/weblogic-application.xml b/examples/sql/adf/EX_ADF/src/META-INF/weblogic-application.xml new file mode 100644 index 00000000..3c29dbfa --- /dev/null +++ b/examples/sql/adf/EX_ADF/src/META-INF/weblogic-application.xml @@ -0,0 +1,14 @@ +<?xml version = '1.0' encoding = 'GBK'?> +<weblogic-application xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://xmlns.oracle.com/weblogic/weblogic-application http://xmlns.oracle.com/weblogic/weblogic-application/1.1/weblogic-application.xsd" + xmlns="http://xmlns.oracle.com/weblogic/weblogic-application"> + <listener> + <listener-class>oracle.adf.share.weblogic.listeners.ADFApplicationLifecycleListener</listener-class> + </listener> + <listener> + <listener-class>oracle.mds.lcm.weblogic.WLLifecycleListener</listener-class> + </listener> + <library-ref> + <library-name>adf.oracle.domain</library-name> + </library-ref> +</weblogic-application> diff --git a/examples/sql/adf/README b/examples/sql/adf/README new file mode 100644 index 00000000..316403cb --- /dev/null +++ b/examples/sql/adf/README @@ -0,0 +1,117 @@ +The BDB JDBC ADF example was tested using both JDeveloper 11g (11.1.2.4.0) +and JDeveloper 12c (12.1.2.0.0). + +=================== PREPARING THE ENVIRONMENT ================ + +1. Install JDeveloper. + +2. Build the BDB JDBC driver and include its path in the system CLASSPATH +and LD_LIBRARY_PATH environment variables. Please refer to the Berkeley DB +Installation Guide for instructions on building the JDBC driver. + + +=================== OPENING THE SAMPLE ======================= + +In JDeveloper, open <example>/EX_ADF.jws. If you are using JDeveloper 12c, +it will ask you to migrate the application to 12c automatically after you +open the file. In this event, please choose "yes" to migrate the example. + + +=================== RUNNING ================================== + +1. Add the BDB JDBC path to project properties. +Select Application -> project properties -> Libraries and Classpath -> +Add JAR/Directory -> locate the path of BDB JDBC -> OK. + +2. Initialize the database schema. +Open <example>/Model/src/dbscheme/PrimaryKeySuppliers.java and +<example>/Model/src/dbscheme/ForeignKeysCoffees.java, and replace "path_to_db" +with the location of the database file you want to store. Then run the 2 java files +in order. + +3. Modify the database connection. +Select Application Resources -> Connections -> Database -> +right click on BDBConnection -> properties -> JDBC URL, and replace +"absolute_path_to_db" with the path of the database file you just created in the +last step. Note that the path in the connection JDBC URL must be absolute, +otherwise JDeveloper can not locate the database file. + +If the password in the connection properties panel is empty, +enter "myPassword". + +4. You can run the example in 2 ways. +a) Run with tester. +Expand uimode.am in the project panel and run AppModule. You can select/insert/ +update/delete rows in the tester. +b) Run without tester. +Expand uimode.am in the project panel and run TestClient.java. This is a Java +program demonstrating how to perform select/insert/update/delete operations +by using ADF classes and APIs. + + +=================== LIST OF FILES ================ + +All files needed by the example are located under examples/sql/adf/EX_ADF. You +need to maintain its file and directory structure. If you want to run the +example in the location other than examples/sql/adf/EX_ADF, please copy the +entire example directory (examples/sql/adf/EX_ADF) into place. + +Here is a brief description of files under examples/sql/adf/EX_ADF. + +1. Application file + EX_ADF.jws + +2. Application configurations and connection properties + .adf/META-INF/adf-config.xml + .adf/META-INF/connections.xml + src/META-INF/jps-config.xml + src/META-INF/weblogic-application.xml + +3. Model project +This is one of the default ADF application projects. + +a) Project file + Model/Model.jpr + +b) ADF Business Component + Model/src/model/Model.jpx + Model/src/model/ModelBundle.properties + +c) Database schema + Model/src/dbschema/ForeignKeysCoffees.java + Model/src/dbschema/PrimaryKeysSuppliers.java + +d) Entity object + Model/src/model/entity/CoffeesEO.xml + Model/src/model/entity/CoffeesEOImpl.java + Model/src/model/entity/SuppliersEO.xml + Model/src/model/entity/SuppliersEOImpl.java + +e) View object and link + Model/src/uimodel/view/CoffeesVO.xml + Model/src/uimodel/view/SuppliersVO.xml + Model/src/uimodel/view/SuppliersVOToCoffeesVOLink.xml + +f) Association + Model/src/model/entity/association/SuppliersEOToCoffeesEOAssoc.xml + +g) Application Module configurations + Model/src/uimodel/am/AppModule.xml + Model/src/uimodel/am/common/bc4j.xcfg + +h) Sample Java program + Model/src/uimodel/am/TestClient.java + +4. ViewController project +This is one of the default ADF application projects. + +a) Project file + ViewController/ViewController.jpr + +b) Project configurations + ViewController/public_html/WEB-INF/adfc-config.xml + ViewController/public_html/WEB-INF/faces-config.xml + ViewController/public_html/WEB-INF/trinidad-config.xml + ViewController/public_html/WEB-INF/web.xml + ViewController/src/META-INF/adf-settings.xml + diff --git a/examples/sql/c/ex_sql_binding.c b/examples/sql/c/ex_sql_binding.c index 339c3804..7032084d 100644 --- a/examples/sql/c/ex_sql_binding.c +++ b/examples/sql/c/ex_sql_binding.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_fts3.c b/examples/sql/c/ex_sql_fts3.c index cc2f5211..e511f23b 100644 --- a/examples/sql/c/ex_sql_fts3.c +++ b/examples/sql/c/ex_sql_fts3.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_index.c b/examples/sql/c/ex_sql_index.c index c0f411c7..bbf41211 100644 --- a/examples/sql/c/ex_sql_index.c +++ b/examples/sql/c/ex_sql_index.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_load.c b/examples/sql/c/ex_sql_load.c index c57f0104..7d5a1a98 100644 --- a/examples/sql/c/ex_sql_load.c +++ b/examples/sql/c/ex_sql_load.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_multi_thread.c b/examples/sql/c/ex_sql_multi_thread.c index b83b8e5a..83e641a3 100644 --- a/examples/sql/c/ex_sql_multi_thread.c +++ b/examples/sql/c/ex_sql_multi_thread.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_query.c b/examples/sql/c/ex_sql_query.c index d8428f64..e1043a4b 100644 --- a/examples/sql/c/ex_sql_query.c +++ b/examples/sql/c/ex_sql_query.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_rtree.c b/examples/sql/c/ex_sql_rtree.c index 29d011ab..d0622bf5 100644 --- a/examples/sql/c/ex_sql_rtree.c +++ b/examples/sql/c/ex_sql_rtree.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_savepoint.c b/examples/sql/c/ex_sql_savepoint.c index 8f0cfdda..bf1cd6f4 100644 --- a/examples/sql/c/ex_sql_savepoint.c +++ b/examples/sql/c/ex_sql_savepoint.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_statement.c b/examples/sql/c/ex_sql_statement.c index 1e962f30..b8d2fc32 100644 --- a/examples/sql/c/ex_sql_statement.c +++ b/examples/sql/c/ex_sql_statement.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_transaction.c b/examples/sql/c/ex_sql_transaction.c index 821fdf70..3d09ba3a 100644 --- a/examples/sql/c/ex_sql_transaction.c +++ b/examples/sql/c/ex_sql_transaction.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_utils.c b/examples/sql/c/ex_sql_utils.c index 0b8a6578..42cfb848 100644 --- a/examples/sql/c/ex_sql_utils.c +++ b/examples/sql/c/ex_sql_utils.c @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 1997, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/c/ex_sql_utils.h b/examples/sql/c/ex_sql_utils.h index d1ec640c..b28bd44f 100644 --- a/examples/sql/c/ex_sql_utils.h +++ b/examples/sql/c/ex_sql_utils.h @@ -1,7 +1,7 @@ /* * See the file LICENSE for redistribution information. * - * Copyright (c) 1997-2012 Oracle. All rights reserved. + * Copyright (c) 1997, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/wce_sql/excxx_wce_sql.cpp b/examples/sql/wce_sql/excxx_wce_sql.cpp index 4e58df67..7ccb0b90 100644 --- a/examples/sql/wce_sql/excxx_wce_sql.cpp +++ b/examples/sql/wce_sql/excxx_wce_sql.cpp @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 2012, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 2010, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/wce_sql/excxx_wce_sql.h b/examples/sql/wce_sql/excxx_wce_sql.h index e9713b84..03b6dfc4 100644 --- a/examples/sql/wce_sql/excxx_wce_sql.h +++ b/examples/sql/wce_sql/excxx_wce_sql.h @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 2012, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 2010, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/wce_sql/excxx_wce_sqlDlg.cpp b/examples/sql/wce_sql/excxx_wce_sqlDlg.cpp index 8be4e134..10d51f97 100644 --- a/examples/sql/wce_sql/excxx_wce_sqlDlg.cpp +++ b/examples/sql/wce_sql/excxx_wce_sqlDlg.cpp @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 2012, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 2010, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/wce_sql/excxx_wce_sqlDlg.h b/examples/sql/wce_sql/excxx_wce_sqlDlg.h index 18b5451c..b401577d 100644 --- a/examples/sql/wce_sql/excxx_wce_sqlDlg.h +++ b/examples/sql/wce_sql/excxx_wce_sqlDlg.h @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 2012, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 2010, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/wce_sql/resourceppc.h b/examples/sql/wce_sql/resourceppc.h index f42e871b..240862ca 100644 --- a/examples/sql/wce_sql/resourceppc.h +++ b/examples/sql/wce_sql/resourceppc.h @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 2012, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 2010, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/wce_sql/stdafx.cpp b/examples/sql/wce_sql/stdafx.cpp index 152e3d68..be51aa13 100644 --- a/examples/sql/wce_sql/stdafx.cpp +++ b/examples/sql/wce_sql/stdafx.cpp @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 2012, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 2010, 2015 Oracle and/or its affiliates. All rights reserved. * */ diff --git a/examples/sql/wce_sql/stdafx.h b/examples/sql/wce_sql/stdafx.h index 68912e4e..676cf0c6 100644 --- a/examples/sql/wce_sql/stdafx.h +++ b/examples/sql/wce_sql/stdafx.h @@ -1,7 +1,7 @@ /*- * See the file LICENSE for redistribution information. * - * Copyright (c) 2012, 2012 Oracle and/or its affiliates. All rights reserved. + * Copyright (c) 2010, 2015 Oracle and/or its affiliates. All rights reserved. * */ |