Connections Conflict??

[sweetp]

I have 2 database connections on my server (using jsp and iPlanet). Everything is fine if users only use one of the programs (it never locks up), but if I make both available, after someone uses one, then the next time a person goes into the other jsp program, it hangs. I have the CloseConnection command at the end of each program.

Thanks for any ideas!
sweetp

 

[petey]

Are you committing the changes? Forgetting to do that could cause it to hang.

http://www.drpeterjones.com/

News and views of some obscure guy

 

[sweetp]

I'm not sure what you mean by "committing". Database A only contains queries (office staff bios), so the database never changes. But after someone goes into it and looks at a bio of a staff member, then closes it, and then someone (anybody) opens Database B (conference room scheduling with insert, delete, etc), that's when the lock-up happens. Sometimes you can keep trying to use it and after 3 times it says the "peer" has been reset and then it works.

??????????? Thanks for any input.

 

[siberian]

Definently sounds like a locking issue to me as well.

What happens is one of your apps conencts to the database and puts it into 'no commit' mode. This means that it owns the database until it 'commits'.

The reason it coems bakc after awhile is that the database times out the session, issues a rollback (usually) and comes available again.

 

[sweetp]

OK, so how do I fix it? What do I need to do and where do I need to do it? I'm still pretty new at this.

Thanks!

 

[sedj]

Do you ever touch the Connection method setAutoCommit() ?

 

[sweetp]

I'm using Dreamweaver, so it writes my code for me. Any suggestions?