No problem, just thought I would check. Thanks again for an awesome library.
On Saturday, May 25, 2013 2:49:13 AM UTC-5, Lukas Eder wrote: > > Hi John, > > I had had a deeper look into catalogs and how they are supported by the > many databases. Unfortunately, it is a far-from-trivial task to add true > catalog support to jOOQ. So this means that it isn't supported yet, in jOOQ > 3.0. Sorry about that. > > Cheers > Lukas > > > 2013/5/24 John Childress <[email protected] <javascript:>> > >> Is multi-database support working now? >> >> thanks, >> >> John >> >> >> On Tuesday, April 17, 2012 4:30:37 PM UTC-5, Lukas Eder wrote: >> >>> 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<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<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/<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 >>> >>> -- >> 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/groups/opt_out. >> >> >> > > -- 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/groups/opt_out.
