%@ page language="java" %>
<%@ page import="java.sql.*,oracle.jdbc.driver.*,java.util.*" %>
Oracle / Windchill / Intralink - JSP/Oracle Query Example
Oracle / Windchill / Intralink - JSP/Oracle Query
<%
String srvrNmStg = (request.getParameter("srvrNm"));
String portNoStg = (request.getParameter("portNo"));
String sidNmStg = (request.getParameter("sidNm"));
String usrNmStg = (request.getParameter("usrNm"));
String passWdStg = (request.getParameter("passWd"));
String sqlQueryArr[] = {"select * from PDMLINK.ACCEPTEDSTRATEGY",
"select * from PDMLINK.ACCESSCONTROLSURROGATE",
"select * from PDMLINK.ACCESSPOLICY",
"select * from PDMLINK.ACCESSPOLICYRULE",
"select * from PDMLINK.ACCESSRULEEVENTINFO",
"select * from PDMLINK.ACTIONITEMEVENTINFO",
"select * from PDMLINK.ACTIONITEMSUBJECTLINK",
"select * from PDMLINK.ACTIONPULLITEM",
"select * from PDMLINK.ACTIONSHIPPINGITEM",
"select * from PDMLINK.ACTIVITYACTIVITYLINK",
"select * from PDMLINK.ACTIVITYASSIGNMENTLINK",
"select * from PDMLINK.ACTIVITYCONNECTORLINK",
"select * from PDMLINK.ADDRESSEDBY2",
"select * from PDMLINK.ADHOCACLLINK",
"select * from PDMLINK.ADHOCACLSPEC",
"select * from PDMLINK.ADHOCEVENTINFO",
"select * from PDMLINK.ADMINISTRATIVEDOMAIN",
"select * from PDMLINK.AFFECTEDACTIVITYDATA",
"select * from PDMLINK.AGGREGATE",
"select * from PDMLINK.AGGTOCONTENTITEM",
"select * from PDMLINK.ALERTITEM",
"select * from PDMLINK.ALTERNATEITEMGROUP",
"select * from PDMLINK.ANNOTATIONBASELINE",
"select * from PDMLINK.ANNOTATIONSET",
"select * from PDMLINK.ANNOTATIONSETTARGETS",
"select * from PDMLINK.APPLICATIONDATA",
"select * from PDMLINK.ATTRIBUTEORGANIZER",
"select * from PDMLINK.AUDITEVENT",
"select * from PDMLINK.BALLOTS",
"select * from PDMLINK.BASELINECONFIGOVERRIDE",
"select * from PDMLINK.BASELINEMEMBER",
"select * from PDMLINK.BASELINEREMOVEMEMBER",
"select * from PDMLINK.BIACTIONPULLITEM",
"select * from PDMLINK.BOOKMARK",
"select * from PDMLINK.BOOLEANDEFINITION",
"select * from PDMLINK.BOOLEANVALUE",
"select * from PDMLINK.BUILDHISTORY",
"select * from PDMLINK.BULKINDEXLISTENTRY",
"select * from PDMLINK.BUSINESSENTITY",
"select * from PDMLINK.CABINET",
"select * from PDMLINK.CADNAMEREGISTRYENTRY",
"select * from PDMLINK.CALENDARCOMPONENT",
"select * from PDMLINK.CAMEFROMUNIT",
"select * from PDMLINK.CHANGEKEY",
"select * from PDMLINK.CHANGERECORD2",
"select * from PDMLINK.CHANGESFORANNOTATIONS",
"select * from PDMLINK.CHANGESFORMARKUPS",
"select * from PDMLINK.CHECKOUTLINK",
"select * from PDMLINK.CLASSIFICATIONNAVSTRUCT",
"select * from PDMLINK.CLASSIFICATIONNODE",
"select * from PDMLINK.CLASSIFICATIONSTRUCT",
"select * from PDMLINK.COMBOCCURRENCEDATAMASTER",
"select * from PDMLINK.COMBOCCURRENCEDOCUMENTATION",
"select * from PDMLINK.COMBOCCURRENCEUSERIBAS",
"select * from PDMLINK.COMPONENTLINK",
"select * from PDMLINK.CONFIGURATIONITEM",
"select * from PDMLINK.CONFIRMABLESHIPPINGITEM",
"select * from PDMLINK.CONNECTORACTIVITYLINK",
"select * from PDMLINK.CONNECTORCONNECTORLINK",
"select * from PDMLINK.CONTAINERTEAM",
"select * from PDMLINK.CONTREPLHISTORY",
"select * from PDMLINK.CONTROLBRANCH",
"select * from PDMLINK.COUNTEDHISTORY",
"select * from PDMLINK.COUNTERPARTATTACHMENT",
"select * from PDMLINK.COUNTERPARTCONTENT",
"select * from PDMLINK.COUNTERPARTDELTA",
"select * from PDMLINK.CREATORSLINK",
"select * from PDMLINK.CRITERION",
"select * from PDMLINK.CRITERIONHISTORY",
"select * from PDMLINK.CRITERIONLINK",
"select * from PDMLINK.CSMCONTAINERCONSTRAINT",
"select * from PDMLINK.CSMSINGLEDEFCONSTRAINT",
"select * from PDMLINK.CURRENTPHASELINK",
"select * from PDMLINK.CUSTOMEVENTINFO",
"select * from PDMLINK.DATAFORMAT",
"select * from PDMLINK.DBPREFENTRY",
"select * from PDMLINK.DEADLINECHANGEEVENT",
"select * from PDMLINK.DEADLINEEVENT",
"select * from PDMLINK.DEFAULTCRITERION",
"select * from PDMLINK.DEFAULTQUERYFORM",
"select * from PDMLINK.DEFAULTWTCONTAINERTEMPLATE",
"select * from PDMLINK.DELIVERABLE",
"select * from PDMLINK.DELIVERABLELINK",
"select * from PDMLINK.DERIVEDFROMCONFIGSPECLINK",
"select * from PDMLINK.DERIVEDIMAGE",
"select * from PDMLINK.DERIVEDIMAGEKEY",
"select * from PDMLINK.DETAILEDBY",
"select * from PDMLINK.DIRECTORYTRANSLATIONTABLE",
"select * from PDMLINK.DIRECTQUERYTARGET",
"select * from PDMLINK.DISCRETEACTIONITEM",
"select * from PDMLINK.DISCUSSIONFORUM",
"select * from PDMLINK.DISCUSSIONFORUMTEMPLATE",
"select * from PDMLINK.DISCUSSIONPOSTING",
"select * from PDMLINK.DISCUSSIONTOPIC",
"select * from PDMLINK.EFFCHANGEAUDIT",
"select * from PDMLINK.EFFCONFIGSPECGROUP",
"select * from PDMLINK.EFFCONTEXTKEY",
"select * from PDMLINK.ELECTRONICSIGNATURE",
"select * from PDMLINK.ELEMENTIMPORTINFO",
"select * from PDMLINK.ENVIRONMENTCONFLICT",
"select * from PDMLINK.EPMASSTOREDCONFIG",
"select * from PDMLINK.EPMASSTOREDMEMBER",
"select * from PDMLINK.EPMBUILDHISTORY",
"select * from PDMLINK.EPMBUILDLINKSRULE",
"select * from PDMLINK.EPMCADNAMESPACE",
"select * from PDMLINK.EPMCHECKPOINT",
"select * from PDMLINK.EPMCHECKPOINTMASTER",
"select * from PDMLINK.EPMCONTAINEDIN",
"select * from PDMLINK.EPMDESCRIBELINK",
"select * from PDMLINK.EPMDOCCONFIGSPEC",
"select * from PDMLINK.EPMDOCUMENT",
"select * from PDMLINK.EPMDOCUMENTMASTER",
"select * from PDMLINK.EPMDOCUMENTMASTERKEY",
"select * from PDMLINK.EPMMEMBERLINK",
"select * from PDMLINK.EPMOCCURRENCETABLE",
"select * from PDMLINK.EPMREFERENCELINK",
"select * from PDMLINK.EPMSUPPORTINGDATA",
"select * from PDMLINK.EPMUSESOCCURRENCE",
"select * from PDMLINK.EPMVARIANTLINK",
"select * from PDMLINK.EPMWORKSPACE",
"select * from PDMLINK.EPMWORKSPACEKEY",
"select * from PDMLINK.EQUIPMENTRESOURCE",
"select * from PDMLINK.ESIRELATEDTRANSACTION",
"select * from PDMLINK.ESITARGET",
"select * from PDMLINK.ESITARGETASSIGNMENTLINK",
"select * from PDMLINK.ESITARGETORGANIZATIONLINK",
"select * from PDMLINK.ESITRANSACTION",
"select * from PDMLINK.ESITRANSACTIONMESSAGE",
"select * from PDMLINK.ESITRANSACTIONOBJECTLINK",
"select * from PDMLINK.ESITRANSACTIONRELEASE",
"select * from PDMLINK.EVENTLOG",
"select * from PDMLINK.EXCHANGECONTAINER",
"select * from PDMLINK.EXECOBJECTEVENTINFO",
"select * from PDMLINK.EXTENDEDPAGERESULTS",
"select * from PDMLINK.FACILITYRESOURCE",
"select * from PDMLINK.FEDERATEDDIRECTORYSERVICE",
"select * from PDMLINK.FEDERATEDINFOENGINESERVICE",
"select * from PDMLINK.FEDERATEDLINK",
"select * from PDMLINK.FILTEREDDYNAMICENUMSET",
"select * from PDMLINK.FLOATDEFINITION",
"select * from PDMLINK.FLOATVALUE",
"select * from PDMLINK.FOLDEREDBOOKMARK",
"select * from PDMLINK.FOLDERMEMBERLINK",
"select * from PDMLINK.FORMALIZEDBY",
"select * from PDMLINK.FORUMCOOKIE",
"select * from PDMLINK.FORUMSUBJECTLINK",
"select * from PDMLINK.FVFOLDER",
"select * from PDMLINK.FVHOST",
"select * from PDMLINK.FVITEM",
"select * from PDMLINK.FVMOUNT",
"select * from PDMLINK.FVPOLICYITEM",
"select * from PDMLINK.FVPOLICYRULE",
"select * from PDMLINK.FVSERVICEPERSISTENTFLAGS",
"select * from PDMLINK.FVVAULT",
"select * from PDMLINK.GROUPEVENTINFO",
"select * from PDMLINK.HOLDERTOCONTENT",
"select * from PDMLINK.HTMLLOG",
"select * from PDMLINK.HTMLLOGMESSAGE",
"select * from PDMLINK.HTTPCONTENTOPERATION",
"select * from PDMLINK.HTTPOPERATIONITEM",
"select * from PDMLINK.IMPORTEDBOOKMARK",
"select * from PDMLINK.IMPORTSESSION",
"select * from PDMLINK.INCLUDEDIN2",
"select * from PDMLINK.INDEPENDENTNAVSTRUCT",
"select * from PDMLINK.INDEPENDENTNODE",
"select * from PDMLINK.INDEXPOLICY",
"select * from PDMLINK.INDEXPOLICYLIST",
"select * from PDMLINK.INDEXPOLICYRULE",
"select * from PDMLINK.INDEXSTATUS",
"select * from PDMLINK.INDIRECTQUERYTARGET",
"select * from PDMLINK.INFOENGINETRANSLATIONTABLE",
"select * from PDMLINK.INFORMATIONRESOURCE",
"select * from PDMLINK.INSTANCEBASEDRULE",
"select * from PDMLINK.INTEGERDEFINITION",
"select * from PDMLINK.INTEGERVALUE",
"select * from PDMLINK.ITERATEDCURRENTPHASELINK",
"select * from PDMLINK.ITERATEDFORUMSUBJECTLINK",
"select * from PDMLINK.ITERATEDNOTEBOOKSUBJECTLINK",
"select * from PDMLINK.ITERATEDSHORTCUTLINK",
"select * from PDMLINK.ITERFOLDERMEMBERLINK",
"select * from PDMLINK.LASTAUDITEVENT",
"select * from PDMLINK.LIFECYCLEHISTORY",
"select * from PDMLINK.LIFECYCLESIGNATURE",
"select * from PDMLINK.LIFECYCLETEMPLATE",
"select * from PDMLINK.LIFECYCLETEMPLATEMASTER",
"select * from PDMLINK.LIGHTWEIGHTPROXY",
"select * from PDMLINK.LOGICALIDENTIFIERMAPENTRY",
"select * from PDMLINK.MADEFROMLINK",
"select * from PDMLINK.MANAGEDBASELINE",
"select * from PDMLINK.MANAGEDBASELINEKEY",
"select * from PDMLINK.MASTEREDONREPLICAITEM",
"select * from PDMLINK.MATERIALRESOURCE",
"select * from PDMLINK.MEASUREMENTSYSTEM",
"select * from PDMLINK.MEETINGCENTERMEETING",
"select * from PDMLINK.MEETINGDELIVERABLE",
"select * from PDMLINK.MEETINGPARTICIPANTLINK",
"select * from PDMLINK.MEETINGSUBJECTLINK",
"select * from PDMLINK.MERGEINFOLINK",
"select * from PDMLINK.MILESTONE",
"select * from PDMLINK.MILESTONETEMPLATE",
"select * from PDMLINK.MYPAGEQUERYABLE",
"select * from PDMLINK.NODEQUERYFORM",
"select * from PDMLINK.NODETEMPLATELINK",
"select * from PDMLINK.NOTAUTHORIZEDEVENTINFO",
"select * from PDMLINK.NOTEBOOK",
"select * from PDMLINK.NOTEBOOKFOLDER",
"select * from PDMLINK.NOTEBOOKSUBJECTLINK",
"select * from PDMLINK.NOTEBOOKTEMPLATE",
"select * from PDMLINK.NOTIFICATIONLIST",
"select * from PDMLINK.NOTIFICATIONPOLICY",
"select * from PDMLINK.NOTIFICATIONRULE",
"select * from PDMLINK.OBJECTDELETIONEVENT",
"select * from PDMLINK.OBJECTHISTORY",
"select * from PDMLINK.OBJECTSUBSCRIPTION",
"select * from PDMLINK.OPLINK",
"select * from PDMLINK.ORGCONTAINER",
"select * from PDMLINK.OUTOFDATEREPRESENTATIONLINK",
"select * from PDMLINK.OVERDUEWORKITEMLINK",
"select * from PDMLINK.OWNERCHANGEEVENT",
"select * from PDMLINK.OWNINGREPOSITORYLOCALOBJECT",
"select * from PDMLINK.PAGERESULTS",
"select * from PDMLINK.PAGINGSESSION",
"select * from PDMLINK.PARTCOMBINEDPATHOCCURRENCE",
"select * from PDMLINK.PARTEXPORTINFO",
"select * from PDMLINK.PARTPATHOCCURRENCE",
"select * from PDMLINK.PARTUSESOCCURRENCE",
"select * from PDMLINK.PATHOCCURRENCEDATAMASTER",
"select * from PDMLINK.PATHOCCURRENCEDOCUMENTATION",
"select * from PDMLINK.PATHOCCURRENCEUSERIBAS",
"select * from PDMLINK.PAYLOADSHIPPINGITEM",
"select * from PDMLINK.PDMLINKPRODUCT",
"select * from PDMLINK.PERDESTINATIONOUTBOX",
"select * from PDMLINK.PERSISTABLEEFFCONFIGSPEC",
"select * from PDMLINK.PERSISTANTARG",
"select * from PDMLINK.PERSISTENTINBOX",
"select * from PDMLINK.PERSISTENTTRACKINGNUMGEN",
"select * from PDMLINK.PERSONRESOURCE",
"select * from PDMLINK.PHASE",
"select * from PDMLINK.PHASELINK",
"select * from PDMLINK.PHASESUCCESSION",
"select * from PDMLINK.PHASETEMPLATE",
"select * from PDMLINK.POLICYACL",
"select * from PDMLINK.POSTINGATTACHMENTLINK",
"select * from PDMLINK.PRIMITIVEARG",
"select * from PDMLINK.PRINCIPALDOMAINKEY",
"select * from PDMLINK.PROBLEMPRODUCT",
"select * from PDMLINK.PROCESSINGQUEUE",
"select * from PDMLINK.PROCESSSTEPTEMPLATELINK",
"select * from PDMLINK.PRODUCTDATEEFFECTIVITY",
"select * from PDMLINK.PRODUCTLNEFFECTIVITY",
"select * from PDMLINK.PRODUCTSNEFFECTIVITY",
"select * from PDMLINK.PROJECT",
"select * from PDMLINK.PROJECT2",
"select * from PDMLINK.PROJECTACTIVITY",
"select * from PDMLINK.PROJECTACTIVITYTEMPLATE",
"select * from PDMLINK.PROJECTASSIGNMENT",
"select * from PDMLINK.PROJECTAUDITEVENT",
"select * from PDMLINK.PROJECTEVENTINFO",
"select * from PDMLINK.PROJECTPLAN",
"select * from PDMLINK.PROJECTPLANTEMPLATE",
"select * from PDMLINK.PROJECTPROXY",
"select * from PDMLINK.PROJECTPROXYTEMPLATE",
"select * from PDMLINK.PROJECTWORKITEM",
"select * from PDMLINK.PROXYDOCUMENT",
"select * from PDMLINK.PROXYDOCUMENTMASTER",
"select * from PDMLINK.PROXYGROUP",
"select * from PDMLINK.PROXYPARTMASTER",
"select * from PDMLINK.PROXYURLDATA",
"select * from PDMLINK.PROXYUSER",
"select * from PDMLINK.PUBLISHEDLINENUMBER",
"select * from PDMLINK.PUBLISHINGPROHIBITION",
"select * from PDMLINK.QUANTITYOFMEASURE",
"select * from PDMLINK.QUASIPART",
"select * from PDMLINK.QUERYFORMELEMENT",
"select * from PDMLINK.QUEUEENTRY",
"select * from PDMLINK.RANKINGCONTEXT",
"select * from PDMLINK.RANKINGDATA",
"select * from PDMLINK.RATIODEFINITION",
"select * from PDMLINK.RATIOVALUE",
"select * from PDMLINK.RDCONTEXTNODE",
"select * from PDMLINK.RDINTERMEDIATENODE",
"select * from PDMLINK.RDNODEKEY",
"select * from PDMLINK.RECEIPT",
"select * from PDMLINK.REFERENCEDEFINITION",
"select * from PDMLINK.REFERENCEVALUE",
"select * from PDMLINK.RELEASEACTIVITY",
"select * from PDMLINK.RELEASEACTIVITYMESSAGE",
"select * from PDMLINK.RELEVANTANALYSISDATA",
"select * from PDMLINK.RELEVANTREQUESTDATA2",
"select * from PDMLINK.REMOTEOBJECTINFO",
"select * from PDMLINK.REMOTESITETEAMTEMPLATE",
"select * from PDMLINK.REMOTESITETEAMTEMPLATELINK",
"select * from PDMLINK.RENAMEEVENTINFO",
"select * from PDMLINK.REPLICAFOLDER",
"select * from PDMLINK.REPLICATEDITEM",
"select * from PDMLINK.REPLICATIONBASELINE",
"select * from PDMLINK.REPLICAVAULT",
"select * from PDMLINK.REPORTEDAGAINST",
"select * from PDMLINK.REPORTTEMPLATE",
"select * from PDMLINK.REPOSITORY",
"select * from PDMLINK.REPRESENTABLECONFIGSPECLINK",
"select * from PDMLINK.RESEARCHEDBY",
"select * from PDMLINK.RESOURCEASSIGNMENTLINK",
"select * from PDMLINK.REVAULTINGSESSION",
"select * from PDMLINK.REVAULTSESSIONID",
"select * from PDMLINK.REVAULTURLSESSION",
"select * from PDMLINK.ROLEACTORROLEMAP",
"select * from PDMLINK.ROLEPOOLMAP",
"select * from PDMLINK.ROLEPRINCIPALMAP",
"select * from PDMLINK.ROLERESOURCE",
"select * from PDMLINK.ROLEROLEMAP",
"select * from PDMLINK.RULEHISTORYENTRY",
"select * from PDMLINK.RVSTREAMIDCOUNTER",
"select * from PDMLINK.SANDBOXBASELINE",
"select * from PDMLINK.SANDBOXCHECKINLINK",
"select * from PDMLINK.SANDBOXCHECKOUTLINK",
"select * from PDMLINK.SAVEDQUERY",
"select * from PDMLINK.SCHEDULEHISTORY",
"select * from PDMLINK.SCHEDULEITEM",
"select * from PDMLINK.SCHEDULEQUEUE",
"select * from PDMLINK.SCHEDULEQUEUEENTRY",
"select * from PDMLINK.SCH_ENTRIES",
"select * from PDMLINK.SEMANTICKEY",
"select * from PDMLINK.SERIALNUMBERMAPPING",
"select * from PDMLINK.SHAREDCONTAINERMAP",
"select * from PDMLINK.SHORTCUTLINK",
"select * from PDMLINK.SIGNATUREHISTORY",
"select * from PDMLINK.SIGNATURELINK",
"select * from PDMLINK.SITE",
"select * from PDMLINK.SITESECURITY",
"select * from PDMLINK.SKELETONBOOKMARK",
"select * from PDMLINK.STATECHANGEEVENT",
"select * from PDMLINK.STATUSCHANGEEVENT",
"select * from PDMLINK.STREAMDATA",
"select * from PDMLINK.STREAMIDENTITY",
"select * from PDMLINK.STRINGDEFINITION",
"select * from PDMLINK.STRINGVALUE",
"select * from PDMLINK.STRUCTUREDANNOTATIONSET",
"select * from PDMLINK.SUBFOLDER",
"select * from PDMLINK.SUBFOLDERLINK",
"select * from PDMLINK.SUBFOLDERLINKCONSTRAINT",
"select * from PDMLINK.SUBJECTPRODUCT",
"select * from PDMLINK.SUMMARYACTIVITY",
"select * from PDMLINK.SUMMARYACTIVITYTEMPLATE",
"select * from PDMLINK.TEAM",
"select * from PDMLINK.TEAMDISTRIBUTIONLIST",
"select * from PDMLINK.TEAMEVENTROLEPOOLINFO",
"select * from PDMLINK.TEAMEVENTROLEPRINCIPALINFO",
"select * from PDMLINK.TEAMTEMPLATE",
"select * from PDMLINK.TEMPLATEDAGENDA",
"select * from PDMLINK.TEMPLATEDMINUTES",
"select * from PDMLINK.TEXTAGENDA",
"select * from PDMLINK.TEXTMINUTES",
"select * from PDMLINK.THEMARKUPTHEVIEWABLE",
"select * from PDMLINK.TIMESTAMPDEFINITION",
"select * from PDMLINK.TIMESTAMPVALUE",
"select * from PDMLINK.TODOITEM",
"select * from PDMLINK.TRADITIONALMEETING",
"select * from PDMLINK.TRANSPARENTINBOX",
"select * from PDMLINK.TRANSPARENTOUTBOX",
"select * from PDMLINK.TYPEBASEDRULE",
"select * from PDMLINK.TYPECONTAINERCONSTRAINT",
"select * from PDMLINK.TYPESINGLEATTRCONSTRAINT",
"select * from PDMLINK.UFIDMAPPING",
"select * from PDMLINK.UNITDEFINITION",
"select * from PDMLINK.UNITEXPORTRECORD",
"select * from PDMLINK.UNITIMPORTRECORD",
"select * from PDMLINK.UNITRECEIVERECORD",
"select * from PDMLINK.UNITSEEDLINK",
"select * from PDMLINK.UNITSENDRECORD",
"select * from PDMLINK.UNITVALUE",
"select * from PDMLINK.UPLOADEDCONTENTDATA",
"select * from PDMLINK.UPLOADSTATUS",
"select * from PDMLINK.URLDATA",
"select * from PDMLINK.URLDEFINITION",
"select * from PDMLINK.URLVALUE",
"select * from PDMLINK.USERELECTRONICIDLINK",
"select * from PDMLINK.USESOCCURRENCEDOCUMENTATION",
"select * from PDMLINK.USESOCCURRENCEUSERIBAS",
"select * from PDMLINK.VIEWASSOCIATION",
"select * from PDMLINK.WFADHOCACTIVITY",
"select * from PDMLINK.WFADHOCACTIVITYTEMPLATE",
"select * from PDMLINK.WFAPPLICATIONROBOT",
"select * from PDMLINK.WFAPPLROBOTTEMPLATE",
"select * from PDMLINK.WFASSIGNEDACTIVITY",
"select * from PDMLINK.WFASSIGNEDACTIVITYTEMPLATE",
"select * from PDMLINK.WFASSIGNMENT",
"select * from PDMLINK.WFASSIGNMENTEVENTAUDIT",
"select * from PDMLINK.WFBALLOT",
"select * from PDMLINK.WFBLOCK",
"select * from PDMLINK.WFBLOCKTEMPLATE",
"select * from PDMLINK.WFBOOKMARK",
"select * from PDMLINK.WFCONNECTOR",
"select * from PDMLINK.WFCONNECTORTEMPLATE",
"select * from PDMLINK.WFCREATEPROCESSEVENTAUDIT",
"select * from PDMLINK.WFDATAEVENTAUDIT",
"select * from PDMLINK.WFEXCEPTIONEVENTAUDIT",
"select * from PDMLINK.WFEXPRESSION",
"select * from PDMLINK.WFEXPRESSIONROBOT",
"select * from PDMLINK.WFEXPRROBOTTEMPLATE",
"select * from PDMLINK.WFEXTERNALMETHOD",
"select * from PDMLINK.WFEXTERNALMETHODTEMPLATE",
"select * from PDMLINK.WFFOLDEREDBOOKMARK",
"select * from PDMLINK.WFINTERNALMETHOD",
"select * from PDMLINK.WFINTERNALMETHODTEMPLATE",
"select * from PDMLINK.WFPROCESS",
"select * from PDMLINK.WFPROCESSREQUESTER",
"select * from PDMLINK.WFPROCESSTEMPLATE",
"select * from PDMLINK.WFPROCESSTEMPLATEMASTER",
"select * from PDMLINK.WFPROXYTEMPLATE",
"select * from PDMLINK.WFREQUESTERACTIVITY",
"select * from PDMLINK.WFSTATEEVENTAUDIT",
"select * from PDMLINK.WFSYNCHROBOT",
"select * from PDMLINK.WFSYNCHROBOTTEMPLATE",
"select * from PDMLINK.WFTIMERACTIVITY",
"select * from PDMLINK.WFTIMERTEMPLATE",
"select * from PDMLINK.WFURLROBOT",
"select * from PDMLINK.WFURLROBOTTEMPLATE",
"select * from PDMLINK.WFVARIABLEEVENTINFO",
"select * from PDMLINK.WORKITEM",
"select * from PDMLINK.WORKITEMLINK",
"select * from PDMLINK.WTACLENTRY",
"select * from PDMLINK.WTANALYSISACTIVITY",
"select * from PDMLINK.WTCALENDAR",
"select * from PDMLINK.WTCHANGEACTIVITY2",
"select * from PDMLINK.WTCHANGEINVESTIGATION",
"select * from PDMLINK.WTCHANGEISSUE",
"select * from PDMLINK.WTCHANGEORDER2",
"select * from PDMLINK.WTCHANGEPROPOSAL",
"select * from PDMLINK.WTCHANGEREQUEST2",
"select * from PDMLINK.WTCONTAINERTEMPLATEMASTER",
"select * from PDMLINK.WTDATEDEFFECTIVITY",
"select * from PDMLINK.WTDOCUMENT",
"select * from PDMLINK.WTDOCUMENTCONFIGSPEC",
"select * from PDMLINK.WTDOCUMENTDEPENDENCYLINK",
"select * from PDMLINK.WTDOCUMENTMASTER",
"select * from PDMLINK.WTDOCUMENTMASTERKEY",
"select * from PDMLINK.WTDOCUMENTUSAGELINK",
"select * from PDMLINK.WTGROUP",
"select * from PDMLINK.WTINCORPORATIONDATE",
"select * from PDMLINK.WTLIBRARY",
"select * from PDMLINK.WTLOTEFFECTIVITY",
"select * from PDMLINK.WTMARKUP",
"select * from PDMLINK.WTORGANIZATION",
"select * from PDMLINK.WTPART",
"select * from PDMLINK.WTPARTALTERNATELINK",
"select * from PDMLINK.WTPARTCONFIGSPEC",
"select * from PDMLINK.WTPARTDESCRIBELINK",
"select * from PDMLINK.WTPARTMASTER",
"select * from PDMLINK.WTPARTMASTERKEY",
"select * from PDMLINK.WTPARTREFERENCELINK",
"select * from PDMLINK.WTPARTSUBSTITUTELINK",
"select * from PDMLINK.WTPARTUSAGELINK",
"select * from PDMLINK.WTPIDESCRIBELINK",
"select * from PDMLINK.WTPIREFERENCELINK",
"select * from PDMLINK.WTPRODUCT",
"select * from PDMLINK.WTPRODUCTCONFIGMASTER",
"select * from PDMLINK.WTPRODUCTCONFIGURATION",
"select * from PDMLINK.WTPRODUCTINSTANCE",
"select * from PDMLINK.WTPRODUCTINSTANCE2",
"select * from PDMLINK.WTPRODUCTINSTANCEMASTER",
"select * from PDMLINK.WTPRODUCTMASTER",
"select * from PDMLINK.WTRNREQUEST",
"select * from PDMLINK.WTSERIALNUMBEREDEFFECTIVITY",
"select * from PDMLINK.WTSERIALNUMBEREDPART",
"select * from PDMLINK.WTSERIALNUMBEREDPARTMASTER",
"select * from PDMLINK.WTSNPARTINSTANCE",
"select * from PDMLINK.WTTYPEDEFINITION",
"select * from PDMLINK.WTTYPEDEFINITIONMASTER",
"select * from PDMLINK.WTUNIT",
"select * from PDMLINK.WTUNITMASTER",
"select * from PDMLINK.WTUNITMASTERKEY",
"select * from PDMLINK.WTUPGINST_INCREMENTALUPDATE",
"select * from PDMLINK.WTUPGINST_INSTALLATION",
"select * from PDMLINK.WTUPGINST_UPGRADEPHASE",
"select * from PDMLINK.WTUPGINST_VERSIONEDASSEMBLY",
"select * from PDMLINK.WTUSER",
"select * from PDMLINK.WTVIEW",
"select * from PDMLINK.WVSCONFIGURATIONTEMPLATE"};
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@"+srvrNmStg+":"+portNoStg+":"+sidNmStg,usrNmStg,passWdStg);
Statement stmt = conn.createStatement();
out.println("");
for(int k = 0; k < sqlQueryArr.length; k++)
{
ResultSet rs = stmt.executeQuery(sqlQueryArr[k]);
ResultSetMetaData rm = rs.getMetaData();
int cols = rm.getColumnCount();
out.println("");
out.println("| " + sqlQueryArr[k] + " | " );
for(int j=1; j<=cols; j++) { out.print("" + rm.getColumnName(j) + " | "); }
out.println("
");
}
out.println("
");
}
catch(SQLException e) {
out.println("SQLException: " + e.getMessage() + "
");
while((e = e.getNextException()) != null)
out.println(e.getMessage() + "
");
}
catch(ClassNotFoundException e){
out.println("ClassNotFoundException: " + e.getMessage() + "
");
}
finally {
if(conn != null){
try {
conn.close();
}
catch (Exception ignored) {}
}
}
%>