search

dbeaver / cloudbeaver

Cloud Database Manager
https://dbeaver.com/
Apache License 2.0
3.52k stars 381 forks source link

Added driver not available in UI #1865

Closed arezvani closed 1 year ago

arezvani commented 1 year ago

Hi, I tried to add hive driver with these configs but hive driver not showing up in UI:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <artifactId>drivers.hive</artifactId>
    <version>1.0.0</version>
    <parent>
        <groupId>io.cloudbeaver</groupId>
        <artifactId>drivers</artifactId>
        <version>1.0.0</version>
        <relativePath>../</relativePath>
    </parent>
    <properties>
        <deps.output.dir>hive</deps.output.dir>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.apache.hive</groupId>
            <artifactId>hive-jdbc</artifactId>
            <version>3.1.3</version>
        </dependency>
        <dependency>
            <groupId>jdk.tools</groupId>
            <artifactId>jdk.tools</artifactId>
            <version>1.6</version>
            <scope>system</scope>
            <systemPath>/usr/lib/jvm/temurin-17-jdk/lib/tools.jar</systemPath>
        </dependency> 
    </dependencies>
</project>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>io.cloudbeaver</groupId>
    <artifactId>drivers</artifactId>
    <version>1.0.0</version>
    <packaging>pom</packaging>

    <properties>
        <deps.output.dir>output</deps.output.dir>
    </properties>

    <modules>
        <module>clickhouse</module>
        <module>clickhouse_com</module>
        <module>db2</module>
        <module>db2-jt400</module>
        <module>derby</module>
        <module>h2</module>
        <module>h2_v2</module>
        <module>jaybird</module>
        <module>mysql</module>
        <module>mariadb</module>
        <module>oracle</module>
        <module>postgresql</module>
        <module>sqlite</module>
        <module>sqlserver</module>
    <module>trino</module>
        <module>hive</module>
    </modules>

    <build>
        <plugins>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.0</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>

            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-dependency-plugin</artifactId>
                <version>2.8</version>
                <executions>
                    <execution>
                        <id>copy-dependencies</id>
                        <phase>package</phase>
                        <goals>
                            <goal>copy-dependencies</goal>
                        </goals>
                        <configuration>
                            <useSubDirectoryPerArtifact>false</useSubDirectoryPerArtifact>
                            <outputDirectory>../../../deploy/drivers/${deps.output.dir}</outputDirectory>
                        </configuration>
                    </execution>
                </executions>
            </plugin>

        </plugins>
    </build>

</project>
<?xml version="1.0" encoding="UTF-8"?>
<plugin>
    <!-- Resource mappings -->
    <extension point="org.jkiss.dbeaver.resources">
        <resource name="drivers/db2"/>
        <resource name="drivers/db2-jt400"/>
        <resource name="drivers/mysql/mysql8"/>
        <resource name="drivers/mariadb"/>
        <resource name="drivers/oracle"/>
        <resource name="drivers/postgresql"/>
        <resource name="drivers/clickhouse"/>
        <resource name="drivers/clickhouse_com"/>
        <resource name="drivers/derby"/>
        <resource name="drivers/jaybird"/>
        <resource name="drivers/h2"/>
        <resource name="drivers/h2_v2"/>
        <resource name="drivers/sqlite/xerial"/>
        <resource name="drivers/mssql/new"/>
    <resource name="drivers/trino"/>
    <resource name="drivers/hive"/>
    </extension>

    <!-- Bundles  -->
    <extension point="org.jkiss.dbeaver.product.bundles">
        <bundle id="drivers.db2" label="DB2 drivers"/>
        <bundle id="drivers.jt400" label="DB2 iSeries drivers"/>
        <bundle id="drivers.mysql" label="MySQL drivers"/>
        <bundle id="drivers.mariadb" label="MariaDB drivers"/>
        <bundle id="drivers.oracle" label="Oracle drivers"/>
        <bundle id="drivers.postgresql" label="PostgreSQL drivers"/>
        <bundle id="drivers.clickhouse" label="Clickhouse (legacy) drivers"/>
        <bundle id="drivers.clickhouse_com" label="Clickhouse drivers"/>
        <bundle id="drivers.derby" label="Derby drivers"/>
        <bundle id="drivers.firebird" label="Firebird drivers"/>
        <bundle id="drivers.h2" label="H2 drivers"/>
        <bundle id="drivers.h2_v2" label="H2 v2 drivers"/>
        <bundle id="drivers.sqlite.xerial" label="SQLite drivers"/>
        <bundle id="drivers.mssql.new" label="SQL Server drivers"/>
    <bundle id="drivers.trino" label="Trino drivers"/>
    <bundle id="drivers.hive" label="Hive drivers"/>
    </extension>

    <!-- Enabled drivers -->
    <extension point="io.cloudbeaver.driver">
        <driver id="db2:db2"/>
        <driver id="db2_i:db2_iseries"/>
        <driver id="mysql:mysql8"/>
        <driver id="mysql:mariaDB"/>
        <driver id="oracle:oracle_thin"/>
        <driver id="postgresql:postgres-jdbc"/>
        <driver id="jaybird:jaybird"/>
        <driver id="clickhouse:yandex_clickhouse"/>
        <driver id="clickhouse:com_clickhouse"/>
        <driver id="generic:derby_server"/>
        <driver id="h2:h2_embedded"/>
        <driver id="h2:h2_embedded_v2"/>
        <driver id="sqlite:sqlite_jdbc"/>
        <driver id="sqlserver:microsoft"/>
    <driver id="generic:trino_jdbc"/>
        <driver id="generic:apache_hive2"/>
    </extension>

</plugin>

My build was successful:

[INFO] io.cloudbeaver.product.ce.feature 23.1.3-SNAPSHOT .. SUCCESS [  0.120 s]
[INFO] drivers 1.0.0 ...................................... SUCCESS [  0.360 s]
[INFO] drivers.clickhouse 1.0.0 ........................... SUCCESS [  0.416 s]
[INFO] drivers.clickhouse_com 1.0.0 ....................... SUCCESS [  0.051 s]
[INFO] drivers.db2 1.0.0 .................................. SUCCESS [  0.025 s]
[INFO] drivers.db2-jt400 1.0.0 ............................ SUCCESS [  0.027 s]
[INFO] drivers.derby 1.0.0 ................................ SUCCESS [  0.027 s]
[INFO] drivers.h2 1.0.0 ................................... SUCCESS [  0.017 s]
[INFO] drivers.h2_v2 1.0.0 ................................ SUCCESS [  0.017 s]
[INFO] drivers.firebird 1.0.0 ............................. SUCCESS [  0.021 s]
[INFO] drivers.mysql 1.0.0 ................................ SUCCESS [  0.024 s]
[INFO] drivers.mariadb 1.0.0 .............................. SUCCESS [  0.016 s]
[INFO] drivers.oracle 1.0.0 ............................... SUCCESS [  0.038 s]
[INFO] drivers.postgresql 1.0.0 ........................... SUCCESS [  0.027 s]
[INFO] drivers.sqlite 1.0.0 ............................... SUCCESS [  0.034 s]
[INFO] drivers.sqlserver 1.0.0 ............................ SUCCESS [  0.018 s]
[INFO] drivers.trino 1.0.0 ................................ SUCCESS [  0.058 s]
[INFO] drivers.hive 1.0.0 ................................. SUCCESS [  2.300 s]
[INFO] tests 1.0.0-SNAPSHOT ............................... SUCCESS [  0.001 s]
[INFO] io.cloudbeaver.test.platform 1.0.0-SNAPSHOT ........ SUCCESS [  9.071 s]
[INFO] Cloudbeaver Server Product 23.1.3-SNAPSHOT ......... SUCCESS [  6.396 s]
[INFO] product 1.0.0-SNAPSHOT ............................. SUCCESS [  0.002 s]
[INFO] CloudBeaver CE Aggregate 1.0.0-SNAPSHOT ............ SUCCESS [  0.001 s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS

but I don't see driver in UI after running cloudbeaver.

arezvani commented 1 year ago

It works, after I changed driver id to hive:apache_hive2 .