Liang Zhang

The database discovery feature has been remove form ShardingSphere, please ref #24486

Due to no feedback from the author for an long period, I am closing this issue for now.

How about add derby for now only?

However, h2 or derby is not important, is it? It is for memory, user do not need aware the memory db. Maybe one db adapt is enough.

If Derby is used to completely replace H2, can it keep the same functionality while solving security issues? I‘d like to think that using an unique memory database, as it...

Standalone mode for H2 is pretty easy, just find a database can be persist into memory. Follow JDBC and SQL92 is enough.

How about hsqldb, is there any CVE issues on it?

I suggest removing the support for Derby and H2, and only keep HSQLDB. After all, memory databases do not need to be aware by users, and there is not much...

How to reproduce it?

Welcome @archits581