User ed8790c2d3
14-10-2009 08:56:42
Hi!
Every time I try to create a search in the Query Builder using a "In list" argument I get the following error:
java.lang.IllegalArgumentException: Unable to find the native type for: jdbcType=12 jdbcKey=varchar suppliedType=null
at com.im.commons.db.ddl.AbstractDBInfo.nativeType(AbstractDBInfo.java:162)
at com.im.commons.db.AbstractDatabasePlatform$1.encodeLiteral(AbstractDatabasePlatform.java:2667)
at com.im.df.impl.db.query2.impl.FieldMatchClause$InList.createShortFragment(FieldMatchClause.java:242)
at com.im.df.impl.db.query2.impl.FieldMatchClause$InList.createFragment(FieldMatchClause.java:201)
at com.im.df.impl.db.query2.FragmentImpl.resolve(FragmentImpl.java:41)
at com.im.df.impl.db.query2.FragmentImpl.resolveParameters(FragmentImpl.java:51)
at com.im.df.impl.db.query2.FragmentImpl$Operator.createFragment(FragmentImpl.java:94)
at com.im.df.impl.db.query2.FragmentImpl.resolve(FragmentImpl.java:41)
at com.im.df.impl.db.query2.FragmentImpl.resolveParameters(FragmentImpl.java:51)
at com.im.df.impl.db.query2.FragmentImpl$Operator.createFragment(FragmentImpl.java:94)
at com.im.df.impl.db.query2.FragmentImpl.resolve(FragmentImpl.java:41)
at com.im.df.impl.db.query2.FragmentImpl.resolveParameters(FragmentImpl.java:51)
at com.im.df.impl.db.query2.FragmentImpl$Operator.createFragment(FragmentImpl.java:94)
at com.im.df.impl.db.query2.SQLSelectImpl.build(SQLSelectImpl.java:280)
at com.im.df.impl.db.query2.QueryDefinitionBuilder.compileMainQuery(QueryDefinitionBuilder.java:391)
at com.im.df.impl.db.query2.QueryDefinitionBuilder.build(QueryDefinitionBuilder.java:458)
at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIdsImpl(DBSchemaDataProviderImpl.java:400)
at com.im.df.impl.db.DBEntityDataProviderImpl.queryForIds(DBEntityDataProviderImpl.java:141)
at com.im.df.impl.db.ResultSetImpl.applyQueryInternal(ResultSetImpl.java:189)
at com.im.df.impl.db.ResultSetImpl.applyWorkingQuery(ResultSetImpl.java:142)
at com.im.ijc.core.query.exec.ExecutableQueryPanel$2.phase1InRequestProcessor(ExecutableQueryPanel.java:232)
at com.im.commons.progress.BackgroundRunner.processTheTask(BackgroundRunner.java:126)
at com.im.commons.progress.BackgroundRunner$1.run(BackgroundRunner.java:90)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:577)
[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1030)
Kind regards,
Fredrik
User ed8790c2d3
14-10-2009 10:00:26
Upon further testing, I realized that I got a very similar error when I try to sort a table that is filtered by a search.
java.lang.IllegalArgumentException: Unable to find the native type for: jdbcType=4 jdbcKey=integer suppliedType=null
at com.im.commons.db.ddl.AbstractDBInfo.nativeType(AbstractDBInfo.java:162)
at com.im.commons.db.AbstractDatabasePlatform$1.encodeLiteral(AbstractDatabasePlatform.java:2667)
at com.im.df.impl.db.query2.impl.FieldMatchClause$InList.createShortFragment(FieldMatchClause.java:242)
at com.im.df.impl.db.query2.impl.FieldMatchClause$InList.createFragment(FieldMatchClause.java:201)
at com.im.df.impl.db.query2.FragmentImpl.resolve(FragmentImpl.java:41)
at com.im.df.impl.db.query2.FragmentImpl.resolveParameters(FragmentImpl.java:51)
at com.im.df.impl.db.query2.FragmentImpl$Operator.createFragment(FragmentImpl.java:94)
at com.im.df.impl.db.query2.FragmentImpl.resolve(FragmentImpl.java:41)
at com.im.df.impl.db.query2.FragmentImpl.resolveParameters(FragmentImpl.java:51)
at com.im.df.impl.db.query2.FragmentImpl$Operator.createFragment(FragmentImpl.java:94)
at com.im.df.impl.db.query2.SQLSelectImpl.build(SQLSelectImpl.java:280)
at com.im.df.impl.db.query2.QueryDefinitionBuilder.compileMainQuery(QueryDefinitionBuilder.java:391)
at com.im.df.impl.db.query2.QueryDefinitionBuilder.build(QueryDefinitionBuilder.java:458)
at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIdsImpl(DBSchemaDataProviderImpl.java:400)
at com.im.df.impl.db.DBEntityDataProviderImpl.queryForIds(DBEntityDataProviderImpl.java:118)
at com.im.df.impl.db.DBEntityDataProviderImpl.sortIds(DBEntityDataProviderImpl.java:154)
at com.im.df.impl.db.ResultSetImpl$VS.setSort(ResultSetImpl.java:617)
at com.im.ijc.core.api.util.IJCCoreUtils$4.phase1InRequestProcessor(IJCCoreUtils.java:287)
at com.im.commons.progress.BackgroundRunner.processTheTask(BackgroundRunner.java:126)
at com.im.commons.progress.BackgroundRunner$1.run(BackgroundRunner.java:90)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:577)
[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1030)
ChemAxon fa971619eb
14-10-2009 10:02:12
We have identified the problem. Something was missing from the 3.0.3 update.
The udpate center will be corrected soon.
Tim
ChemAxon fa971619eb
14-10-2009 10:17:25
The update is now made. Once you update IJC again the problems should be solved.
Appologies for these difficulties.
Tim
User ed8790c2d3
14-10-2009 11:21:11
Thank you for the swift response!