Shulou(Shulou.com)06/01 Report--

A problem description

User feedback Unable to query data in foreground, error 500 reported, background view logs are as follows, using ibatis+oracle connection mode:

09:05:56 INFO - atomikos connection proxy for oracle.jdbc.driver.LogicalConnection@24367013: close()...

09:05:56 ERROR -Exception occurred in obtaining list data of own category in store ~

--- The error occurred while applying a parameter map.

--- Check the SHOP.queryListByParentId-InlineParameterMap.

--- Check the statement (query failed).

--- Cause: java.sql.SQLException: ORA-00904: "IS_DEFAULT": Invalid identifier

com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred while applying a parameter map.

--- Check the SHO.queryListByParentId-InlineParameterMap.

--- Check the statement (query failed).

--- Cause: java.sql.SQLException: ORA-00904: "IS_DEFAULT": Invalid identifier

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)

at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)

at com.supplier.service.impl.ShopServiceImpl.queryShopByParentId(ShopServiceImpl.java:119)

at sun.reflect.GeneratedMethodAccessor395.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)

at $Proxy61.queryShopByParentId(Unknown Source)

at com.supplier.action.SupplierBaseAction.setShopForList(SupplierBaseAction.java:690)

at com.supplier.action.product.ProductMainAction.showList(ProductMainAction.java:196)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

II Analytical thinking

1. Check sql.xml configuration is OK, fields and sql statements are normal

2. Check the jdbc.xml configuration file, view the database configuration, log in the corresponding database, check the table shop, and find that there is really no such field IS_DEFAULT under the shop.

Three Solutions

Add this field under shop (forgot to add it before)

Check the database:

SQL> desc shop

Name Null? Type

----------------------------------------- -------- ----------------------------

SHOP_ID NOT NULL NUMBER(22)

MODIF_USER NUMBER(22)

EXEC_SQL VARCHAR2(250)

IS_EXPANDALL VARCHAR2(2)

Normal conditions:

SQL> desc shop

Name Null? Type

----------------------------------------- -------- ----------------------------

SHOP_ID NOT NULL NUMBER(22)

MODIF_USER NUMBER(22)

EXEC_SQL VARCHAR2(250)

IS_EXPANDALL VARCHAR2(2)

IS_DEFAULT VARCHAR2(2)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.