Hey all, Managed to get a bit further after my last email. However now I'm getting the message below. I'm not sure what to do about this. The piece of code I'm executing is: Criteria crit = new Criteria(); crit.add(AualdocsPeer.FMT_ACC, "015.2003.00000005.001"); List doclist = AualdocsPeer.doSelect(crit); Is there anyway I can configure it so that it doesn't set read-only mode to true? Thanks heaps, Andrew. java.sql.SQLException: Read only mode not supported at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:346) at com.informix.jdbc.IfxSqliConnect.setReadOnly(IfxSqliConnect.java:1558) at org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setReadOnly(ConnectionImp l.java:392) at org.apache.commons.dbcp.datasources.PerUserPoolDataSource.setupDefaults(PerU serPoolDataSource.java:459) at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(Inst anceKeyDataSource.java:704) at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(Inst anceKeyDataSource.java:665) at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743) at org.apache.torque.Torque.getConnection(Torque.java:306) at org.apache.torque.util.Transaction.beginOptional(Transaction.java:118) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365) at com.amyers.torque.eservice.BaseAualdocsPeer.doSelectVillageRecords(BaseAuald ocsPeer.java:666) at com.amyers.torque.eservice.BaseAualdocsPeer.doSelectVillageRecords(BaseAuald ocsPeer.java:635) at com.amyers.torque.eservice.BaseAualdocsPeer.doSelect(BaseAualdocsPeer.java:6 03) at com.amyers.torque.testapp.TorqueTester.main(TorqueTester.java:28) --------------------------------------------------------------------- This email is from Civica Pty Limited and it, together with any attachments, is confidential to the intended recipient(s) and the contents may be legally privileged or contain proprietary and private information. It is intended solely for the person to whom it is addressed. If you are not an intended recipient, you may not review, copy or distribute this email. If received in error, please notify the sender and delete the message from your system immediately.Any views or opinions expressed in this email and any files transmitted with it are those of the author only and may not necessarily reflect the views of Civica and do not create any legally binding rights or obligations whatsoever. Unless otherwise pre-agreed by exchange of hard copy documents signed by duly authorised representatives, contracts may not be concluded on behalf of Civica by email. Please note that neither Civica nor the sender accepts any responsibility for any viruses and it is your responsibility to scan the email and the attachments (if any). All email received and sent by Civica may be monitored to protect the business interests of Civica. ---------------------------------------------------------------------