Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

oracle, ibatis, log4jdbc error adobe sql #46

Open
GoogleCodeExporter opened this issue Mar 25, 2015 · 4 comments
Open

oracle, ibatis, log4jdbc error adobe sql #46

GoogleCodeExporter opened this issue Mar 25, 2015 · 4 comments
Labels
auto-migrated Priority-Medium Type-Defect

Comments

@GoogleCodeExporter
Copy link 

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 [email protected] on 5 Mar 2012 at 11:29
@GoogleCodeExporter
Copy link
Author 

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

Original comment by [email protected] on 5 Mar 2012 at 11:38

  • Added labels: ****
  • Removed labels: ****

@GoogleCodeExporter
Copy link
Author 

Can you post the exception stack dump here?

Original comment by [email protected] on 5 Mar 2012 at 11:45

  • Added labels: ****
  • Removed labels: ****

@GoogleCodeExporter
Copy link
Author 

[deleted comment]

@GoogleCodeExporter
Copy link
Author 

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 [email protected] on 5 Mar 2012 at 12:01

  • Added labels: ****
  • Removed labels: ****

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
auto-migrated Priority-Medium Type-Defect
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@GoogleCodeExporter