Here's the message:
java.sql.SQLException: DB2JDBCSQLCompiler Received Error in Method compileSQL -> Insert/Update/Delete not honored. Database is readOnly.
I don't know if the properties for the database connection are defined as read-only in WebSphere but that's a possibility. Review the resource configuration for the connection. Here's some information on where the read-only property for the connection can be set (below). With WebSphere, the admin console exposes pre-defined resources like database connections. They can also be created dynamically in your code and, therefore, not defined in WebSphere.
Properties for the DB2 Universal JDBC Driver
Properties define how the connection to a particular data source should be made. Unless otherwise noted, properties can be set for a DataSource object or for a Connection object. Properties can be set in one of the following ways:
Properties are applicable to the following DB2-specific implementations that inherit from com.ibm.db2.jcc.DB2BaseDataSource:
See Summary of DB2 Universal JDBC Driver extensions to JDBC for a summary of the property names and data types.
Dig Deeper on Web Development
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.