Maxime
1) When I last got the drivers there were 3 jars, namely msbase.jar mssqlserver.jar msutil.jar Try putting all 3 jars into cocoon's WEB-INF/lib 2) For mssql add following lines (between ... ...) to in WEB-INF/web.xml within <init-param> <param-name>load-class</param-name> <param-value> ... <!-- For mssql2000 Driver: --> com.microsoft.jdbc.sqlserver.SQLServerDriver ... 3) Add following jdbc element within <datasources/> in cocoon.xconf <jdbc name="my_sql2000_cocoon_datasource"> <pool-controller min="5" max="10"/> <dburl>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydatabase </dburl> <user>sa</user> <password>mypassword</password> </jdbc> assuming database on Server: localhost Port: 1433 Database: mydatabase and user and password as specified please edit as necessary 4) You can now (after restarting servlet engine) do something like <?xml version="1.0"?> <xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2" > <page> <esql:connection> <esql:pool>my_sql2000_cocoon_datasource</esql:pool> <my_table_element> <esql:execute-query> <esql:query> select fld1 as myfield1, fld1 as myfield2 from mytable </esql:query> <esql:results> <esql:row-results> <my_row_element> <my_column_one_element><esql:get-string column="myfield1"/></my_column_one_element> <my_column_two_element><esql:get-string column="myfield2"/></my_column_two_element> </my_row_element> </esql:row-results> </esql:results> <esql:no-results> <no-results>no-results</no-results> </esql:no-results> </esql:execute-query> </my_table_element> </esql:connection> </page> </xsp:page> Where -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 10:10 To: [EMAIL PROTECTED] Subject: Microsoft SQLserver with cocoon Hi I want to use a microsoft sql server with cocoon, so I downloaded Microsoft JDBC drivers for MS Sql server, and put the lib (JAR) into cocoon's library dir, restarted cocoon. Now, do I have to modify the cocoon.xconf? Can anybody tell me the way to make a connection and get data? Thanks --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>