is there any difference b/w connection of a simple java prog. and a servlet.

[Garg]

Hi All,

Can anny one help me.

I am trying to update the database by using a callable statement. But
in case of servlet i am getting an error
java.sql.SQLException: Not all parameters bound.

But if i call the same procedure with same data and every thing. it is
able to update the database.

I am not able to understand the difference between a simple java
program call and a servlet call.

Thanks
Tarun Garg

 

[Daniel Pitts]

Hi All,

Can anny one help me.

I am trying to update the database by using a callable statement. But
in case of servlet i am getting an error
java.sql.SQLException: Not all parameters bound.

But if i call the same procedure with same data and every thing. it is
able to update the database.

I am not able to understand the difference between a simple java
program call and a servlet call.

Thanks
Tarun Garg

I'm guessing that you're not Actually calling stored proc the same way
in both cases. Use a debugger, or logger, to verify that the exact
same SQL and parameters are passed through.

 

[Garg]

No.

I am coping and pasting the same code from the jave prog. to the
servlet. so there is no mismatch.

butmine understanding is java prog is run by a JVM and that handles all
the thing. but in case of servlet application server (tomcat i m using)
is handling all these things. So is there any difference between
'execute' of JVM and application server.

Or as i am using Cache as a database, that it self is not able to
handle this.

Tarun Garg

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

I am coping and pasting the same code from the jave prog. to the
servlet. so there is no mismatch.

butmine understanding is java prog is run by a JVM and that handles all
the thing. but in case of servlet application server (tomcat i m using)
is handling all these things. So is there any difference between
'execute' of JVM and application server.

A standalone app and a servlet can differ in how the
connection is created. There should be no
difference in the execution of SQL statements.

Try and check:
- that JDBC driver version is the same
- that the parameters you set are actually the same

Arne