Giter Club home page Giter Club logo

ali-dbhub's Introduction

此仓库将不再维护

ali-dbhub's People

Contributors

aobingjava avatar chenxian01 avatar dangdang01234 avatar fanjinyu-fjy avatar gt-tool avatar hou-shuaishuai avatar idjack avatar ke1ying avatar shanhexi avatar shenchenyang avatar swallowgg avatar tmlx1990 avatar xinzhuxiansheng avatar yuanzhixiang avatar zhuangjiaju avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

ali-dbhub's Issues

window版 启动报错

启动后报错“COMMON_SYSTEM_ERROR: 系统开小差啦,请尝试刷新页面或者联系管理员”,展开数据库表也报这个错,执行查询也报这个错,好像做任何操作都报这个错

unable to find valid certification path to requested target: null

连接 内网sql_server 点击连接测试时报 【unable to find valid certification path to requested target: null】 连接不上,如何修正呢
日志如下:
2023-05-18 11:25:40.315 [http-nio-127.0.0.1-10824-exec-4] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed begin:com.alibaba.dbhub.server.web.api.controller.data.source.DataSourceControllerpreConnect ,param:[{"alias":"@xxxx","extendInfo":[],"host":"xxxx","password":"","port":"1433","ssh":{"password":"","use":false,"userName":""},"type":"SQLSERVER","url":"jdbc:sqlserver://xxxx:1433;","user":"xxx"}]
2023-05-18 11:25:40.461 [http-nio-127.0.0.1-10824-exec-4] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed end:com.alibaba.dbhub.server.web.api.controller.data.source.DataSourceControllerpreConnect, result:{"errorCode":"unable to find valid certification path to requested target","success":false}, cost:146

希望支持的产品功能

希望新增数据源是可以连接odps的,目前工作用的都是maxcompute如果能连接这种在线数据源就好了

在开启全局代理的情况下,Chat2DB无法调用OpenAI API,建议像IDEA那样支持手动设置代理

以下是ChatGPT的回答:

Clash 是一个代理工具,它可以设置系统代理,使得大部分应用程序通过代理服务器进行通信。然而,并非所有的应用程序都会自动使用系统代理。Java 应用程序在某些情况下不会自动使用系统代理设置,因此您需要在 Java 代码中显式配置代理。

我本机HTTP代理端口是1080,修改类OpenAIClient的代码如下,则Chat2DB可以正常调用OpenAI API

    public static void refresh() {
        String apikey;
        ConfigService configService = ApplicationContextUtil.getBean(ConfigService.class);
        Config config = configService.find(OPENAI_KEY).getData();
        if (config != null) {
            apikey = config.getContent();
        } else {
            apikey = ApplicationContextUtil.getProperty(OPENAI_KEY);
        }
        log.info("refresh openai apikey:{}", maskApiKey(apikey));

        // 新增代码:自定义OkHttpClient,支持代理
        Proxy proxy = new Proxy(Proxy.Type.HTTP, new InetSocketAddress("127.0.0.1", 1080));
        OkHttpClient okHttpClient = new OkHttpClient.Builder().proxy(proxy).build();
        OPEN_AI_STREAM_CLIENT = OpenAiStreamClient.builder().apiHost(OpenAIConst.OPENAI_HOST).apiKey(
            Lists.newArrayList(apikey)).okHttpClient(okHttpClient).build();
        apiKey = apikey;
    }

零日期值问题

打开已有的表,显示“Zero date value prohibited”,虽然这种确实不规范,但是应该需要展示查询出来的数据

连接Oracle11g出现问题

1、测试连接报错
image
将URL中的斜杠改成 @ ,能 通过连接测试 jdbc:oracle:thin:@192.168.8.143:1521:orcl
2、连接后双击打开连接报错
image
3、点击编辑数据源,数据未回显
image
4、编辑数据源,在数据未回显状态下,随便修改点内容,如填写密码,url 会变成 underfined
image

分组

可以支持将链接分组的功能吗?

M1 Pro 修改database不生效

通过编辑数据源操作将连接中的数据库由postgres修改为demo后,refresh 连接后仍然是postgres数据库,而不是修改后的demo数据库
image
image

Schema是否也是数据隐私的一部分

如题,虽然通过LLM生成SQL只需要表的Schema,但是在公司(比如我在的淘特)眼里,Schema可能也是数据隐私,如何规避这种情况?是否有必要做一个对Schema做一层模糊的映射才可能在公司内部使用?

使用mysql库时,启动报错,需添加依赖 flyway-mysql

编译之后,使用mysql数据源启动,报错org.flywaydb 不支持mysql,需添加依赖 flyway-mysql 或者降低 flyway-core版本。
ali-dbhub-server-start/pom.xml 添加相应版本的依赖重新打包启动成功

org.flywaydb
flyway-mysql
9.8.1

产品功能建议

目前发现只有查询功能,不能在线修改表中的数据;
希望增加如下最常用的功能:
1、在查询Tab中查询某张表后 ,在结果集中可以在线编辑然后执行生效操作。
2、右键表名时可以查看表结构,类似执行 DESC 表名。
3、右键表名时希望可以修改表结构。
4、根据查询结构可以导出 insert 语句。

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.