Package org.pjdbc.drivers

Class ReadonlyDriver

java.lang.Object

org.pjdbc.sql.AbstractDriver

org.pjdbc.sql.AbstractProxyDriver

org.pjdbc.drivers.ReadonlyDriver

All Implemented Interfaces:

Driver

@DriverCapability(prefix="readonly",
                  description="Enforces read-only database access",
                  capabilities={"security","filtering"})
@DriverParameter(name="allowDDL",type=BOOLEAN,description="Allow DDL statements (CREATE, ALTER, DROP)",defaultValue="false") @DriverParameter(name="allowDML",type=BOOLEAN,description="Allow DML statements (INSERT, UPDATE, DELETE)",defaultValue="false") @DriverParameter(name="message",type=STRING,description="Custom error message for blocked operations")
public class ReadonlyDriver
extends AbstractProxyDriver

ReadonlyDriver enforces read-only database access by blocking write operations.

URL format: jdbc:readonly[param=value,...]:jdbc:target:...

Blocked operations (by default):

• DML: INSERT, UPDATE, DELETE, MERGE, UPSERT, REPLACE, TRUNCATE
• DDL: CREATE, ALTER, DROP, RENAME
• DCL: GRANT, REVOKE
• TCL: (transactions are allowed)

Example URLs:

 jdbc:readonly:jdbc:postgresql://localhost/mydb
 jdbc:readonly[allowDDL=true]:jdbc:postgresql://localhost/mydb
 jdbc:readonly[message=No writes allowed in reporting mode]:jdbc:mysql://localhost/db
 

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	ReadonlyDriver.ReadonlyConfig	Configuration holder for readonly parameters.

Driver Parameters

URL format: jdbc:readonly[param=value,...]:<target-url>

Parameter	Type	Default	Constraints	Description
allowDDL	boolean	false	-	Allow DDL statements (CREATE, ALTER, DROP)
allowDML	boolean	false	-	Allow DML statements (INSERT, UPDATE, DELETE)
message	string	-	-	Custom error message for blocked operations

Constructor Summary

Constructors

Constructor	Description
ReadonlyDriver()

Method Summary

Modifier and Type	Method	Description
protected boolean	acceptsSubName(String subname)
protected boolean	acceptsSubProtocol(String subprotocol)
Connection	connect(String url, Properties info)
protected CallableStatement	proxyCallableStatement(CallableStatement delegate, Connection conn)
protected Connection	proxyConnection(Connection delegate, String url, Properties info, Driver driver)
protected PreparedStatement	proxyPreparedStatement(PreparedStatement delegate, Connection conn)
protected Statement	proxyStatement(Statement delegate, Connection conn)

Methods inherited from class org.pjdbc.sql.AbstractProxyDriver

getPropertyInfo, isCompositionValidationEnabled, isValidateParametersEnabled, proxyCallableStatement, proxyConnection, proxyConnection, proxyPreparedStatement, proxyResultSet

Methods inherited from class org.pjdbc.sql.AbstractDriver

acceptsProtocol, acceptsURL, getMajorVersion, getMinorVersion, getParentLogger, getUrlParameter, getUrlParameter, getUrlParameters, jdbcCompliant, parseUrl, protocol, subname, subprotocol, validateParameters

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

ReadonlyDriver

public ReadonlyDriver()

Method Details

acceptsSubProtocol

protected boolean acceptsSubProtocol(String subprotocol)

Specified by:

acceptsSubProtocol in class AbstractDriver

acceptsSubName

protected boolean acceptsSubName(String subname)

Overrides:

acceptsSubName in class AbstractProxyDriver

connect

public Connection connect(String url,
 Properties info)
                   throws SQLException

Specified by:

connect in interface Driver

Overrides:

connect in class AbstractProxyDriver

Throws:

SQLException

proxyConnection

protected Connection proxyConnection(Connection delegate,
 String url,
 Properties info,
 Driver driver)
                              throws SQLException

Overrides:

proxyConnection in class AbstractProxyDriver

Throws:

SQLException

proxyStatement

protected Statement proxyStatement(Statement delegate,
 Connection conn)
                            throws SQLException

Overrides:

proxyStatement in class AbstractProxyDriver

Throws:

SQLException

proxyPreparedStatement

protected PreparedStatement proxyPreparedStatement(PreparedStatement delegate,
 Connection conn)
                                            throws SQLException

Overrides:

proxyPreparedStatement in class AbstractProxyDriver

Throws:

SQLException

proxyCallableStatement

protected CallableStatement proxyCallableStatement(CallableStatement delegate,
 Connection conn)
                                            throws SQLException

Overrides:

proxyCallableStatement in class AbstractProxyDriver

Throws:

SQLException