[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: please, help with SQL transformer

Subject: RE: please, help with SQL transformer
From: Jerónimo Molina <j.molina@xxxxxxxxx>
Date: Wed, 10 Apr 2002 09:17:01 +0200
cocoon sql transformer
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:  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:  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

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.