problem with "insert statement" using JSP

This is one of the most peculiar problems I have faced while using JSP with Oracle. The "insert" statement stops working on its own and then starts working on its own. Is there some problem on the JSP side or the oracle side. I have kept the varchar2 values in database more than 500.

[298 byte] By [dineshk_saini] at [2007-9-26 18:09:23]

«« Aggregate Entity with entity-entity EJB relations is inelegant?
»» How do I pass arguments to an executable and get it's return value ...

# 1

Check whether the table gets locked, if u r not closing the connection or the resultset. There is a chance that the insert and update fails if the table gets locked.

Its always better to close the ResultSet object if used previously and also the Connection.

Hope this helps

vikramdesai at 2007-7-3 1:54:28 >

top of Java-index,Enterprise & Remote Computing,Web Tier APIs...

# 2

My connection is closed at the end of each page so there is no chance of either connection or resultset being left open.

As **** as the locking of tables is concerned, the other statements on the same table are working fine...and moreover, the insert statement starts working on its own after some time.

dineshk_saini at 2007-7-3 1:54:29 >

# 3

hello, there, can i ask u all how to integrate oracle and jsp. I've set the classpath with the value:

classpath=.;c:\orant\jdbc\lib\classes12.zip

and i've changed the classes12.zip to jar file and locate the jar file in the lib folder under web-inf folder. however, as i run my jsp file that connect to database, the error message indicate;

"The network adapter could not establish the connection"

can u all give me piece of advice... i really appreciate ur advice... the version of the oracle is 8.1.7 and tomcat 4.0.1 . is there any wrong configuration there?

thanks in advance and regards

pat

kl001851 at 2007-7-3 1:54:29 >

# 4

At the moment, I cannot help you as I am not using TOMCAT...but will get back to you later.Dinesh

dineshk_saini at 2007-7-3 1:54:29 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

problem with "insert statement" using JSP

Enterprise & Remote Computing New Topic

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified