oracle, ibatis, log4jdbc error adobe sql

[GoogleCodeExporter]

What steps will reproduce the problem?
1. use oracle and ibatis, log4jdbc 
2. make sqlmap for ibatis
3. sql use oracle string concatenation '||'

What is the expected output? What do you see instead?
run ok
I see error (ibtais throw exception with error code 17004)

What version of the product are you using? On what operating system?
my system windows7 x64 sp1, ibatis, oracle 11gr2, jdk 1.6.0_u31,
eclipse hellios r2, tomcat 6

Please provide any additional information below.

where somefield = #field1#||#field2#||#field3#

run ok without log4jdbc.
but error throw with log4jdbc  

Original issue reported on code.google.com by moonu...@gmail.com on 5 Mar 2012 at 11:29

[GoogleCodeExporter]

sorry my mistake.
my classpath has two ojdbc dirvers.
(ojdbc14, ojdbc6)

Original comment by moonu...@gmail.com on 5 Mar 2012 at 11:38

[GoogleCodeExporter]

Can you post the exception stack dump here?

Original comment by arthur.b...@gmail.com on 5 Mar 2012 at 11:45

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

ok

2012. 3. 5 오후 8:52:47 org.apache.catalina.core.AprLifecycleListener init
정보: Loaded APR based Apache Tomcat Native library 1.1.20.
2012. 3. 5 오후 8:52:47 org.apache.catalina.core.AprLifecycleListener init
정보: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], 
random [true].
2012. 3. 5 오후 8:52:47 org.apache.tomcat.util.digester.SetPropertiesRule 
begin
경고: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting 
property 'source' to 'org.eclipse.jst.jee.server:myprojectName' did not find a 
matching property.
2012. 3. 5 오후 8:52:47 org.apache.tomcat.util.digester.SetPropertiesRule 
begin
경고: [SetPropertiesRule]{Server/Service/Engine/Host/Context/Loader} Setting 
property 'useSystemClassLoaderAsParent' to 'false' did not find a matching 
property.
2012. 3. 5 오후 8:52:48 org.apache.coyote.http11.Http11AprProtocol init
정보: Initializing Coyote HTTP/1.1 on http-8076
2012. 3. 5 오후 8:52:48 org.apache.coyote.ajp.AjpAprProtocol init
정보: Initializing Coyote AJP/1.3 on ajp-8009
2012. 3. 5 오후 8:52:48 org.apache.catalina.startup.Catalina load
정보: Initialization processed in 769 ms
2012. 3. 5 오후 8:52:48 org.apache.catalina.core.StandardService start
정보: Starting service Catalina
2012. 3. 5 오후 8:52:48 org.apache.catalina.core.StandardEngine start
정보: Starting Servlet Engine: Apache Tomcat/6.0.32
2012. 3. 5 오후 8:52:48 org.apache.catalina.core.ApplicationContext log
정보: Initializing Spring root WebApplicationContext
2012. 3. 5 오후 8:52:51 org.apache.catalina.core.ApplicationContext log
정보: Initializing Spring FrameworkServlet 'action'
2012. 3. 5 오후 8:52:51 org.apache.coyote.http11.Http11AprProtocol start
정보: Starting Coyote HTTP/1.1 on http-8076
2012. 3. 5 오후 8:52:51 org.apache.coyote.ajp.AjpAprProtocol start
정보: Starting Coyote AJP/1.3 on ajp-8009
2012. 3. 5 오후 8:52:51 org.apache.catalina.startup.Catalina start
정보: Server startup in 3168 ms
D[20120305 20:52:58] 
myclassname#mymethodname():77:[>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>1]
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]... log4jdbc initializing ...
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]  log4jdbc.properties not found on classpath
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.debug.stack.prefix is not defined
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.sqltiming.warn.threshold is not defined
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.sqltiming.error.threshold is not defined
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.booleanastruefalse is not defined (using default value 
false)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.sql.maxlinelength is not defined (using default of 90)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.fulldebugstacktrace is not defined (using default value 
false)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.statement.warn is not defined (using default value false)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.sql.select is not defined (using default value true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.sql.insert is not defined (using default value true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.sql.update is not defined (using default value true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.sql.delete is not defined (using default value true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.sql.create is not defined (using default value true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.dump.sql.addsemicolon is not defined (using default value 
false)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.auto.load.popular.drivers is not defined (using default value 
true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.trim.sql is not defined (using default value true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.trim.sql.extrablanklines is not defined (using default value 
true)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.suppress.generated.keys.exception is not defined (using 
default value false)
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]x log4jdbc.drivers is not defined
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]  FOUND DRIVER oracle.jdbc.OracleDriver
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]  FOUND DRIVER oracle.jdbc.driver.OracleDriver
[DEBUG][20120305 
20:52:58][sf.log4jdbc.Slf4jSpyLogDelegator][F:Slf4jSpyLogDelegator.java,M:debug,
L:519]... log4jdbc initialized! ...
[DEBUG][20120305 
20:52:58][logging.jakarta.JakartaCommonsLoggingImpl][F:JakartaCommonsLoggingImpl
.java,M:debug,L:27]{conn-100000} Connection
[DEBUG][20120305 
20:52:58][logging.jakarta.JakartaCommonsLoggingImpl][F:JakartaCommonsLoggingImpl
.java,M:debug,L:27]{conn-100000} Preparing Statement: 

my project sql...           

[input parameter java benas values], [UncategorizedSQLException] 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator#translat
e():83: SqlMapClient operation; uncategorized SQLException for SQL []; SQL 
state [null]; error code [17004];   
--- The error occurred in sqlmap/dummyQuery.xml.  
--- The error occurred while applying a parameter map.  
--- Check the my project sqlmap sql id.  
--- Check the parameter mapping for the 'bean mapped somefieldname' property.  
--- Cause: java.sql.SQLException: 부적합한 열 유형; nested exception is 
com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/dummyQuery.xml.  
--- The error occurred while applying a parameter map.  
--- Check the my sqlmap statement id-InlineParameterMap.  
--- Check the parameter mapping for the 'bchppsNo' property.  
--- Cause: java.sql.SQLException: 부적합한 열 유형

Original comment by moonu...@gmail.com on 5 Mar 2012 at 12:01