SQL Server 2016 (13.0.4199) code generation
77 views
Skip to first unread message
Roded Bahat
Dec 28, 2016, 9:39:37 AM12/28/16
to jOOQ User Group
Hi,
I'm using the gradle jooq plugin in trying to generate code based on my SQL Server 2016 database and could use some assistance.
Attached are the code generation configuration and the outputted log.
Why are no schemata found?
The generated config.xml looks fine to my eyes (i.e., it contains all the elements defined in the gradle config).
The missing sources are making this hard to debug so any help regarding what I'm missing would be great.
Thanks!
Ouptut:
I'm using the gradle jooq plugin in trying to generate code based on my SQL Server 2016 database and could use some assistance.
Attached are the code generation configuration and the outputted log.
Why are no schemata found?
The generated config.xml looks fine to my eyes (i.e., it contains all the elements defined in the gradle config).
The missing sources are making this hard to debug so any help regarding what I'm missing would be great.
Thanks!
jooq {
version = "3.9.0"
edition = 'TRIAL'
jooqGen(sourceSets.main) {
jdbc {
driver = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
url = 'jdbc:sqlserver://127.0.0.1\\SQLEXPRESS:1433;databaseName=mydb'
user = 'sa'
password = 'secret'
}
generator {
name = 'org.jooq.util.JavaGenerator'
database {
name = 'org.jooq.util.sqlserver.SQLServerDatabase'
catalogs {
catalog {
inputCatalog = "mydb"
}
}
inputSchema = "dbo"
}
generate {
relations = true
deprecated = false
records = true
fluentSetters = true
interfaces = true
pojos = true
immutablePojos = true
pojosEqualsAndHashCode = true
emptyCatalogs = true
emptySchemas = true
}
target {
packageName = 'com.xxx.persistence.jooq'
directory = "src/jooq-gen/java"
}
}
}
}
Ouptut:
16:35:23: Executing external task 'generateJooqGenJooqSchemaSource --rerun-tasks -Xbootclasspath/p:"X:\development\modelity\marketplace\marketplace-workspace\marketplace-server\src\main\resources"'...
:jooq-commons:compileJava
:jooq-commons:processResources UP-TO-DATE
:jooq-commons:classes
:jooq-commons:jar
:marketplace-server:generateJooqGenJooqSchemaSource
16:35:37.388 [main] INFO org.jooq.util.GenerationTool - Initialising properties : X:\development\modelity\marketplace\marketplace-workspace\marketplace-server\build\tmp\jooq\config.xml
16:35:38.375 [main] INFO org.jooq.util.AbstractGenerator - License parameters
16:35:38.375 [main] INFO org.jooq.util.AbstractGenerator - ----------------------------------------------------------
16:35:38.375 [main] INFO org.jooq.util.AbstractGenerator - Thank you for using jOOQ and jOOQ's code generator
16:35:38.375 [main] INFO org.jooq.util.AbstractGenerator -
16:35:38.375 [main] INFO org.jooq.util.AbstractGenerator - Database parameters
16:35:38.375 [main] INFO org.jooq.util.AbstractGenerator - ----------------------------------------------------------
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - dialect : SQLSERVER
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - URL : jdbc:sqlserver://127.0.0.1\sqlexpress:1433;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=marketplace;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - target dir : src/jooq-gen/java
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - target package : com.modelity.marketplace.persistence.jooq
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - includes : [.*]
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - excludes : []
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - includeExcludeColumns : false
16:35:38.466 [main] INFO org.jooq.util.AbstractGenerator - ----------------------------------------------------------
16:35:38.466 [main] INFO org.jooq.util.JavaGenerator -
16:35:38.466 [main] INFO org.jooq.util.JavaGenerator - JavaGenerator parameters
16:35:38.466 [main] INFO org.jooq.util.JavaGenerator - ----------------------------------------------------------
16:35:38.466 [main] INFO org.jooq.util.JavaGenerator - strategy : class org.jooq.util.DefaultGeneratorStrategy
16:35:38.466 [main] INFO org.jooq.util.JavaGenerator - deprecated : false
16:35:38.467 [main] INFO org.jooq.util.JavaGenerator - generated annotation : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - JPA annotations : false
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - validation annotations : false
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - instance fields : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - sequences : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - udts : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - routines : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - tables : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - records : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - pojos : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - immutable pojos : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - interfaces : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - immutable interfaces : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - daos : false
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - relations : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - table-valued functions : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - global references : true
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator - ----------------------------------------------------------
16:35:38.470 [main] INFO org.jooq.util.JavaGenerator -
16:35:38.471 [main] INFO org.jooq.util.AbstractGenerator - Generation remarks
16:35:38.472 [main] INFO org.jooq.util.AbstractGenerator - ----------------------------------------------------------
16:35:38.472 [main] INFO org.jooq.util.JavaGenerator -
16:35:38.472 [main] INFO org.jooq.util.JavaGenerator - ----------------------------------------------------------
16:35:38.698 [main] INFO org.jooq.Constants -
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @ @ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Thank you for using the 30 day free jOOQ 3.9.0 trial edition
16:35:38.705 [main] DEBUG org.jooq.tools.LoggerListener - Executing query : select 1 [one] -- SQL rendered with a free trial version of jOOQ 3.9.0
16:35:38.707 [main] DEBUG org.jooq.tools.LoggerListener - -> with bind values : select 1 [one]
16:35:38.754 [main] DEBUG org.jooq.tools.StopWatch - Query executed : Total: 59.654ms
16:35:38.808 [main] DEBUG org.jooq.tools.LoggerListener - Fetched result : +----+
16:35:38.808 [main] DEBUG org.jooq.tools.LoggerListener - : | one|
16:35:38.808 [main] DEBUG org.jooq.tools.LoggerListener - : +----+
16:35:38.808 [main] DEBUG org.jooq.tools.LoggerListener - : | 1|
16:35:38.808 [main] DEBUG org.jooq.tools.LoggerListener - : +----+
16:35:38.808 [main] DEBUG org.jooq.tools.StopWatch - Finishing : Total: 113.793ms, +54.138ms
16:35:38.809 [main] DEBUG org.jooq.tools.LoggerListener - Executing query : select name from sys.databases where name in (?) order by database_id asc -- SQL rendered with a free trial version of jOOQ 3.9.0
16:35:38.809 [main] DEBUG org.jooq.tools.LoggerListener - -> with bind values : select name from sys.databases where name in ('marketplace') order by database_id asc
16:35:38.833 [main] DEBUG org.jooq.tools.StopWatch - Query executed : Total: 140.05ms
16:35:38.834 [main] DEBUG org.jooq.tools.LoggerListener - Fetched result : +-----------+
16:35:38.834 [main] DEBUG org.jooq.tools.LoggerListener - : |name |
16:35:38.834 [main] DEBUG org.jooq.tools.LoggerListener - : +-----------+
16:35:38.834 [main] DEBUG org.jooq.tools.LoggerListener - : |marketplace|
16:35:38.834 [main] DEBUG org.jooq.tools.LoggerListener - : +-----------+
16:35:38.834 [main] DEBUG org.jooq.tools.StopWatch - Finishing : Total: 141.253ms, +1.203ms
16:35:38.836 [main] INFO org.jooq.util.JavaGenerator - Generating catalogs : Total: 1
16:35:38.836 [main] INFO org.jooq.util.JavaGenerator - No schema version is applied for catalog marketplace. Regenerating.
16:35:38.839 [main] INFO org.jooq.util.JavaGenerator -
16:35:38.839 [main] INFO org.jooq.util.JavaGenerator - Generating catalog : Marketplace.java
16:35:38.839 [main] INFO org.jooq.util.JavaGenerator - ==========================================================
16:35:38.848 [main] DEBUG org.jooq.tools.LoggerListener - Executing query : use [marketplace]
16:35:38.851 [main] DEBUG org.jooq.tools.StopWatch - Query executed : Total: 3.539ms
16:35:38.851 [main] DEBUG org.jooq.tools.StopWatch - Warning : Total: 3.676ms, +0.137ms
16:35:38.851 [main] DEBUG org.jooq.tools.StopWatch - Finishing : Total: 4.093ms, +0.416ms
16:35:38.860 [main] DEBUG org.jooq.tools.LoggerListener - Executing query : select [INFORMATION_SCHEMA].[SCHEMATA].[SCHEMA_NAME] from [INFORMATION_SCHEMA].[SCHEMATA] where [INFORMATION_SCHEMA].[SCHEMATA].[CATALOG_NAME] = ? -- SQL rendered with a free trial version of jOOQ 3.9.0
16:35:38.861 [main] DEBUG org.jooq.tools.LoggerListener - -> with bind values : select [INFORMATION_SCHEMA].[SCHEMATA].[SCHEMA_NAME] from [INFORMATION_SCHEMA].[SCHEMATA] where [INFORMATION_SCHEMA].[SCHEMATA].[CATALOG_NAME] = 'marketplace'
16:35:38.864 [main] DEBUG org.jooq.tools.StopWatch - Query executed : Total: 4.092ms
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - Fetched result : +------------------+
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : |SCHEMA_NAME |
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : +------------------+
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : |dbo |
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : |guest |
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : |INFORMATION_SCHEMA|
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : |sys |
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : |db_owner |
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : +------------------+
16:35:38.865 [main] DEBUG org.jooq.tools.LoggerListener - : |...8 record(s) truncated...
16:35:38.866 [main] DEBUG org.jooq.tools.StopWatch - Finishing : Total: 5.73ms, +1.637ms
16:35:38.866 [main] WARN org.jooq.util.AbstractDatabase - No schemata were loaded : Please check your connection settings, and whether your database (and your database version!) is really supported by jOOQ. Also, check the case-sensitivity in your configured <inputSchema/> elements : {}
16:35:38.868 [main] INFO org.jooq.util.JavaGenerator - Generating schemata : Total: 0
16:35:38.868 [main] INFO org.jooq.util.JavaGenerator - Removing excess files
BUILD SUCCESSFUL
Total time: 15.685 secs
16:35:39: External task execution finished 'generateJooqGenJooqSchemaSource --rerun-tasks -Xbootclasspath/p:"X:\development\modelity\marketplace\marketplace-workspace\marketplace-server\src\main\resources"'.
Lukas Eder
Dec 28, 2016, 10:05:23 AM12/28/16
to jooq...@googlegroups.com
Hi Roded,
Thank you very much for your message. Indeed, the free trial doesn't ship any sources, which may be a bit cumbersome for debugging. Rest assured that we do ship the sources with the jOOQ Professional Edition. If you're interested in an extended trial that includes the sources, please let me know and we'll issue a license key for you.
Are you using this third party Gradle plugin, perhaps?
Regarding your issue, I think there is a configuration mistake.
You should either use the top-level declarations of inputCatalog AND inputSchema, or the nested versions of both of them. So, either use this (if you plan for adding more catalogs / schemas):
database {
name = 'org.jooq.util.sqlserver.SQLServerDatabase'
catalogs {
catalog {
inputCatalog = "mydb"
schemata {
schema {
inputSchema = "dbo"
}
}
}
}
}
Or, use this:
database {
name = 'org.jooq.util.sqlserver.SQLServerDatabase'
inputCatalog = "mydb"
inputSchema = "dbo"
}
I hope this helps,
Lukas
--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Lukas Eder
Dec 28, 2016, 10:08:10 AM12/28/16
to jooq...@googlegroups.com
... I've also created an issue to add a WARN message to the logs indicating this malconfiguration:
Roded Bahat
Dec 28, 2016, 11:24:31 AM12/28/16
to jOOQ User Group
Works like charm. Apparently that was a configuration combination which I have not tried.
Many thanks Lukas
Many thanks Lukas
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages