This is a discussion on error 245 in JDBC within the Informix forums, part of the Database Server Software category; --> Hi, I get error message -245 and the database is defect. What could be the problem??? Thanks Norbert...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| On Fri, 11 Jun 2004 05:18:48 -0400, Norbert Staiger wrote: finderr -245 Says: -245 Could not position within a file via an index. The ISAM code will tell you why but most likely some key was locked. Try adding 'SET LOCK MODE TO WAIT 10' this will cause any attempt to access a locked object to wait ten seconds before returning an error. Since most locks are transient this should do the trick. If not you have some massive transaction affecting and locking rows for long periods of time that needs to be rewritten. Art S. Kagel > Hi, > > I get error message -245 and the database is defect. What could be the > problem??? > > Thanks > > Norbert |