XUZHOUWANG opened a new issue #10274:
URL: https://github.com/apache/shardingsphere/issues/10274
**table：**
@TableName("t_user")
@Data
public class User implements Serializable {
@TableId(type = IdType.INPUT)
private Long id;
private String name;
private Date gmtCreate;
private Date gmtModified;
private String phone;
private Integer isDeleted;
}
**config**
sharding:
tables:
t_user:
actual-data-nodes: skshardingjdbc.t_user_$->{0..1}
logicTable: t_user
tableStrategy:
inline:
shardingColumn: id
algorithmExpression: t_user_$->{id % 2}
keyGenerator:
type: UUID
column: id
**error**
### SQL: INSERT INTO t_user ( id, name, gmt_create, gmt_modified, phone )
VALUES ( ?, ?, ?, ?, ? )
### Cause: java.lang.IllegalArgumentException: Sharding value must
implements Comparable.
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
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)
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 37 more
--
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:
[email protected]
