Re: svn commit: r415549 - /tomcat/connectors/trunk/jni/native/src/network.c

[prakash shanmugam]

hello mturk
 i want to know how to store a *.doc file ,or *.pdf file in MYSQL
database using JSP or SERVLET as a front end
if you know the asnwer please reply me soon its very important.
bye



On 6/20/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


Author: mturk
Date: Tue Jun 20 00:56:27 2006
New Revision: 415549

URL: http://svn.apache.org/viewvc?rev=415549&view=rev
Log:
Ups. Deleted the crucial Revision tag :)

Modified:
   tomcat/connectors/trunk/jni/native/src/network.c

Modified: tomcat/connectors/trunk/jni/native/src/network.c
URL:
http://svn.apache.org/viewvc/tomcat/connectors/trunk/jni/native/src/network.c?rev=415549&r1=415548&r2=415549&view=diff

==
--- tomcat/connectors/trunk/jni/native/src/network.c (original)
+++ tomcat/connectors/trunk/jni/native/src/network.c Tue Jun 20 00:56:27
2006
@@ -16,7 +16,7 @@
/*
*
* @author Mladen Turk
- * @version
+ * @version $Revision$, $Date$
*/

#include "tcn.h"



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: New Feature List

[prakash shanmugam]

hai if you can help me it will be a big relief for me
now iam using tomcat 5.0 and linux as my server machine and the client
machine are windows xp
in my coding iam using JSP and SERVLETS. the problem is i want to store
images and pdf files into mydatabase . the backend is mysql 4.0
can u able to help. if u are able todo this i will be really helpful to u.
bye


On 6/23/06, Riyaz Mansoor <[EMAIL PROTECTED]> wrote:



i'll keep it brief.

i'm looking to spend time on working on the new features coming to
tomcat 5.5 or 6

on the website, i could find no info on this. i was hoping there would
be a page listing the features being worked in 5.5 and the coming
features in 6

riyaz

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

error in connecting MYSQL database (Too many connections error)

[prakash shanmugam]

hai all,

 i have one major issue in my project..

 My project is developed using jsp,servlets in Tomcat5 with MySql as
database.. i am using type1 driver

 My project is now used by end users in intranet..

 When multiple users are accessing at the same time ,its throwing *too many
connections exception* at sometimes . And at sometimes its dispaying error
as "*Operation not allowed after ResultSet is closed"*

 i dont know how to rectify this ..  Can anybody help me to overcome this..

  Here is my bean file used for establing database connections...

package com.pts.database;
import java.io.*;
import java.sql.*;
import java.net.*;

public class DBCon
{
  private static final String DriverClass = "com.mysql.jdbc.Driver";
  private static final String CONNECTION_STRING = "jdbc:mysql://";
  private static final String PORT = "3306";
  private static final String DATABASE = "opts";
  private static final String user = "dav";
  private static final String pwd="";
  private static Connection  con = null;
  private static Statement stmt = null;
  private static Statement stmt2 = null;
  private static PreparedStatement pst = null;
  private static ResultSet rs = null;
  private static int count = 0;

  public static void assignCon()
  {
 String CONNECTION_IP="100.100.100.6";
try{
   Class.forName(DriverClass).newInstance();
   }
   catch(ClassNotFoundException ce){System.out.println(ce);}
   catch(InstantiationException ie){}
   catch(IllegalAccessException ie1){}

   try{
   con = DriverManager.getConnection
(CONNECTION_STRING+CONNECTION_IP+":"+PORT+"/"+DATABASE,user,pwd);
   stmt = con.createStatement();
   stmt2 = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
   }catch(SQLException sqle){System.out.println("STMT:"+sqle);}
  }
  public static ResultSet retrieveFromDB(String sql) throws SQLException
  {
   return (stmt.executeQuery(sql));
  }
  public static ResultSet retrieveScrollDB(String sql) throws SQLException
  {
   return (stmt2.executeQuery(sql));
  }
  public static int updateDB(String sql) throws SQLException
  {
   return (stmt.executeUpdate(sql));
  }
  public static PreparedStatement prepareStmt(String sql) throws
SQLException{
 pst=con.prepareStatement(sql);
return pst;
  }
  public static ResultSet getProjectsList() throws SQLException{
 rs=((PreparedStatement)con.prepareStatement("select projID,projName from
proj_det where delFlag=0 || delFlag IS NULL")).executeQuery();
return rs;
  }
  public Connection getConn() {
return con;
  }
  public Statement getStmt()
  {
return stmt;
  }
  public  static void CloseAll() throws SQLException
  {
   stmt.close();
   stmt2.close();
   con.close();
  }
}



Hope Any of u can help me.. it would be very much helpful to me if any body
suggest me a solution to this... Because of this issue my project is in
pending..



Thanks in Advance