Actually I was confused on the topic mentioned in the following url:
Define a JMS connection pool
I am using Weblogic5.1 and Oracle 8i
In the url it is written that - If you do not use persistent messages with JMS, you do not need to set up a connection pool for JMS. So, if I need persistent messages I need to set up a JDBC connection pool.
(weblogic.jms.connectionPool=yourpoolname must be there in weblogic.properties file)
So, I understood that if I use JDBC connection pool then my messages will be stored in DB insted of memory. And if application / Machine crashes then also the messages will be persisted. And when application comes back then JMS Queue can read those data again. Have I interpreted it correctly?
Where to mention the TABLE name and description of the colums in which the messages will be persisted? Or it will be created by default automacially?
If it is created by default automatically, then when it is created? If it takes the userid password etc from Connection Pool properties defined in weblogic.properties file then it can be possible that it will not be able to create those tables , because the user defined in connection pool properties may not(and should not)have the Table creation permission.
Please help me out. I am really confused.