how does this declaration differs !!!

[Manishada]

<%!<br /> Connection conn = null %>
and
<% Connection conn = null %>.
Which one should be used....

[mahadevan raja]

what was that??

[Manishada]

Sorry !! that was surprising !!
Actual doubt is:
This is how I declare my Connection Object
< ! Connection con=null %>
Is this is right ??
<% Connection con=null %>
Pls comment

[Andre Glauser]

The first one is an incorrect JSP Declaration and the second one is an incorrect JSP scriptlet. Scriptlets are translated into the service method of the translated servlet, whereas the declaration is translated to the body of the servlet class.
The syntax in the example is incorrect they must both have a semi-colon at the end in order to compile. The declaration will become an instance variable whereas the scriptlet will become a method variable.
Therefore this

<%! Connection con=null; %>
<% Connection con=null; %>

would get translated to something like this

  
public class XXX extends HttpJspPage implements HttpServlet {
  public Connection con=null;
  
  ...
  public xxx service(xxx, xxx) {
     Connection con=null;
     ...
  }
}

So, depending on what you are going to do with the variable, will depend where you put it. But, preferably the option is to put your DB access code somewhere other than the JSP, i.e a JavaBean or EJB.
BTW: You should download and have a look at the JSP specification to see the JSP constructs.
------------------------------------

Originally posted by Manishada:
Sorry !! that was surprising !!
Actual doubt is:
This is how I declare my Connection Object
< ! Connection con=null %>
Is this is right ??
<% Connection con=null %>
Pls comment

[satya]

Hi abhi... i mean manishada,
ur declaration is causing the single connection object to handle mutliple connectivity when the same jsp file is being accessed by concurrent users. this can lead to a prob when the close method is called as the other request won't get the connection and they will be forced to create new connections.
I hope things are clearer now. pl try the same and revert back.
regards,
satya

[Manishada]

Hi all,
Thanx for all those valuable suggestions.
Regards
By the way Mr.Satya what was that abhi i mean manishada !!! needs more clarification

[satya]

i don't why but instead of writing ur name i was going to write abhilash and then i stopped.. I hope things are clearer now. i hope u will not get a compilation error now.