oceanbase/obconnector-j

OceanBase Client for Java is a JDBC 4.2 compatible driver, used to connect applications developed in Java to OceanBase Database Server.

English | 中文版

OceanBase Database is a distributed relational database. It is developed entirely by Ant Group. The OceanBase Database is built on a common server cluster. Based on the Paxos protocol and its distributed structure, the OceanBase Database provides high availability and linear scalability. The OceanBase Database is not dependent on specific hardware architectures.

Key features

• Transparent Scalability: 1,500 nodes, PB data and a trillion rows of records in one cluster.
• Ultra-fast Performance: TPC-C 707 million tmpC and TPC-H 15.26 million QphH @30000GB.
• Cost Efficiency: saves 70%–90% of storage costs.
• Real-time Analytics: supports HTAP without additional cost.
• Continuous Availability: RPO = 0(zero data loss) and RTO < 8s(recovery time)
• MySQL Compatible: easily migrated from MySQL database.

See also key features for more details.

Quick start

🔥 Start with all-in-one

You can quickly deploy a stand-alone OceanBase Database to experience with the following commands:

Note: Linux Only

# download and install all-in-one package (internet connection is required)
bash -c "$(curl -s https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/installer.sh)"
source ~/.oceanbase-all-in-one/bin/env.sh

# quickly deploy OceanBase database
obd demo

🐳 Start with docker

1. Start an OceanBase Database instance:

   # Deploy a mini standalone instance.
   docker run -p 2881:2881 --name oceanbase-ce -e MODE=mini -d oceanbase/oceanbase-ce

2. Connect to the OceanBase Database instance:

   docker exec -it oceanbase-ce ob-mysql sys # Connect to the root user of the sys tenant.

See also Quick experience or Quick Start (Simplified Chinese) for more details.

☸️ Start with Kubernetes

You can deploy and manage OceanBase Database instance in kubernetes cluster with ob-operator quickly. Refer to the document Quick Start for ob-operator to see details.

👨‍💻 Start developing

See OceanBase Developer Document to learn how to compile and deploy a manually compiled observer.

Roadmap

For future plans, see Product Iteration Progress. See also OceanBase Roadmap for more details.

Case study

OceanBase has been serving more than 1000 customers and upgraded their database from different industries, including Financial Services, Telecom, Retail, Internet, and more.

See also success stories and Who is using OceanBase for more details.

System architecture

Introduction to system architecture

Contributing

Contributions are highly appreciated. Read the development guide to get started.

License

OceanBase Database is licensed under the Mulan Public License, Version 2. See the LICENSE file for more info.

Community

Join the OceanBase community via:

• Slack Workspace
• Ask on Stack Overflow
• Chinese User Forum
• DingTalk Group: 33254054 (QR code)
• WeChat Group (Add the assistant with WeChat ID: OBCE666)

obconnector-j's Issues

[Bug]: 高并发下getCachedSql报java.lang.ClassCastException

Describe the bug

报错信息：
Suppressed: java.lang.ClassCastException: java.util.LinkedHashMap$Entry cannot be cast to java.util.HashMap$TreeNode at java.util.HashMap$TreeNode.moveRootToFront(HashMap.java:1835) ~[?:1.8.0_242] at java.util.HashMap$TreeNode.treeify(HashMap.java:1951) ~[?:1.8.0_242] at java.util.HashMap.treeifyBin(HashMap.java:772) ~[?:1.8.0_242] at java.util.HashMap.putVal(HashMap.java:644) ~[?:1.8.0_242] at java.util.HashMap.put(HashMap.java:612) ~[?:1.8.0_242] at com.oceanbase.jdbc.OceanBaseConnection.getCachedSql(OceanBaseConnection.java:612) ~[oceanbase-client-2.4.1.jar!/:?] at com.oceanbase.jdbc.OceanBaseConnection.internalPrepareStatement(OceanBaseConnection.java:643) ~[oceanbase-client-2.4.1.jar!/:?] at com.oceanbase.jdbc.OceanBaseConnection.prepareStatement(OceanBaseConnection.java:438) ~[oceanbase-client-2.4.1.jar!/:?] at com.p6spy.engine.wrapper.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:118) ~[p6spy-3.7.0.jar!/:?] at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337) ~[HikariCP-4.0.3.jar!/:?] at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) ~[HikariCP-4.0.3.jar!/:?] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1556) ~[spring-jdbc-5.2.24.RELEASE.jar!/:5.2.24.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:615) ~[spring-jdbc-5.2.24.RELEASE.jar!/:5.2.24.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669) ~[spring-jdbc-5.2.24.RELEASE.jar!/:5.2.24.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700) ~[spring-jdbc-5.2.24.RELEASE.jar!/:5.2.24.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:753) ~[spring-jdbc-5.2.24.RELEASE.jar!/:5.2.24.RELEASE]

Environment

版本：oceanbase-client-2.4.1.jar

Fast reproduce steps

频繁查询即可触发

Expected behavior

No response

Actual behavior

No response

Additional context

No response

[Bug]: 海量数据查询报OOM错误

Describe the bug

通过jdbc oracle企业版在查询海量数据的时候，如1亿以上，报OOM。同样代码在ORACLE下无问题，部分代码如下：
stmt = conn.prepareStatement(sql,
ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
stmt.setFetchDirection(ResultSet.FETCH_FORWARD);
stmt.setFetchSize(1000);
rs = stmt.executeQuery(); // 内存溢出

Environment

驱动版本2.4.3

Fast reproduce steps

/

Expected behavior

No response

Actual behavior

No response

Additional context

No response

IDEA连接oceanbase数据库获取不到注释的建议

针对IDEA连接oceanbase数据库获取不到注释的建议，我的做法是join user_col_comments 表 关联查询出字段对应的comments

[Bug]: JDBC查询BINARY_FLOAT类型时出错

Describe the bug

create table T4(ID BINARY_FLOAT);
insert into T4 values(1.2);

然后通过jdbc 使用select 查询这个表,当调用resultSet.getObject()方法时驱动会报错,驱动用的oceanbase-client:2.4.3
错误的位置在下面截图这里:

这里直接new String(bytes) 没看懂..

下面用Float.intBitsToFloat转换能正常显示出插入值 1.2