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]>