<%@ 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("" ); for(int j=1; j<=cols; j++) { out.print(""); } out.println(""); } out.println("
" + sqlQueryArr[k] + "" + rm.getColumnName(j) + "
"); } 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) {} } } %>