Purpose of Query
The query on this page provides information on object types stored in the CAST Knowledge Base.
The object type is stored in table OBJTYPSTR of the Knowledge base, with its ID given in the OBJTYPSTR.OBJTYP column and its description given in OBJTYPSTR.OBJTYPSTR
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
Query for CSS
The query below will show the object type information for JSP objects in the local database (KB). For other objects, please modify the query below for the technologies that you desire to query on the local database
SELECT * FROM OBJTYPSTR WHERE OBJTYPSTR LIKE '%JSP%'
Query result example
281;"JSP Application";284;12;"WEB"
972;"JSP EL Function";256;3;"WEB"
286;"JSP Custom Tag Attribute";256;3;"WEB"
Query result interpretation
The query returns the object type id, the object description, and other information in the tables pertaining to the object type.
Query for Oracle
Query result example
Query result interpretation
Query for SQL server
Query result example
Query result interpretation
Notes/comments
Related Pages