Christopher, Would you consider putting this information into some form of documentation we could include with the code?
Thanks, J. > -----Original Message----- > From: Christopher Watson [mailto:[EMAIL PROTECTED]] > Sent: Monday, 2 December 2002 11:37 am > To: [EMAIL PROTECTED] > Subject: RE: Microsoft SQLserver with cocoon > > > 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]> ======================================================================= Information in this email and any attachments are confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other commitment through the use of this email. Experian Limited (registration number 653331). Registered office: Talbot House, Talbot Street, Nottingham NG1 5HF --------------------------------------------------------------------- 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]>
