Announcement

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

    Foreign key conundrum (2)

    I am posting a new entry for an old problem. The original was in the wrong forum. Also, I have been adding replies as I experimented with solutions. So, I may have been messing with the Maximum Response Time calculation. It is way past 3 days.

    I appreciate the confidence in me that I will solve my problem by myself. But, I think that won't happen in this case.

    For the record, I am running SmartClient Version: SC_SNAPSHOT-2012-01-09_v8.2p/Pro Development Only (built 2012-01-09) on Mozilla Firefox 3.6.18 with Firebug using Windows XP Pro 32 bit.

    I have attached the Database definition SQL, the application xml, and datasource xml involved.

    Help would be appreciated as this problem has become a road block.

    Please let me know what else I can do or give to diagnose the problem.
    Attached Files

    #2
    Not sure why you are referring to maximum response time - you have not purchased support.

    As far as your old thread, if you hope for Isomorphic or community members to chime in, you need to take elementary troubleshooting steps yourself, and report results. For example, you're not mentioning whether you're seeing server requests to the optionDataSource, whether you've looked in the RPC tab to see if the data is correct and matched it up with values from the main dataset, etc.

    Comment


      #3
      Good point on the support. It is in my future, but things right now have to be done on the lean.

      I agree I need to post more of my results. They are more notable in what they lack. I don't see any RPC tab entries.

      So, here is the listgrid.
      Code:
      <ListGrid dataSource="ref:Task" ID="ListGrid0" autoDraw="false">
          <fields>
              <ListGridField name="PROJECTID" title="Project#">
                  <type>text</type>
                  <optionDataSource>Project</optionDataSource>
                  <valueField>PROJECTID</valueField>
                  <displayField>PROJECTNUMBER</displayField>
                  <autoFetchDisplayMap>false</autoFetchDisplayMap>
              </ListGridField>
              <ListGridField name="OWNERID" title="Owner">
                  <optionDataSource>TeamMember</optionDataSource>
                  <valueField>TEAMMEMBERID</valueField>
                  <displayField>TEAMMEMBERNAME</displayField>
              </ListGridField>
              <ListGridField name="ISSUEID" title="Issue Title"/>
              <ListGridField name="TASKNUMBER" title="Task#"/>
              <ListGridField name="STATUS" title="Status"/>
              <ListGridField name="TASKTITLE" title="Task Title"/>
              <ListGridField name="DUEDATE" title="Due"/>
              <ListGridField name="COMPLETEDDATE" title="Completed"/>
              <ListGridField name="ORIGINALDUEDATE" title="Original Due"/>
              <ListGridField name="STARTDATE" title="Start"/>
              <ListGridField name="DESC" title="Description"/>
              <ListGridField name="LOG" title="Log"/>
              <ListGridField name="CREATED" title="Created"/>
              <ListGridField name="MODIFIED" title="Modified"/>
          </fields>
          <autoFetchData>true</autoFetchData>
      </ListGrid>
      And, here is the server log I see as it loads. I look at the whole log and do not find any references showing the fetching of PROJECTNUMBER, for example. I surmise that I have left out some link to kick the FK fetch into action. I just don't know what it is.

      Code:
      === 2012-02-02 14:35:10,359 [sor6] DEBUG AppBase - [builtinApplication.Filesystem_fetch] No userTypes defined, allowing anyo
      ne access to all operations for this application
      === 2012-02-02 14:35:10,375 [sor6] DEBUG AppBase - [builtinApplication.Filesystem_fetch] No public zero-argument method name
      d '_Filesystem_fetch' found, performing generic datasource operation
      === 2012-02-02 14:35:10,375 [sor6] DEBUG FilesystemDataSource - [builtinApplication.Filesystem_fetch] returnContent is: fals
      e
      === 2012-02-02 14:35:10,375 [sor6] DEBUG FilesystemDataSource - [builtinApplication.Filesystem_fetch] listing files at: /iso
      morphic/../tools/visualBuilder/workspace
      === 2012-02-02 14:35:10,390 [sor1] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2012-02-02 14:35:10,406 [sor2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2012-02-02 14:35:10,421 [sor1] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      === 2012-02-02 14:35:10,421 [sor2] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      === 2012-02-02 14:35:10,437 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/AssociateApp.xml
      === 2012-02-02 14:35:10,453 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/demoAppXML.xml
      === 2012-02-02 14:35:10,453 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/isc_test.xml
      === 2012-02-02 14:35:10,468 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/AutoSave.xml
      === 2012-02-02 14:35:10,468 [sor6] INFO  DSResponse - [builtinApplication.Filesystem_fetch] DSResponse: List with 4 items
      === 2012-02-02 14:35:10,468 [sor6] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2012-02-02 14:35:10,484 [sor6] WARN  DSResponse - Attempted to call getRecord() on a DSResponse with null DataSource
      === 2012-02-02 14:35:10,578 [sor1] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/Dialog/say.png', User-Ag
      ent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-E
      ncoding header
      === 2012-02-02 14:35:10,656 [sor6] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      === 2012-02-02 14:35:10,703 [sor2] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_st
      art.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gec
      ko) with Accept-Encoding header
      === 2012-02-02 14:35:10,921 [sor3] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_en
      d.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko
      ) with Accept-Encoding header
      === 2012-02-02 14:35:10,953 [sor6] INFO  RequestContext - URL: '/tools/visualBuilder/vbOperations.jsp', User-Agent: 'Mozilla
      /5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Encoding heade
      r
      === 2012-02-02 14:35:10,968 [sor6] DEBUG XML - Parsed XML from (in memory stream): 15ms
      === 2012-02-02 14:35:10,968 [sor4] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_st
      retch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (G
      ecko) with Accept-Encoding header
      === 2012-02-02 14:35:11,015 [sor2] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_start.png
      === 2012-02-02 14:35:11,046 [sor6] DEBUG RPCManager - Processing 1 requests.
      === 2012-02-02 14:35:11,046 [sor3] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_end.png
      === 2012-02-02 14:35:11,062 [sor6] DEBUG RPCManager - Request #1 (DSRequest) payload: {
          criteria:{
              fileFilter:".xml$",
              parentID:"[VBWORKSPACE]"
          },
          operationConfig:{
              dataSource:"Filesystem",
              operationType:"fetch",
              textMatchStyle:"substring"
          },
          startRow:0,
          endRow:75,
          sortBy:[
              "name"
          ],
          componentId:"isc_TSaveFileDialog_0_directoryListing",
          appID:"builtinApplication",
          operation:"Filesystem_fetch",
          oldValues:{
              fileFilter:".xml$",
              parentID:"[VBWORKSPACE]"
          }
      }
      === 2012-02-02 14:35:11,125 [sor6] DEBUG AppBase - [builtinApplication.Filesystem_fetch] No userTypes defined, allowing anyo
      ne access to all operations for this application
      === 2012-02-02 14:35:11,125 [sor6] DEBUG AppBase - [builtinApplication.Filesystem_fetch] No public zero-argument method name
      d '_Filesystem_fetch' found, performing generic datasource operation
      === 2012-02-02 14:35:11,125 [sor6] DEBUG FilesystemDataSource - [builtinApplication.Filesystem_fetch] returnContent is: fals
      e
      === 2012-02-02 14:35:11,140 [sor6] DEBUG FilesystemDataSource - [builtinApplication.Filesystem_fetch] listing files at: /iso
      morphic/../tools/visualBuilder/workspace
      === 2012-02-02 14:35:11,140 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_stretch.png
      === 2012-02-02 14:35:11,171 [sor1] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/Dialog/say.png
      === 2012-02-02 14:35:11,203 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/isc_test.xml
      === 2012-02-02 14:35:11,218 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/AutoSave.xml
      === 2012-02-02 14:35:11,218 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/ProjectManagerApp.xml
      === 2012-02-02 14:35:11,234 [sor8] INFO  RequestContext - URL: '/tools/visualBuilder/vbOperations.jsp', User-Agent: 'Mozilla
      /5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Encoding heade
      r
      === 2012-02-02 14:35:11,250 [sor8] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2012-02-02 14:35:11,265 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/AssociateApp.xml
      === 2012-02-02 14:35:11,265 [sor8] DEBUG RPCManager - Processing 1 requests.
      === 2012-02-02 14:35:11,281 [sor6] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/demoAppXML.xml
      === 2012-02-02 14:35:11,281 [sor8] DEBUG RPCManager - Request #1 (DSRequest) payload: {
          criteria:{
              fileFilter:".xml$",
              parentID:"[VBWORKSPACE]"
          },
          operationConfig:{
              dataSource:"Filesystem",
              operationType:"fetch",
              textMatchStyle:"substring"
          },
          startRow:0,
          endRow:75,
          sortBy:[
              "name"
          ],
          componentId:"isc_TLoadFileDialog_0_directoryListing",
          appID:"builtinApplication",
          operation:"Filesystem_fetch",
          oldValues:{
              fileFilter:".xml$",
              parentID:"[VBWORKSPACE]"
          }
      }
      === 2012-02-02 14:35:11,343 [sor8] DEBUG AppBase - [builtinApplication.Filesystem_fetch] No userTypes defined, allowing anyo
      ne access to all operations for this application
      === 2012-02-02 14:35:11,359 [sor8] DEBUG AppBase - [builtinApplication.Filesystem_fetch] No public zero-argument method name
      d '_Filesystem_fetch' found, performing generic datasource operation
      === 2012-02-02 14:35:11,359 [sor8] DEBUG FilesystemDataSource - [builtinApplication.Filesystem_fetch] returnContent is: fals
      e
      === 2012-02-02 14:35:11,359 [sor8] DEBUG FilesystemDataSource - [builtinApplication.Filesystem_fetch] listing files at: /iso
      morphic/../tools/visualBuilder/workspace
      === 2012-02-02 14:35:11,375 [sor6] INFO  DSResponse - [builtinApplication.Filesystem_fetch] DSResponse: List with 5 items
      === 2012-02-02 14:35:11,375 [sor6] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2012-02-02 14:35:11,375 [sor6] WARN  DSResponse - Attempted to call getRecord() on a DSResponse with null DataSource
      === 2012-02-02 14:35:11,390 [sor6] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      === 2012-02-02 14:35:11,406 [sor8] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/isc_test.xml
      === 2012-02-02 14:35:11,421 [sor8] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/AutoSave.xml
      === 2012-02-02 14:35:11,437 [sor8] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/ProjectManagerApp.xml
      === 2012-02-02 14:35:11,437 [sor8] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/AssociateApp.xml
      === 2012-02-02 14:35:11,437 [sor8] WARN  FilesystemDataSource - [builtinApplication.Filesystem_fetch] using path: /tools/vis
      ualBuilder/workspace/demoAppXML.xml
      === 2012-02-02 14:35:11,468 [sor8] INFO  DSResponse - [builtinApplication.Filesystem_fetch] DSResponse: List with 5 items
      === 2012-02-02 14:35:11,484 [sor8] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2012-02-02 14:35:11,500 [sor8] WARN  DSResponse - Attempted to call getRecord() on a DSResponse with null DataSource
      === 2012-02-02 14:35:11,500 [sor8] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      === 2012-02-02 14:35:23,843 [sor2] INFO  RequestContext - URL: '/tools/visualBuilder/workspace/ProjectManagerApp.jsp', User-
      Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept
      -Encoding header
      === 2012-02-02 14:35:27,843 [sor2] DEBUG LoadISCTag - isomorphicURI not specified in tag, defaulting to: ../../../isomorphic
      /
      === 2012-02-02 14:35:27,859 [sor2] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2012-02-02 14:35:27,968 [sor2] INFO  JSSyntaxScannerFilter - /tools/visualBuilder/workspace/ProjectManagerApp.jsp: scann
      ing <script> tags in html output
      === 2012-02-02 14:35:28,796 [sor4] INFO  RequestContext - URL: '/isomorphic/system/modules/ISC_Forms.js', User-Agent: 'Mozil
      la/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Encoding hea
      der
      === 2012-02-02 14:35:29,031 [sor4] INFO  Download - Using gzipped form of request file: D:/My Websites/SmartClient/isomorphi
      c/system/modules/ISC_Forms.js
      === 2012-02-02 14:35:29,187 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/system/modules/ISC
      _Forms.js
      === 2012-02-02 14:35:29,796 [sor3] INFO  RequestContext - URL: '/isomorphic/system/modules/ISC_Drawing.js', User-Agent: 'Moz
      illa/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Encoding h
      eader
      === 2012-02-02 14:35:29,859 [sor3] INFO  Download - Using gzipped form of request file: D:/My Websites/SmartClient/isomorphi
      c/system/modules/ISC_Drawing.js
      === 2012-02-02 14:35:29,875 [sor3] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/system/modules/ISC
      _Drawing.js
      === 2012-02-02 14:35:30,109 [sor1] INFO  RequestContext - URL: '/isomorphic/system/modules/ISC_Analytics.js', User-Agent: 'M
      ozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Encoding
       header
      === 2012-02-02 14:35:30,125 [sor1] INFO  Download - File D:/My Websites/SmartClient/isomorphic/system/modules/ISC_Analytics.
      js not found, sending 404
      === 2012-02-02 14:35:30,203 [sor6] INFO  RequestContext - URL: '/isomorphic/system/modules/ISC_DocViewer.js', User-Agent: 'M
      ozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Encoding
       header
      === 2012-02-02 14:35:30,203 [sor6] INFO  Download - File D:/My Websites/SmartClient/isomorphic/system/modules/ISC_DocViewer.
      js not found, sending 404
      === 2012-02-02 14:35:30,250 [sor8] INFO  RequestContext - URL: '/isomorphic/system/modules/ISC_VisualBuilder.js', User-Agent
      : 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Enco
      ding header
      === 2012-02-02 14:35:30,281 [sor8] INFO  Download - File D:/My Websites/SmartClient/isomorphic/system/modules/ISC_VisualBuil
      der.js not found, sending 404
      === 2012-02-02 14:35:30,937 [sor2] INFO  RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows; U;
      Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) with Accept-Encoding header
      === 2012-02-02 14:35:30,937 [sor2] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2012-02-02 14:35:30,968 [sor2] DEBUG RPCManager - Processing 1 requests.
      === 2012-02-02 14:35:30,968 [sor2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
          criteria:{
          },
          operationConfig:{
              dataSource:"Task",
              operationType:"fetch",
              textMatchStyle:"substring"
          },
          startRow:0,
          endRow:75,
          componentId:"ListGrid0",
          appID:"builtinApplication",
          operation:"Task_fetch",
          oldValues:{
          }
      }
      === 2012-02-02 14:35:31,015 [sor2] INFO  IDACall - Performing 1 operation(s)
      === 2012-02-02 14:35:31,015 [sor2] DEBUG AppBase - [builtinApplication.Task_fetch] No userTypes defined, allowing anyone acc
      ess to all operations for this application
      === 2012-02-02 14:35:31,015 [sor2] DEBUG AppBase - [builtinApplication.Task_fetch] No public zero-argument method named '_Ta
      sk_fetch' found, performing generic datasource operation
      === 2012-02-02 14:35:31,031 [sor2] INFO  SQLDataSource - [builtinApplication.Task_fetch] Performing fetch operation with
              criteria: {}    values: {}
      === 2012-02-02 14:35:31,031 [sor2] INFO  SQLWhereClause - [builtinApplication.Task_fetch] empty condition
      === 2012-02-02 14:35:31,031 [sor2] INFO  SQLDataSource - [builtinApplication.Task_fetch] derived query: SELECT $defaultSelec
      tClause FROM $defaultTableClause WHERE $defaultWhereClause
      === 2012-02-02 14:35:31,046 [sor2] DEBUG SQLDataSource - [builtinApplication.Task_fetch] Executing row count query: SELECT C
      OUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
      === 2012-02-02 14:35:31,046 [sor2] DEBUG SQLDataSource - [builtinApplication.Task_fetch] Eval'd row count query: SELECT COUN
      T(*) FROM PUBLIC.Task WHERE ('1'='1')
      === 2012-02-02 14:35:31,046 [sor2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] DriverManager fetchi
      ng connection for PlanetProjectDB via jdbc url jdbc:hsqldb:file:D:\My Websites\smartclient/WEB-INF/db/hsqldb/PlanetProjectDB
      
      === 2012-02-02 14:35:31,062 [sor2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Passing JDBC URL onl
      y to getConnection
      === 2012-02-02 14:35:31,062 [sor2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Returning pooled Con
      nection
      === 2012-02-02 14:35:31,078 [sor2] INFO  SQLDriver - [builtinApplication.Task_fetch] Executing SQL query on 'PlanetProjectDB
      ': SELECT COUNT(*) FROM PUBLIC.Task WHERE ('1'='1')
      === 2012-02-02 14:35:31,078 [sor2] DEBUG SQLDataSource - [builtinApplication.Task_fetch] Using SQL Limit query
      === 2012-02-02 14:35:31,078 [sor2] DEBUG SQLDataSource - [builtinApplication.Task_fetch] SQL windowed select rows 0->75, res
      ult size 75. Query: SELECT LIMIT 0 75  Task.COMMUNITYID, Task.COMPLETEDDATE, Task.CREATED, Task.DESC, Task.DUEDATE, Task.ISS
      UEID, Task.LOG, Task.MODIFIED, Task.ORIGINALDUEDATE, Task.OWNERID, Task.PROJECTID, Task.STARTDATE, Task.STATUS, Task.TASKID,
       Task.TASKNUMBER, Task.TASKTITLE FROM PUBLIC.Task WHERE ('1'='1')
      === 2012-02-02 14:35:31,093 [sor2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] DriverManager fetchi
      ng connection for PlanetProjectDB via jdbc url jdbc:hsqldb:file:D:\My Websites\smartclient/WEB-INF/db/hsqldb/PlanetProjectDB
      
      === 2012-02-02 14:35:31,093 [sor2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Passing JDBC URL onl
      y to getConnection
      === 2012-02-02 14:35:31,109 [sor2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Returning pooled Con
      nection
      === 2012-02-02 14:35:31,109 [sor2] INFO  DSResponse - [builtinApplication.Task_fetch] DSResponse: List with 5 items
      === 2012-02-02 14:35:31,109 [sor2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2012-02-02 14:35:31,125 [sor2] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      === 2012-02-02 14:35:37,609 [sor4] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Over_start
      .png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko)
       with Accept-Encoding header
      === 2012-02-02 14:35:37,625 [sor1] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Over_end.p
      ng', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) w
      ith Accept-Encoding header
      === 2012-02-02 14:35:37,640 [sor3] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Over_stret
      ch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Geck
      o) with Accept-Encoding header
      === 2012-02-02 14:35:37,703 [sor1] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Over_end.png
      === 2012-02-02 14:35:37,718 [sor3] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Over_stretch.png
      === 2012-02-02 14:35:37,718 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Over_start.png
      === 2012-02-02 14:35:40,203 [sor3] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_Do
      wn_end.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (
      Gecko) with Accept-Encoding header
      === 2012-02-02 14:35:40,203 [sor4] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_Do
      wn_stretch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': M
      oz (Gecko) with Accept-Encoding header
      === 2012-02-02 14:35:40,218 [sor1] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_Do
      wn_start.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz
       (Gecko) with Accept-Encoding header
      === 2012-02-02 14:35:40,234 [sor2] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_Ov
      er_end.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (
      Gecko) with Accept-Encoding header
      === 2012-02-02 14:35:40,234 [sor8] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_Ov
      er_stretch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': M
      oz (Gecko) with Accept-Encoding header
      === 2012-02-02 14:35:40,250 [sor6] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/button/button_Focused_Ov
      er_start.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz
       (Gecko) with Accept-Encoding header
      === 2012-02-02 14:35:40,375 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_Down_stretch.png
      === 2012-02-02 14:35:40,390 [sor2] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_Over_end.png
      === 2012-02-02 14:35:40,406 [sor3] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_Down_end.png
      === 2012-02-02 14:35:40,406 [sor6] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_Over_start.png
      === 2012-02-02 14:35:40,421 [sor1] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_Down_start.png
      === 2012-02-02 14:35:40,421 [sor8] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/button/button_Focused_Over_stretch.png
      === 2012-02-02 14:35:40,984 [sor4] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/controls/selectPicker_Over
      .gif', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko)
       with Accept-Encoding header
      === 2012-02-02 14:35:41,031 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/controls/selectPicker_Over.gif
      === 2012-02-02 14:36:29,484 [sor2] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/SectionHeader/opener_Ove
      r_opened.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz
       (Gecko) with Accept-Encoding header
      === 2012-02-02 14:41:41,828 [or13] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Selected_Ove
      r_start.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz
      (Gecko) with Accept-Encoding header
      === 2012-02-02 14:41:41,796 [or14] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Selected_Ove
      r_stretch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Mo
      z (Gecko) with Accept-Encoding header
      === 2012-02-02 14:41:41,781 [or15] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Selected_Ove
      r_end.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (G
      ecko) with Accept-Encoding header
      === 2012-02-02 14:41:41,734 [or16] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Over_end.png
      ', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) wit
      h Accept-Encoding header
      === 2012-02-02 14:41:41,734 [sor9] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Over_start.p
      ng', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) w
      ith Accept-Encoding header
      === 2012-02-02 14:41:41,593 [or10] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Over_stretch
      .png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko)
       with Accept-Encoding header
      === 2012-02-02 14:41:14,578 [or11] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Selected_Ove
      r_start.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz
      (Gecko) with Accept-Encoding header
      === 2012-02-02 14:41:14,562 [sor8] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Selected_Ove
      r_stretch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Mo
      z (Gecko) with Accept-Encoding header
      === 2012-02-02 14:41:14,531 [sor6] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Selected_Ove
      r_end.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (G
      ecko) with Accept-Encoding header
      === 2012-02-02 14:41:13,859 [sor1] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Over_stretch
      .png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko)
       with Accept-Encoding header
      === 2012-02-02 14:41:13,843 [sor3] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Over_start.p
      ng', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) w
      ith Accept-Encoding header
      === 2012-02-02 14:41:13,796 [sor4] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/tTabs/top/tab_Over_end.png
      ', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Gecko) wit
      h Accept-Encoding header
      === 2012-02-02 14:36:29,578 [sor5] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/SectionHeader/header_Ove
      r_opened_end.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18':
       Moz (Gecko) with Accept-Encoding header
      === 2012-02-02 14:36:29,546 [sor7] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/SectionHeader/header_Ove
      r_opened_start.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18
      ': Moz (Gecko) with Accept-Encoding header
      === 2012-02-02 14:36:29,515 [or12] INFO  RequestContext - URL: '/isomorphic/skins/SilverWave/images/SectionHeader/header_Ove
      r_opened_stretch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.
      18': Moz (Gecko) with Accept-Encoding header
      === 2012-02-02 14:42:28,046 [sor2] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/SectionHeader/opener_Over_opened.png
      === 2012-02-02 14:42:28,062 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Over_end.png
      === 2012-02-02 14:42:28,062 [sor8] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Selected_Over_stretch.png
      === 2012-02-02 14:42:28,078 [sor3] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Over_start.png
      === 2012-02-02 14:42:28,078 [or15] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Selected_Over_end.png
      === 2012-02-02 14:42:28,093 [sor9] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Over_start.png
      === 2012-02-02 14:42:28,109 [sor6] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Selected_Over_end.png
      === 2012-02-02 14:42:28,109 [or13] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Selected_Over_start.png
      === 2012-02-02 14:42:28,125 [or14] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Selected_Over_stretch.png
      === 2012-02-02 14:42:28,125 [or10] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Over_stretch.png
      === 2012-02-02 14:42:28,156 [or16] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Over_end.png
      === 2012-02-02 14:42:28,156 [sor7] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/SectionHeader/header_Over_opened_start.png
      === 2012-02-02 14:42:28,171 [or12] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/SectionHeader/header_Over_opened_stretch.png
      === 2012-02-02 14:42:28,171 [sor5] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/SilverWave/i
      mages/SectionHeader/header_Over_opened_end.png
      === 2012-02-02 14:42:28,296 [or11] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Selected_Over_start.png
      === 2012-02-02 14:42:28,312 [sor1] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
      ges/tTabs/top/tab_Over_stretch.png
      I appreciate the help I get. I see other posts. Y'all are very good at it.

      Comment


        #4
        Uhh you set autoFetchDisplayMap to false. So you're telling the system not to fetch, explicitly.

        Comment


          #5
          My bad example. I tried a lot of configurations, turning autoFetchDisplayMap off and on. I uploaded the stuff with them all off. Oops.

          When they are all turned ON they still don't work.

          Attached is the server log from a run with the three of them set to true. It starts from loading the listgrid. The developer console does not show any RPC activity. I don't see any fetches for the FK fields. I don't even find their names when I scan the whole log.

          So, I must have really hosed something.

          Thanks for the quick look, by the way.
          Attached Files

          Comment


            #6
            I wonder if I have messed up my install. I seem to be going downhill. I got some of the foreign key fields working before. I just cannot seem to get the combination of parameters I thought were working to work again.

            Also, VB is starting to hang more often when it opens a datasource for editing.

            At one point I copied the SDK folder files on top of existing files to retain the artifacts I had created, like applications and datasources and databases. If reinstalling a more recent release might help I am open to trying that.

            I can move my artifacts out of the way and move them back into a fresh new SDK folder.

            Comment


              #7
              I thought I had something working today. But, I hit SAVE and lost it. I copied the SDK on top of the installed files and started in VB with a new listgrid.

              I am using the approach described under optionDataSource. The one that says do not use optionDataSource. I need this because the foreign table will be large.

              I have an ID column in the foreign table and a NAME column. So, I leave the listGridField.optionDataSource null. The listGridField.valueField is null and the listGridField.displayField is set to the NAME column.

              The result is I get blank fields in the listgrid. There are no RPC entries. There are no fetches for the NAME column in the server log.

              When I added the appropriate listGridField.valueField it still did not work.

              Early on, when I saw in VB the NAME columns populated with the correct values, I did not see the values when I ran the app. I just saw the ID key values.

              I would blow away everything I have created and start from scratch if I thought that would help. But, I have days of effort invested in the data sources I created and one of the apps.

              Below is the listgrid. Attached are the listgrid DS (Task) and foreign table DS (Project).

              Code:
              <ListGrid dataSource="ref:Task" ID="ListGrid4" autoDraw="false">
                  <fields>
                      <ListGridField name="TASKID" title="Taskid"/>
                      <ListGridField name="PROJECTID" title="Project#">
                          <type>text</type>
                          <displayField>PROJECTNUMBER</displayField>
                          <valueField></valueField>
                      </ListGridField>
                      <ListGridField name="OWNERID" title="Ownerid">
                          <type>text</type>
                          <displayField>TEAMMEMBERNAME</displayField>
                      </ListGridField>
                      <ListGridField name="ISSUEID" title="Issue Title">
                          <type>text</type>
                          <displayField>ISSUETITLE</displayField>
                      </ListGridField>
                      <ListGridField name="TASKNUMBER" title="Task#"/>
                      <ListGridField name="STATUS" title="Status"/>
                      <ListGridField name="TASKTITLE" title="Task Title"/>
                      <ListGridField name="DUEDATE" title="Due"/>
                  </fields>
                  <showDetailFields>false</showDetailFields>
                  <autoFetchData>true</autoFetchData>
                  <autoFetchDisplayMap>false</autoFetchDisplayMap>
              </ListGrid>
              Attached Files

              Comment


                #8
                So, this morning I tried all the combinations in VB I could think of systematically:

                listGridField.type: null and text
                listGridField.optionDataSource: null and DS name
                listGridField.valueField: null and ID column name
                listGridField.autoFetchDisplayMap: null, true and false

                The results varied from blank, ID value justified left, and ID value justified right. There is nary a fetch in the server log when I search it for NAME column references.

                I am doing something wrong, I just don't know what it is. It might be right in front of my eyes and I don't recognize it.

                I have tried creating just a listgrid under the DataView. The approach I cannto get to work is the one in the Reference.

                Unlike the similar use of PickList.optionDataSource for pickLists used during editing or filtering, listGridField.optionDataSource causes the entire set of records from the optionDataSource to be fetched, without paging. Hence listGridField.optionDataSource is appropriate only for smaller valueMaps. For very large valueMap situations, such as an accountId field that should be displayed as an accountName where there are thousands of accounts, the recommended approach is:

                * do not set listGridField.optionDataSource
                * declare two fields in the DataSource, eg "accountId" and "accountName".
                * Set the ListGridField.displayField attribute on the data field to the name of the display field.
                * When fetching records for display in a grid, have your server send back values for both fields, but show only the data field ("accountId") in the grid.

                In this case the cells in the accountId field will show the record value from the accountName field. This approach means the valueMap will never be loaded in its entirety, instead, each loaded record contains the valueMapping for that one record, as a pair of fields within the record.
                The only way I can get it to fetch the values is to set listGridField.autoFetchDisplayMap to true with an .optionDataSource. And, that only works on some other datasources with foreign relations.

                Well, I am stuck on the client side. The good news is that I got JasperReports running with JasperWave in Eclipse connected to my HSQLDB database and was able to produce a report from data entered with my client code. Progress of sorts, I suppose.
                Last edited by RickBollinger; 7 Feb 2012, 15:15.

                Comment


                  #9
                  Below is the server log for the load of a brand new listgrid for the Task datasource. I updated my table definitions and recreated the datasources involved from the HSQLDB tables. So, all the foreign keys got checked.

                  I have also attached a screen shot.

                  The steps were:

                  1. create new application.
                  2. drop new listgrid component on DataView0.
                  3. set listgrid Show Detail Fields to false, Auto Fetch Data to true.
                  4. drop the Task datasource on the listgrid.
                  5. select the PROJECTID listGridField (the FK column declared as 'text' type in the DS).
                  6. change the Value Field to PROJECTID (the ID column).
                  7. change the Display Field to PROJECTNUMBER (the 'name' text field to retrieve).

                  The result is that the list of Tasks in VB in the top frame stops showing the PROJECTID values. That column goes blank. When I test the app it looks the same.

                  I note that listgrid.autoFetchDisplayMap is ON by default. There is no change when I click this OFF in step 3.

                  There are 'No items to show' in the RPC tab. There are no server requests to the optionDataSource in the server log.

                  I think I am doing what the listGridField.optionDataSource documentation recommends. I just need a clue as to what else to check or change.

                  Code:
                  === 2012-02-08 10:13:32,312 [sor4] DEBUG SQLDataSource - [builtinApplication.Task_fetch] Executing row count query: SELECT C
                  OUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
                  === 2012-02-08 10:13:32,312 [sor4] DEBUG SQLDataSource - [builtinApplication.Task_fetch] Eval'd row count query: SELECT COUN
                  T(*) FROM PUBLIC.Task WHERE ('1'='1')
                  === 2012-02-08 10:13:32,312 [sor4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] DriverManager fetchi
                  ng connection for PlanetProjectDB via jdbc url jdbc:hsqldb:file:D:\My Websites\smartclient/WEB-INF/db/hsqldb/PlanetProjectDB
                  
                  === 2012-02-08 10:13:32,312 [sor4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Passing JDBC URL onl
                  y to getConnection
                  === 2012-02-08 10:13:32,312 [sor4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Returning pooled Con
                  nection
                  === 2012-02-08 10:13:32,312 [sor4] INFO  SQLDriver - [builtinApplication.Task_fetch] Executing SQL query on 'PlanetProjectDB
                  ': SELECT COUNT(*) FROM PUBLIC.Task WHERE ('1'='1')
                  === 2012-02-08 10:13:32,359 [sor4] DEBUG SQLDataSource - [builtinApplication.Task_fetch] Using SQL Limit query
                  === 2012-02-08 10:13:32,359 [sor4] DEBUG SQLDataSource - [builtinApplication.Task_fetch] SQL windowed select rows 0->75, res
                  ult size 75. Query: SELECT LIMIT 0 75  Task.COMMUNITYID, Task.COMPLETEDDATE, Task.CREATED, Task.DESC, Task.DUEDATE, Task.ISS
                  UEID, Task.ISSUEID2, Task.LOG, Task.MODIFIED, Task.ORIGINALDUEDATE, Task.OWNERID, Task.PROJECTID, Task.STARTDATE, Task.STATU
                  S, Task.TASKID, Task.TASKNUMBER, Task.TASKTITLE FROM PUBLIC.Task WHERE ('1'='1')
                  === 2012-02-08 10:13:32,375 [sor4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] DriverManager fetchi
                  ng connection for PlanetProjectDB via jdbc url jdbc:hsqldb:file:D:\My Websites\smartclient/WEB-INF/db/hsqldb/PlanetProjectDB
                  
                  === 2012-02-08 10:13:32,375 [sor4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Passing JDBC URL onl
                  y to getConnection
                  === 2012-02-08 10:13:32,375 [sor4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.Task_fetch] Returning pooled Con
                  nection
                  === 2012-02-08 10:13:32,375 [sor4] INFO  DSResponse - [builtinApplication.Task_fetch] DSResponse: List with 5 items
                  === 2012-02-08 10:13:32,390 [sor4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
                  === 2012-02-08 10:13:32,390 [sor4] DEBUG RPCManager - non-DMI response, dropExtraFields: false
                  === 2012-02-08 10:13:44,328 [sor8] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/button/button_Focused_Down
                  _start.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (
                  Gecko) with Accept-Encoding header
                  === 2012-02-08 10:13:44,359 [sor2] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/button/button_Focused_Down
                  _stretch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz
                   (Gecko) with Accept-Encoding header
                  === 2012-02-08 10:13:44,375 [sor4] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/button/button_Focused_Down
                  _end.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Ge
                  cko) with Accept-Encoding header
                  === 2012-02-08 10:13:45,218 [sor2] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
                  ges/button/button_Focused_Down_stretch.png
                  === 2012-02-08 10:13:45,218 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
                  ges/button/button_Focused_Down_end.png
                  === 2012-02-08 10:13:45,312 [sor8] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
                  ges/button/button_Focused_Down_start.png
                  === 2012-02-08 10:14:14,546 [sor1] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/button/button_Focused_Down
                  _end.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (Ge
                  cko) with Accept-Encoding header
                  === 2012-02-08 10:14:14,765 [sor8] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/button/button_Focused_Down
                  _stretch.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz
                   (Gecko) with Accept-Encoding header
                  === 2012-02-08 10:14:14,953 [sor1] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
                  ges/button/button_Focused_Down_end.png
                  === 2012-02-08 10:14:15,046 [sor4] INFO  RequestContext - URL: '/isomorphic/skins/ToolSkin/images/button/button_Focused_Down
                  _start.png', User-Agent: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18': Moz (
                  Gecko) with Accept-Encoding header
                  === 2012-02-08 10:14:15,140 [sor8] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
                  ges/button/button_Focused_Down_stretch.png
                  === 2012-02-08 10:14:15,593 [sor4] INFO  Download - done streaming: D:/My Websites/SmartClient/isomorphic/skins/ToolSkin/ima
                  ges/button/button_Focused_Down_start.png
                  By the way, as part of my research I came across the thread about pulling two fields out of one table using this really neat mechanism. The database change included adding such a copy of an ID column. So, when I get this working I will have solved two problems. Thanks!
                  Attached Files
                  Last edited by RickBollinger; 8 Feb 2012, 08:24.

                  Comment

                  Working...
                  X