Missing files

Question

Missing files

palaciosdiego opened this issue 6 years ago · 22 comments

Hi some errors that i get, i could not find the jooq folder in the repo.

import static org.blackdread.sqltojava.jooq.InformationSchema.INFORMATION_SCHEMA;
import static org.blackdread.sqltojava.jooq.tables.KeyColumnUsage.KEY_COLUMN_USAGE;

regards.

Answer 1 · 2018-08-08T06:53:30.000Z

same issue, please up them.
regards.

Answer 2 · 2018-08-08T08:47:27.000Z

to dpalaciosarriaga

i got it, before mvn installing, you must set the part of database url in pom.xml.
enjoy!

Answer 3 · 2018-08-08T10:42:12.000Z

Yes indeed :)
I will add later in readme that pom.xml might need to be changed.
But the default url should work if you have wampserver running for example.

There is also the application.yml of course to set as well

Answer 4 · 2018-08-09T05:26:50.000Z

Hello, I got the same issue.

Answer 5 · 2018-08-09T06:58:11.000Z

See jOOQ doc for code generation
Make sure to have the mysql db running otherwise jooq cannot generate these two classes
these classes are generated code so you need to do "mvn compile" at least once before running the main

Answer 6 · 2018-08-09T10:38:13.000Z

Thanks, MySql is running and files are genereted except for InformationSchema and KeyColumnUsage

Answer 7 · 2018-08-09T14:19:49.000Z

give your pom.xml, you must have changed it, this issue is very basic.
Default pom.xml I provide is supposed to generate the information schema with everything needed to generate the jdl file:


                <generator>
                        <name>org.jooq.util.DefaultGenerator</name>
                        <database>
                            <name>org.jooq.util.mysql.MySQLDatabase</name>
                            <includes>.*</includes>
                            <excludes></excludes>
                            <!--<inputSchema></inputSchema>--> <!-- This will generate all schema of db, better to only generate the one interested in -->
                            <inputSchema>information_schema</inputSchema>
                        </database>
                        <target>
                            <packageName>org.blackdread.sqltojava.jooq</packageName>
                            <directory>target/generated-sources/jooq</directory>
                        </target>
                </generator>

Answer 8 · 2018-08-09T15:47:44.000Z

Thank you so much.
I found my mistake.
<database.url>jdbc:mysql://localhost:3306/DatabaseName</database.url>
I shoud not added the database name to connection String.

Answer 9 · 2018-08-15T14:37:48.000Z

Do not change (only eventually port and localhost):

POM:
<database.url>jdbc:mysql://localhost:3306/</database.url>
properties:
url: jdbc:mysql://localhost:3306/?useUnicode=true&characterEncoding=utf8&useSSL=false

Most users will only change:

application:
    table-to-export: my_schema
    ignored-table-names:
        - databasechangelog
        - databasechangeloglock
    export:
        path: ./my-project-jdl.jh
type: jdl

Answer 10 · 2018-10-09T16:50:14.000Z

See jOOQ doc for code generation

Make sure to have the mysql db running otherwise jooq cannot generate these two classes

these classes are generated code so you need to do "mvn compile" at least once before running the main

i tried to go mvn compile and i got this

A required class was missing while executing org.jooq:jooq-codegen-maven:3.10.5:generate: javax/xml/bind/JAXB

Answer 11 · 2018-10-10T02:59:32.000Z

Can you provide your configuration?
Also provide a screenshot of phpMyAdmin of dbs you have.

For example, for me property "table-to-export" would be "auto" which is db I want to export to JDL.

I just pulled this project and was able to compile the project.
I also restarted a build with travis, no errors.

Just make sure you have your db ON (wampserver for example), same port, the property "table-to-export" with name of schema to export -> name of db

Important
javax/xml/bind/JAXB has been removed, please use Java 8 for compile and runtime.

Answer 12 · 2018-10-20T15:47:51.000Z

Hello @Blackdread I'm currently working on Mac so I don't have PHPMyAdmin running but I have a sql server running and I'm using MAMP as a server, any suggestions ?

Answer 13 · 2019-03-14T23:47:24.000Z

Do not change (only eventually port and localhost):

POM:
<database.url>jdbc:mysql://localhost:3306/</database.url>

properties:
url: jdbc:mysql://localhost:3306/?useUnicode=true&characterEncoding=utf8&useSSL=false

Most users will only change:
application:
    table-to-export: my_schema
    ignored-table-names:
        - databasechangelog
        - databasechangeloglock
    export:
        path: ./my-project-jdl.jh
type: jdl

Hello

I ran 'mvn compile' but no jdl was generated from sql. Please do I need to run ant additional command?

Answer 14 · 2019-03-15T03:44:56.000Z

what is your config?

Answer 15 · 2019-03-15T11:12:34.000Z

what is your config?
application.yml

spring:
    datasource:
            type: com.zaxxer.hikari.HikariDataSource
            url: jdbc:mysql://localhost:3306/?useUnicode=true&characterEncoding=utf8&useSSL=false
            username: root
            password: MyPassword
            hikari:
                data-source-properties:
                    cachePrepStmts: true
                    prepStmtCacheSize: 250
                    prepStmtCacheSqlLimit: 2048
                    useServerPrepStmts: true
    jooq:
        sql-dialect: mysql


application:
    table-to-export: my-database
    ignored-table-names:
        - databasechangelog
        - databasechangeloglock
    export:
        path: ./my-project-jdl.jh
        type: jdl


pom.xml


<database.url>jdbc:mysql://localhost:3306/my-database?useLegacyDatetimeCode=false&amp;serverTimezone=UTC</database.url>

                     <jdbc>
                        <driver>com.mysql.cj.jdbc.Driver</driver>
                        <url>${database.url}</url>
                        <user>root</user>
                        <password>MyPassword</password>
                    </jdbc

I noticed that application.yml is overwritten any time I run "mvn compile".

Thanks

Answer 16 · 2019-03-15T13:21:39.000Z

do not change jdbc:mysql://localhost:3306/my-database

Answer 17 · 2019-03-15T13:32:05.000Z

do not change jdbc:mysql://localhost:3306/my-database
application.yml
Where do locate the jdl output that is generated? I can see it anywhere.
Is this okay. This is 100% generated.

 application.yml
spring:
    datasource:
            type: com.zaxxer.hikari.HikariDataSource
            url: jdbc:mysql://localhost:3306/?useUnicode=true&characterEncoding=utf8&useSSL=false
            username: root
            password:
            hikari:
                data-source-properties:
                    cachePrepStmts: true
                    prepStmtCacheSize: 250
                    prepStmtCacheSqlLimit: 2048
                    useServerPrepStmts: true
    jooq:
        sql-dialect: mysql


application:
    table-to-export: my_schema
    ignored-table-names:
        - databasechangelog
        - databasechangeloglock
    export:
        path: ./my-project-jdl.jh
        type: jdl`

Answer 18 · 2019-04-04T10:05:53.000Z

@sreerajr137 create another issue

Answer 19 · 2019-12-17T10:06:20.000Z

Hello , i really want steps to run this project .. what are jooq and mysql version you're using .. and what are the config to change exactly .. thank you

Answer 20 · 2019-12-17T11:34:18.000Z

use "mvn compile" or "mvnw compile", with db ON.
Then read full issue for any other build issue

Answer 21 · 2020-12-17T08:56:22.000Z

is it possible to connect with a sqlserver database

Answer 22 · 2020-12-18T02:01:04.000Z

See Readme or #52
Need to impl few changes to support it