java.sql.SQLException: 无法转换为内部表示

[chenchongqi]

建索引的时候有个异常，抽时间处理一下，把出错日志都淹没了，低优先级。

[04-22 06:51:15.758] java.sql.SQLException: 无法转换为内部表示
[04-22 06:51:15.758] at oracle.jdbc.driver.DatabaseError?.throwSqlException(DatabaseError?.java:112)
[04-22 06:51:15.758] at oracle.jdbc.driver.DatabaseError?.throwSqlException(DatabaseError?.java:146)
[04-22 06:51:15.758] at oracle.jdbc.driver.DatabaseError?.throwSqlException(DatabaseError?.java:208)
[04-22 06:51:15.758] at oracle.jdbc.driver.CharCommonAccessor?.getInt(CharCommonAccessor?.java:132)
[04-22 06:51:15.758] at oracle.jdbc.driver.OracleResultSetImpl?.getInt(OracleResultSetImpl?.java:521)
[04-22 06:51:15.758] at oracle.jdbc.driver.OracleResultSet?.getInt(OracleResultSet?.java:1563)
[04-22 06:51:15.758] at cn.com.pconline.enterprise.kuaisou.ItemConfig?.<init>(ItemConfig?.java:66)
[04-22 06:51:15.758] at cn.com.pconline.enterprise.kuaisou.IndexBuilder?.addProduct2Index(IndexBuilder?.java:612)
[04-22 06:51:15.758] at cn.com.pconline.enterprise.kuaisou.IndexBuilder?.buildProduct2IndexAll(IndexBuilder?.java:530)
[04-22 06:51:15.758] at cn.com.pconline.enterprise.service.BuildIndexService?.buildProduct2Index(BuildIndexService?.java:57)
[04-22 06:51:15.758] at cn.com.pconline.enterprise.service.BuildIndexService?$$FastClassByCGLIB$$d3606623.invoke(<generated>)
[04-22 06:51:15.758] at net.sf.cglib.proxy.MethodProxy?.invoke(MethodProxy?.java:149)
[04-22 06:51:15.758] at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation?.invokeJoinpoint(Cglib2AopProxy.jav
a:700)
[04-22 06:51:15.758] at org.springframework.aop.framework.ReflectiveMethodInvocation?.proceed(ReflectiveMethodInvocation?.java:149)
[04-22 06:51:15.758] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor?.invoke(PersistenceExceptionTra?
nslationInterceptor.java:138)
[04-22 06:51:15.758] at org.springframework.aop.framework.ReflectiveMethodInvocation?.proceed(ReflectiveMethodInvocation?.java:171)
[04-22 06:51:15.758] at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor?.intercept(Cglib2AopProxy.java:
635)
[04-22 06:51:15.759] at cn.com.pconline.enterprise.service.BuildIndexService?$$EnhancerByCGLIB$$263cb5ed.buildProduct2Index(<gener
ated>)
[04-22 06:51:15.759] at cn.com.pconline.enterprise.web.servlet.BuildIndexServlet?.service(BuildIndexServlet?.java:39)
[04-22 06:51:15.759] at javax.servlet.http.HttpServlet?.service(HttpServlet?.java:91)
[04-22 06:51:15.759] at com.caucho.server.dispatch.ServletFilterChain?.doFilter(ServletFilterChain?.java:103)
[04-22 06:51:15.759] at cn.com.pconline.enterprise.util.UrlRewriteFilter?.doFilter(UrlRewriteFilter?.java:145)
[04-22 06:51:15.759] at com.caucho.server.dispatch.FilterFilterChain?.doFilter(FilterFilterChain?.java:87)
[04-22 06:51:15.759] at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter?.doFilterInternal(OpenEntityManagerInVie?
wFilter.java:112)
[04-22 06:51:15.759] at org.springframework.web.filter.OncePerRequestFilter?.doFilter(OncePerRequestFilter?.java:76)
[04-22 06:51:15.759] at com.caucho.server.dispatch.FilterFilterChain?.doFilter(FilterFilterChain?.java:87)
[04-22 06:51:15.759] at cn.com.pconline.enterprise.util.EnvFilter?.doFilter(EnvFilter?.java:34)
[04-22 06:51:15.759] at com.caucho.server.dispatch.FilterFilterChain?.doFilter(FilterFilterChain?.java:87)
[04-22 06:51:15.759] at org.springframework.web.filter.CharacterEncodingFilter?.doFilterInternal(CharacterEncodingFilter?.java:96)
[04-22 06:51:15.759] at org.springframework.web.filter.OncePerRequestFilter?.doFilter(OncePerRequestFilter?.java:76)
[04-22 06:51:15.759] at com.caucho.server.dispatch.FilterFilterChain?.doFilter(FilterFilterChain?.java:87)
[04-22 06:51:15.759] at com.caucho.server.cache.CacheFilterChain?.doFilter(CacheFilterChain?.java:175)
[04-22 06:51:15.759] at com.caucho.server.webapp.WebAppFilterChain?.doFilter(WebAppFilterChain?.java:181)
[04-22 06:51:15.759] at com.caucho.server.dispatch.ServletInvocation?.service(ServletInvocation?.java:266)
[04-22 06:51:15.759] at com.caucho.server.http.HttpRequest?.handleRequest(HttpRequest?.java:268)
[04-22 06:51:15.759] at com.caucho.server.port.TcpConnection?.run(TcpConnection?.java:602)
[04-22 06:51:15.759] at com.caucho.util.ThreadPool?$Item.runTasks(ThreadPool?.java:690)
[04-22 06:51:15.759] at com.caucho.util.ThreadPool?$Item.run(ThreadPool?.java:612)
[04-22 06:51:15.759] at java.lang.Thread.run(Thread.java:619)

[chenyinle]

任务已完成。

修改的项目：
1、商品、产品、店铺、vip店铺的建索引的增量、全量索引的sql查询优化过了
2、代码调整
3、异常处理
4、顺便把上面需求的log拒绝输出了

涉及的代码：
IndexBuilder?.getSelectProductSql
IndexBuilder?.getSelectProduct2Sql
IndexBuilder?.getSelectShopSql
IndexBuilder?.getSelectVipShopSql
IndexBuilder?.addProduct2Index
IndexBuilder?.addProductIndex
ItemConfig?
...