This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: please, help with SQL transformer
- From: Astor Rivera <arivera at esri dot com>
- To: "'xsl-list at lists dot mulberrytech dot com'" <xsl-list at lists dot mulberrytech dot com>
- Date: Tue, 9 Apr 2002 10:57:00 -0700
- Subject: RE: [xsl] please, help with SQL transformer
- Reply-to: xsl-list at lists dot mulberrytech dot com
Hello Jeronimo,
I believe that when you execute the query in the tags
you must use the namespace for SQL and the execute tag.
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
<query>
select id,nombre from nombres
</query>
</execute-query>
</page>
Astor
-----Original Message-----
From: Joerg Heinicke [mailto:joerg.heinicke@gmx.de]
Sent: Tuesday, April 09, 2002 10:25 AM
To: xsl-list@lists.mulberrytech.com
Subject: Re: [xsl] please, help with SQL transformer
I think this is a very specific Cocoon question, so you should ask on a
Cocoon list: http://xml.apache.org/cocoon/mail-lists.html. I often use
Cocoon but not the SQL transformer, so I can't help you.
Joerg
> Hi all (sorry for my poor english):
>
> My name's Jeronimo Molina, and I'm neby with cocoon.
> I'm trying to work with SQL transformers, for generate an HTML page with
> data stored in a ACCESS database on my machine (it's my first work with
> cocoon, so I don't want to do this with ORACLE any other DB).
>
> I'm trying to do this at the next steps:
>
> 1.- Configure the JDBC-ODBC driver at the web.xml file, by adding
>
> sun.jdbc.odbc.JdbcOdbcDriver
>
> as shown bellow:
>
> <init-param>
> <param-name>load-class</param-name>
> <!-- For IBM WebSphere
> com.ibm.servlet.classloader.Handler -->
>
> <!-- For Database Driver -->
> oprg.hsqldb.jdbcDriver
>
> <!-- For JDBC:ODBC -->
> sun.jdbc.odbc.JdbcOdbcDriver
> </param-value>
> </init-pram>
>
> 2.- Configure the connection ad the cocoon.xml file as shown bellow:
>
> <datasources>
> <jdbc name="personas">
> <dburl>jdbc:odbc:nombres</dburl>
> </jdbc>
> </datasources>
>
> Note that nombres is the name of the ODBC I've just created pointing to my
> access database.
>
> 3.- Configure the sitemap.xmap file to use my new connection. I've done
> this modifying a line:
>
>
> <map:match pattern="sql/*">
> <map:generate src="docs/samples/sql/{1}.xml"/>
> <map:transform type="sql">
> <map:parameter name="use-connection" value="personas"/>
> </map:transform>
> <map:transform src="stylesheets/simple-sql2html.xsl"/>
> <map:serialize/>
> </map:match>
>
>
> 4.- I've also modified the sql-page.xml, putting the code
>
> <query>
> select id,nombre from nombres
> </query>
>
> (where nombres is the table name)
>
> in order of the query example provided in that file.
>
> BUT.... I don't get the data stored in my access database, and I don't
know
> why.
>
> please, can anyone help me?
>
> Thanks... Jeronimo.
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list