FreeTDS Development Group

["Eric Mountain" <e.mountain AT dev.amadeus.net>]

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')
>