Home > Ask the AS/400 Experts > iSeries Web Development Questions & Answers > WAS 5 error message
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

WAS 5 error message

Jim Mason EXPERT RESPONSE FROM: Jim Mason

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 27 July 2004
We are getting an error message on a WAS 5 server running on zOS. We are not getting this message when the developer runs the code locally off of his PC (WASD, V5R1). The message says the database is in read-only, but it's not. The code and SQL are the same. The difference is WAS on ZOS vs. WAS on the developer's PC.

Here's the message:

java.sql.SQLException: DB2JDBCSQLCompiler Received Error in Method compileSQL -> Insert/Update/Delete not honored. Database is readOnly.

COM.ibm.db2os390.sqlj.jdbc.DB2JDBCSQLCompiler.compileSQL(DB2JDBCSQLCompiler.java:205)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Web Development
IBM i shop boosts online sales with RPG-based Web platform
Migrating from RPG to EGL on IBM i
Groovy programming on IBM i
Running PHP open source applications: NOBODY needs authority
Zend Web software teams up with IBM System i
The best technologies and tools for System i programmers in 2009
Seven IBM i project lessons learned in 2008
AS/400 lessons from the past, present, and future: A holiday tale
Application modernization strategies for System i
RPG application modernization for i5

iSeries Web Development
JDBCODBC functionality -- Java to Excel for complex workbooks
Accessing AS/400 data using Excel ODBC drivers
IBM WebSphere Studio Application Developer error
Database pooling on iSeries
Connecting WebSphere to AS/400 for image retrieval
Retrieving the value selected by a user
Condense ILE service program procedures
WebSphere error during login process
Connecting WebSphere to a DB2 database
WebFacing error: User ID or password invalid

iSeries Java programming
Groovy programming on IBM i
EGL Rich UI on IBM i: Do you Dojo?
Programming for the Web on the IBM i, what is possible
Database performance comparisons on IBM i
Database drivers on the i: MySQL vs. IBM Toolbox
How to: Output SQL script to a text file from an AS/400
Application modernization for the iSeries: Why bother?
JDBCODBC functionality -- Java to Excel for complex workbooks
Necessity leads to iSeries Watchdog development
Accessing AS/400 data using Excel ODBC drivers
iSeries Java programming Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
WebSphere Development Studio Client (WDSC)  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


It sounds like the SQLJ connection is opening the database in read-only mode for some reason. When running from WSAD, you're probably using a different SQLJ Compiler because the driver is different than when you're running in WebSphere.

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:

  • Using setXXX methods

    • Properties are applicable to the following DB2-specific implementations that inherit from com.ibm.db2.jcc.DB2BaseDataSource:

  • com.ibm.db2.jcc.DB2SimpleDataSource
  • com.ibm.db2.jcc.DB2DataSource
  • com.ibm.db2.jcc.DB2ConnectionPoolDataSource
  • com.ibm.db2.jcc.DB2XADataSource

  • See Summary of DB2 Universal JDBC Driver extensions to JDBC for a summary of the property names and data types.

  • In a java.util.Properties value in the info parameter of a DriverManager.getConnection call, as shown in Connecting to a data source using the DriverManager interface with the DB2 Universal JDBC Driver.
  • In a java.lang.String value in the url parameter of a DriverManager.getConnection call, as shown in Connecting to a data source using the DriverManager interface with the DB2 Universal JDBC Driver.




    • Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice



    iSeries Networking - Printing, Remote Access, TCP/IP
    HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy     		  TechTarget - The IT Media ROI Experts