PreparedStatement hangs

First check where it is hanging: hit control-\ (Unix) or control-break (Windows) to get a stack trace.

Which databases are you using?

Can some other process be locking something in the database? If insert really is hanging you may need to use database tools to find out what's doing what.

Insert the same stuff from a command line SQL interpreter to see if that hangs. Try a simpler example with fewer columns, using a temp table so nobody else is touching it.

sjasjaa at 2007-7-13 0:01:12 >

> First check where it is hanging: hit control-\ (Unix)

> or control-break (Windows) to get a stack trace.

I will try that.

> Which databases are you using?

Oracle

> Can some other process be locking something in the

> database? If insert really is hanging you may need to

> use database tools to find out what's doing what.

>

> Insert the same stuff from a command line SQL

> interpreter to see if that hangs. Try a simpler

> example with fewer columns, using a temp table so

> nobody else is touching it.

I had done a similar thing a couple of months ago with no issues, but I will try again with a more simple example.

Thanks

black_lotusa at 2007-7-13 0:01:13 >