[code=Java]2011-01-17 01:59:59 DEBUG - Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@d9205] for iBATIS operation
2011-01-17 01:59:59 DEBUG - {conn-100024} Connection
2011-01-17 01:59:59 DEBUG - Obtained JDBC Connection [Transaction-aware proxy for target Connection from DataSource [org.apache.commons.dbcp.BasicDataSource@56182f]] for iBATIS operation
2011-01-17 01:59:59 DEBUG - {conn-100024} Preparing Statement: INSERT INTO abc ( abc ) VALUES ( ? )
2011-01-17 01:59:59 DEBUG - Fetching JDBC Connection from DataSource
2011-01-17 01:59:59 INFO - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2011-01-17 01:59:59 DEBUG - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
2011-01-17 01:59:59 DEBUG - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN 2.0//EN] and system ID [http://www.springframework.org/dtd/spring-beans-2.0.dtd]
2011-01-17 01:59:59 DEBUG - Trying to locate [spring-beans-2.0.dtd] in Spring jar
2011-01-17 01:59:59 DEBUG - Found beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in classpath: spring-beans-2.0.dtd
2011-01-17 01:59:59 DEBUG - Loading bean definitions
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'DB2'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'DB2'
2011-01-17 01:59:59 DEBUG - Eagerly caching bean 'DB2' to allow for resolving potential circular references
2011-01-17 01:59:59 DEBUG - Getting BeanInfo for class [org.springframework.jdbc.support.SQLErrorCodes]
2011-01-17 01:59:59 DEBUG - Caching PropertyDescriptors for class [org.springframework.jdbc.support.SQLErrorCodes]
2011-01-17 01:59:59 DEBUG - Found bean property 'badSqlGrammarCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'cannotAcquireLockCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'cannotSerializeTransactionCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'class' of type [java.lang.Class]
2011-01-17 01:59:59 DEBUG - Found bean property 'customSqlExceptionTranslator' of type [org.springframework.jdbc.support.SQLExceptionTranslator]
2011-01-17 01:59:59 DEBUG - Found bean property 'customSqlExceptionTranslatorClass' of type [java.lang.Class]
2011-01-17 01:59:59 DEBUG - Found bean property 'customTranslations' of type [[Lorg.springframework.jdbc.support.CustomSQLErrorCodesTranslation;]
2011-01-17 01:59:59 DEBUG - Found bean property 'dataAccessResourceFailureCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'dataIntegrityViolationCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'databaseProductName' of type [java.lang.String]
2011-01-17 01:59:59 DEBUG - Found bean property 'databaseProductNames' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'deadlockLoserCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'duplicateKeyCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'invalidResultSetAccessCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'permissionDeniedCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'transientDataAccessResourceCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'useSqlStateForTranslation' of type [boolean]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'DB2'
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'Derby'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'Derby'
2011-01-17 01:59:59 DEBUG - Eagerly caching bean 'Derby' to allow for resolving potential circular references
2011-01-17 01:59:59 DEBUG - Converting String to [boolean] using property editor [org.springframework.beans.propertyeditors.CustomBooleanEditor@135877f]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'Derby'
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'H2'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'H2'
2011-01-17 01:59:59 DEBUG - Eagerly caching bean 'H2' to allow for resolving potential circular references
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'H2'
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'HSQL'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'HSQL'
2011-01-17 01:59:59 DEBUG - {conn-100024} Connection
2011-01-17 01:59:59 DEBUG - Obtained JDBC Connection [Transaction-aware proxy for target Connection from DataSource [org.apache.commons.dbcp.BasicDataSource@56182f]] for iBATIS operation
2011-01-17 01:59:59 DEBUG - {conn-100024} Preparing Statement: INSERT INTO abc ( abc ) VALUES ( ? )
2011-01-17 01:59:59 DEBUG - Fetching JDBC Connection from DataSource
2011-01-17 01:59:59 INFO - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2011-01-17 01:59:59 DEBUG - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
2011-01-17 01:59:59 DEBUG - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN 2.0//EN] and system ID [http://www.springframework.org/dtd/spring-beans-2.0.dtd]
2011-01-17 01:59:59 DEBUG - Trying to locate [spring-beans-2.0.dtd] in Spring jar
2011-01-17 01:59:59 DEBUG - Found beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in classpath: spring-beans-2.0.dtd
2011-01-17 01:59:59 DEBUG - Loading bean definitions
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'DB2'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'DB2'
2011-01-17 01:59:59 DEBUG - Eagerly caching bean 'DB2' to allow for resolving potential circular references
2011-01-17 01:59:59 DEBUG - Getting BeanInfo for class [org.springframework.jdbc.support.SQLErrorCodes]
2011-01-17 01:59:59 DEBUG - Caching PropertyDescriptors for class [org.springframework.jdbc.support.SQLErrorCodes]
2011-01-17 01:59:59 DEBUG - Found bean property 'badSqlGrammarCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'cannotAcquireLockCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'cannotSerializeTransactionCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'class' of type [java.lang.Class]
2011-01-17 01:59:59 DEBUG - Found bean property 'customSqlExceptionTranslator' of type [org.springframework.jdbc.support.SQLExceptionTranslator]
2011-01-17 01:59:59 DEBUG - Found bean property 'customSqlExceptionTranslatorClass' of type [java.lang.Class]
2011-01-17 01:59:59 DEBUG - Found bean property 'customTranslations' of type [[Lorg.springframework.jdbc.support.CustomSQLErrorCodesTranslation;]
2011-01-17 01:59:59 DEBUG - Found bean property 'dataAccessResourceFailureCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'dataIntegrityViolationCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'databaseProductName' of type [java.lang.String]
2011-01-17 01:59:59 DEBUG - Found bean property 'databaseProductNames' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'deadlockLoserCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'duplicateKeyCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'invalidResultSetAccessCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'permissionDeniedCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'transientDataAccessResourceCodes' of type [[Ljava.lang.String;]
2011-01-17 01:59:59 DEBUG - Found bean property 'useSqlStateForTranslation' of type [boolean]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1b14530]
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'DB2'
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'Derby'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'Derby'
2011-01-17 01:59:59 DEBUG - Eagerly caching bean 'Derby' to allow for resolving potential circular references
2011-01-17 01:59:59 DEBUG - Converting String to [boolean] using property editor [org.springframework.beans.propertyeditors.CustomBooleanEditor@135877f]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@152b6f5]
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'Derby'
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'H2'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'H2'
2011-01-17 01:59:59 DEBUG - Eagerly caching bean 'H2' to allow for resolving potential circular references
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d297c0]
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'H2'
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'HSQL'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'HSQL'
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'PostgreSQL'
2011-01-17 01:59:59 DEBUG - Creating shared instance of singleton bean 'Sybase'
2011-01-17 01:59:59 DEBUG - Creating instance of bean 'Sybase'
2011-01-17 01:59:59 DEBUG - Eagerly caching bean 'Sybase' to allow for resolving potential circular references
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@12f4538]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@12f4538]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@12f4538]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@12f4538]
2011-01-17 01:59:59 DEBUG - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@12f4538]
2011-01-17 01:59:59 DEBUG - Finished creating instance of bean 'Sybase'
2011-01-17 01:59:59 INFO - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2011-01-17 01:59:59 DEBUG - Looking up default SQLErrorCodes for DataSource [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy@69695f]
2011-01-17 01:59:59 DEBUG - Fetching JDBC Connection from DataSource
2011-01-17 01:59:59 DEBUG - Fetching JDBC Connection from DataSource
2011-01-17 01:59:59 DEBUG - Returning JDBC Connection to DataSource
2011-01-17 01:59:59 DEBUG - Returning JDBC Connection to DataSource
2011-01-17 01:59:59 DEBUG - Database product name cached for DataSource [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy@69695f]: name is 'MySQL'
2011-01-17 01:59:59 DEBUG - SQL error codes for 'MySQL' found
2011-01-17 01:59:59 DEBUG - Unable to translate SQLException with Error code '0', will now try the fallback translator
2011-01-17 01:59:59 DEBUG - Returning JDBC Connection to DataSource[/code]
这个错是什么意思 咋冒出这么多数据库来 我用的是mysql 是不是SQL语句有问题?求解[/code]
你这个语句打?号干嘛呀sqlMap.xml有问题
debug看看值是否为空