Generator does not report file in which invalid SQL was found

[codemonstur]

When there is SQL in a migration file that JOOQ doesn't understand it prints an error like so:

[ERROR] An exception occurred while parsing script source : src/main/resources/db/migration/*. Please report this error to https://github.com/jOOQ/jOOQ/issues/new

The error message prints the script source as it is configured (with wildcard). I'd like it to print the actual file where it found the error.

[lukaseder]

Thank you very much for your suggestion. Incidentally, we've discussed this just recently and we're going to improve internal APIs that allow for tracking these sources.

We don't have an issue for this yet, but yours will do :) We'll definitely improve this message in the future.

[lukaseder]

There's already an INFO log message indicating which file is being read just before the error occurs:

[INFO] Reading from: C:\Users\lukas\jOOQ\master\workspace\jOOQ-pro\jOOQ-test-codegen\src\main\resources\javabeansgettersandsetters.sql [*]

However, I'll also add an additional ERROR log message just below:

[ERROR] DDLDatabase Error        : Your SQL string could not be parsed or interpreted. This may have a variety of reasons, including:
- The jOOQ parser doesn't understand your SQL
- The jOOQ DDL simulation logic (translating to H2) cannot simulate your SQL

If you think this is a bug or a feature worth requesting, please report it here: https://github.com/jOOQ/jOOQ/issues/new/choose

As a workaround, you can use the Settings.parseIgnoreComments syntax documented here:
https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-parser/
[ERROR] Error while loading file: C:\Users\lukas\jOOQ\master\workspace\jOOQ-pro\jOOQ-test-codegen\src\main\resources\javabeansgettersandsetters.sql
[ERROR] An exception occurred while parsing script source : C:\Users\lukas\jOOQ\master\workspace\jOOQ-pro\jOOQ-test-codegen/src/main/resources/*gettersandsetters.sql. Please report this error to https://github.com/jOOQ/jOOQ/issues/new
org.jooq.impl.ParserException: Identifier expected: [38:19] ... "K_Mn"  INT,
  "K_MO"  INT
);

CREATE TABLE foo ([*]);

The new message being:

[ERROR] Error while loading file: C:\Users\lukas\jOOQ\master\workspace\jOOQ-pro\jOOQ-test-codegen\src\main\resources\javabeansgettersandsetters.sql

[lukaseder]

The specific implementation of this fix depends on #9725 and a few other changes, which is why this will not be backported to 3.12.