DataGrip连接oceanbase（OB）数据库操作步骤

梦里梦外; 2022-12-28 01:53 661阅读 0赞

1.  新建Driver

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70]  
2. 配置OB驱动  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 1]  
3. 创建数据源  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 2]  
4. 配置数据源![List item][]  
5.有的同学配置完上面的文件后总是提示时区找不到  
![在这里插入图片描述][2020121409115919.png]  
此时需要对数据源的advanced进行配置，添加时区  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 3]  
最后，大功告成。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 4]  
喜欢就关注我的公众号吧，不定期的技术分享哦！  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 5]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70]: /images/20221120/c0837f0ea0f24ddbb1921262e2704a76.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201214090702703.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201214090830500.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ==,size_16,color_FFFFFF,t_70
[List item]: https://img-blog.csdnimg.cn/20201214090947772.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ==,size_16,color_FFFFFF,t_70
[2020121409115919.png]: https://img-blog.csdnimg.cn/2020121409115919.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201214091344470.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201214091543708.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20201214091623302.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ==,size_16,color_FFFFFF,t_70