Good afternoon, there are two features I need to implement in the software which I'm currently developing:
1. creation date, last change date, creator-user, last modified user as columns in each table for basic tracking of that information 2. complete change history of each table-row (in each table) I'm coming from C# world, where I worked a few years with a modified Subsonic ORM Layer. Now I have to develop this new software in Java, and due to some recent projects where I already used jOOQ I'm also using jOOQ right now. The first feature could be done on every saving operation, just upfront setting the values. However, 2 fields are current date, and the other two the current user. It would be cool e.g. to just use: dbRecord.store(userId) and that the "magic" is out of sight of the developer. The second feature is a whole different story. Currently I'm thinking of creating triggers that will do the work in the DBMS (postgreSQL). But maybe there are other solutions too? Sepp -- 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/d/optout.
