jsp - TNS error on Tomcat -

-

I am working on a social networking website project. The user who will be displayed to shorten their code from that website page, I have created a separate class which I have included in my various pages and I use different functions defined in class.

Example: I want to display user details, this is the code for it: 

  User objUser = new user (); Results set rs = objUser.getAllDetails (userName); Rs.next (); Data = "& lt; div id = text & gt;" + "From the & lt; Table & gt;" + "From & lt; tr & gt; & lt; td colspan = 2 & gt; & lt; h1 & gt; User Details & lt; bell & gt; & lt; / h1 & gt; & lt; / td & Lt; / T & gt; & lt; TR & gt; & lt; TD & gt; First Name: & lt; / TD & gt; & lt; TD & gt; "+ rs .getString ("firstname") + '& lt; / TD & gt; & Lt; / TR & gt; From "+" to & lt; TR & gt; & Lt; TD & gt; Last name: & lt; / TD & gt; & Lt; TD & gt; "+ Rs.getString (" aliases ") + '& lt; / td> gt; & lt; / tr & gt; + "From & lt; TR & gt; & lt; TD & gt; Username: & lt; / TD & gt; & lt; TD & gt;" + rs.getString ("username") + '& lt ; / TD & gt; & Lt; / TR> from "+" to & lt; TR & gt; & Lt; TD & gt; Mail ID: & lt; / TD & gt; & Lt; TD & gt; "+ Rs.getString (" mailid ") + '& lt; / td> gt; & lt; / tr & gt; + "From & lt; TR & gt; & lt; TD & gt; Contacts: & lt; /td><td>"+rs.getString("contact")+"</td></tr> ; "+" & Lt; Tr & gt; & lt; TD & gt; Course:   + +getgetstring ("course") + "& lt; / Td> & Lt; / Tr & gt; "+" & lt; Tr & gt; & Lt; TD & gt; Branch: & lt; / Td> & Lt; Td> "+ rsgetstring (+" branch ") +" & lt; / Td> & Lt; / Tr & gt; "+" & lt; Tr & gt; & Lt; TD & gt; Year: & lt; / Td> & Lt; Td> "+ rsgetString (" year ") +" & lt; / Td> & Lt; / Tr & gt; "+" & lt; / Table> "+" & lt; / Div>   
 This is my code to get the details. My class name is user, I make an object of it and use the function defined in it As a result, I get the result which I process as a string and print it later.  
 This is my code, Functon getAllDetails ()  
  Get public results all the details (string user no ) {Result as rs = null; try {class.forName (application.getInitParameter ("driver"); connection con = DriverManager.getConnection (application.getInitParameter ("url"), application.getInitParameter ("user name"), application .getInitParameter ("password"); Details: st = con.createStatement (); Rs = st.executeQuery ("select from userfine * username = '" + username "+' ''); Returns RS; } Hold (exception e) {return RS; }}   
 Now, the problem is that if I run my webpad for some time, I get a TNS error, which I believe is because there is no open connection Because all the connections have been captured. The problem is that I am not closing the connection, which I install in my getDetails () function, but if I try to close the connection before returning the ResultSet, it shows an error that the connection is closed has gone. If I turn it off after returning the object, I do not think that it does not make any sense, but I also tried to do it and the errors say that the code is never executed after the return statement. And if I try to close the connection in the block at the end, then it does not recognize the variable and the conif.  
 I believe that the number of connections will increase, but I do not think it is good, because if ever I live this app and there are many users for it, then I can increase the number of connections not can.  
 Please help, thank you already for your help. I hope I want to ask myself what I want.  
  
 
 
 You are doing it wrong First of all the connection () is in a wrong place, very deep is. Use a similar () in the beginning of a user session, at the same level of code where you can finally claim that all the results are read from the database and you can safely close the connection ()  
 Or better, Google "connection pooling" to see how you can design it more efficiently.

Comments

Post a Comment

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

-
I have a SKScene where I am adding an SKSpriteNode I have subclassed the SKSpriteNode class to create this node. In the subclass I am defining some SKActions on Sprite. What do I want to do when the end of this phantom ends the SKAction sequence, then I add a new Prayer node to this scene. How is this possible. The following code is mine: The code for the sequence is that I'm running on the Scansprinitode subclass (TEMissileNode): - SKAction * moveDown = [SKAction moveToY: Self.position.y - 20 Duration: 0.2]; SKAction * animation = [SKAction animateWithTextures: textures timePerFrame: time / 7]; SKAction * moveMissileProjectile = [SKAction Moving: Pointoffscreen Term: Time]; SKAction * group = [SKAction group: @ [animation, movement projectile]]; SKAction * Sequence = [SKAction Sequence: @ [Hilldown, Group, [SKAction removalFromParent]]]; [Self run action: sequence]; From the main scene, I call those actions that execute these tasks TEMissileNode * missile = [tmissil...
Read more

Matlab transpose a table vector -

-
An embarrassing simple question seems to be, but how can I move a Matlab table vector? aTableT = aTable '; I tried a standard syntax for the simple interaction of a line vector to a line vector aTable : ATableT = reshape (aTable, 1, Height (aTable)); and aTableT = rot90 (aTable); According to the head, the last time table should work for table, see. However, I get this error code: Error type in using table / permit (line 396) Undefined function 'permute' for the input arguments. Error in rot 90 (line 29) b = magnitude (b, [2 1 3: ndims (a)]); NB: fliplr is not useful either pretty sure I have covered clear angles - any ideas? Thanks! Try changing your table into an array, move it, then back to a table In other words, try doing this: aTableArray = table2array (aTable); ATableT = array 2table (aTableArray. '); I have also read the document for rot90 , and it says that rot90 is definitely working for tables Do, and I find you...
Read more

c# - Textbox not clickable but editable -

-
I have a small form with 10 text boxes, I have set them in the correct tab order. I want them on my tab service I was wondering if there is a way to set the text box so that they can be selected for editing until they are tabbed. That is ... I do not want the end user to edit the text box to click on them, I just want to make them editable through tabu. this should do the trick public partial category poor text box: Text Box {Safe Override Zero WndProc (Ref: Message Message) {if (m.msg == (Int) WM.LBUTTONDOWN) {Return; // mount down events} base.WndProc (ref m); }} Window message enum can be found. How to do this without anherizing: text box : class EatMouseDown: netwindows {safe override zero WndProc (ref message message) {if (m.msg == (int) WM.LBUTTONDOWN) {return; } Base.WandProc (Ref M); }} Safe Override Zero Onload (EventEurge E) {base.OnLoad (e); How to do this without any part: left a clean part, whatever is important, this can be a buggy but it works R...
Read more