Digest for jooq-user@googlegroups.com - 4 updates in 2 topics

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Digest for jooq-user@googlegroups.com - 4 updates in 2 topics

http://groups.google.com/group/jooq-user/topics mailing list
Ezhil arasu <[hidden email]>: Sep 15 05:07AM -0700

I am new to JOOQ. When i try to create java files with JOOQ it will creats
too many java files. i need prefered java file only. anyone can help me for
that.
Lukas Eder <[hidden email]>: Sep 15 03:06PM +0200

Hi Ezhil,
 
Thank you very much for your message. The number of files jOOQ generates is
just right - eventually, you will profit from all of them!
 
If you're sure you don't want the records to be generated, for instance,
you could turn them off. Instructions are given here:
https://www.jooq.org/doc/latest/manual/code-generation/codegen-records
 
Essentially, you need to pass the flag
 
<configuration>
<generator>
<generate>
* <records>false</records>*
</generate>
</generator>
</configuration>
 
flag.
 
I hope this helps,
Lukas
 
Lukas Eder <[hidden email]>: Sep 14 11:33PM +0200

Hi Sulaiman,
 
Thank you very much for your message.
 
Currently, there is no way for a batch store operation to implement the
INSERT .. ON DUPLICATE KEY UPDATE or MERGE semantics that you intend for it
to do. Batch store is simply a batch version of the ordinary
UpdatableRecord.store() operation, which makes the decision whether to
INSERT or UPDATE the record in the client, not the server.
 
I suggest you actually run a set based INSERT .. ON DUPLICATE KEY UPDATE
statement, or a MERGE statement instead.
 
I hope this helps,
Lukas
 
Sulaiman Malik <[hidden email]>: Sep 14 11:03PM -0700

Hi Lucas,
 
Thankyou for your reply,
 
I have done it with the different approach, by using a common interface
UpdatableRecord, first I have used a fetchOne() query to get the record on
the basis of the unique constraint which will give the UpdatableRecord and
then set the values with the updated ones which are then added to
userRecordlist which will be further passed into batchStore which will
decide either to insert or update. I think this approach is also fine. What
you say?
 
On Friday, 15 September 2017 02:33:16 UTC+5, Lukas Eder wrote:
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to [hidden email].