Thanks again Lukas. After viewing your responses and attached links, I explored the database a bit more. It turns out I needed to change the Initial Catalog of the database user to the Study database and then use dbo as my inputSchema. Before I was logging into the master database and getting the dbo schema for the master database.
Thus, changing the <url> tag of my properties file to jdbc:sqlserver://MM177978-PC\SQLEXPRESS;Initial Catalog=STUDY instead of jdbc:sqlserver://MM177978-PC\SQLEXPRESS generated the code I was looking for. Thanks again for all of your help, Justin On Tuesday, April 17, 2012 2:10:43 AM UTC-4, Lukas Eder wrote: > > > 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 > >
