2 deleted 100 characters in body
source | link

As I'm not allowed to add comments yet here an answer on the problem reported by Dimitrios Desyllas regarding the JDBC driver as comment on the other answer.

I have issues setting up the JDBC driver

Jailer already ships several database JDBC drivers (PostgreSQL, MySQL, MSSQL, etc.). They

They are located in the "lib" subdirectory. So there is no need to update unless there is an issue. The

The PostgreSQL JDBC driver shipped with the current Jailer vesionversion should be new enough to handle the task (it's this one: postgresql-42.2.0.jre7.jarpostgresql-42.2.0.jre7.jar).

After addedadding and namednaming your data model (jailerGUI --> "Database subsetting tool"), and click "Analyze Database" you get the "Connnect with Database" dialog, where you add a new connection string. After

After hitting the "New" button, a dialog pops up where you select the database. Scroll down to "PostgresQL JDBC Driver 42.2.0" (the one shipped with Jailer v8.8.4 released 2019-08-20) select the line and hit the "OK" button. You

You now get the dialog to enter your connection string, username, password, etc. Here The JDBC Driver jar should be preselected (on Windows "lib\postgresql-42.2.0.jre7.jar" or on Linux "lib/postgresql-42.2.0.jre7.jar"). So

So you only need to fill out the last three rows of the dialog (your DB-URL, the Username and the Password). When

When done you can test the connection by hitting the "Test Connection" button. It should work except for possible restrictions from where the database accepts the connection (check --> pg_hba.conf).

If you still think you need the latest version of the JDBC driver go to https://jdbc.postgresql.org/ and download the latest PostgreSQL JDBC driver directly from the source (Currently: postgresql-42.2.6.jar; or one of the other versions for older JREs). You

You may want to directly drop the driver in the "lib" sub-directory of the Jailer installation directory.

As I'm not allowed to add comments yet here an answer on the problem reported by Dimitrios Desyllas regarding the JDBC driver as comment on the other answer.

Jailer already ships several database JDBC drivers (PostgreSQL, MySQL, MSSQL, etc.). They are located in the "lib" subdirectory. So there is no need to update unless there is an issue. The PostgreSQL JDBC driver shipped with the current Jailer vesion should be new enough to handle the task (it's this one: postgresql-42.2.0.jre7.jar).

After added and named your data model (jailerGUI --> "Database subsetting tool"), and click "Analyze Database" you get the "Connnect with Database" dialog, where you add a new connection string. After hitting the "New" button, a dialog pops up where you select the database. Scroll down to "PostgresQL JDBC Driver 42.2.0" (the one shipped with Jailer v8.8.4 released 2019-08-20) select the line and hit the "OK" button. You now get the dialog to enter your connection string, username, password, etc. Here The JDBC Driver jar should be preselected (on Windows "lib\postgresql-42.2.0.jre7.jar" or on Linux "lib/postgresql-42.2.0.jre7.jar"). So you only need to fill out the last three rows of the dialog (your DB-URL, the Username and the Password). When done you can test the connection by hitting the "Test Connection" button. It should work except for possible restrictions from where the database accepts the connection (check --> pg_hba.conf).

If you still think you need the latest version of the JDBC driver go to https://jdbc.postgresql.org/ and download the latest PostgreSQL JDBC driver directly from the source (Currently: postgresql-42.2.6.jar; or one of the other versions for older JREs). You may want to directly drop the driver in the "lib" sub-directory of the Jailer installation directory.

I have issues setting up the JDBC driver

Jailer already ships several database JDBC drivers (PostgreSQL, MySQL, MSSQL, etc.).

They are located in the "lib" subdirectory. So there is no need to update unless there is an issue.

The PostgreSQL JDBC driver shipped with the current Jailer version should be new enough to handle the task (it's this one: postgresql-42.2.0.jre7.jar).

After adding and naming your data model (jailerGUI --> "Database subsetting tool"), and click "Analyze Database" you get the "Connnect with Database" dialog, where you add a new connection string.

After hitting the "New" button, a dialog pops up where you select the database. Scroll down to "PostgresQL JDBC Driver 42.2.0" (the one shipped with Jailer v8.8.4 released 2019-08-20) select the line and hit the "OK" button.

You now get the dialog to enter your connection string, username, password, etc. Here The JDBC Driver jar should be preselected (on Windows "lib\postgresql-42.2.0.jre7.jar" or on Linux "lib/postgresql-42.2.0.jre7.jar").

So you only need to fill out the last three rows of the dialog (your DB-URL, the Username and the Password).

When done you can test the connection by hitting the "Test Connection" button. It should work except for possible restrictions from where the database accepts the connection (check --> pg_hba.conf).

If you still think you need the latest version of the JDBC driver go to https://jdbc.postgresql.org/ and download the latest PostgreSQL JDBC driver directly from the source (Currently: postgresql-42.2.6.jar; or one of the other versions for older JREs).

You may want to directly drop the driver in the "lib" sub-directory of the Jailer installation directory.

1
source | link

As I'm not allowed to add comments yet here an answer on the problem reported by Dimitrios Desyllas regarding the JDBC driver as comment on the other answer.

Jailer already ships several database JDBC drivers (PostgreSQL, MySQL, MSSQL, etc.). They are located in the "lib" subdirectory. So there is no need to update unless there is an issue. The PostgreSQL JDBC driver shipped with the current Jailer vesion should be new enough to handle the task (it's this one: postgresql-42.2.0.jre7.jar).

After added and named your data model (jailerGUI --> "Database subsetting tool"), and click "Analyze Database" you get the "Connnect with Database" dialog, where you add a new connection string. After hitting the "New" button, a dialog pops up where you select the database. Scroll down to "PostgresQL JDBC Driver 42.2.0" (the one shipped with Jailer v8.8.4 released 2019-08-20) select the line and hit the "OK" button. You now get the dialog to enter your connection string, username, password, etc. Here The JDBC Driver jar should be preselected (on Windows "lib\postgresql-42.2.0.jre7.jar" or on Linux "lib/postgresql-42.2.0.jre7.jar"). So you only need to fill out the last three rows of the dialog (your DB-URL, the Username and the Password). When done you can test the connection by hitting the "Test Connection" button. It should work except for possible restrictions from where the database accepts the connection (check --> pg_hba.conf).

If you still think you need the latest version of the JDBC driver go to https://jdbc.postgresql.org/ and download the latest PostgreSQL JDBC driver directly from the source (Currently: postgresql-42.2.6.jar; or one of the other versions for older JREs). You may want to directly drop the driver in the "lib" sub-directory of the Jailer installation directory.