DBJettJT Java Swing (with JTable) for SQL Query of a Windchill, Oracle or Intralink Database. Used to query Windchill/PdmLink, Oracle or Intralink for standard info(same as above JSP Query, but this is a java application & output can go to html, txt (text),cvs, etc): WTPARTMASTER, WTDOCUMENTMASTER, WTORGANIZATION, EPMWORKSPACE, WFPROCESS, CONTAINERTEAM, WTGROUP, WTLIBRARY, WTUSER, etc. ========== Sample SQL Query to show all windchill Tables (Table_Name) select TABLE_NAME from dba_tables where owner='WCUSER' http://windchill.datajett.com/wc_dev/WC_Table_Name.htm This code assumes windchill schema/owner of WCUSER (easily adjusted with modification in textarea for sql input) ==================== Sample Windchill Database SQL Queries: WCUSER.CABINET - select NAME,DESCRIPTION from WCUSER.CABINET WCUSER.CONTAINERTEAM - select NAME from WCUSER.CONTAINERTEAM WCUSER.DATAFORMAT - select FORMATNAME,DESCRIPTION,MIMETYPE from WCUSER.DATAFORMAT WCUSER.EPMWORKSPACE - select NAME,DESCRIPTION from WCUSER.EPMWORKSPACE WCUSER.FVFOLDER - select * from WCUSER.FVFOLDER WCUSER.FVITEM - select * from WCUSER.FVITEM WCUSER.WTDOCUMENTMASTER - select NAME,WTDOCUMENTNUMBER from WCUSER.WTDOCUMENTMASTER WCUSER.WTGROUP - select NAME from WCUSER.WTGROUP WCUSER.WTLIBRARY - select NAMECONTAINERINFO from WCUSER.WTLIBRARY WCUSER.WTORGANIZATION - select * from WCUSER.WTORGANIZATION WCUSER.WTPARTMASTER - select NAME,WTPARTNUMBER from WCUSER.WTPARTMASTER WCUSER.WTPRODUCT - select * from WCUSER.WTPRODUCT WCUSER.WTPRODUCTMASTER - select NAME,WTPARTNUMBER from WCUSER.WTPRODUCTMASTER WCUSER.WTUSER - select NAME,IDA2A2 from WCUSER.WTUSER WCUSER.WTVIEW - select * from WCUSER.WTVIEW WCUSER.WFPROCESS - select * from WCUSER.WFPROCESS  Functional Combo SQL Query: SELECT WTU.NAME, WFP.NAME, WTU.IDA2A2  FROM wcuser.WFPROCESS WFP, wcuser.WTUSER WTU  WHERE WTU.IDA2A2=WFP.IDA3B7 order by WTU.NAME Combines usage of WFPROCESS & WTUSER: Shows all users change management (CMII) workflow entries. ************************************************************************ Zip Download: DBJettJT.zip You need to have the java in the path environment variable. You need these files/folders included in your CLASSPATH environment variable 1) DBJettJT classes 2) java /bin & /lib folders 3) proper jdbc classes zip 4) folder where DBJettJT classes are located. You also need to include the java /bin & /lib folders in your PATH environment variable You can download with this link: classes12.zip CD /D D:/wc/DEV/DBJettJT (or whatever folder you place classes in) set PATH=%PATH%;./;D:\j2sdk1.4.2_12\bin;D:\j2sdk1.4.2_12\lib set CLASSPATH=%CLASSPATH%;./;.\classes12.zip;D:\j2sdk1.4.2_12\bin;D:\j2sdk1.4.2_12\lib java -mx1024m DBJettJT -h <hostname> -p 1521 -s wind -mx1024m = max heap (since some queries can really use up the heap) -h <hostname> -p port -s sid The wind_run.bat dos bat with all the above settings & java run command are included in the DBJettJT.zip.