Hi Justin, Thanks for your feedback.
So STUDY is in fact your database/catalog, not your schema. jOOQ currently doesn't support multi-database code generation, so that might be a bit confusing at first. I expect, multi-database support will be added in late 2012. Cheers Lukas 2012/4/17 Justin <[email protected]>: > 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
