Re: Mass data batch processing

2017-03-02 Thread Mike Foody
:-) - Mike Foody Providence HR http://www.providencehr.com (832) 714 1652 m...@providencehr.com On Thu, Mar 2, 2017 at 9:53 AM, Lukas Eder <lukas.e...@gmail.com> wrote: > Yes, indeed, an Observer might be a better way to abstract over a stream > of data to merge into different t

Re: Mass data batch processing

2017-03-02 Thread mike
Please excuse me if I misunstand the requirements. You want to process the stream of data and collect it into inserts into the contact history table and updates to the email address and then batch process these once you've collected enough to make the batch efficient. The pain is that Java

Re: [REQUEST FOR FEEDBACK]: What small but incredibly useful utility are you missing the most in jOOQ?

2017-03-02 Thread mike
We've solved writing back entity graphs a bit differently. The application has a requirement for business process purposes as well as compliance reasons to maintain a complete history of all changes. We've chosen to support this using a bi-temporal data model. Almost every table in the

Re: [REQUEST FOR FEEDBACK]: What small but incredibly useful utility are you missing the most in jOOQ?

2016-12-07 Thread Mike Foody
You might try creating your own function. public Field now() { return DSL.function("now", DateTime.class); } - Mike Foody Providence HR http://www.providencehr.com (832) 714 1652 m...@providencehr.com On Wed, Dec 7, 2016 at 7:53 PM, Samir Faci <sa...@esamir.com> wrote: >

Re: [REQUEST FOR FEEDBACK]: What small but incredibly useful utility are you missing the most in jOOQ?

2016-07-15 Thread Mike Foody
dsl.batchInsert(records) significantly slowed down the process. - Mike Foody Providence HR http://www.providencehr.com (832) 714 1652 m...@providencehr.com On Fri, Jul 15, 2016 at 11:23 AM, Lukas Eder <lukas.e...@gmail.com> wrote: > Hi Mike, > > Thanks a lot for your feedba

Re: [REQUEST FOR FEEDBACK]: What small but incredibly useful utility are you missing the most in jOOQ?

2016-07-14 Thread mike
Hi Lukas, A generated method to provide a type safe insert statement including all the table columns would be extremely useful for us. We typically use records to do inserts but for a few high volume processes we are batching raw inserts. We found this significantly faster than instantiating

Re: Map resultset into objectGraph / json

2015-10-26 Thread Mike Foody
We're using Scala and simply using the standard collection operations to map one object graph into another. If you're using Java 8 you should be able to achieve something pretty concise. In our case at least we like the no magic solution which is easy to understand and type safe. If you can't

Possible jOOQ bug with MS Sql Server and limit-offset on a join query

2013-01-30 Thread Mike Fayer
] asc) as limit_107798178) as outer_limit_107798178 where rownum_107798178 ? and rownum_107798178 = (? + ?) ]; The column 'MUN_ID' was specified multiple times for 'limit_107798178'. Thanks in advance! Mike -- You received this message because you are subscribed to the Google Groups jOOQ