Subject: Re: [xsl] please, help with SQL transformer From: "Joerg Heinicke" <joerg.heinicke@xxxxxx> Date: Tue, 9 Apr 2002 19:24:32 +0200 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] please, help with SQL transfo, Jerónimo Molina | Thread | RE: [xsl] please, help with SQL tra, Astor Rivera |
RE: [xsl] tableheader sort on date , "Braumüller, Hans" | Date | RE: [xsl] gedML VS. the new gedcom , Michael Kay |
Month |