Hi all,
I'm update to cocoon 2.0b2 and Tomcat 4b7.
Everything works fine except the same error
when I query SQL server with cocoon....so bad....
any idea greatly appreciated
Thanks
Florent
for the "off-topic a little" : i'm using freetds_jdbc.snapshot.jar
(last version)
-----Original Message-----
From: Alfredas Chmieliauskas [mailto:[EMAIL PROTECTED]]
Sent: mercredi 22 août 2001 17:58
To: '[EMAIL PROTECTED]'
Subject: RE: C2 & SQL-server 7 : webbrowser keeps on loading
Hi,
off-topic a little:
You mentioned FreeTds driver you use for SQLServer7.0. What version of the
driver are you using?
I've tried to install that driver (i guess v0.51) half a year ago but I
couldn't make it work witn my SQLServer7.
Could you please tell me what version of the dirver are you using? And is
there any installation specifics? If you are using version higher 0.51 could
you mail me the compiled driver, I could not find one on the net.
Thanks,
Alfredas
-----Original Message-----
From: florent barbare [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 6:31 PM
To: [EMAIL PROTECTED]
Subject: C2 & SQL-server 7 : webbrowser keeps on loading
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]>
---------------------------------------------------------------------
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]>
