Hi, I'm having trouble in code generation for my SQL Server 2016 database. I downloaded jOOQ trial professional edition and set up my generator project in Eclipse like shown in this section in the manual: https://www.jooq.org/doc/3.9/manual/code-generation/codegen-configuration/#N3F035 .
Project: All JARs are taken from org\jooq\trial generated folder after running maven-install.bat script in downloaded folder from jOOQ site. Run configuration: <https://lh3.googleusercontent.com/-OGAjAA23Qng/WO3Sf2tk-mI/AAAAAAAAB2U/io7JGMtB5wMDmwg8eCQqlia1ulCuR9QBQCLcB/s1600/2.jpg> <https://lh3.googleusercontent.com/-oA30r7JBf2A/WO3SvWYkceI/AAAAAAAAB2Y/F8yuPiihvjYoGIQmwEfU6NlfmDJJ2wL0ACLcB/s1600/3.jpg> <https://lh3.googleusercontent.com/-ztwhyfIyCEE/WO3S-VOnfiI/AAAAAAAAB2c/PYTIElnwBwgvtogI7L9JduuvEtU7jXq0QCLcB/s1600/4.jpg> After Run, nothing gets generated with no errors or warnings and I get this in console: INFO : org.jooq.util.GenerationTool - Initialising properties : /fluentdemo.xml INFO : org.jooq.util.GenerationTool - No <inputCatalog/> was provided. Generating ALL available catalogs instead. INFO : org.jooq.util.AbstractGenerator - License parameters INFO : org.jooq.util.AbstractGenerator - ---------------------------------------------------------- INFO : org.jooq.util.AbstractGenerator - Thank you for using jOOQ and jOOQ's code generator INFO : org.jooq.util.AbstractGenerator - INFO : org.jooq.util.AbstractGenerator - Database parameters INFO : org.jooq.util.AbstractGenerator - ---------------------------------------------------------- INFO : org.jooq.util.AbstractGenerator - dialect : SQLSERVER INFO : org.jooq.util.AbstractGenerator - URL : jdbc:sqlserver://localhost\mssqlserver2016:1433;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=FluentDemo;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; INFO : org.jooq.util.AbstractGenerator - target dir : C:/STS/SpringWorkspace/jOOQDemoGen/src INFO : org.jooq.util.AbstractGenerator - target package : repository.generated INFO : org.jooq.util.AbstractGenerator - includes : [.*] INFO : org.jooq.util.AbstractGenerator - excludes : [] INFO : org.jooq.util.AbstractGenerator - includeExcludeColumns : false INFO : org.jooq.util.AbstractGenerator - ---------------------------------------------------------- INFO : org.jooq.util.JavaGenerator - INFO : org.jooq.util.JavaGenerator - JavaGenerator parameters INFO : org.jooq.util.JavaGenerator - ---------------------------------------------------------- INFO : org.jooq.util.JavaGenerator - strategy : class org.jooq.util.DefaultGeneratorStrategy INFO : org.jooq.util.JavaGenerator - deprecated : true INFO : org.jooq.util.JavaGenerator - generated annotation : true INFO : org.jooq.util.JavaGenerator - JPA annotations : false INFO : org.jooq.util.JavaGenerator - validation annotations : false INFO : org.jooq.util.JavaGenerator - instance fields : true INFO : org.jooq.util.JavaGenerator - sequences : true INFO : org.jooq.util.JavaGenerator - udts : true INFO : org.jooq.util.JavaGenerator - routines : true INFO : org.jooq.util.JavaGenerator - tables : true INFO : org.jooq.util.JavaGenerator - records : true INFO : org.jooq.util.JavaGenerator - pojos : false INFO : org.jooq.util.JavaGenerator - immutable pojos : false INFO : org.jooq.util.JavaGenerator - interfaces : false INFO : org.jooq.util.JavaGenerator - immutable interfaces : false INFO : org.jooq.util.JavaGenerator - daos : false INFO : org.jooq.util.JavaGenerator - relations : true INFO : org.jooq.util.JavaGenerator - table-valued functions : true INFO : org.jooq.util.JavaGenerator - global references : true INFO : org.jooq.util.JavaGenerator - ---------------------------------------------------------- INFO : org.jooq.util.JavaGenerator - INFO : org.jooq.util.AbstractGenerator - Generation remarks INFO : org.jooq.util.AbstractGenerator - ---------------------------------------------------------- INFO : org.jooq.util.JavaGenerator - INFO : org.jooq.util.JavaGenerator - ---------------------------------------------------------- INFO : org.jooq.Constants - @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@ @@ @@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@ @@@@@@@@@@@@@@@@ @@ @@ @@@@@@@@@@ @@@@@@@@@@ @@@@ @@ @@ @@@@@@@@@@ @@@@@@@@@@ @@ @@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@ @@ @@@@@@@@@@ @@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@ @@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@ @@@@@@@@@@ @@ @ @ @@@@@@@@@@ @@@@@@@@@@ @@ @@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Thank you for using the 30 day free jOOQ 3.9.1 trial edition DEBUG: org.jooq.tools.LoggerListener - Executing query : select 1 [one] -- SQL rendered with a free trial version of jOOQ 3.9.1 DEBUG: org.jooq.tools.LoggerListener - -> with bind values : select 1 [one] DEBUG: org.jooq.tools.StopWatch - Query executed : Total: 48.669ms DEBUG: org.jooq.tools.LoggerListener - Fetched result : +----+ DEBUG: org.jooq.tools.LoggerListener - : | one| DEBUG: org.jooq.tools.LoggerListener - : +----+ DEBUG: org.jooq.tools.LoggerListener - : | 1| DEBUG: org.jooq.tools.LoggerListener - : +----+ DEBUG: org.jooq.tools.StopWatch - Finishing : Total: 112.17ms, +63.501ms DEBUG: org.jooq.tools.LoggerListener - Executing query : select name from sys.databases where 1 = 0 order by database_id asc -- SQL rendered with a free trial version of jOOQ 3.9.1 DEBUG: org.jooq.tools.LoggerListener - -> with bind values : select name from sys.databases where 1 = 0 order by database_id asc DEBUG: org.jooq.tools.StopWatch - Query executed : Total: 139.758ms DEBUG: org.jooq.tools.LoggerListener - Fetched result : +----+ DEBUG: org.jooq.tools.LoggerListener - : |name| DEBUG: org.jooq.tools.LoggerListener - : +----+ DEBUG: org.jooq.tools.StopWatch - Finishing : Total: 140.365ms, +0.606ms DEBUG: org.jooq.tools.LoggerListener - Executing query : select name from sys.databases where 1 = 0 order by database_id asc -- SQL rendered with a free trial version of jOOQ 3.9.1 DEBUG: org.jooq.tools.LoggerListener - -> with bind values : select name from sys.databases where 1 = 0 order by database_id asc DEBUG: org.jooq.tools.StopWatch - Query executed : Total: 1.174ms DEBUG: org.jooq.tools.LoggerListener - Fetched result : +----+ DEBUG: org.jooq.tools.LoggerListener - : |name| DEBUG: org.jooq.tools.LoggerListener - : +----+ DEBUG: org.jooq.tools.StopWatch - Finishing : Total: 1.761ms, +0.587ms INFO : org.jooq.util.JavaGenerator - Generating catalogs : Total: 0 INFO : org.jooq.util.JavaGenerator - Removing excess files First i thought that I wrote something wrong in connection string, but then it actually outputs error. My fluentdemo.xml config: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <configuration> <jdbc> <driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver> <url>jdbc:sqlserver://localhost\MSSQLSERVER2016;integratedSecurity=true;databaseName=FluentDemo</url> </jdbc> <generator> <database> <name>org.jooq.util.sqlserver.SQLServerDatabase</name> <includes>.*</includes> <excludes></excludes> <inputSchema>dbo</inputSchema> </database> <target> <packageName>repository.generated</packageName> <directory>C:/STS/SpringWorkspace/jOOQDemoGen/src</directory> </target> </generator> </configuration> -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
