Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
  • 02:02
    15993192077 starred apache/shardingsphere
  • 01:06
    cheese8 labeled #17987
  • 01:06
    cheese8 labeled #17987
  • 01:04
    cheese8 commented #17987
  • May 28 22:57
    codecov-commenter commented #18037
  • May 28 22:40
    Liangda-w labeled #18036
  • May 28 22:40
    Liangda-w labeled #18036
  • May 28 22:40
    Liangda-w labeled #18034
  • May 28 22:40
    Liangda-w labeled #18034
  • May 28 22:39
    Liangda-w labeled #18032
  • May 28 22:39
    Liangda-w labeled #18032
  • May 28 22:37

    Liangda-w on master

    Support Parsing DROP RULE in op… (compare)

  • May 28 22:37
    Liangda-w closed #18034
  • May 28 22:34

    Liangda-w on master

    Support Parsing ALTER RULE in o… (compare)

  • May 28 22:34
    Liangda-w closed #18032
  • May 28 22:30

    Liangda-w on master

    Support parsing ALTER FLASHBACK… (compare)

  • May 28 22:30
    Liangda-w closed #18036
  • May 28 22:21
    menghaoranss converted_to_draft #18037
  • May 28 22:21
    menghaoranss labeled #18037
  • May 28 22:21
    menghaoranss milestoned #18037
吴晟 Wu Sheng
There is no side-effect of salaried contributors. They are everywhere.
When I using "delete from t_name where id= ?" to delete a record, the "id" is sharding key, then throw "java.lang.IllegalArgumentException: Sharding value must implements Comparable.", what problem?

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.3:compile (default-compile) on project sharding-core-api: Fatal error compiling: java.lang.ExceptionInInitializerError: com.sun.tools.javac.code.TypeTags -> [Help 1]
when i install using mvn clean install -Prelease ,show this error
no driver in docker image,why?

I'm using sharding-jdbc for READ-WRITE SPLIT,


but it seems sharding-jdbc can't recognize @Lock,here is a jpa method

    GuestAuthorization findUpdateByUniqueIdAndAppId(String uniqueId,String appId);

when execute it i got this error.
Caused by: java.sql.SQLException: The MySQL server is running with the --read-only option so it cannot execute this statement

any suggestions?

append: DataBase is Mysql
need help
update oepration will spread to all subTable ?
MySQL Workbench cannot connect to sharding-proxy
question solved user HintManager.setMasterOnly()
@wu-sheng sorry for bother, our new project start use Sharing-JDBC ,it's configuration is pretty easy. but I got some problem:
we are using hibernate as orm, and hibernate only use primary-key as condition when update, which will
cause SS route to all sub tables. is there any known solution? modify hibernate or SS ?
Can Sharding-Sphere future release support "insert into Schema_1.Table_A select * from Schema_2.Table_B" syntax ?
does sharding-jdbc support mysql "force index” syntax ?
./mvnw org.apache.maven.plugins:maven-checkstyle-plugin:3.1.0:check failed in java 1.7
jdk11 java.lang.NoClassDefFoundError: Could not initialize class org.apache.shardingsphere.core.parse.core.rule.registry.ParseRuleRegistry
jdk8 is normal
what reason?
Use multithreading to test performance, write 100000 records, how can it take more than 10 minutes
Spring boot environment
hi, everybody. how sharding-proxy work with high availability ?
hi, does anyone use shardingsphere_jdbc 4.1.0 + dbunit 2.7.0 + h2 for testing ?
I got the warning message "[WARN DatabaseTableMetaData:275] - Cannot find column from ResultSetMetaData info via DatabaseMetaData. Returning null. Even if this is expected to never happen it probably happened due to a JDBC driver bug. To get around this you may want to configure a user defined interface org.dbunit.database.IMetadataHandler
java.lang.IllegalStateException: Did not find column 'id' for <schema.table> 'logic_db.user_account' in catalog 'logic_db' because names do not exactly match."
往垂直分表(子表)里插入数据,sharding报Sharding value must implements Comparable.异常是为什么呀
sharding-proxy encryption don't work.vision:4.1.1
What could be the cause?
在sharding-proxy中 可以配置读写分离和数据脱敏用一个schemaName配置吗?版本是4.1.1
可以说中文吗? 可以的话,问个问题,5.0 什么时候发布Release 版本呢
@cmonkey maybe this week.
Anyone deploy shardingproxy on k8s as a service ? I have a issue that client connections can transfer to new or restarted pod, the service is unbalance unless I restart all the client. Any one have Ideas to resolve this issue?
I have multi shardingproxy pod to make the service HA, But cannot balance connections while add a new shardingproxy instance.
大家好,sharding proxy 可以添加自定义的加密算法嘛,怎么添加?你们有用过吗?
Hello everyone, can sharding proxy add a custom encryption algorithm, how to add it? Have you ever used it?

Hi guys, does anybody can explain this confusion of mine?

When I was using shardingsphere, I met a exception as follows, and it's from the class HintManager, method is getInstance().
java.lang.NullPointerException: Hint has previous value, please clear first.

I read the source code, more or less, feeling a little confused about the code design here.
According to my understanding, the reason why HintManager.getInstance() throw a NullPointerException is that wants to guarantee, or we can say it wants to tell its caller that ONLY ONE instance can be used here, during the whole period.
But why not consider that design the code as a singleton pattern? I mean that there is no need to throw the NPE exception here, instead that the sharding framework should guarantee this (just only one instance of HintManager), but not external caller to guarantee that.

Looking forward to your reply, thanks so much.

@ShardingSphereTransactionType(TransactionType.XA) 能作用在存在RPC调用的方法上吗
Devam Parikh
Screenshot from 2022-04-01 15-27-27.png

Does anyone know how to remove `ava.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.connection" is null

at org.apache.shardingsphere.mode.repository.standalone.h2.H2Repository.get(H2Repository.java:85)
at org.apache.shardingsphere.mode.repository.standalone.h2.H2Repository.persist(H2Repository.java:129)
at org.apache.shardingsphere.mode.repository.standalone.h2.H2RepositoryTest.assertMethodPersistAndGet(H2RepositoryTest.java:52)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)


2 replies
How can we remove this error??
Devam Parikh
Hi, will anyone let me know how to set environment variable for this project?



Try adding the dependency dbcp2.