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
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
Comment