cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christopher Watson" <c.wat...@zen.co.uk>
Subject RE: Microsoft SQLserver with cocoon
Date Mon, 02 Dec 2002 11:36:55 GMT
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: Maxime.Gheysen@swisscom.com [mailto:Maxime.Gheysen@swisscom.com] 
Sent: 02 December 2002 10:10
To: cocoon-users@xml.apache.org
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>



---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message