sequel console

Answered

Hi,

have 2 small questions:

1 -Is the sequel console compatible with IBM DB2?

2- now with the sequel console after creating a new table in my DB, am i able to generate a class in my domain from the sequel console? like right click on a table and select generate domain class, or drag and drop whatever way... thanks.

Moine

1 comment
Comment actions Permalink

Hello Moine,

1. IBM DB2 connections should work. You will need jdbc driver for IBM DB2 database. IntelliJ ships two BD2 jdbc libraries: JTOpen - IBM’s Java Toolbox Driver (jt400.jar) and LUW - IBM’s native JDBC driver (db2jcc4-4.9.78.jar) and provides corresponding pre-defined Database Connection templates: https://www.jetbrains.com/idea/help/managing-data-sources.html#define_database .

2. It is possible to generate annotated Java classes from Configured in project Data Source via Generate Persistence Mapping by Database Schema action, but it requires configured JPA or Hibernate support in project.

We are working on a convenient way of generating POJO Java classes from the DB schema. And there is Generate POJOs.clj bundled DB Schema extractor file available for the DB objects extraction. You can find it if switch to Scranches view in Project Tool Window and go to Extensions | schema folder. The generate action is available from Schema context menu for the created Data Source:

For some more information about Database extractors see https://www.jetbrains.com/datagrip/help/extending-the-datagrip-functionality.html

0

Please sign in to leave a comment.