Guten Tag Lukas Eder, am Dienstag, 9. Juni 2020 um 09:34 schrieben Sie: > But my other suggestion stands. Why have concurrent access to the JDBC > Connection when you can have a single process that manages this connection > and that can receive messages (possibly async) to hide managing the > connection for you?
Things depend on how my app works currently and which I can't change too easily: SOAP-request -> 1 JDBC-connection -> app business logic [-> possibly many threads] -> collect results -> 1 COMMIT/ROLLBACK -> SOAP-response This way there's one transaction spanning the entire request managing all changed data, whatever it is. There's no pool or else involved, the app is pretty oold-school. Of course it could be added... But even if there was a pool, I would still need to think of how to process reports concurrently: Executing each in its own JDBC-conn. means possibly re-executing the same query over and over again, increasing the load on the system, when executing the query once per SOAP-request would be enough. Or I would need to cache results in memory somehow, which would require additional serialization on the executed queries to execute the same query once only. OTOH, multiple JDBC-connections allow concurrent exec of unrelated reports, increasing per-request performance most likely. But what happens if I at some point decide reports are not read-only anymore, but keep some history as well? Already considered that. My current transaction model commits/rollbacks per SOAP-request, all or nothing, which doesn't hold with multiple connections. Instead, I would need to keep them until shortly before the response to either commit/rollback all of those or need to abandon the all-or-nothing I have currently or ... Currently I prefer all-or-nothing, makes life easier. Mit freundlichen Grüßen, Thorsten Schöning -- Thorsten Schöning E-Mail: [email protected] AM-SoFT IT-Systeme http://www.AM-SoFT.de/ Telefon...........05151- 9468- 55 Fax...............05151- 9468- 88 Mobil..............0178-8 9468- 04 AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/254753652.20200609121545%40am-soft.de.
