You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/04/04 05:44:24 UTC

[GitHub] [incubator-shardingsphere] KomachiSion opened a new issue #2159: ShardingResultSet getTimestamp throw ClassCastException when using oracle database

KomachiSion opened a new issue #2159: ShardingResultSet getTimestamp throw ClassCastException when using oracle database
URL: https://github.com/apache/incubator-shardingsphere/issues/2159
 
 
   ## Bug Report
   
   ClassCastException is thrown when querying the timestamp type field of the Oracle database
   
   ### Which version of ShardingSphere did you use?
   
   4.0.0-RC1-SNAPSHOT
   
   ### Which project did you use? Sharding-JDBC or Sharding-Proxy?
   
   Sharding-JDBC
   
   ### Expected behavior
   
   query successfully
   
   ### Actual behavior
   
   ```
   java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.sql.Timestamp
   	at org.apache.shardingsphere.shardingjdbc.jdbc.core.resultset.ShardingResultSet.getTimestamp(ShardingResultSet.java:223)
   	at org.hibernate.type.descriptor.sql.TimestampTypeDescriptor$2.doExtract(TimestampTypeDescriptor.java:76)
   	at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47)
   	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:238)
   	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:234)
   	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:224)
   	at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:300)
   	at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2790)
   	at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1729)
   	at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1655)
   	at org.hibernate.loader.Loader.getRow(Loader.java:1544)
   	at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:727)
   	at org.hibernate.loader.Loader.processResultSet(Loader.java:972)
   	at org.hibernate.loader.Loader.doQuery(Loader.java:930)
   	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
   	at org.hibernate.loader.Loader.doList(Loader.java:2617)
   	at org.hibernate.loader.Loader.doList(Loader.java:2600)
   	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)
   	at org.hibernate.loader.Loader.list(Loader.java:2424)
   	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
   	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
   	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
   	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
   	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
   	at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
   	at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483)
   	at org.hibernate.jpa.criteria.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:50)
   	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.readPage(SimpleJpaRepository.java:589)
   	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:409)
   	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:377)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   ```
   
   ### Reason analyze (If you can)
   
   ShardingResultSet cached result as QueryRow which created by jdbc.getObject method.
   But ojdbc.getObject will return `oracle.sql.TIMESTAMP` instead of `java.sql.Timestamp`
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ojdbc version is 12.1.0.1
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services