Skip to Content.
Sympa Menu

freetds - Re: too much connections

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Eric Mountain" <e.mountain AT dev.amadeus.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: too much connections
  • Date: Tue, 22 Jun 1999 09:46:32 +0200


You don't need to open a new connection each time you process a statement.
You should be doing something like:

Class.forName ("com.internetcds.jdbc.tds.Driver");
Connection con = DriverManager.getConnection(url, "user", "pass");

Statement stmt = con.createStatement ();
ResultSet rs1 = stmt.executeQuery (query1);
ResultSet rs2 = stmt.executeQuery (query2);
etc.

(Of course I've omitted try/catch, etc. etc. etc.)

:E

-----Original Message-----
From: Edu <non ay@vale> <Edu <non ay@vale>>
Newsgroups: freetds
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Date: Monday, 21 June, 1999 12:33
Subject: [freetds] too much connections


> hi, I've a problem with FreeTds driver:
>
> it establish a new connection for each select query which my program
> request. My SqlServer only permits 15 connection.....
>
> Is normal this working? what can I do for use only one connection ?
>
>
> Im using, JDBC.
>
> What can I do, I want to use only one connection.
>
> thanks, Eduardo
>
> Edu AT mundomail.net
>
>
>
>
>---
>You are currently subscribed to freetds as: eric AT minouche.demon.co.uk
>To unsubscribe, forward this message to
$subst('Email.Unsub')
>




  • Re: too much connections, Eric Mountain, 06/22/1999

Archive powered by MHonArc 2.6.24.

Top of Page