Wow Lukas, that was fast. That did it! Everything generated perfectly, even my stored procedures. Thank you so much!
<https://lh3.googleusercontent.com/-x8AGxV5wG5o/WO3sZlKv-jI/AAAAAAAAB3A/txf136BDzigAqRFCpV3G2xrAevJxo2DzgCLcB/s1600/1.jpg> On Wednesday, April 12, 2017 at 10:42:18 AM UTC+2, Lukas Eder wrote: > > Hi Lucciano, > > Thank you very much for the detailed report. > That's curious - it appears that no input catalogs are loaded despite the > log message indicating to fetch "ALL" input catalogs. Can you try adding > the following : > > <?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> > <inputCatalog>FluentDemo</inputCatalog> > <inputSchema>dbo</inputSchema> > </database> > <target> > <packageName>repository.generated</packageName> > <directory>C:/STS/SpringWorkspace/jOOQDemoGen/src</directory> > </target> > </generator> > </configuration> > > 2017-04-12 9:33 GMT+02:00 <[email protected] <javascript:>>: > >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.
