he derby.log , it is possible to narrow down
> the statements that might be
> holding the locks.
>
>
> -suresh
>
>
>
> Jeremiah Jahn wrote:
>
> >I have autocommit set to true and one process accessing the system at a
> >time. anyone know of a rea
I have autocommit set to true and one process accessing the system at a
time. anyone know of a reason that a delete * from a table would give me
this message?
ERROR 40XL1: A lock could not be obtained within the time requested
at
org.apache.derby.iapi.error.StandardException.newException(
Thoughts on this one? This follows the examples given in the replies exactly.
if (currentIteration %2 == 0){
insertPreparedStatement.setTimestamp(5,new Timestamp(new
Date().getTime()));
}
else {
insertPreparedStatement.setNull(5,Types.TIMESTAMP); <-problem code
}
java.sql.Ba
It was the crack then...! I guess postgres and the as400 are just more
forgiving thanx for the help.
-jj-
On Mon, 2005-02-07 at 15:11 -0800, Sunitha Kambhampati wrote:
> Jeremiah Jahn wrote:
>
> > insertPreparedStatement.setNull(5,Types.NULL); where column is a
> &g
Am I on crack or shouldn't this work?
insertPreparedStatement.setNull(5,Types.NULL); where column is a
timestamp column.
This is with the latest official release(10.0.2.1). running on java 5
and linux.
SQL Exception: An attempt was made to get a data value of type 'TIMESTAMP' from
a dat