cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gianluca Sartori <g.sart...@elis.org>
Subject Re: Trouble connecting to MS SQL Server
Date Thu, 16 Oct 2003 10:07:49 GMT
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


Mime
View raw message