Hi all ,

I have the following error :

C2 gets stuck while processing query to SQL-server 7.
When I access that file in the browser cocoon is doing "something"
(activity in cocoon.log). In SQL-Server's Enterprise Manager I see a
connection coming in from the Cocoon-Linux-Box with the right
SQL-Statement.

But: Cocoon never produces any output. The webbrowser keeps on loading
the page forever...


WHAT I TRIED

- Installed C2a5 (Redhat 7.0, Tomcat 3.2.1)
- compiled and installed FreeTDS drivers from www.freetds.org (including
JDBC drivers)
- added com.internetcds.jdbc.tds.Driver to
$TOMCAT_HOME/webapps/cocoon/WEB-INF/web.xml so that it is loaded at
server start

Now I'm trying to run the following XSP-Script:

   <esql:connection>
     <esql:driver>com.internetcds.jdbc.tds.Driver</esql:driver>
 
<esql:dburl>jdbc:freetds:sqlserver://my_servername:1433/my_database</esq
l:dburl>
     <esql:username>***</esql:username>
     <esql:password>***</esql:password>
     <esql:execute-query>
       <esql:query>select * from tablename</esql:query>
       <esql:results>
         <esql:row-results>
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>



- Database access with ESQL taglib to Mysql database is working.
- Database access to SQL Server from a small java test programm is
working (via FreeTDS JDBC drivers)


Someone can help me please ?

Thanks in advance

Florent


___________________________________

Florent Barbare
Project manager


NETIA 
Halle Industrielle de Farjou 
34 270 Claret - France
Tel. +33 4 67 59 08 07 
Fax +33 4 67 59 08 20
E-mail : [EMAIL PROTECTED] 
Web site : www.netia.net

___________________________________

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Reply via email to