Is it possible in Weblogic to create readonly JDBC datasource?

Question

I am using Weblogic web server. Please let me know, how can i create a readonly JDBC datasource ,or should i handle this in my Java code ?

Answer 1

Shouldn't the DBMS enforce that for you? That is, if you connect to a database with a certain user identification the DBMS just gives read access to that database?

Answer 2

The datasource allows you to obtain pooled connection instances, each pooled connection instance representing a physical connection to a database that remains open during use by a series of logical connection instances.

So, what you are allowed to do with a pooled connection instance strictly depends on the database permissions granted to the user used to create the physical connection. In other words, if you want a read only pool, use a user with restricted rights at the database level when creating your pool.