Announcement

**Isomorphic** · 6 Apr 2011, 08:56

Sounds like you've got a bad driver. It's pretty spectacularly bad that it would throw an exception when we ask for it's JDBC version.

Make sure you've got the right driver for your database and that your DB hostname, credentails etc are correct (easiest to check via the Admin Console).

If you need more help, provide:
1. the full server log starting from the request arriving at the server
2. Oracle DB version
3. JDBC driver version and where you got it

**Isomorphic** · 6 Apr 2011, 08:59

Note, you can skip this dynamic detection entirely by setting:

Code:

sql.oracle.encloseEscapeClauseInBraces: false

.. in server.properties

**curiousgally** · 12 May 2011, 11:39

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:

Code:

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

**Isomorphic** · 12 May 2011, 11:40

So... what changed?

**curiousgally** · 12 May 2011, 11:50

listGrid.setInitialCriteria(Criteria);

Is breaking it.

**Isomorphic** · 12 May 2011, 12:39

That really doesn't make sense. The way this check is performance does not depend on the criteria in the request. Look for an alternative cause, such as somehow overwriting the server.properties file such that you don't have this property set any more.

**curiousgally** · 12 May 2011, 21:31

Commenting that line and running the application i dont see the error. Records are fetched into the list grid

**curiousgally** · 13 May 2011, 00:20

My observations so far,
I was trying to set autofetchdata(true) and then set the initial criteria, it failed.
But when I comment the setInitialCriteria line it works fine but fetches data without any criteria.

Then I changed autofetchdata(false) and tried a manual fetch operation with criteria. It works but when i try to filter it again complains saying it's trying to check driver version.

I'm using nightly build on 11th this month.

Thanks.

**Isomorphic** · 13 May 2011, 09:31

Sorry, once again, there doesn't seem to be any way the check for the driver version could depend on the criteria (literally the criteria are not even in the function scope when this check is made). You may instead have some weird IDE problem where it is loading different server libraries each time. If you think there really might be a bug here, try putting together a standalone test case.

**curiousgally** · 13 May 2011, 10:02

Only filter seems to be failing while fetchData works fine without issues.

I tried it using the Visual builder too. I could able to filter data using datasource hsqldb but not with my oracle datasource.

I also tried putting the ojdbc14.jar which contains the oracle driver implementation in the lib directory.

Thanks.

**curiousgally** · 13 May 2011, 10:35

Another observation is after I put the following filtering of data works fine.

listGrid.setAutoFetchAsFilter(false);

I have another question.

I'm trying to achieve something like this:

User enters a form based on which Criteria is formed and a list grid is constructed. I want to provide filter capability only within the Criteria initially set. So even if user clears the intial criteria in the filter and clicks on filter button it should not increase the scope beyond the the initial criteria.

Is there any way to achieve this without manually handling the filtering mechanism, verifying the filter data and all.

Also is it possible to provide multiple column value selection in the filter.
ex: I have column Airport and data as LHR,JFK. When I user types LHR,JFK inthe filter it should filter all rows with Airport as LHR or JFK

Thanks.

**curiousgally** · 16 May 2011, 03:05

Now, fetch doesn't suffice my requirements.

I want to have a handler for filter but which has a method 'onfilter' and no 'onfetch'. So setting

listGrid.setAutoFetchAsFilter(false);

is not helping me do it. If I set the previous line to true, then i get the Driver version error mentioned above.

How do I get this resolved. It looks all method calls on fetch work but everything on filter method call throw driver version error. Will create a smaller test case..!

Announcement

Filter doesn't work on ListGrid

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment