Return-Path: <iboyer@capgemini.fr>
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-dev@xml.apache.org
Delivered-To: moderator for cocoon-dev@xml.apache.org
Received: (qmail 97315 invoked from network); 5 Mar 2001 09:40:46 -0000
Received: from gw.capgemini.fr (194.3.247.254)
  by h31.sny.collab.net with SMTP; 5 Mar 2001 09:40:46 -0000
Received: from prenoms.capgemini.fr (capmail.capgemini.fr [194.2.91.200])
	by gw.capgemini.fr (8.9.3/8.9.1) with ESMTP id KAA17490;
	Mon, 5 Mar 2001 10:40:18 +0100 (MET)
Received: from prenoms.capgemini.fr (localhost [127.0.0.1])
	by prenoms.capgemini.fr (8.9.3/8.9.3) with ESMTP id KAA25900;
	Mon, 5 Mar 2001 10:40:17 +0100 (MET)
Received: from iboyernew ([10.68.145.54])
	by prenoms.capgemini.fr (8.9.3/8.9.3) with SMTP id KAA25767;
	Mon, 5 Mar 2001 10:40:15 +0100 (MET)
Message-ID: <013001c0a558$4a5b81f0$3691440a@alpes.capgemini.fr>
From: "Isabelle Boyer" <iboyer@capgemini.fr>
To: "UserCocoon" <cocoon-users@xml.apache.org>,
        "DevCocoon" <cocoon-dev@xml.apache.org>
Subject: Connection to database and stylesheet
Date: Mon, 5 Mar 2001 10:39:32 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

Hi all,

I have a connection problem with a query to a SQL dataBase, named
"DB_NDSUSERS.
My query is ok but when Itested it 4 times, I have the following error
message :
com.jnetdirect.jsql.m: Failed connection:com.jnetdirect.jsql.m: This trial
license allows a maximum of 1 connections and 2 are already connected
url:jdbc:JSQLConnect://mars:1433/database=DB_NDSUSERS

I have tried to crease the number of connection in cocoon.properties in
section "Turbine DB Connection Pool" at line
processor.xsp.pool.database.default.maxConnections=100 instead of 3.

I use the servlet engine, "litewebserver" and jdk 1.3 in NT workstation.

So could you tell me what is the solution to have a unlimited connection to
the Database., what are cocoon 's properties I have to change or if this
error is included in the freeware ?

I have another request about the stylesheet. I want to use 2 differents
stylesheets in a xml document according to user's request.
Th syntax I use is as following :

<?xml version="1.0"?>

<?cocoon-process type="xsp"?>
<xsp:page language="java"
          xmlns:ldap="http://www.apache.org/2000/LDAP"
          xmlns:xsp="http://www.apache.org/1999/XSP/Core">

<?cocoon-process type="xslt"?>
<?xml-stylesheet href="nds2-3.xsl" type="text/xsl"?>

<page>

    <xsp:logic>
    String all;

    if (request.getParameter("all") != null)
  {
       all = request.getParameter("all");
   }
   else
   {
        all = "";
    }

   String XSLRef="\"href=\"nds2-3.xsl\\\"";

   if ((all.compareTo("all") == 0))
  {
       XSLRef = "\"href=\"nds2-2.xsl\\\"";
  }
  else
  {
      XSLRef = "\"href=\"nds2-3.xsl\\\"";
  }


ument.appendChild( 
   document.createProcessingInstruction("xml-stylesheet",XSLRef+ "type=\"text/xsl\""));
       
    </xsp:logic>
  <ldap:execute-query>
   ...
  </ldap:execute-query>
</page>
</xsp:page>


But it is not working.As you can see, I put a default stylesheet to not have a blank in href because it raise me an erro
r.
So could you give me an idea or another way to do this ?

Thanks in advance for your support and your help.

Best Regards,
Isabelle Boyer.