Thanks for your help Lukas. Sorry again about the double post, is there a way to delete the old topic?
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". 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. 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. 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 > >
