Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Problems with customSQL query

    I kind of have the same issue. I have an object

    BusinessLine
    - id
    - name

    ProductLine
    - id
    - name
    - tbl foreignKey

    I got the name of the businessLine to show up on the grid of the productLine by using the customSQL pattern. However, when I tried selecting the filter dropdown list I am getting a "View/Table not found" error.

    Here is my code:


    ListGridField tblField = new ListGridField("tblName", CONSTANTS.tbl(),500);
    tblField.setEditorType(new SelectItem());
    tblField.setFilterEditorType(new ComboBoxItem());
    tblField.setDisplayField("name");

    Do I need to do something on the filter setup?

    TIA,

    #2
    Your problem was unrelated to the thread where you posted it (which was about Hibernate) so we moved it.

    What we need to see is:
    1) your .ds.xml file
    2) the server-side logs for the failing request

    Comment


      #3
      Here is my DS file:

      <DataSource ID="productLine" serverType="sql" tableName="ESD_PRODUCT_LINE">
      <fields>
      <field name="id" type="sequence" primaryKey="true" hidden="true" />
      <field name="name" type="text" required="true" length="200"
      title="Product Line" />
      <field name="tbl" title="Business Line" type="number" required="true"
      foreignKey="tbl.id" detail="true"/>
      <field name="tblName" type="text" customSQL="true" tableName="tbl" />
      </fields>
      <schema>ESD</schema>
      <operationBindings>
      <operationBinding operationType="fetch" customValueFields="tblName" customCriteriaFields="tblName">
      <tableClause>productLine, tbl</tableClause>
      <whereClause>productLine.tbl = tbl.id AND ($defaultWhereClause)</whereClause>
      </operationBinding>
      </operationBindings>
      </DataSource>

      <DataSource ID="tbl" serverType="sql" tableName="ESD_TBL" qualifyColumnNames="false">
      <fields>
      <field name="id" type="sequence" primaryKey="true" sequenceName="ESD_SEQ" hidden="true" />
      <field name="name" type="text" required="true" length="200" title="Business Line"/>
      </fields>
      <schema>ESD</schema>
      <dbName></dbName>
      </DataSource>


      The file look like this without say much about the table it is try to reach?

      15:38:51.878:WARN:RPCManager:ORA-00942: table or view does not exist
      , response: {operationId: "productLine_fetch",
      clientContext: Obj,
      context: Obj,
      transactionNum: 3,
      httpResponseCode: 200,
      httpResponseText: "//isc_RPCResponseStart-->[{isDSResponse:..."[147],
      xmlHttpRequest: Obj,
      transport: "xmlHttpRequest",
      status: -1,
      clientOnly: undef,
      httpHeaders: Obj,
      isStructured: true,
      callbackArgs: null,
      results: Obj,
      isDSResponse: true,
      invalidateCache: false,
      data: "ORA-00942: table or view does not exist
      ",
      startRow: 0,
      endRow: 0,
      totalRows: 0}

      Comment


        #4
        I also have a cross reference mapping table that we use to map data from multiple tables. I tried doing the same customSQL here however this time I am not seeing the name for the reference item showing up.

        Do you have issue with main object and the reference object having the same field name?

        Comment


          #5
          OK, that's 1 of 2. The second thing we needed was the server-side log. This is the "Console" tab if you're using Eclipse. It's got all kinds of very useful diagnostic information and you should be consulting it all the time.

          Comment


            #6
            Here is the console log. It looks to me like the same time of error. I am not seeing anything else.
            Please see attachement.
            Attached Files

            Comment


              #7
              Not sure if you intentionally trimmed this log - if so, please don't do that.

              With normal log settings there is quite a bit more output, including the generated SQL, which is what we want to see. Make sure you have deployed the log4j settings file mentioned in the installation instructions, and that you have not turned off any log categories in this file.

              Comment


                #8
                the reason i remove some log is b/c the file was too big. I did not see any SQL dump on this log. I know I seen these. But if there is flag I need to set to make the log more verbose let me know.

                Comment


                  #9
                  There's no flag. If you followed the installation instructions completely, the log would have more information, including the SQL query.

                  If you're not seeing this information, now is a good time to re-install and make sure you've corrected the situation. The diagnostics shown in the server-side console are critically important.

                  Comment


                    #10
                    I change the setting for the log4j.xml. Please see below.

                    ------------------------------

                    [l0-2] DEBUG RequestContext.debug - Paths for request:
                    Servlet path: '/apt/sc/IDACall'
                    Request URI: '/apt/sc/IDACall'
                    Path Info: 'null'
                    Path Translated: 'null'
                    Real FileSystem Path: 'C:\workspaceESD\sapt\war\apt\sc\IDACall'
                    [l0-2] DEBUG RequestContext.debug - Paths for request:
                    Servlet path: '/apt/sc/IDACall'
                    Request URI: '/apt/sc/IDACall'
                    Path Info: 'null'
                    Path Translated: 'null'
                    Real FileSystem Path: 'C:\workspaceESD\sapt\war\apt\sc\IDACall'
                    [l0-2] INFO RequestContext.info - URL: '/apt/sc/IDACall', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6.6; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; yie8)': MSIE with Accept-Encoding header, ready for compressed JS
                    [l0-2] INFO RequestContext.info - URL: '/apt/sc/IDACall', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6.6; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; yie8)': MSIE with Accept-Encoding header, ready for compressed JS
                    [l0-2] DEBUG Compression.debug - /apt/sc/IDACall: Request looks compressable.
                    [l0-2] DEBUG Compression.debug - /apt/sc/IDACall: Request looks compressable.
                    [l0-2] DEBUG RequestContext.debug - Paths for request:
                    Servlet path: '/apt/sc/IDACall'
                    Request URI: '/apt/sc/IDACall'
                    Path Info: 'null'
                    Path Translated: 'null'
                    Real FileSystem Path: 'C:\workspaceESD\sapt\war\apt\sc\IDACall'
                    [l0-2] DEBUG RequestContext.debug - Paths for request:
                    Servlet path: '/apt/sc/IDACall'
                    Request URI: '/apt/sc/IDACall'
                    Path Info: 'null'
                    Path Translated: 'null'
                    Real FileSystem Path: 'C:\workspaceESD\sapt\war\apt\sc\IDACall'
                    [l0-2] DEBUG RequestContext.debug - Paths for request:
                    Servlet path: '/apt/sc/IDACall'
                    Request URI: '/apt/sc/IDACall'
                    Path Info: 'null'
                    Path Translated: 'null'
                    Real FileSystem Path: 'C:\workspaceESD\sapt\war\apt\sc\IDACall'
                    [l0-2] DEBUG RequestContext.debug - Paths for request:
                    Servlet path: '/apt/sc/IDACall'
                    Request URI: '/apt/sc/IDACall'
                    Path Info: 'null'
                    Path Translated: 'null'
                    Real FileSystem Path: 'C:\workspaceESD\sapt\war\apt\sc\IDACall'
                    [l0-2] DEBUG XML.debug - Parsed XML from (in memory stream): 0ms
                    [l0-2] DEBUG XML.debug - Parsed XML from (in memory stream): 0ms
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (failure): 'transaction' instance of datasources: 0ms
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (failure): 'transaction' instance of datasources: 0ms
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.xsi: value is: http://www.w3.org/2000/10/XMLSchema-instance
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.xsi: value is: http://www.w3.org/2000/10/XMLSchema-instance
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/transactionNum as Object.transactionNum type: long
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/transactionNum as Object.transactionNum type: long
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'List' instance of datasources: 16ms
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'List' instance of datasources: 16ms
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations as Object.operations type: List
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations as Object.operations type: List
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (failure): 'elem' instance of datasources: 0ms
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (failure): 'elem' instance of datasources: 0ms
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/criteria as Object.criteria type: Object
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/criteria as Object.criteria type: Object
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/operationConfig as Object.operationConfig type: Object
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/operationConfig as Object.operationConfig type: Object
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.dataSource: value is: productLine
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.dataSource: value is: productLine
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.operationType: value is: fetch
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.operationType: value is: fetch
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.textMatchStyle: value is: startsWith
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.textMatchStyle: value is: startsWith
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/startRow as Object.startRow type: long
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/startRow as Object.startRow type: long
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/endRow as Object.endRow type: long
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/endRow as Object.endRow type: long
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.componentId: value is: isc_PickListMenu_0
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.componentId: value is: isc_PickListMenu_0
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.appID: value is: builtinApplication
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.appID: value is: builtinApplication
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.operation: value is: productLine_fetch
                    [l0-2] DEBUG Validation.debug - Value provided for unknown field: Object.operation: value is: productLine_fetch
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/oldValues as Object.oldValues type: Object
                    [l0-2] DEBUG Validation.debug - Validating field:
                    /transaction/operations/elem/oldValues as Object.oldValues type: Object
                    [l0-2] DEBUG Timing.debug - DataSource record created from XML with document element: 'transaction': 16ms
                    [l0-2] DEBUG Timing.debug - DataSource record created from XML with document element: 'transaction': 16ms
                    [l0-2] DEBUG RPCManager.debug - Processing 1 requests.
                    [l0-2] DEBUG RPCManager.debug - Processing 1 requests.
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'productLine' instance of datasources: 0ms
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'productLine' instance of datasources: 0ms
                    [l0-2] DEBUG InterfaceProvider.debug - Instantiating com.isomorphic.sql.SQLDataSource to satisfy request for an SQLDataSource
                    [l0-2] DEBUG InterfaceProvider.debug - Instantiating com.isomorphic.sql.SQLDataSource to satisfy request for an SQLDataSource
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Returning pooled Connection
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Returning pooled Connection
                    [l0-2] DEBUG Timing.debug - Time to convert org.apache.commons.collections.map.LinkedMap to JS Object: 0ms
                    [l0-2] DEBUG Timing.debug - Time to convert org.apache.commons.collections.map.LinkedMap to JS Object: 0ms
                    [l0-2] DEBUG RPCManager.debug - Request #1 (DSRequest) payload: {
                    criteria:{
                    },
                    operationConfig:{
                    dataSource:"productLine",
                    operationType:"fetch",
                    textMatchStyle:"startsWith"
                    },
                    startRow:0,
                    endRow:75,
                    componentId:"isc_PickListMenu_0",
                    appID:"builtinApplication",
                    operation:"productLine_fetch",
                    oldValues:{
                    }
                    }
                    [l0-2] DEBUG RPCManager.debug - Request #1 (DSRequest) payload: {
                    criteria:{
                    },
                    operationConfig:{
                    dataSource:"productLine",
                    operationType:"fetch",
                    textMatchStyle:"startsWith"
                    },
                    startRow:0,
                    endRow:75,
                    componentId:"isc_PickListMenu_0",
                    appID:"builtinApplication",
                    operation:"productLine_fetch",
                    oldValues:{
                    }
                    }
                    [l0-2] INFO IDACall.info - Performing 1 operation(s)
                    [l0-2] INFO IDACall.info - Performing 1 operation(s)
                    [l0-2] DEBUG Reflection.debug - adaptArgsAndInvoke:

                    public com.isomorphic.datasource.DSResponse com.halliburton.lgc.esd.server.ProductLineDMI.fetch(com.isomorphic.datasource.DSRequest,javax.servlet.http.HttpServletRequest) throws java.lang.Exception

                    requiredArgs: [] optionalArgs: [com.isomorphic.servlet.RequestContext, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, javax.servlet.ServletContext, javax.servlet.http.HttpSession, com.isomorphic.rpc.RPCManager, com.isomorphic.datasource.DSRequest, com.isomorphic.datasource.DataSource, java.sql.Connection, com.isomorphic.log.Logger, java.util.Map]
                    [l0-2] DEBUG Reflection.debug - adaptArgsAndInvoke:

                    public com.isomorphic.datasource.DSResponse com.halliburton.lgc.esd.server.ProductLineDMI.fetch(com.isomorphic.datasource.DSRequest,javax.servlet.http.HttpServletRequest) throws java.lang.Exception

                    requiredArgs: [] optionalArgs: [com.isomorphic.servlet.RequestContext, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, javax.servlet.ServletContext, javax.servlet.http.HttpSession, com.isomorphic.rpc.RPCManager, com.isomorphic.datasource.DSRequest, com.isomorphic.datasource.DataSource, java.sql.Connection, com.isomorphic.log.Logger, java.util.Map]
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.servlet.RequestContext fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.servlet.RequestContext fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpServletRequest fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpServletRequest fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpServletResponse fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpServletResponse fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.ServletContext fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.ServletContext fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpSession fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpSession fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.rpc.RPCManager fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.rpc.RPCManager fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.datasource.DSRequest fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.datasource.DSRequest fulfills type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - Successfully adapted optional arg type: com.isomorphic.datasource.DSRequest to type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - Successfully adapted optional arg type: com.isomorphic.datasource.DSRequest to type: com.isomorphic.datasource.DSRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.servlet.RequestContext fulfills type: javax.servlet.http.HttpServletRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: com.isomorphic.servlet.RequestContext fulfills type: javax.servlet.http.HttpServletRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpServletRequest fulfills type: javax.servlet.http.HttpServletRequest
                    [l0-2] DEBUG Reflection.debug - checking whether type: javax.servlet.http.HttpServletRequest fulfills type: javax.servlet.http.HttpServletRequest
                    [l0-2] DEBUG Reflection.debug - Successfully adapted optional arg type: javax.servlet.http.HttpServletRequest to type: javax.servlet.http.HttpServletRequest
                    [l0-2] DEBUG Reflection.debug - Successfully adapted optional arg type: javax.servlet.http.HttpServletRequest to type: javax.servlet.http.HttpServletRequest
                    [l0-2] DEBUG Reflection.debug - method takes: 2 args. I've assembled: 2 args
                    [l0-2] DEBUG Reflection.debug - method takes: 2 args. I've assembled: 2 args
                    [l0-2] DEBUG Reflection.debug - invoking method:
                    com.isomorphic.datasource.DSResponse com.halliburton.lgc.esd.server.ProductLineDMI.fetch(com.isomorphic.datasource.DSRequest, javax.servlet.http.HttpServletRequest) throws java.lang.Exception

                    with arg types: com.isomorphic.datasource.DSRequest, com.isomorphic.servlet.ISCHttpServletRequest
                    [l0-2] DEBUG Reflection.debug - invoking method:
                    com.isomorphic.datasource.DSResponse com.halliburton.lgc.esd.server.ProductLineDMI.fetch(com.isomorphic.datasource.DSRequest, javax.servlet.http.HttpServletRequest) throws java.lang.Exception

                    with arg types: com.isomorphic.datasource.DSRequest, com.isomorphic.servlet.ISCHttpServletRequest
                    [l0-2] DEBUG AppBase.debug - [builtinApplication.productLine_fetch] No userTypes defined, allowing anyone access to all operations for this application
                    [l0-2] DEBUG AppBase.debug - [builtinApplication.productLine_fetch] No userTypes defined, allowing anyone access to all operations for this application
                    [l0-2] DEBUG AppBase.debug - [builtinApplication.productLine_fetch] No public zero-argument method named '_productLine_fetch' found, performing generic datasource operation
                    [l0-2] DEBUG AppBase.debug - [builtinApplication.productLine_fetch] No public zero-argument method named '_productLine_fetch' found, performing generic datasource operation
                    [l0-2] DEBUG Timing.debug - [builtinApplication.productLine_fetch] Time to convert org.apache.commons.collections.map.LinkedMap to JS Object: 0ms
                    [l0-2] DEBUG Timing.debug - [builtinApplication.productLine_fetch] Time to convert org.apache.commons.collections.map.LinkedMap to JS Object: 0ms
                    [l0-2] DEBUG Timing.debug - [builtinApplication.productLine_fetch] Time to convert org.apache.commons.collections.map.LinkedMap to JS Object: 0ms
                    [l0-2] DEBUG Timing.debug - [builtinApplication.productLine_fetch] Time to convert org.apache.commons.collections.map.LinkedMap to JS Object: 0ms
                    [l0-2] INFO SQLDataSource.info - [builtinApplication.productLine_fetch] Performing fetch operation with
                    criteria: {sessionId:"zgtbcbw3nlgp"} values: {sessionId:"zgtbcbw3nlgp"}
                    [l0-2] INFO SQLDataSource.info - [builtinApplication.productLine_fetch] Performing fetch operation with
                    criteria: {sessionId:"zgtbcbw3nlgp"} values: {sessionId:"zgtbcbw3nlgp"}
                    [l0-2] INFO SQLDataSource.info - [builtinApplication.productLine_fetch] derived query: SELECT $defaultSelectClause FROM productLine, tbl WHERE productLine.tbl = tbl.id AND ($defaultWhereClause)
                    [l0-2] INFO SQLDataSource.info - [builtinApplication.productLine_fetch] derived query: SELECT $defaultSelectClause FROM productLine, tbl WHERE productLine.tbl = tbl.id AND ($defaultWhereClause)
                    [l0-2] DEBUG SQLDataSource.debug - [builtinApplication.productLine_fetch] Executing row count query: SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND ($defaultWhereClause)
                    [l0-2] DEBUG SQLDataSource.debug - [builtinApplication.productLine_fetch] Executing row count query: SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND ($defaultWhereClause)
                    [l0-2] DEBUG SQLDataSource.debug - [builtinApplication.productLine_fetch] Eval'd row count query: SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND (('1'='1'))
                    [l0-2] DEBUG SQLDataSource.debug - [builtinApplication.productLine_fetch] Eval'd row count query: SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND (('1'='1'))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Returning pooled Connection
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Returning pooled Connection
                    [l0-2] INFO SQLDriver.info - [builtinApplication.productLine_fetch] Executing SQL query on 'ESD': SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND (('1'='1'))
                    [l0-2] INFO SQLDriver.info - [builtinApplication.productLine_fetch] Executing SQL query on 'ESD': SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND (('1'='1'))
                    [l0-2] INFO SQLDriver.info - [builtinApplication.productLine_fetch] Execute of select: SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND (('1'='1')) on db: ESD threw exception: java.sql.SQLException: ORA-00942: table or view does not exist
                    - assuming stale connection and retrying query.
                    [l0-2] INFO SQLDriver.info - [builtinApplication.productLine_fetch] Execute of select: SELECT COUNT(*) FROM productLine, tbl WHERE productLine.tbl = tbl.id AND (('1'='1')) on db: ESD threw exception: java.sql.SQLException: ORA-00942: table or view does not exist
                    - assuming stale connection and retrying query.
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Returning pooled Connection
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - [builtinApplication.productLine_fetch] Returning pooled Connection
                    [l0-2] DEBUG DataSourceDMI.debug - Invocation threw exception
                    java.sql.SQLException: ORA-00942: table or view does not exist

                    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
                    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
                    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
                    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
                    at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4047)
                    at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4187)
                    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1271)
                    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:324)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:267)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:261)
                    at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:354)
                    at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:556)
                    at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1474)
                    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1284)
                    at com.isomorphic.sql.SQLDataSource.execute(SQLDataSource.java:257)
                    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
                    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
                    at com.isomorphic.application.AppBase.execute(AppBase.java:491)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1418)
                    at com.halliburton.lgc.esd.server.ProductLineDMI.fetch(ProductLineDMI.java:26)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:908)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:575)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1415)
                    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:173)
                    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:130)
                    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:95)
                    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:54)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
                    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
                    at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
                    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
                    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
                    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
                    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
                    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.Server.handle(Server.java:324)
                    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
                    at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
                    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
                    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
                    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
                    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
                    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
                    [l0-2] DEBUG DataSourceDMI.debug - Invocation threw exception
                    java.sql.SQLException: ORA-00942: table or view does not exist

                    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
                    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
                    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
                    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
                    at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4047)
                    at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4187)
                    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1271)
                    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:324)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:267)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:261)
                    at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:354)
                    at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:556)
                    at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1474)
                    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1284)
                    at com.isomorphic.sql.SQLDataSource.execute(SQLDataSource.java:257)
                    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
                    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
                    at com.isomorphic.application.AppBase.execute(AppBase.java:491)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1418)
                    at com.halliburton.lgc.esd.server.ProductLineDMI.fetch(ProductLineDMI.java:26)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:908)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:575)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1415)
                    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:173)
                    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:130)
                    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:95)
                    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:54)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
                    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
                    at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
                    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
                    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
                    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
                    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
                    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.Server.handle(Server.java:324)
                    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
                    at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
                    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
                    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
                    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
                    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
                    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
                    [l0-2] WARN RequestContext.warn - dsRequest.execute() failed:
                    java.sql.SQLException: ORA-00942: table or view does not exist

                    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
                    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
                    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
                    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
                    at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4047)
                    at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4187)
                    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1271)
                    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:324)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:267)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:261)
                    at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:354)
                    at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:556)
                    at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1474)
                    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1284)
                    at com.isomorphic.sql.SQLDataSource.execute(SQLDataSource.java:257)
                    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
                    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
                    at com.isomorphic.application.AppBase.execute(AppBase.java:491)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1418)
                    at com.halliburton.lgc.esd.server.ProductLineDMI.fetch(ProductLineDMI.java:26)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:908)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:575)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1415)
                    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:173)
                    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:130)
                    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:95)
                    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:54)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
                    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
                    at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
                    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
                    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
                    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
                    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
                    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.Server.handle(Server.java:324)
                    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
                    at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
                    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
                    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
                    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
                    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
                    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
                    [l0-2] WARN RequestContext.warn - dsRequest.execute() failed:
                    java.sql.SQLException: ORA-00942: table or view does not exist

                    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
                    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
                    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
                    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
                    at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4047)
                    at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4187)
                    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1271)
                    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:324)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:267)
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:261)
                    at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:354)
                    at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:556)
                    at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1474)
                    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1284)
                    at com.isomorphic.sql.SQLDataSource.execute(SQLDataSource.java:257)
                    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
                    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
                    at com.isomorphic.application.AppBase.execute(AppBase.java:491)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1418)
                    at com.halliburton.lgc.esd.server.ProductLineDMI.fetch(ProductLineDMI.java:26)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:908)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:575)
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1415)
                    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:173)
                    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:130)
                    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:95)
                    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:54)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
                    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
                    at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
                    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
                    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
                    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
                    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
                    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
                    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
                    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
                    at org.mortbay.jetty.Server.handle(Server.java:324)
                    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
                    at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
                    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
                    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
                    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
                    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
                    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
                    [l0-2] DEBUG RequestContext.debug - Setting headers to disable caching
                    [l0-2] DEBUG RequestContext.debug - Setting headers to disable caching
                    [l0-2] DEBUG RPCManager.debug - Content type for RPC transaction: text/plain; charset=UTF-8
                    [l0-2] DEBUG RPCManager.debug - Content type for RPC transaction: text/plain; charset=UTF-8
                    [l0-2] DEBUG RequestContext.debug - Getting output stream via servletResponse.getWriter()
                    [l0-2] DEBUG RequestContext.debug - Getting output stream via servletResponse.getWriter()
                    [l0-2] DEBUG ProxyHttpServletResponse.debug - Using charset: UTF-8 (CompressionFilter)
                    [l0-2] DEBUG ProxyHttpServletResponse.debug - Using charset: UTF-8 (CompressionFilter)
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'productLine' instance of datasources: 16ms
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'productLine' instance of datasources: 16ms
                    [l0-2] DEBUG InterfaceProvider.debug - Instantiating com.isomorphic.sql.SQLDataSource to satisfy request for an SQLDataSource
                    [l0-2] DEBUG InterfaceProvider.debug - Instantiating com.isomorphic.sql.SQLDataSource to satisfy request for an SQLDataSource
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Returning pooled Connection
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Returning pooled Connection
                    [l0-2] DEBUG RPCManager.debug - non-DMI response, dropExtraFields: false
                    [l0-2] DEBUG RPCManager.debug - non-DMI response, dropExtraFields: false
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'productLine' instance of datasources: 0ms
                    [l0-2] DEBUG DataStructCache.debug - getInstanceFile (success): 'productLine' instance of datasources: 0ms
                    [l0-2] DEBUG InterfaceProvider.debug - Instantiating com.isomorphic.sql.SQLDataSource to satisfy request for an SQLDataSource
                    [l0-2] DEBUG InterfaceProvider.debug - Instantiating com.isomorphic.sql.SQLDataSource to satisfy request for an SQLDataSource
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - DriverManager fetching connection for ESD via jdbc url jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = np1psdb701-vip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = CRMQ.lgc.com)))
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Passing credentials getConnection separately from JDBC URL
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Returning pooled Connection
                    [l0-2] DEBUG PoolableSQLConnectionFactory.debug - Returning pooled Connection
                    [l0-2] DEBUG Timing.debug - Time to convert java.util.ArrayList to JS Object: 0ms
                    [l0-2] DEBUG Timing.debug - Time to convert java.util.ArrayList to JS Object: 0ms
                    [l0-2] DEBUG Timing.debug - Request: /apt/sc/IDACall (start->finish): 688ms
                    [l0-2] DEBUG Timing.debug - Request: /apt/sc/IDACall (start->finish): 688ms
                    [l0-2] DEBUG Compression.debug - /apt/sc/IDACall: Using upstream-specified mime type: text/plain; charset=UTF-8 (container-derived mime type was: null)
                    [l0-2] DEBUG Compression.debug - /apt/sc/IDACall: Using upstream-specified mime type: text/plain; charset=UTF-8 (container-derived mime type was: null)
                    [l0-2] INFO Compression.info - /apt/sc/IDACall: 147 -> 141 bytes
                    [l0-2] INFO Compression.info - /apt/sc/IDACall: 147 -> 141 bytes

                    Comment


                      #11
                      OK, now you've turned on DEBUG logging everywhere and also appear to have done something that doubles all logs. Really, just use the file that comes with the SDK - the logging levels in that file provide just the right level of detail for normal development.

                      As far as the error, Oracle is saying that one of referenced tables (either "productLine" or "tbl") doesn't exist. The most likely cause is that the table really doesn't exist (eg you spelled the name wrong), you've provided credentials for a user that can't access the table, or the table is in a namespace different from where your JDBC URL is placing you.

                      Comment


                        #12
                        Do you have anything new on this subject. Aparently the query for the grid work but once I click on the filter for the foreign key I am getting this view not found error?

                        Thanks

                        Comment


                          #13
                          Hi,
                          Apparently with this setup the fetch for the grid work with the foreign key data showing up. However, when I click on the the dropdown for the filter, it is tell me that the view or table is not found. If you look at the log it seem like it is trying the same table/view for the grid?

                          TIA,

                          Comment


                            #14
                            You're getting a pretty clear error from Oracle here that the table doesn't exist - not sure what more we can do to help?

                            The only thing that we can suggest is that maybe you've got two sets of database settings - perhaps you used the Admin Console to define two sets of connection settings and one DataSource is using one set while the other DataSource is using a different set.

                            Comment


                              #15
                              I finally got the filter foreign key and header filter to work out now. However, I want to know how I can narrow down my filter selection. Anotherword, my current filter selection have repeating data. I am assuming the data comes from the one to many relationship from the grid. Should there be a simple way to tell the filter comboBox to allow only unique value/key?

                              TIA,

                              Comment

                              Working...
                              X