Hi,
Earlier the parameter in server.properties u have mentioned worked. But now suddenly it doesn’t seem to work anymore. Normal data fetch for list grid fails.
logs:
ISC: Configuring log4j from: file:/C:/tomcat2/apache-tomcat-5.5.25/webapps/ROOT/WEB-INF/classes/log4j.isc.config.xml
=== 2011-05-13 01:05:20,966 [main] INFO ISCInit - Isomorphic SmartClient Framework - Initializing
=== 2011-05-13 01:05:20,981 [main] INFO ConfigLoader - Attempting to load framework.properties from CLASSPATH
=== 2011-05-13 01:05:21,028 [main] INFO ConfigLoader - Successfully loaded framework.properties from CLASSPATH at location: jar:file:/C:/tomcat2/apache-tomcat-5.5.25/webapps/ROOT/WEB-INF/lib/isomorphic_core_rpc.jar!/framework.properties
=== 2011-05-13 01:05:21,028 [main] INFO ConfigLoader - Attempting to load project.properties from CLASSPATH
=== 2011-05-13 01:05:21,044 [main] INFO ConfigLoader - Unable to locate project.properties in CLASSPATH
=== 2011-05-13 01:05:21,044 [main] INFO ConfigLoader - Successfully loaded isc_interfaces.properties from CLASSPATH at location: jar:file:/C:/tomcat2/apache-tomcat-5.5.25/webapps/ROOT/WEB-INF/lib/isomorphic_core_rpc.jar!/isc_interfaces.properties
=== 2011-05-13 01:05:21,075 [main] INFO ConfigLoader - Attempting to load server.properties from CLASSPATH
=== 2011-05-13 01:05:21,075 [main] INFO ConfigLoader - Successfully loaded server.properties from CLASSPATH at location: file:/C:/tomcat2/apache-tomcat-5.5.25/webapps/ROOT/WEB-INF/classes/server.properties
=== 2011-05-13 01:05:21,075 [main] INFO Logger - Logging system started.
=== 2011-05-13 01:05:21,075 [main] INFO ISCInit - Isomorphic SmartClient Framework (SC_SNAPSHOT-2011-02-28/EVAL Deployment 2011-03-01) - Initialization Complete
=== 2011-05-13 01:05:21,075 [main] INFO ISCInit - Auto-detected webRoot - using: C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT
=== 2011-05-13 01:05:21,482 [main] INFO PreCache - Isomorphic PreCache servlet loading
=== 2011-05-13 01:05:21,498 [main] INFO PoolManager - SmartClient pooling disabled for 'DataSource' objects
=== 2011-05-13 01:05:21,529 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\DataSource.ds.xml: 0ms
=== 2011-05-13 01:05:21,544 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\builtinTypes.xml: 0ms
=== 2011-05-13 01:05:21,591 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\DataSourceField.ds.xml: 0ms
=== 2011-05-13 01:05:21,607 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\Validator.ds.xml: 0ms
=== 2011-05-13 01:05:21,607 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\ValueMap.ds.xml: 0ms
=== 2011-05-13 01:05:21,623 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\InstantDataApp.ds.xml: 0ms
=== 2011-05-13 01:05:21,670 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\Application.ds.xml: 0ms
=== 2011-05-13 01:05:21,670 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\IDAPage.ds.xml: 0ms
=== 2011-05-13 01:05:21,670 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\IDAUserType.ds.xml: 0ms
=== 2011-05-13 01:05:21,685 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\IDAOperation.ds.xml: 0ms
=== 2011-05-13 01:05:21,701 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\Canvas.ds.xml: 0ms
=== 2011-05-13 01:05:21,779 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\MethodDeclaration.ds.xml: 0ms
=== 2011-05-13 01:05:21,795 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\Img.ds.xml: 0ms
=== 2011-05-13 01:05:21,795 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\StatefulCanvas.ds.xml: 0ms
=== 2011-05-13 01:05:21,810 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\Button.ds.xml: 0ms
=== 2011-05-13 01:05:21,826 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\ListViewer.ds.xml: 0ms
=== 2011-05-13 01:05:21,842 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\ListGrid.ds.xml: 16ms
=== 2011-05-13 01:05:21,857 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\DynamicForm.ds.xml: 0ms
=== 2011-05-13 01:05:21,873 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\FormItem.ds.xml: 0ms
=== 2011-05-13 01:05:21,889 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\DetailViewer.ds.xml: 0ms
=== 2011-05-13 01:05:21,889 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\DetailViewerField.ds.xml: 0ms
=== 2011-05-13 01:05:21,889 [main] DEBUG XML - Parsed XML from C:\tomcat2\apache-tomcat-5.5.25\webapps\ROOT\customds\sc\system\schema\isomorphicXML.ds.xml: 0ms
=== 2011-05-13 01:05:21,904 [main] INFO PreCache - Isomorphic PreCache complete (422ms)
May 13, 2011 1:05:22 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8090
May 13, 2011 1:05:22 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
May 13, 2011 1:05:22 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
May 13, 2011 1:05:22 AM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
May 13, 2011 1:05:22 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 3881 ms
Connected to server
=== 2011-05-13 01:05:23,234 [or25] INFO RequestContext - URL: '/builtinds/BuiltInDS.html', User-Agent: 'Java/1.6.0_21': Unsupported WITHOUT Accept-Encoding header
=== 2011-05-13 01:05:23,297 [or24] INFO RequestContext - URL: '/', User-Agent: 'Java/1.6.0_21': Unsupported WITHOUT Accept-Encoding header
=== 2011-05-13 01:05:23,688 [or24] INFO RequestContext - URL: '/builtinds/builtinds/sc/DataSourceLoader', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1': Moz (Gecko) with Accept-Encoding header
=== 2011-05-13 01:05:23,704 [or24] DEBUG XML - Parsed XML from C:\Documents and Settings\sg0209257\My Documents\Downloads\smartgwtee-2.5\samples\built-in-ds\classes\artifacts\builtinds\ds\supplyItem.ds.xml: 0ms
=== 2011-05-13 01:05:23,766 [or24] DEBUG XML - Parsed XML from C:\Documents and Settings\sg0209257\My Documents\Downloads\smartgwtee-2.5\samples\built-in-ds\classes\artifacts\builtinds\ds\animals.ds.xml: 0ms
=== 2011-05-13 01:05:23,782 [or23] INFO Compression - /builtinds/builtinds/builtinds.nocache.js: 6729 -> 2642 bytes
=== 2011-05-13 01:05:23,876 [or24] DEBUG XML - Parsed XML from C:\Documents and Settings\sg0209257\My Documents\Downloads\smartgwtee-2.5\samples\built-in-ds\classes\artifacts\builtinds\ds\employees.ds.xml: 0ms
=== 2011-05-13 01:05:23,907 [or24] DEBUG XML - Parsed XML from C:\Documents and Settings\sg0209257\My Documents\Downloads\smartgwtee-2.5\samples\built-in-ds\classes\artifacts\builtinds\ds\adb.ds.xml: 15ms
=== 2011-05-13 01:05:24,048 [or24] DEBUG XML - Parsed XML from C:\Documents and Settings\sg0209257\My Documents\Downloads\smartgwtee-2.5\samples\built-in-ds\classes\artifacts\builtinds\builtinds\sc\system\schema\OperationBinding.ds.xml: 16ms
=== 2011-05-13 01:05:24,095 [or24] INFO PoolableSQLConnectionFactory - No explicit configuration for db: jdbc/mdads in server.properties - will look for a Connection object at jdbc/mdads or java:comp/env/jdbc/mdads.
=== 2011-05-13 01:05:24,095 [or24] INFO PoolManager - SmartClient pooling disabled for 'jdbc/mdads' objects
=== 2011-05-13 01:05:24,095 [or24] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for 'jdbc/mdads' via JNDI
=== 2011-05-13 01:05:24,643 [or23] INFO Compression - /builtinds/builtinds/sc/modules/ISC_Core.js: 685115 -> 177590 bytes
=== 2011-05-13 01:05:38,663 [or24] INFO PoolableSQLConnectionFactory - Auto-configuring connection to jdbc/mdads - connected to Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options via JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0
=== 2011-05-13 01:05:38,663 [or24] INFO PoolableSQLConnectionFactory - Derived DB type is: oracle, for serverName: jdbc/mdads, jndiName: jdbc/mdads
=== 2011-05-13 01:05:38,663 [or24] DEBUG PoolableSQLConnectionFactory - Returning unpooled Connection
=== 2011-05-13 01:05:38,757 [or23] INFO Compression - /builtinds/builtinds/6BF5B07ECB0A9DB6330608E889101BF2.cache.html: 126263 -> 33552 bytes
=== 2011-05-13 01:05:47,535 [or24] INFO RequestContext - URL: '/builtinds/builtinds/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1': Moz (Gecko) with Accept-Encoding header
=== 2011-05-13 01:05:47,550 [or24] DEBUG XML - Parsed XML from (in memory stream): 0ms
=== 2011-05-13 01:05:47,566 [or24] DEBUG XML - Parsed XML from C:\Documents and Settings\sg0209257\My Documents\Downloads\smartgwtee-2.5\samples\built-in-ds\classes\artifacts\builtinds\builtinds\sc\system\schema\List.ds.xml: 0ms
=== 2011-05-13 01:05:47,582 [or24] DEBUG RPCManager - Processing 1 requests.
=== 2011-05-13 01:05:47,597 [or24] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
ORIG:"BOM",
DEST:"DEL",
security_id:"120",
DATES:200901
},
operationConfig:{
dataSource:"adb",
operationType:"fetch",
textMatchStyle:"substring"
},
startRow:0,
endRow:100,
componentId:"isc_ListGrid_0",
appID:"builtinApplication",
operation:"adb_fetch",
oldValues:{
ORIG:"BOM",
DEST:"DEL",
security_id:"120",
DATES:200901
}
}
=== 2011-05-13 01:05:47,613 [or24] INFO IDACall - Performing 1 operation(s)
=== 2011-05-13 01:05:47,613 [or24] DEBUG AppBase - [builtinApplication.adb_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2011-05-13 01:05:47,613 [or24] DEBUG AppBase - [builtinApplication.adb_fetch] No public zero-argument method named '_adb_fetch' found, performing generic datasource operation
=== 2011-05-13 01:05:47,613 [or24] INFO SQLDataSource - [builtinApplication.adb_fetch] Performing fetch operation with
criteria: {ORIG:"BOM",DEST:"DEL",security_id:"120",DATES:200901} values: {ORIG:"BOM",DEST:"DEL",security_id:"120",DATES:200901}
=== 2011-05-13 01:05:47,629 [or24] DEBUG OracleDriver - [builtinApplication.adb_fetch] Grabbing connection for driver version checking
=== 2011-05-13 01:05:47,629 [or24] DEBUG PoolableSQLConnectionFactory - [builtinApplication.adb_fetch] Returning unpooled Connection
=== 2011-05-13 01:05:47,629 [or24] WARN OracleDriver - [builtinApplication.adb_fetch] Error trying to ascertain JDBC driver version
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at oracle.jdbc.OracleDatabaseMetaData.getJDBCMajorVersion(OracleDatabaseMetaData.java:4475)
at com.isomorphic.sql.OracleDriver.useNewEscapeSyntax(OracleDriver.java:92)
at com.isomorphic.sql.OracleDriver.escapeClause(OracleDriver.java:340)
at com.isomorphic.sql.SQLWhereClause.substringFilter(SQLWhereClause.java:652)
at com.isomorphic.sql.SQLWhereClause.substringFilter(SQLWhereClause.java:632)
at com.isomorphic.sql.SQLWhereClause.buildExpression(SQLWhereClause.java:594)
at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:355)
at com.isomorphic.sql.SQLWhereClause.buildCompoundExpression(SQLWhereClause.java:416)
at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:361)
at com.isomorphic.sql.SQLWhereClause.toString(SQLWhereClause.java:301)
at com.isomorphic.sql.SQLWhereClause.getSQLString(SQLWhereClause.java:307)
at com.isomorphic.sql.SQLDataSource.getClausesContext(SQLDataSource.java:1902)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1187)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:280)
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:224)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1077)
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:1620)
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:710)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:662)
=== 2011-05-13 01:05:47,629 [or24] DEBUG OracleDriver - [builtinApplication.adb_fetch] Freeing connection we used for driver version checking
=== 2011-05-13 01:05:47,629 [or24] WARN RequestContext - dsRequest.execute() failed:
java.lang.NullPointerException
at com.isomorphic.sql.OracleDriver.useNewEscapeSyntax(OracleDriver.java:107)
at com.isomorphic.sql.OracleDriver.escapeClause(OracleDriver.java:340)
at com.isomorphic.sql.SQLWhereClause.substringFilter(SQLWhereClause.java:652)
at com.isomorphic.sql.SQLWhereClause.substringFilter(SQLWhereClause.java:632)
at com.isomorphic.sql.SQLWhereClause.buildExpression(SQLWhereClause.java:594)
at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:355)
at com.isomorphic.sql.SQLWhereClause.buildCompoundExpression(SQLWhereClause.java:416)
at com.isomorphic.sql.SQLWhereClause.getOutput(SQLWhereClause.java:361)
at com.isomorphic.sql.SQLWhereClause.toString(SQLWhereClause.java:301)
at com.isomorphic.sql.SQLWhereClause.getSQLString(SQLWhereClause.java:307)
at com.isomorphic.sql.SQLDataSource.getClausesContext(SQLDataSource.java:1902)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1187)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:280)
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:224)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1077)
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:1620)
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:710)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:662)
=== 2011-05-13 01:05:47,629 [or24] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2011-05-13 01:05:47,644 [or24] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2011-05-13 01:05:47,644 [or24] INFO Compression - /builtinds/builtinds/sc/IDACall: 123 -> 113 bytes