In 1PC, a single coordinator manages the transaction. It contacts all involved nodes (participants) to ensure their readiness for commit. If all nodes are ready, the coordinator initiates the commit phase, where all participants execute the transaction. If successful, the coordinator sends a commit message, otherwise, it sends an abort message. This protocol is simple but has limitations in ensuring atomicity and reliability. 2PC involves a coordinator and multiple participants. It operates in two phases: the prepare phase and the commit phase. During the prepare phase, the coordinator asks participants if they are ready to commit. If all participants agree, it proceeds to the commit phase; otherwise, it aborts the transaction. This protocol ensures atomicity but can suffer from blocking issues if the coordinator fails during the process.
in leaked datasource connections scenario , observing patterns what does it mean how can we do this ? if we see multiple inactive connections at db end what should weblogic admin do ? what is pool out of connection ? please explain this clearly it is very useful to me.
if we enable test connection reserve one query will be generated from datasource to db right ? if that query fails if reply not received from db to datasource what wii happen what is the result ?
A connection which is not handed over to the connection pool once work is finished called the leaked connection. You have to observe the patterns, in case of leak connection pool your pool will always get out of connection or you will see multiple inactive connections at db
Hi Sir, one most important topic which has not been covered on RUclips(as far as i can see) is Replication and it's types... Please make a video on this topic. Did not get this topic anywhere...
how can i connect DB from my weblogic machine or database connectivity through command line from my weblogic machine? is there any command to connect to DB by using DB user name and password ?
dbping is to test connectivity between weblogic and db host, you have to provide username and password in dbping as well. If you want to connect db to connect SQL prompt to work on db then you have to install Oracle db client on weblogic host
Awesome experience sir thank you so much 😊👏
Really a great tutorial. Hats off
inside cluster all ms servers will be targeted to single db in backend ?
All Ms targeted to cluster and data source also targeted to cluster
what is the difference between one phase commit and two phase commit ?
In 1PC, a single coordinator manages the transaction. It contacts all involved nodes (participants) to ensure their readiness for commit. If all nodes are ready, the coordinator initiates the commit phase, where all participants execute the transaction. If successful, the coordinator sends a commit message, otherwise, it sends an abort message. This protocol is simple but has limitations in ensuring atomicity and reliability.
2PC involves a coordinator and multiple participants. It operates in two phases: the prepare phase and the commit phase. During the prepare phase, the coordinator asks participants if they are ready to commit. If all participants agree, it proceeds to the commit phase; otherwise, it aborts the transaction. This protocol ensures atomicity but can suffer from blocking issues if the coordinator fails during the process.
in leaked datasource connections scenario , observing patterns what does it mean how can we do this ? if we see multiple inactive connections at db end what should weblogic admin do ? what is pool out of connection ? please explain this clearly it is very useful to me.
Replied on other thread. You can check the leaked connections from console. Data source monitoring
if we enable test connection reserve one query will be generated from datasource to db right ? if that query fails if reply not received from db to datasource what wii happen what is the result ?
Yes, in that case application will not get connection from db
where exactly we can check that we are having database connection leaks or not ?
Code if closing connections after use, maximum utilization regularly, from console leaked connection count
What is leaked jdbc connection how can we troubleshoot it ?
A connection which is not handed over to the connection pool once work is finished called the leaked connection. You have to observe the patterns, in case of leak connection pool your pool will always get out of connection or you will see multiple inactive connections at db
Hi Sir, one most important topic which has not been covered on RUclips(as far as i can see) is Replication and it's types...
Please make a video on this topic. Did not get this topic anywhere...
Thanks for suggestion. I will create.
how can i connect DB from my weblogic machine or database connectivity through command line from my weblogic machine? is there any command to connect to DB by using DB user name and password ?
dbping
no i want to connect DB directly by using DB user name and password is it possible ?@@digitak.middleware
sir please answer this question
dbping is to test connectivity between weblogic and db host, you have to provide username and password in dbping as well. If you want to connect db to connect SQL prompt to work on db then you have to install Oracle db client on weblogic host
Thank you sir@@digitak.middleware
I am getting connection reset error while testing configuration
Send complete error stack on digitalk.fmw@gmail.com
Sir, can make a video on gridlink datasource,
Will make soon..