Subject: RE: [xsl] please, help with SQL transformer From: Jerónimo Molina <j.molina@xxxxxxxxx> Date: Wed, 10 Apr 2002 09:17:01 +0200 |
Hello, Astor and Joerg: First&Principal, Thanks for your help, I agree. Sorry for don't detail all the code, but yes, I use the namespace, so ther is another error in my code. As theese list is for XSL general pourposes, I'll suscribe to http://xml.apache.org/cocoon/mail-lists.html (Cocoon users). Thanks anyway, Jerónimo Molina. -----Mensaje original----- De: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]En nombre de Astor Rivera Enviado el: martes, 09 de abril de 2002 19:57 Para: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx' Asunto: RE: [xsl] please, help with SQL transformer 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@xxxxxx] Sent: Tuesday, April 09, 2002 10:25 AM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx 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 XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] please, help with SQL tra, Astor Rivera | Thread | [xsl] Efficiency Issues, Laura Jenkins |
RE: [xsl] '>' or '<' in element xml, Mark Seaborne | Date | RE: [xsl] Efficiency Issues, Bryan Rasmussen |
Month |