ORA-00904: "Is_default": Invalid identifier

A description of the problem

User feedback can not query the front desk data, error 500, the background to view the log as follows, using the ibatis+oracle connection method:

09:05:56 Info-atomikos Connection proxy for [email protected]:close () ...

09:05:56 ERROR- get an exception in the store's own categorized list data ~ 

---The erroroccurred while applying a parameter map.

---Check theshop.querylistbyparentid-inlineparametermap.

---Check thestatement (query failed).

---cause:java.sql.sqlexception:ora-00904: "is_default": Invalid identifier

Com.ibatis.common.jdbc.exception.NestedSQLException:

---The erroroccurred while applying a parameter map.

---Check thesho.querylistbyparentid-inlineparametermap.

---Check thestatement (query failed).

---cause:java.sql.sqlexception:ora-00904: "is_default": Invalid identifier

Atcom.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback (mappedstatement.java:201 )

Atcom.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList (mappedstatement.java:139)

Atcom.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList (sqlmapexecutordelegate.java:567)

Atcom.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList (sqlmapexecutordelegate.java:541)

Atcom.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList (sqlmapsessionimpl.java:118)

Atcom.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList (sqlmapclientimpl.java:94)

Atcom.supplier.service.impl.ShopServiceImpl.queryShopByParentId (shopserviceimpl.java:119)

Atsun.reflect.GeneratedMethodAccessor395.invoke (Unknown Source)

Atsun.reflect.DelegatingMethodAccessorImpl.invoke (DELEGATINGMETHODACCESSORIMPL.JAVA:25)

Atjava.lang.reflect.Method.invoke (method.java:597)

Atorg.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection (aoputils.java:309)

Atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke (jdkdynamicaopproxy.java:196)

At$proxy61.queryshopbyparentid (Unknown Source)

Atcom.supplier.action.SupplierBaseAction.setShopForList (supplierbaseaction.java:690)

Atcom.supplier.action.product.ProductMainAction.showList (productmainaction.java:196)

ATSUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method)

Atsun.reflect.NativeMethodAccessorImpl.invoke (nativemethodaccessorimpl.java:39)

Atsun.reflect.DelegatingMethodAccessorImpl.invoke (DELEGATINGMETHODACCESSORIMPL.JAVA:25)

Atjava.lang.reflect.Method.invoke (method.java:597)

Two analytical ideas

1. Check sql.xml configuration no problem, fields and SQL statements are OK

2. Check the Jdbc.xml configuration file, view the database configuration, log in to the corresponding database, check the table shop, found that the shop does not have this field Is_default

Three-way solution

Add this field below the shop (you forgot to add it before)

Check the database:

Sql> desc Shop

Name Null? Type

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

shop_id not Nullnumber (22)

Modif_user Number (22)

Exec_sql VARCHAR2 (250)

Is_expandall VARCHAR2 (2)

Normal Condition:

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)

This article is from the "Ruffian Cook actor" blog, please be sure to keep this source http://chenwei.blog.51cto.com/32183/1703431

ORA-00904: "Is_default": Invalid identifier