[JBoss JIRA] (FORGE-2636) No specified tables error
by John Spencer (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
John Spencer edited comment on FORGE-2636 at 6/20/16 4:57 PM:
--------------------------------------------------------------
>From IDEA, I've managed to successfully generate the entities from the table using the same settings as I was using before and selecting the tables on the second page of the wizard. I also tried creating a connection profile and managed to successfully generate the entities from the table again, by using forge's UI inside intellij. I then proceeded to use that same profile from the command line and failed with the same "At least one database table must be specified" error. This leads me to believe that the bug simply lays in that forge fails to ask (or take in as a param) for the tables from the command line and thus attempts to generate the entities without having any tables specified.
I haven't installed the h2 database you proposed but if the error is unreproduceable using that database then I suspect thats due to h2's in-memory nature. I'll try to reproduce the error with the conditions you proposed and get back to you, as soon as I have the time.
was (Author: misterdee):
>From IDEA, I've managed to successfully generate the entities from the table using the same settings as I was using before and selecting the tables on the second page of the wizard. I also tried creating a connection profile and managed to successfully generate the entities from the table again, by using forge's UI inside intellij. I then proceeded to use that same profile from the command line and failed with the same "At least one database table must be specified" error. This leads me to believe that the bug simply lays in that forge fails to ask (or take in as a param) for the tables from the command line and thus attempts to generate the entities without having any tables specified.
I haven't installed the h2 database you proposed but if the error is unreproduceable using that database then I suspect thats because of the nature of h2 given that its in-memory database. I'll try to reproduce the error with the conditions you proposed and get back to you, as soon as I have the time.
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by John Spencer (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
John Spencer edited comment on FORGE-2636 at 6/20/16 3:46 PM:
--------------------------------------------------------------
>From IDEA, I've managed to successfully generate the entities from the table using the same settings as I was using before and selecting the tables on the second page of the wizard. I also tried creating a connection profile and managed to successfully generate the entities from the table again, by using forge's UI inside intellij. I then proceeded to use that same profile from the command line and failed with the same "At least one database table must be specified" error. This leads me to believe that the bug simply lays in that forge fails to ask (or take in as a param) for the tables from the command line and thus attempts to generate the entities without having any tables specified.
I haven't installed the h2 database you proposed but if the error is unreproduceable using that database then I suspect thats because of the nature of h2 given that its in-memory database. I'll try to reproduce the error with the conditions you proposed and get back to you, as soon as I have the time.
was (Author: misterdee):
>From IDEA, I've managed to successfully generate the entities from the table using the same settings as I was using before and selecting the tables on the second page of the wizard. I also tried creating a connection profile and managed to successfully generate the entities from the table again, by using forge's UI inside intellij. I then proceeded to use that same profile from the command line and failed with the same "At least one database table must be specified" error. This leads me to believe that the bug simply lays in that forge fails to ask (or take in as a param) for the tables from the command line and thus attempts to generate the entities without having any tables specified.
I haven't installed the h2 database you proposed but if the error is unpronounceable using that database then I suspect thats because of the nature of h2 given that its in-memory database. I'll try to reproduce the error with the conditions you proposed and get back to you, as soon as I have the time.
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by John Spencer (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
John Spencer commented on FORGE-2636:
-------------------------------------
>From IDEA, I've managed to successfully generate the entities from the table using the same settings as I was using before and selecting the tables on the second page of the wizard. I also tried creating a connection profile and managed to successfully generate the entities from the table again, by using forge's UI inside intellij. I then proceeded to use that same profile from the command line and failed with the same "At least one database table must be specified" error. This leads me to believe that the bug simply lays in that forge fails to ask (or take in as a param) for the tables from the command line and thus attempts to generate the entities without having any tables specified.
I haven't installed the h2 database you proposed but if the error is unpronounceable using that database then I suspect thats because of the nature of h2 given that its in-memory database. I'll try to reproduce the error with the conditions you proposed and get back to you, as soon as I have the time.
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by George Gastaldi (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
George Gastaldi commented on FORGE-2636:
----------------------------------------
Also, {{database-tables}} will only appear if the connection info succeeds. If you open this wizard in an IDE (Ctrl+4 in Eclipse, Ctrl+Alt+4 in IDEA), you'll see that this information is in the second page of the {{JPA: Generate Entitties from Tables}} wizard
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by George Gastaldi (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
Work on FORGE-2636 stopped by George Gastaldi.
----------------------------------------------
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by George Gastaldi (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
George Gastaldi commented on FORGE-2636:
----------------------------------------
I still can't reproduce your error. This is my command:
{code}
jpa-generate-entities-from-tables --jdbc-url jdbc:h2:tcp://localhost/~/workspace/sakila-h2/sakila --user-name sa --driver-location ~/workspace/sakila-h2/h2-1.4.192.jar --driver-class org.h2.Driver --hibernate-dialect org.hibernate.dialect.H2Dialect --database-tables *
{code}
You can try with this database: https://github.com/gastaldi/sakila-h2 (Start by running the runh2.sh script)
In your example, {{verify-connection}} and {{save-user-password}} do not take any arguments. If you specify them, they will be true. If you want to force it to be false, you need to do: _--verify-connection=false_
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by George Gastaldi (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
George Gastaldi updated FORGE-2636:
-----------------------------------
Fix Version/s: 3.x Future
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by George Gastaldi (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
George Gastaldi reassigned FORGE-2636:
--------------------------------------
Assignee: George Gastaldi
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2636) No specified tables error
by George Gastaldi (JIRA)
[ https://issues.jboss.org/browse/FORGE-2636?page=com.atlassian.jira.plugin... ]
Work on FORGE-2636 started by George Gastaldi.
----------------------------------------------
> No specified tables error
> -------------------------
>
> Key: FORGE-2636
> URL: https://issues.jboss.org/browse/FORGE-2636
> Project: Forge
> Issue Type: Bug
> Components: Database Tools, UI - Shell
> Affects Versions: 3.0.1.Final, 3.2.2.Final
> Environment: Windows 10, x64, Fedora 23
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.x Future
>
>
> When I try to execute jpa-generate-entities-from-tables, using:
> Using windows 10 + mysql:
> {code:java}
> jpa-generate-entities-from-tables --database-tables * --jdbc-url "jdbc:mysql://localhost:3306/validDB" --user-name root --user-password 1234 --driver-location "validpath\mysql-connector-java-5.1.6-bin.jar" --driver-class com.mysql.jdbc.Driver;
> {code}
> Using fedora 23 + postgres:
> {code}
> jpa-generate-entities-from-tables --database-tables * --user-name validuser --user-password validpassword --jdbc-url jdbc:postgresql://localhost:5432/validDB --driver-location validpath/postgresql-9.4-1201-jdbc4.jar --verify-connection y --save-user-password y --driver-class 0 --hibernate-dialect 9
> {code}
> Forge asks me again to enter all of information specified in the command, I do so, and then says "At least one database table must be specified".
> Also the "--database-tables" parameter does not show up in the list of available parameters when pressing tab after having specified a connection profile and/or specifying connection parameters. This might possibly be related to this [issue] (https://issues.jboss.org/projects/FORGE/issues/FORGE-2635?filter=allopeni...).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (FORGE-2659) Forge suggests using deprecated hibernate Postgresql dialect
by George Gastaldi (JIRA)
[ https://issues.jboss.org/browse/FORGE-2659?page=com.atlassian.jira.plugin... ]
George Gastaldi closed FORGE-2659.
----------------------------------
Fix Version/s: 3.2.3.Final
Resolution: Done
> Forge suggests using deprecated hibernate Postgresql dialect
> ------------------------------------------------------------
>
> Key: FORGE-2659
> URL: https://issues.jboss.org/browse/FORGE-2659
> Project: Forge
> Issue Type: Bug
> Components: Database Tools
> Affects Versions: 3.2.2.Final
> Environment: Fedora 23 x64
> Reporter: John Spencer
> Assignee: George Gastaldi
> Fix For: 3.2.3.Final
>
>
> When using the jpa-generate-entities-from-tables command forge eventually asks for a --hibernate dialect and lists the deprecated org.hibernate.dialect.PostgreSQLDialect (option 9) instead of the newer PostgreSQL82Dialect which isn't listed at all:
> [0] ( ) org.hibernate.dialect.MySQL5Dialect
> [1] ( ) org.hibernate.dialect.MySQL5InnoDBDialect
> [2] ( ) org.hibernate.dialect.MySQLMyISAMDialect
> [3] ( ) org.hibernate.dialect.OracleDialect
> [4] ( ) org.hibernate.dialect.Oracle9iDialect
> [5] ( ) org.hibernate.dialect.Oracle10gDialect
> [6] ( ) org.hibernate.dialect.DB2Dialect
> [7] ( ) org.hibernate.dialect.DB2400Dialect
> [8] ( ) org.hibernate.dialect.DB2390Dialect
> [9] ( ) org.hibernate.dialect.PostgreSQLDialect
> [10] ( ) org.hibernate.dialect.SQLServerDialect
> [11] ( ) org.hibernate.dialect.SQLServer2005Dialect
> [12] ( ) org.hibernate.dialect.SQLServer2008Dialect
> [13] ( ) org.hibernate.dialect.SAPDBDialect
> [14] ( ) org.hibernate.dialect.InformixDialect
> [15] ( ) org.hibernate.dialect.HSQLDialect
> [16] ( ) org.hibernate.dialect.H2Dialect
> [17] ( ) org.hibernate.dialect.IngresDialect
> [18] ( ) org.hibernate.dialect.ProgressDialect
> [19] ( ) org.hibernate.dialect.MckoiDialect
> [20] ( ) org.hibernate.dialect.InterbaseDialect
> [21] ( ) org.hibernate.dialect.PointbaseDialect
> [22] ( ) org.hibernate.dialect.FrontbaseDialect
> [23] ( ) org.hibernate.dialect.FirebirdDialect
> [24] ( ) org.hibernate.dialect.SybaseASE15Dialect
> [25] ( ) org.hibernate.dialect.SybaseAnywhereDialect
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months