Return-Path: 
 <users-return-56707-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 60284 invoked from network); 16 Oct 2003 10:08:50 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 16 Oct 2003 10:08:50 -0000
Received: (qmail 21236 invoked by uid 500); 16 Oct 2003 10:08:14 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 21166 invoked by uid 500); 16 Oct 2003 10:08:13 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
list-post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 21078 invoked from network); 16 Oct 2003 10:08:12 -0000
Received: from unknown (HELO exchange2000.ELIS.ORG) (195.103.122.27)
  by daedalus.apache.org with SMTP; 16 Oct 2003 10:08:12 -0000
Received: from ego.elis.org ([10.200.1.6] unverified) by exchange2000.ELIS.ORG
 with Microsoft SMTPSVC(5.0.2195.6713);
	 Thu, 16 Oct 2003 12:08:00 +0200
Subject: Re: Trouble connecting to MS SQL Server
From: Gianluca Sartori <g.sartori@elis.org>
To: users@cocoon.apache.org
In-Reply-To: <1066217036.912.32.camel@localhost>
References: <1066209319.914.25.camel@localhost>
	 <1066217036.912.32.camel@localhost>
Content-Type: text/plain
Message-Id: <1066298869.868.90.camel@localhost>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Thu, 16 Oct 2003 12:07:49 +0200
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 16 Oct 2003 10:08:00.0035 (UTC)
 FILETIME=[60EED730:01C393CD]
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Still no luck... I followed the article in the cocoon wiki but the
result is not different from the previous one.

Thanks anyway,
Gianluca

Il mer, 2003-10-15 alle 13:23, Gianluca Sartori ha scritto:
> Okay I solved the first problem but the second still remains. Someone of
> you has knowledge about MSSQLServer + Cocoon 2.1.2 ? I'm running Linux
> with MSSQLServer drivers from Microsoft. They worked just fine with JSPs
> and Servlets.
> 
> Any help?
> Gianluca
> 
> Il mer, 2003-10-15 alle 11:15, Gianluca Sartori ha scritto:
> > Hi,
> > 
> > 	I have two problems in trying to connect to a MS SQL Server. The first
> > is a configuration problem:
> > 
> > I configured cocoon.xconf modifing the existing "hb_pool" connection as
> > follow:
> > 
> >    <jdbc name="hb_pool">      
> >      <pool-controller min="5" max="10"/>
> >      <dburl>jdbc:microsoft:sqlserver://sql.elis.org:1433</dburl>  
> >      <user>DatabaseUser</user>
> >      <password>[passwd]</password>
> >    </jdbc>
> > 
> > the xsp from which i use the connection is (the incriminated part only):
> > 
> > <esql:connection>
> >        <esql:pool>hb_pool</esql:pool>
> > 
> > With this configuration the connection works (okay, it gives me an
> > exception, but it's SQL Server talking). Trying to modify the jdbc name
> > in both files, cocoon gives me the following error:
> > 
> > org.apache.cocoon.ProcessingException: Exception in
> > ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not
> > get the datasource
> > org.apache.avalon.framework.component.ComponentException: datasources:
> > ComponentSelector could not find the component for hint [hb_pool] (key
> > [hb_pool])
> > 
> > Now, why is it still concerning about "hb_pool" while the connection
> > name I used is different? Are there any other referencies somewhere I
> > don't know to this name?
> > 
> > 
> > The second problem is the exception returned by the SQL Server. Leaving
> > the "hb_pool" name as it is and using it in the <esql:connection> i get
> > this message (and only this, the rest of the page is blank):
> > 
> > Cocoon  [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid
> > object name 'srv_trans'.
> > 
> > What's it? I never mentioned "srv_trans" in the query I'm trying to
> > execute.
> > 
> > Thanks for any kind of help,
> > Gianluca
> > 
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> > For additional commands, e-mail: users-help@cocoon.apache.org
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org