Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • 14:25
    tristaZero commented #13909
  • 14:18
    tristaZero assigned #13909
  • 12:33
    meSunnySrivastava commented #13792
  • 11:42

    terrymanu on master

    Separate cdc dialect classes fr… (compare)

  • 11:42
    terrymanu closed #13935
  • 06:10
    EarthXuan closed #13930
  • 06:10
    EarthXuan commented #13930
  • 06:10
    EarthXuan commented #13930
  • 06:09
    EarthXuan commented #13930
  • 05:34
    RaigorJiang commented #13930
  • 05:31
    RaigorJiang commented #13930
  • 05:30
    EarthXuan commented #13930
  • 05:28
    TeslaCN commented #13930
  • 05:28
    TeslaCN commented #13930
  • 05:26
    EarthXuan commented #13930
  • 05:23
    EarthXuan commented #13930
  • 05:23
    EarthXuan commented #13930
  • 05:10
    EarthXuan commented #13930
  • 05:10
    EarthXuan commented #13930
  • 05:06
    RaigorJiang commented #13930
MaxBill
@MaxBill
导致数据分片都到同一个表中了
oneone1995
@oneone1995
图片.png
启动后一直在刷这个是正常的嘛
Liang Zhang
@terrymanu
please read document first
shaojava
@shaojava
如果只想分库应该如何设置?如何动态添加数据源?
Liang Zhang
@terrymanu
see example
saaav
@saaavsaaa
@oneone1995 spring cloud?
hyjcxy
@hyjcxy
我用3.0.0.M1插入数据时为什么会报空指针呢,哪位大神告诉一下呗
主从的时候 插入数据 报 ### Error updating database. Cause: java.lang.NullPointerException

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: insert into t_user (id,user_id,name,age) values (?,?,?,?)

Cause: java.lang.NullPointerException] with root cause 这个问题最后怎么解决的啊?

Liang Zhang
@terrymanu
for en only
hyjcxy
@hyjcxy
@terrymanu
when i user 3.0.0.M1 insert it will tell me java.lang.NullPointerException
Liang Zhang
@terrymanu
please provide more details
hyjcxy
@hyjcxy

Error updating database. Cause: java.lang.NullPointerException

The error may involve main.com.yi23.dao.IVipLookDao.addLogViplookRemrk-Inline

The error occurred while setting parameters

SQL: insert into log_viplook_match_order ( viplook_match_order_id, remark, add_time, add_admin_id, add_admin_name, uid ) values ( ?, ?, ?, ?, ?, ? )

Cause: java.lang.NullPointerException

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141)
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:358)
... 102 more

Caused by: java.lang.NullPointerException
at io.shardingsphere.core.jdbc.metadata.dialect.JDBCShardingRefreshHandler.execute(JDBCShardingRefreshHandler.java:49)
at io.shardingsphere.core.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:159)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
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.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at main.com.yi23.console.interceptor.MybatisLogInterceptor.intercept(MybatisLogInterceptor.java:62)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:60)
at com.sun.proxy.$Proxy168.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
... 108 more

image.png
Liang Zhang
@terrymanu
this issue is fixed at 3.0.0.m2
hyjcxy
@hyjcxy
Can I use this version now?
my version is m1 for now
when will the version m2 release?
Liang Zhang
@terrymanu
neither m1 nor m2 are not stable version,3.0.0 is stable version,but still need few month to release
hyjcxy
@hyjcxy
got it
hyjcxy
@hyjcxy
Didn't find 3.0.0 repository ,can u share the repository url please,thx
Liang Zhang
@terrymanu
3.0.0 will release after milestone stable
吴晟 Wu Sheng
@wu-sheng
Oh, your guys are still awake?
Liang Zhang
@terrymanu
write test case now (T_T)
吴晟 Wu Sheng
@wu-sheng
:P Crazy~
Liang Zhang
@terrymanu
will fix soon
hyjcxy
@hyjcxy
@terrymanu
hi
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'io.shardingsphere.jdbc.spring.boot.SpringBootConfiguration': Initialization of bean failed; nested exception is io.shardingsphere.core.exception.ShardingException
can you tell me what this exception
how to deal it
JingShouyan
@jingshouyan
@terrymanu table name will be rewrite into lowercase when create table sharding-sphere/sharding-sphere#1080
lonelyboy
@lonelyboy
@terrymanu 我用3.0.0.M1 我在官网的文档库看到是支持postgresql的,但是发现集成sharding-jdbc 3.0.0M1后, 我本来的查询脚本是 select xxx from schema.tablename 但是实际经过sharding-jdbc的解析后,变成了select xxx from tablename ,schema被取掉了,导致查询出错,我是个初学者 请问sharding 有这方面的问题吗?
sunyinhui
@sunyinhui
@ik662 ,你好,请问下老版中怎么配置特定mapper不走sharding的啊?谢谢啦
jason
@jasondeepny
请问下分表的话,是通过配置分表策略来生成多张表?还是需要自己写脚本生成表?持久层框架使用的是mybatis,谢谢
@terrymanu
Share猿
@lywlefan
@jasondeepny 需要自己用脚本生成
wqwin
@wqwin
有没有好的处理分页的方式
exception-coder
@exception-coder
同样的语句 分库的键变了就抛异常了
image.png
image.png
exception-coder
@exception-coder
有没有人
言七墨
@qimok
update message
set message.sender_visible = case message.message_id
when 100002 then false
when 100013 then true
end,
message.visible_roles = case message.message_id
when 100002 then 2
when 100013 then 4
end
where (
message.message_id in (
100013, 100002
)
and message.session_root_id in (
6, 1
)
)
Cannot support Multiple-Table for
麻烦问下,有人知道这个问题吗,我明明只更新一张表...
@terrymanu
noodv
@noodv
hello
god
when i use sharding-sphere and mybatis-plus
always tell me ### Cause: java.lang.NullPointerException