> Thanks for your help Lukas. Sorry again about the double post, is there a > way to delete the old topic?
I don't think there is. But never mind that! > I ran the query listed below and it returned some interesting results. It > turns out that the only unique schema in my database is called "dbo". Yes, that is the default schema in SQL Server. Every database has it. You may find some further information here: http://stackoverflow.com/questions/1062075/why-do-table-names-in-sql-server-start-with-dbo > If I > remove the distinct clause from the sql query, I get multiple schemas named > dbo, but can't correlate them to the number of databases. Unfortunately, > I'm new to SqlServer and the database I'm trying to interface with was > created by a third-party so I'm not really sure how everything is setup. The query I gave you is actually a query for tables. I happened to remove duplicate schema names with the DISTINCT keyword. This query will clarify why you got duplicates: SELECT * FROM information_schema.tables Anyway, before using jOOQ, I recommend you get acquainted with your database. You can use Microsoft SQL Server Management studio for that (which is shipped with SQL Server 2008). Here's a screenshot to show what I mean: http://lukaseder.files.wordpress.com/2012/04/sql-server.png > Trying to re-run the generator against dbo generates quite a few classes, > but they seem to be related to database administration(?). I've tried > running with [dbo].STUDY and dbo.STUDY, but that didn't seem to work either. In jooq-codegen, <inputSchema> defines the schema you want to read and generate. There is a possibility to specify multiple input schemata. This is documented here: http://www.jooq.org/manual/META/AdvancedConfiguration/ In order to include / exclude tables, you can use the <includes/> and <excludes/> elements, as documented in the sample configuration file Cheers Lukas > > Once again, thank you for your help. > > - Justin > > > On Monday, April 16, 2012 4:31:00 PM UTC-4, Lukas Eder wrote: >> >> Hello Justin, >> >> I'm guessing that you may not have spelled STUDY correctly? Did you >> create the schema in upper-case only letters? What does the following >> query return on the JDBC connection that you've specified? >> >> SELECT DISTINCT table_schema >> FROM information_schema.tables >> >> Cheers >> Lukas >> >> 2012/4/16 Justin <[email protected]>: >> > Hi all, >> > >> > First I apologize if I double-post this. >> > >> > I am attempting to use JOOQ to generate code for a SqlServer 2008 >> > database. >> > Things seem to run fine in the generator, but the only output I get is >> > two >> > source files, one is named after my inputSchema(Study), while the other >> > is >> > called StudyFactory. Neither of them seem to really have anything to do >> > with the tables in my database . I think that I am configuring the >> > inputSchema field incorrectly, but can't seem to figure out what I am >> > doing >> > wrong. I've attached the console output from running the code generator >> > and >> > my configuration file. >> > >> > Any help is greatly appreciated. >> > >> > Thank you for your time and consideration, >> > Justin
