Announcement

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

    DataSource Generation For A Table with CLOB column

    Hi Guys,
    I am using te following versions:
    SmartGWTEE 2.5
    GWT 2.0.4
    TOMCAT( 5.5 )
    I have a table which has CLOB column, and I am trying to generate SQL DataSource by using Visual Builder.
    When I select the Table in Tables & Views Section, the 'Loading Data' circle keeps on rotating and never comes back.
    I am accesing the visual builder by deploying the showcase webapp in TOMCAT( 5.5 )
    Can you please help or suggest any way around this issue? Following are the Server Logs:
    Best regards,
    Debashis
    Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR
    3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
    === 2011-10-06 16:39:08,123 [or22] DEBUG XML - Parsed XML from (in memory stream): 0ms
    === 2011-10-06 16:39:08,123 [or22] DEBUG RPCManager - Processing 1 requests.
    === 2011-10-06 16:39:08,123 [or22] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
    },
    operationConfig:{
    dataSource:"TABLE3-dbBrowser",
    operationType:"fetch",
    textMatchStyle:"exact"
    },
    startRow:0,
    endRow:75,
    componentId:"isc_DatabaseBrowser_0_dataGrid",
    appID:"builtinApplication",
    operation:"TABLE3-dbBrowser_fetch",
    oldValues:{
    }
    }
    === 2011-10-06 16:39:08,139 [or22] DEBUG AppBase - [builtinApplication.TABLE3-dbBrowser_fetch] No userTypes defined, allowing anyone ac
    cess to all operations for this application
    === 2011-10-06 16:39:08,139 [or22] DEBUG AppBase - [builtinApplication.TABLE3-dbBrowser_fetch] No public zero-argument method named '_T
    ABLE3-dbBrowser_fetch' found, performing generic datasource operation
    === 2011-10-06 16:39:08,139 [or22] INFO SQLDataSource - [builtinApplication.TABLE3-dbBrowser_fetch] Performing fetch operation with
    criteria: {} values: {}
    === 2011-10-06 16:39:08,139 [or22] INFO SQLWhereClause - [builtinApplication.TABLE3-dbBrowser_fetch] empty condition
    === 2011-10-06 16:39:08,139 [or22] INFO SQLDataSource - [builtinApplication.TABLE3-dbBrowser_fetch] derived query: SELECT $defaultSele
    ctClause FROM $defaultTableClause WHERE $defaultWhereClause
    === 2011-10-06 16:39:08,389 [or22] DEBUG SQLDataSource - [builtinApplication.TABLE3-dbBrowser_fetch] Executing row count query: SELECT
    COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
    === 2011-10-06 16:39:08,389 [or22] DEBUG SQLDataSource - [builtinApplication.TABLE3-dbBrowser_fetch] Eval'd row count query: SELECT COU
    NT(*) FROM OPS$NEMMANAG.TABLE3 WHERE ('1'='1')
    === 2011-10-06 16:39:08,685 [or22] DEBUG PoolableSQLConnectionFactory - [builtinApplication.TABLE3-dbBrowser_fetch] Returning pooled Co
    nnection
    === 2011-10-06 16:39:08,717 [or22] INFO SQLDriver - [builtinApplication.TABLE3-dbBrowser_fetch] Executing SQL query on 'Oracle': SELEC
    T COUNT(*) FROM OPS$NEMMANAG.TABLE3 WHERE ('1'='1')
    === 2011-10-06 16:39:08,842 [or22] WARN SQLDataSource - [builtinApplication.TABLE3-dbBrowser_fetch] DataSource 'TABLE3-dbBrowser': sql
    Paging was explicitly specified as 'sqlLimit', but the underlying database (oracle) does not support SQL limit queries. Falling back t
    o 'jdbcScroll'
    === 2011-10-06 16:39:08,842 [or22] DEBUG SQLDataSource - [builtinApplication.TABLE3-dbBrowser_fetch] JDBC driver windowed select rows 0
    ->75, result size 75. Query: SELECT TABLE3.ENTITY_ID, TABLE3.TIME, TABLE3.MESSAGE, TABLE3.ENTITY_NAME, TABLE3.DS_REF FROM OPS$NEMMANAG.
    TABLE3 WHERE ('1'='1')
    === 2011-10-06 16:39:09,670 [or22] INFO DSResponse - [builtinApplication.TABLE3-dbBrowser_fetch] DSResponse: List with 75 items
    === 2011-10-06 16:39:09,701 [or22] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-10-06 16:39:09,701 [or22] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-10-06 16:39:09,732 [or22] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
    === 2011-10-06 16:39:09,732 [or22] DEBUG RPCManager - non-DMI response, dropExtraFields: false
    === 2011-10-06 16:39:09,732 [or22] INFO Compression - /showcase/showcase/tools/visualBuilder/vbOperations.jsp: 4522 -> 1039 bytes

    #2
    We're not sure what you did wrong, but no reason to pursue it: as a developer you should not be using Visual Builder to generate DataSources. Use autoDeriveSchema instead - see QuickStart Guide, Server Framework chapter.

    Comment


      #3
      Hi, Thanks for the reply. I have tried by modifying the builtinDS example for my own table with CLOB and it worked fine. However i can see many errors in the logs, it will be really good to get clarity on them.
      Problem1
      ---------------
      Code:
      [WARN] Configuration problem at <mime-mapping>
              <extension>manifest</extension>
              <mime-type>text/cache-manifest</mime-type>
          </mime-mapping>
      java.lang.NullPointerException
      	at org.mortbay.jetty.webapp.WebXmlConfiguration.initMimeConfig(WebXmlConfiguration.java:680)
      	at org.mortbay.jetty.webapp.WebXmlConfiguration.initWebXmlElement(WebXmlConfiguration.java:340)
      	at org.mortbay.jetty.webapp.WebXmlConfiguration.initialize(WebXmlConfiguration.java:289)
      	at org.mortbay.jetty.webapp.WebXmlConfiguration.configure(WebXmlConfiguration.java:222)
      	at com.google.gwt.dev.ServletValidator.create(ServletValidator.java:69)
      	at com.google.gwt.dev.ServletValidator.create(ServletValidator.java:52)
      	at com.google.gwt.dev.DevMode.doSlowStartup(DevMode.java:356)
      	at com.google.gwt.dev.DevModeBase.startUp(DevModeBase.java:1057)
      	at com.google.gwt.dev.DevModeBase.run(DevModeBase.java:783)
      	at com.google.gwt.dev.DevMode.main(DevMode.java:275)
      [WARN] Unable to process 'file:/C:/HOMEWARE/GWT/Copy%20of%20smartgwtee-2.5/samples/built-in-ds/war/WEB-INF/web.xml' for servlet validation
      javax.servlet.UnavailableException: Configuration problem
      	at org.mortbay.jetty.webapp.WebXmlConfiguration.initialize(WebXmlConfiguration.java:298)
      	at org.mortbay.jetty.webapp.WebXmlConfiguration.configure(WebXmlConfiguration.java:222)
      	at com.google.gwt.dev.ServletValidator.create(ServletValidator.java:69)
      	at com.google.gwt.dev.ServletValidator.create(ServletValidator.java:52)
      	at com.google.gwt.dev.DevMode.doSlowStartup(DevMode.java:356)
      	at com.google.gwt.dev.DevModeBase.startUp(DevModeBase.java:1057)
      	at com.google.gwt.dev.DevModeBase.run(DevModeBase.java:783)
      	at com.google.gwt.dev.DevMode.main(DevMode.java:275)
      Problem2
      ---------
      NEMMANAG is the password of the DB. Attached is the server.properties file.
      Code:
      === 2011-10-06 18:41:57,301 [l0-2] INFO  RequestContext - URL: '/builtinds/sc/DataSourceLoader', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
      === 2011-10-06 18:41:57,410 [l0-0] INFO  Compression - /builtinds/sc/modules/ISC_Core.js: 696283 -> 180350 bytes
      === 2011-10-06 18:41:57,489 [l0-2] INFO  PoolManager - SmartClient pooling disabled for 'table3' objects
      === 2011-10-06 18:41:57,504 [l0-3] INFO  Download - Returning 304: Not modified on conditional get of: C:\HOMEWARE\GWT\Copy of smartgwtee-2.5\samples\built-in-ds\war\builtinds\sc\skins\Enterprise\load_skin.js
      === 2011-10-06 18:41:57,520 [l0-2] DEBUG XML - Parsed XML from C:\HOMEWARE\GWT\Copy of smartgwtee-2.5\samples\built-in-ds\war\builtinds\sc\system\schema\builtinTypes.xml: 16ms
      === 2011-10-06 18:41:57,567 [l0-2] DEBUG XML - Parsed XML from C:\HOMEWARE\GWT\Copy of smartgwtee-2.5\samples\built-in-ds\war\ds\table3.ds.xml: 16ms
      === 2011-10-06 18:41:57,567 [l0-2] DEBUG XML - Parsed XML from C:\HOMEWARE\GWT\Copy of smartgwtee-2.5\samples\built-in-ds\war\builtinds\sc\system\schema\DataSource.ds.xml: 0ms
      === 2011-10-06 18:41:57,645 [l0-2] INFO  SQLDataSource - Deriving dataSource table3 from table: TABLE3
      java.lang.Exception: variable expansion failed for variable: NEMMANAG
      	at com.isomorphic.base.ConfigParser.interpolateVariable(ConfigParser.java:163)
      	at com.isomorphic.base.ConfigParser.interpolate(ConfigParser.java:112)
      	at com.isomorphic.base.ConfigParser.get(ConfigParser.java:82)
      	at org.apache.commons.collections.map.AbstractMapDecorator.get(AbstractMapDecorator.java:95)
      	at com.isomorphic.base.Config.get(Config.java:321)
      	at com.isomorphic.util.DataTools.getSubtreePrefixed(DataTools.java:1412)
      	at com.isomorphic.base.Config.getSubtree(Config.java:190)
      	at com.isomorphic.sql.PoolableSQLConnectionFactory.<init>(PoolableSQLConnectionFactory.java:87)
      	at com.isomorphic.sql.PoolableSQLConnectionFactory.newInstance(PoolableSQLConnectionFactory.java:79)
      	at com.isomorphic.pool.PoolManager.makeSource(PoolManager.java:177)
      	at com.isomorphic.pool.PoolManager.getObjectSource(PoolManager.java:158)
      	at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:69)
      	at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:150)
      	at com.isomorphic.sql.SQLDSGenerator.generate(SQLDSGenerator.java:165)
      	at com.isomorphic.sql.SQLDataSource.getConfigFromTable(SQLDataSource.java:2202)
      	at com.isomorphic.sql.SQLDataSource.fromTable(SQLDataSource.java:2150)
      	at com.isomorphic.sql.SQLDataSource.init(SQLDataSource.java:141)
      	at com.isomorphic.datasource.DataSource.initialize(DataSource.java:363)
      	at com.isomorphic.datasource.BasicDataSource.fromConfig(BasicDataSource.java:165)
      	at com.isomorphic.datasource.DataSource.fromConfig(DataSource.java:348)
      	at com.isomorphic.datasource.FileSystemDSRepo.loadDS(FileSystemDSRepo.java:110)
      	at com.isomorphic.datasource.DataSource.forName(DataSource.java:167)
      	at com.isomorphic.datasource.DataSource.forName(DataSource.java:159)
      	at com.isomorphic.datasource.DataSource.forName(DataSource.java:154)
      	at com.isomorphic.datasource.PoolableDataSourceFactory.makeUnpooledObject(PoolableDataSourceFactory.java:95)
      	at com.isomorphic.datasource.PoolableDataSourceFactory.makeObject(PoolableDataSourceFactory.java:102)
      	at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:82)
      	at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:87)
      	at com.isomorphic.servlet.DataSourceLoader.processRequest(DataSourceLoader.java:107)
      	at com.isomorphic.servlet.DataSourceLoader.doGet(DataSourceLoader.java:83)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      	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.headerComplete(HttpConnection.java:829)
      	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
      	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
      	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)


      Apologies for such a long problem statement, but I am trying this tool first time and we will be developing a lot of functionality using SMART GWT in the organization.
      Best Regards,
      debashis

      Originally posted by Isomorphic
      We're not sure what you did wrong, but no reason to pursue it: as a developer you should not be using Visual Builder to generate DataSources. Use autoDeriveSchema instead - see QuickStart Guide, Server Framework chapter.
      Attached Files

      Comment


        #4
        The "$" character in your password is causing it to be treated as a variable. Use a backslash (\) before it to quote it so it's treated as a normal character.

        Something seems to be wrong with your web.xml file. Copy the one provided in the SDK over again.

        Comment


          #5
          Hi, Thanks for the fast reply.Attached is the web.xml.
          However \ infront of the $ does not work either, but its not end of the world, I can get it changed.
          Best Regards,
          Debashis


          Originally posted by Isomorphic
          The "$" character in your password is causing it to be treated as a variable. Use a backslash (\) before it to quote it so it's treated as a normal character.

          Something seems to be wrong with your web.xml file. Copy the one provided in the SDK over again.
          Attached Files

          Comment


            #6
            We don't need to see the web.XML, just revert to the copy from the SDK.

            Comment


              #7
              Hi I did copied this from the SDK only.
              However I have now removed the tag for which it was complaining and then it seems to work fine. But I am still not clear why it was an issue in the first place when i copied it from SDK.
              Regards,
              Debashis

              Originally posted by Isomorphic
              We don't need to see the web.XML, just revert to the copy from the SDK.

              Comment


                #8
                Ah, with a little Googling, it turns out this is a bug in older GWT.

                Comment


                  #9
                  OK, Thanks a lot. I have removed the mime tages anyway, and it works just fine.
                  Thanks Again,
                  Debashis
                  Originally posted by Isomorphic
                  Ah, with a little Googling, it turns out this is a bug in older GWT.

                  Comment

                  Working...
                  X