Re: Return value from Oracle Stored Procedure
I can give you a really humble help: try use a get-object instead of
get-string. Maybe your out parameter contains something not interpreted.
A second suggestion: I have struggled with xml content and at the end we've
found in the group that you must do something like this:
esql:execute-query
esql:call{call your stored procedure}/esql:call
esql:call-results
util:include-expr
util:expr
esql:get-object column=7 from-call=true/
/util:expr
/util:include-expr
/esql:call-results
esql:error-results
esql:get-message/
esql:get-stacktrace/
/esql:error-results
/esql:execute-query
This only if your content is xml of course but maybe that's not the case..
- Original Message -
From: Nigel Shrieves
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 3:14 PM
Subject: Return value from Oracle Stored Procedure
Cannot get a return value from the following:
esql:execute-query
esql:call{call iauth_user_process.is_valid_authlogin(
esql:parameter direction=in
type=Stringxsp:exprp_authlogin/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_authpassword/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_clientipaddress/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_secure/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_session/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_siteid/xsp:expr/esql:parameter,
esql:parameter direction=out type=String/)}
/esql:call
esql:call-results
esql:get-string column=7/
/esql:call-results
/esql:execute-query
The error log is:
org.apache.avalon.framework.CascadingRuntimeException: Error getting ascii
data for column 7
Regards
Nigel
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Return value from Oracle Stored Procedure
I can give you a really humble help: try use a get-object instead of
get-string. Maybe your out parameter contains something not interpreted.
A second suggestion: I have struggled with xml content and at the end we've
found in the group that you must do something like this:
esql:execute-query
esql:call{call your stored procedure}/esql:call
esql:call-results
util:include-expr
util:expr
esql:get-object column=7 from-call=true/
/util:expr
/util:include-expr
/esql:call-results
esql:error-results
esql:get-message/
esql:get-stacktrace/
/esql:error-results
/esql:execute-query
This only if your content is xml of course but maybe that's not the case..
- Original Message -
From: Nigel Shrieves
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 3:14 PM
Subject: Return value from Oracle Stored Procedure
Cannot get a return value from the following:
esql:execute-query
esql:call{call iauth_user_process.is_valid_authlogin(
esql:parameter direction=in
type=Stringxsp:exprp_authlogin/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_authpassword/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_clientipaddress/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_secure/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_session/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprp_siteid/xsp:expr/esql:parameter,
esql:parameter direction=out type=String/)}
/esql:call
esql:call-results
esql:get-string column=7/
/esql:call-results
/esql:execute-query
The error log is:
org.apache.avalon.framework.CascadingRuntimeException: Error getting ascii
data for column 7
Regards
Nigel
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: *** proposal to summarise - all, comments please ***
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:05 AM Subject: *** proposal to summarise - all, comments please *** Dear all, as in each and every newsgroup a lot of knowledge is in the flow of these discussions, however - most of the time nothing is really summarised and captured. I would like to propose that once a problem has been solved by the help of different 'brains' that the original poster of this problem posts a summary (which clearly says SUMMARY: in the headline) in which he briefly summarises the problem and the solution that worked for him finally. I totally agree. But I would propose also to write something on cocoon wiky when something so wonderful happens It would be very nice to post this condensed knowledge back to group then and I think it would facilitate finding and retrieval of this knowledge (also in the archives)!! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
cocoon-2.1-dev how to run
For anyone interested in trying cocoon-2.1-dev I discovered that to run it you have to set the variable JETTY_WEBAPP to build/cocoon-2.1-dev/webapp because the default setting (build/webapp) doesn't point to the right location. INSTALL.txt must be fixed. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: The new build system
I suggest you to: read BUILD.txt cp blocks.properties local.blocks.properties cp build.properties local.build.properties [modify the local copies as you like, leaving the original intact] build webapp [this will generate the webapp] build run [this will run jetty] Build failed and I received this error: partOfTheErrorMessage /usr/local/xml-cocoon2/build/cocoon-2.1-dev/blocks/databases/src/org/apache/cocoon/acting/OraAddAction.java:53: package oracle.jdbc does not exist import oracle.jdbc.OracleResultSet; /partOfTheErrorMessage I haven't got Oracle jdbc drivers of course because I don't use them at home. How can I exclude them? Thank you - 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]
Re: Scheduler with cocoon
Xavier RODRIGUEZ wrote: Does anybody know how to make a scheduler that will execute part of a pipeline ... In other word, I would like to execute a generation/transformation/serialization process each day ... I normally use an utility to do a similar job called geturl. It's free and works in windows Does anybody know if a cocoon component exists to do this? There is a way to use cocoon from the command line. Try to search in the group Thanks Xavier - 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]
Cocoon-2.0.4 possible bug in Sql transformer
Cocoon-2.0.4 seems to repeat namespace declaration in the sql:rowset
element resulting from a sql transformation launching a stored procedure.
I have cocoon 2.0.3 and cocoon 2.0.4 side by side on the same machine.
I call an Oracle stored procedure with SQL transformer
With this code:
execute-query xmlns=http://apache.org/cocoon/SQL/2.0;
query lang=1 isstoredprocedure=true
begin dbchem.scheda_xml('1',?,'30060','1',''); end;
/query
out-parameter sql:nr=1 sql:name=resultset2
sql:type=java.sql.Types.CHAR/
/execute-query
And I obtain this
?xml version=1.0 encoding=UTF-8?
content
sql:rowset xmlns:sql=http://apache.org/cocoon/SQL/2.0;
sql:resultset2:
content of the out parameter
/sql:resultset2
/sql:rowset
/content
If I use the same invocation on cocoon 2.0.4
I get this error from the same browser (MSIE):
Duplicate attribute. Line 10, Position 52
rowset xmlns=http://apache.org/cocoon/SQL/2.0;
xmlns=http://apache.org/cocoon/SQL/2.0;resultset2:
---^
My system
- jre
version 1.4.1
java-vendor Sun Microsystems Inc.
- operating-system
name Windows 2000
architecture x86
version 5.0
If you confirm I could compile a bug even if It would be my first.
--
Gabriele Domenichini
[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]
Oracle SP with ESQL an c2 2.0.3
I had this stored procedure running well with SQL Transformer:
query lang=1 isstoredprocedure=true
begin dbchem.scheda_xml('substitute-value sql:name=lingua/',
?,
'substitute-value sql:name=codice/',
'substitute-value sql:name=revisione/',
''); end;
/query
I have to convert it to ESQL because the out parameter is xml.
I've tried everything and the most possible candidate to work is the
following:
esql:execute-query
esql:call
{call dbchem.scheda_xml(
esql:parameter direction=in
type=Stringxsp-request:get-parameter
name=lingua//esql:parameter,
esql:parameter direction=out type=String/,
esql:parameter direction=in
type=Stringxsp-request:get-parameter
name=codice//esql:parameter,
esql:parameter direction=in
type=Stringxsp-request:get-parameter
name=revisione//esql:parameter,
,'0')}
/esql:call
esql:results
esql:call-results
esql:get-xml column=1 from-call=yes/
/esql:call-results
/esql:results
/esql:execute-query
The error is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Exception in ServerPagesGenerator.generate()
Original exception : java.lang.NullPointerException
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.init(EsqlQuery.java:99)
at
org.apache.cocoon.www.scheda_tecnica.oracletestesql_risposta_xml.generate(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\oracletestesql_risposta_xml.java:306)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:258)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:399)
at
org.apache.cocoon.www.scheda_tecnica.sitemap_xmap.matchN400065(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\sitemap_xmap.java:716)
Is there something that I could try?
Should I upgrade to cocoon 2.0.4?
Thank you anyway
--
Gabriele Domenichini
[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]
Re: Pleeese! retrieving xml code as out-parameter
I began to switch but it doesn't seem to work.
Here is my procedure how it was written for the sql transformer
execute-query xmlns=http://apache.org/cocoon/SQL/2.0;
query lang=1 isstoredprocedure=true
begin dbchem.scheda_xml('substitute-value sql:name=lingua/'
,?
,'substitute-value sql:name=codice/'
,'substitute-value sql:name=revisione/'
,''); end;
/query
out-parameter sql:nr=1 sql:name=resultset2
sql:type=java.sql.Types.CHAR/
/execute-query
Here is what I've written in xsp / Esql:
esql:execute-query
esql:call
{call procedure.tds_xml(esql:parameter direction=in
type=Stringxsp-request:get-parameter name=lingua//esql:parameter,
esql:parameter direction=out type=String/,
esql:parameter direction=in
type=Stringxsp-request:get-parameter
name=codice//esql:parameter,esql:parameter direction=in
type=Stringxsp-request:get-parameter name=revisione//esql:parameter)}
/esql:call
esql:results
output
esql:call-results
esql:get-string column=1 from-call=yes/
/esql:call-results
/output
/esql:results
/esql:execute-query
And this is the error I get:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Exception in ServerPagesGenerator.generate()
More precisely:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.NullPointerException
The full exception stack trace says something like:
Original exception : java.lang.NullPointerException
at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:270)
at
oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray(TTCAdapter.java:256)
at
oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet(TTCAdapter.java:231)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1363)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1602)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1527)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2045)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:446)
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute(EsqlQuery.java:362)
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute(EsqlQuery.java:336)
at
org.apache.cocoon.www.scheda_tecnica.oracletestesql_risposta_xml.generate(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\oracletestesql_risposta_xml.java:414)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:258)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:399)
at
org.apache.cocoon.www.scheda_tecnica.sitemap_xmap.matchN400065(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\sitemap_xmap.java:716)
Thank you
On Fri, 06 Dec 2002 12:52:37 +0200, Gabriele Domenichini
[EMAIL PROTECTED] said:
Thank you so much.
I'll began the switching. If in the mean time a solution is found I'd
prefere to use the sql transformer.
On Fri, 6 Dec 2002 11:38:22 +0100, Christian Haul
[EMAIL PROTECTED] said:
On 06.Dec.2002 -- 12:19 PM, Gabriele Domenichini wrote:
I need to retrieve xml data from Oracle database as an out-parameter. The
stored procedure works but the output is like this:
lt;rootElementgt;
lt;elementgt;
Something written
lt;/elementgt;
lt;/rootElementgt;
I think that SQL Transformer convert and signs in entities. I
need desperately to have my code back. Please help me
No idea how to achieve this with the transformer, but with esql you
could use esql:get-xml for this (or enclose a get-string with
util:include-expr).
Switching to XSP would surely have a major impact but since you are
desparate
I believe there has just been a similar thread, so have a look at the
archives.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
-
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]
--
Gabriele Domenichini
[EMAIL PROTECTED
Re: SQL query cannot be read.
Don't Know try to use the same namespace qualifiers (sql:)...
Jin Wei Yong wrote:
Hi,
I am still exploring the use of SQLTranformer. I am
using a book, Cocoon:Building XML Application by
Matthew Langham and Carsten Ziegeler. If you have the
book, you can refer to Chapter 7. The this SQL-related
example does not use XSP at all. The query is written
in the xsl file.
In the example, I use subsitemap, which is the only
difference from Langham's example.
I write the following in the xsl file:
user
execute-query
xmlns=http://apache.org.cocoon/SQL/2.0;
use-connectionpersonnel/use-connection
query
INSERT INTO DEPARTMENT_TABLE VALUES(18,'jinwei2')
/query
/execute-query
user
however, the SQL statement cannot be executed.
When I check the Cocoon.log file, Langham's example is
as follows:
/JaxpParser: Looking up
org.apache.cocoon.components.resolver.Resolver
/JaxpParser: SAXParserFactory: null
/JaxpParser: DocumentBuilderFactory: null
/JaxpParser: SAXParser: null
/SQLTransformer: PUBLIC ID: null
/SQLTransformer: SYSTEM ID:
file:/C:/jakarta-tomcat-3.3a/webapps/cocoon/sqlexample.xml
/SQLTransformer: RECEIVED CHARACTERS:
/SQLTransformer: RECEIVED START ELEMENT execute-query
/SQLTransformer: RECEIVED CHARACTERS:
/SQLTransformer: RECEIVED START ELEMENT use-connection
/SQLTransformer: RECEIVED CHARACTERS: personnel
/SQLTransformer: RECEIVED END ELEMENT
use-connection(http://apache.org/cocoon/SQL/2.0)
/SQLTransformer: SETTING VALUE ELEMENT name
{use-connection} value {personnel}
/SQLTransformer: RECEIVED CHARACTERS:
/SQLTransformer: RECEIVED START ELEMENT query
/SQLTransformer: RECEIVED CHARACTERS:
INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
/SQLTransformer: RECEIVED END ELEMENT
query(http://apache.org/cocoon/SQL/2.0)
/SQLTransformer: QUERY IS
INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
/SQLTransformer: RECEIVED CHARACTERS:
/SQLTransformer: RECEIVED END ELEMENT
execute-query(http://apache.org/cocoon/SQL/2.0)
/SQLTransformer: SQLTransformer executing query nr 0
/SQLTransformer$Query: EXECUTING
INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
/DefaultPool: Retrieving a
org.apache.avalon.excalibur.datasource.JdbcConnection
from the pool
whereas my log is something like:
JaxpParser: Looking up
org.apache.cocoon.components.resolver.Resolver
/JaxpParser: SAXParserFactory: null
/JaxpParser: DocumentBuilderFactory: null
/JaxpParser: SAXParser: null
/SQLTransformer: RECEIVED CHARACTERS: personnel
/SQLTransformer: RECEIVED CHARACTERS:
INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
/URLFactoryImpl: Making URL from
file:/C:/jakarta-tomcat-3.3a/webapps/cocoon/boac/stylesheets/../documents/toc.xml
/URLFactoryImpl: Making URL from
file:/C:/jakarta-tomcat-3.3a/webapps/cocoon/boac/stylesheets/../documents/toc.xml
/DefaultComponentFactory: ComponentFactory
decommissioning instance of
org.apache.cocoon.components.parser.JaxpParser.
/DefaultPool: Returning a
org.apache.cocoon.components.sax.XMLByteStreamCompiler
to the pool
/CachingEventPipeline: Recycling of
CachingEventPipeline
/DefaultPool: Returning a
org.apache.cocoon.generation.FileGenerator to the pool
One thing to note is that the start/end elements are
not being read. Have I missed out anything in the
configuration?
Thanks very much.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
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]
Re: xinclude support or not?
Of course you have to had the xinclude trasformer in the map... Joerg Heinicke wrote: Should work without any problem. Did you declare the namespace prefix xi? How does your sitemap matcher look like? Joerg Cocoon User wrote: is there any working example under cocoon i try to use xinclude inside an .xsp but without success my code quotation xi:include href=source.xml / /quotation is somethingi have missed or just there is no xinclude support from cocoon? thnx Stavros Kounis - 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]
Pleeese! retrieving xml code as out-parameter
I need to retrieve xml data from Oracle database as an out-parameter. The stored procedure works but the output is like this: lt;rootElementgt; lt;elementgt; Something written lt;/elementgt; lt;/rootElementgt; I think that SQL Transformer convert and signs in entities. I need desperately to have my code back. Please help me Gabriele Domenichini -- Gabriele Domenichini [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]
Re: Pleeese! retrieving xml code as out-parameter
Thank you so much. I'll began the switching. If in the mean time a solution is found I'd prefere to use the sql transformer. On Fri, 6 Dec 2002 11:38:22 +0100, Christian Haul [EMAIL PROTECTED] said: On 06.Dec.2002 -- 12:19 PM, Gabriele Domenichini wrote: I need to retrieve xml data from Oracle database as an out-parameter. The stored procedure works but the output is like this: lt;rootElementgt; lt;elementgt; Something written lt;/elementgt; lt;/rootElementgt; I think that SQL Transformer convert and signs in entities. I need desperately to have my code back. Please help me No idea how to achieve this with the transformer, but with esql you could use esql:get-xml for this (or enclose a get-string with util:include-expr). Switching to XSP would surely have a major impact but since you are desparate I believe there has just been a similar thread, so have a look at the archives. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 - 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] -- Gabriele Domenichini [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]
MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections
Are you wondering how to connect Cocoon to your database and you have got one of theese?: * As400 http://outerthought.net/wiki/Wiki.jsp?page=As400 * BasisPlus http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus * Oracle http://outerthought.net/wiki/Wiki.jsp?page=Oracle * PostgreSQL http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL * MsSQL http://outerthought.net/wiki/Wiki.jsp?page=MsSQL * MySQL http://outerthought.net/wiki/Wiki.jsp?page=MySQL Then go to http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection Thanks to the tribute from people who had your same problem, you can now follow instructions on: - Where to find the right drivers - Which class to load for connection - Tips and tricks specific of each database. Please go there and contribute using the page and writing into it. Now we can improve the mini-site: - Restructuring it using the official documentation for the parts that are common to all the DBs and Cocoon specific - Going deeply describing success cases with complicated query or stored procedures - Enlargeing the number of DBs. - Asking for inserting the best part of the initiative in the official Covcoon documentation Please support - 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]
Re: Microsoft SQLserver with cocoon
Thanks all, Please please contribute to the page on specific database connections on wiki. It's pretty simple: 1. go to http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection 2. see what others like you have done. Copy one of them in a new page you create 3. Adapt it to the specifity of Ms SQL connection and add tips that you have learned If someone had done it before, Maxime wouldn't have needed to ask for the solution to the group. Christopher Watson wrote: 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-nameload-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/ dburljdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydatabase /dburl usersa/user passwordmypassword/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:poolmy_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_elementesql:get-string column=myfield1//my_column_one_element my_column_two_elementesql:get-string column=myfield2//my_column_two_element /my_row_element /esql:row-results /esql:results esql:no-results no-resultsno-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] - 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]
Re: Parsing XML from SQL
Your problem is not simple. If I've understood you have resources record made like this: something.jpg | somewhere/somethingelse.mov | resourceFound.txt | Well if this is the point, I think the best way to act is to make some xslt transformation after the sql transformation. I don't have experiences about parsing text but I think the text generator do such a thing. If you have to make estraction and elaboration before aggregation I would use cinclude instead xinclude. The main difference between the is the two is the possibility of cinclude to invoke a specific pipeline (so a transformation) as source with the protocol cocoon:/. I find this very powerfull even if a little proprietary ;-) I agree with the orientation of avoiding esql where possible, and I think that here it doesn't help a lot Sorry if I'm not specific but I should know the project and even so it would take me time. I hope to have been useful somehow Jeremy Quinn wrote: Dear All We are using the SQLTransformer for a project. Our SQL Database contains a Table called Resource, which keeps information about the resources in our archive. Most of these resources are binary, ie. .gif, .jpg, .swf, .mov etc. So we merely 'embed' the resource reference in the page produced by a Resource record, to show it on the page. We now find we have a few 'text' resources, that require a bit of markup in them, mainly just paragraphs. We either need to XInclude the resource into the pipeline from an XML file referred to in the SQL, or keep the actual resource in the SQL and parse it as it comes out. I know that it is possible to parse SQL fields via the ESQL TagLib, but we prefer the Transformer approach. Does anyone know if it is possible to Parse fields extracted from SQL via the SQLTransformer? Thanks for any suggestions. regards Jeremy - 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]
Re: Cocoon Portal Sample ..It works!!!!
For all the interested. I have updated cocoon from the cvs today and it works!! I have started it I have removed from $COCOON_HOME/WEB-INF/lib the duplicated Xalan.jar and xercesImpl.jar I have moved from $COCOON_HOME/WEB-INF to $TOMCAT_HOME/common/endorsed libxalan-2.4.1.jar xercesImpl-2.1.0.jar xercesImpl.jar xml-apis.jar - 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]
Re: Cocoon Cobundle ? Please!
Please believe me when I say that: yes. Often happens that cocoon doesn't work the first time but normally it's a question of restarting all over on a new machine. If you cannot use a new machine at least delete the cache directory $TOMCAT_HOME/work/Standalone/localhost/cocoon ** and of course $TOMCAT_HOME/webapps/cocoon before restarting it with the new .war file in the webapps directory Christian Kissner wrote: Hi, this is a plea, from an experienced developer, to bundle working versions of cocoon with servlet engines. Just Tomcat would be enough. This is my story: 2 years ago I came across cocoon, liked the concept, and developed a cocoon-1.8 based application - see www.efonds24.de Every 3-5 months since then I start thinking along the similar lines and try to install cocoon 2.x on Jboss, Tomcat or whatever and notice IT DOES NOT WORK. I go back to the web site, read the parts about installing and replacing the XML parser, try that and find that IT STILL DOES NOT WORK I then guess, the tomcat/jboss/whatever codebase may have moved on or maybe the cocoon codebase moved on or my JDK ist out of date and maybe the documentation on the web site has not yet caught on. So I go back, read the mailing lists and fetch the latest releases, compile, fix and reinstall and find that ***NONE OF IT WORKS *** Now I may be a dumb idiot or simply out of luck, but I always think: HOW SAD... cocoon is great technology, but it would have much wider distribution if they could ease deployment and +--+ |JUST BUNDLE WORKING VERSIONS TOGETHER.| +--+ thanks for listening. - 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]
Re: Cocoon Portal Sample - Failed to execute pipeline error
On Thu, 21 Nov 2002 15:14:52 +, Jeremy Quinn [EMAIL PROTECTED] said: On Thursday, Nov 21, 2002, at 14:59 Europe/London, Carsten Ziegeler wrote: Sorry to say this - I am glad you did ;) but I just did a clean checkout and build the webapp with JKD 1.4 and run this with JDK 1.4 and Tomcat 3.3 using w2k - and what should I say: without any problems. Maybe could be a problem of Tomcat server version? I use Apache Tomcat/4.1.12 What do you think about it? Is there someone that use correctly the cocoon portal sample with this or similar version of Tomcat?? -- Gabriele Domenichini [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]
Re: cocoon to oracle ?
On Thu, 14 Nov 2002 17:17:37 +0530, Dhiman Paul [EMAIL PROTECTED] said: Dear All, Is it possible to communicate with oracle via cocoon ? Please say me the way to do that ? I'm very proud to say that: 1) I do it at work 2) Is simple 3) I have created a wiki page on specific database connection on which wonderful people has contributed 4) There is a section where everything useful about Oracle (we hope) is explained http://outerthought.net/wiki/Wiki.jsp?page=Oracle -- Gabriele Domenichini [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]
Re: Cocoon Portal Sample - Failed to execute pipeline error
Sorry this is not a solution/suggestion but I want to point out that the same happen with the cvs version Franck Lumpe wrote: Hello everyone, I use JDK 1.4.1 + Tomcat 4.1.12 + Cocoon 2.1 DEV Updated Head CVS on Windows 2000. Cocoon seems to be using the correct versions of Xerces, Xalan and XML-Api (from the Tomcat endorsed directory). Samples are running quite nicely :-) except for: 1) The XMLForm-sample error already reported by Wolfram. 2) The Portal Framework Sample: I get an error 500 with - 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]
Specific Database Connection Documentation added
I have added on cocoon wiki a document on specific database connection with cocoon. IMHO the official documentation is poor about: - where to find the jdbc driver for a specific database (oracle, AS400, PostgreSQL,...) - How the driver is called - The connection's class name - The tricky things to do for a specific database I have begun with IBM AS400 or Iseries (a well known database in italy). The performances are astonishing! A lot of work has to be done think about theese database: - Oracle - PostgreSQL - Microsoft SQL Server - My SQL - Access - IBM DB2 -... Please contribute and comments are welcome http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection - 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]
Re: Help wanted: Cocoon documentation tracks!
Alle 15:31, lunedì 14 ottobre 2002, Bertrand Delacretaz ha scritto: added sql track. comments are welcome (cross-posted to -dev and -user, we need you too!) IMHO adding tracks to the Cocoon documentation could make it much more useful, by providing several reading lists targeted to the various uses of Cocoon. Please see http://outerthought.net/wiki/Wiki.jsp?page=DocumentationTracksProject about how you can easily contribute to this. This needs input from different users/developers/documenters so that each track can be specific, short and useful. - 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]
Proposal: Documentation about database connection
What about setting up a page with the configurations needed to connect cocoon to the various database ? There is already something but is distributed among web pages, cocoon official documentation, mailing lists, etc... I was thinking about a page in which for any commercial or open source databases is written: * where to find jdbc drivers * how to modify the configuration filles * notes about personal experiences Example: Oracle: 1. download the drivers from .. 2. the jar you need to add to the cocoon\web-inf\lib is ... (Idon't remember sorry) 3. web.xml: add the following lines. 4. cocoon.xconf: add the following lines. 5. sitemap.xmp: add lines like the following Notes:.. IBM As400: 1. download the drivers from .. 2. the jar you need to add to the cocoon\web-inf\lib is ... (Idon't remember sorry) 3. web.xml: add the following lines. 4. cocoon.xconf: add the following lines. 5. sitemap.xmp: add lines like the following I could do it for theese database and the ideal page is on cocoon wiky. If you give me suggestion on where to put it and the mailing list can contribute I can start the page - 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]
Re: saxon as default transformer + xalan also available?
Alle 21:54, mercoledì 9 ottobre 2002, gv ha scritto: Hello, Because of some quirks in both Saxon Xalan, I would like to set Saxon to be my default XSLT transformer, then add Xalan to be available when I need it (in the sitemap: map:transformer type=xslt-xalan...) I've done exactly the opposite (xalan the default and saxon as an option (in the sitemap: map:transformer type=xslt-Saxon...). If this can give you an help I've put it on cocoon wiky: http://outerthought.net/wiki/Wiki.jsp?page=DocbookTransformation - 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]
Re: Cocoon 2, Docbook and Norman Walsh's Stylesheets
Alle 12:38, lunedì 30 settembre 2002, Diana Shannon ha scritto: I have succeded in transforming Docbook to pdf and to html on cocoon 2.0.3 using the stylesheet by Norman Walsh on the official docbook repository (http://docbook.sourceforge.net/projects/xsl/index.html). Cocoon has some weakness in doing this and I spent 15 days to make it Thanks Gabriele! I know you already spent a lot of time on this issue, but (please, please) how about contributing a patch (snippet) of this doc for the cocoon cvs/web site or perhaps adding it to CocoonWiki? -- Diana No. I thank you and all the people who has answered to the mail and I'll try to set it up as soon as I can. if not tonight (now for me it's 8 pm) maybe tomorrow morning. Just please go on also making critics and I' ltake them in consideration in writing the snippet. - 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]
Re: Cocoon 2, Docbook and Norman Walsh's Stylesheets
Alle 15:35, lunedì 30 settembre 2002, Vadim Gritsenko ha scritto: Gabriele, Some comments. 1. Saxon does *not* support incremental processing, thus: parameter name=incremental-processing value=false/ effectively does nothing. Thank you, I didn't know 2. Saxon works with XSP. I do have an app with Saxon only (no Xalan) and XSPs. Never had any problem. The only problem is you still need Xalan.jar if you are using XPath component. I do have Xalan.jar in my classpath and I get error if don't say in the sitemap to use it instead of saxon. 3. I might be mistaken, but I do not see why Saxon needs to be modified. Cocoon by default will use Xerces parser, not Aelfred, and from Saxon only XSLT engine will be used. I read this information on http://sources.redhat.com/ml/docbook-apps/2002-q2/msg00397.html and after the modification it works. It could be a question of versioning. I use cocoon 2.0.3 Saxon 6.5.2 and xalan 2.4.0. Anyway I'm trying to write a snippet and I'll report your observations. - 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]
Re: Cocoon 2, Docbook and Norman Walsh's Stylesheets
Alle 12:38, lunedì 30 settembre 2002, Diana Shannon ha scritto: .. I know you already spent a lot of time on this issue, but (please, please) how about contributing a patch (snippet) of this doc for the cocoon cvs/web site or perhaps adding it to CocoonWiki? Added snippett in cocoonWiki. I will correct it tomorrow. Everyone is invited to modify it. I'm preparing the snippet to send to apache.org by bugzilla. Thanks again Gabriele Domenichini - 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]
Cocoon 2, Docbook and Norman Walsh's Stylesheets
I have succeded in transforming Docbook to pdf and to html on cocoon 2.0.3
using the stylesheet by Norman Walsh on the official docbook repository
(http://docbook.sourceforge.net/projects/xsl/index.html).
Cocoon has some weakness in doing this and I spent 15 days to make it work
properly, so if you want save some time and you want to do something similar
you are interested in this mail.
What I learned is that:
1. While xalan can do docbook transformation to xslfo correctly from the
command line, on cocoon it can't.
2. If you use Saxon instead of xalan the transformation is almost successful
but not completly: ie. I lost all the sect1/title.
3. If you use Saxon you loose all the xsp capabilities in cocoon (I want to
make sql transformation with as400 and Oracle)
4. Incremental processing is not suggested for docbook to pdf transformation
The solutions I have found to this problems thanks to all I have read on the
mailing lists and on the official site is:
1. Setting up cocoon to use xalan and saxon in alternative (defult: xalan) and
set incremental processing to false in Saxon
2. Renaming saxon.jar to z-saxon.jar (I am not sure if is necessary but in
this way works)
3. Modifying Saxon to make it use the parser xerces instead of aelfred
Let'see theese points in detail
1. Setting up cocoon to use xalan and saxon in alternative (defult: xalan) and
set incremental processing to false in Saxon.
To do this:
1.1 Put saxon652.jar WEB-INF/lib ( in the cocoon directory of course)
1.2 Here are extracts of what you have to add in cocoon.xconf and
sitemap.xmap:
# cocoon.xconf
component
role=org.apache.cocoon.components.xslt.XSLTProcessor/Saxon
class=org.apache.cocoon.components.xslt.XSLTProcessorImpl
logger=core.xslt-processor
parameter name=use-store value=true/
parameter name=incremental-processing value=false/
parameter name=transformer-factory
value=com.icl.saxon.TransformerFactoryImpl/
/component
# sitemap.xmap
map:transformer name=xslt-saxon pool-grow=2 pool-max=32 pool-min=8
src=org.apache.cocoon.transformation.TraxTransformer
use-request-parametersfalse/use-request-parameters
use-browser-capabilities-dbfalse/use-browser-capabilities-db
xslt-processor-roleorg.apache.cocoon.components.xslt.XSLTProcessor/Saxon/xslt-processor-role
/map:transformer
/citationFromAMail.SeeTheReferences
in yor pipeline when you do a transformation from docbook to pdf you will use
something similar:
map:match pattern=*.pdf
map:generate src={1}.docbook/
map:tranform type=xslt-saxon src=WhereverYouPutIt/fo/docbook.xsl/
map:serialize type=fo2pdf/
/map:match
map:match pattern=*.html
map:generate src={1}.docbook/
map:tranform type=xslt-saxon src=WhereverYouPutIt/html/docbook.xsl/
map:serialize type=fo2pdf/
/map:match
In this way if you will leave xslt as the default type of transformation, you
will use use xalan and all his xsp capabilities for all the the other cocoon
functions.
2. Renaming saxon.jar z-saxon.jar (I am not sure that is necessary but in this
way works)
3. Modifying Saxon to make it use xerces instead of aelfred as parser
Change the content of
META-INF/services/javax.xml.parsers.SAXParserFactory from
com.icl.saxon.aelfred.SAXParserFactoryImpl to
org.apache.xerces.jaxp.SAXParserFactoryImpl. That tells
Saxon to use xerces instead of aelfred as parser.
Don't be worried it is not so complicated: you have to extract the file
(javax.xml.parsers.SAXParserFactory) from saxon.jar edit it (is a text file)
and to put it again in the same place in saxon.jar
Conclusion:
I must say that the Saxon and xalan problems in using Norman Walsh's
stylesheets should be addressed inside cocoon developing activity. It
shouldn't be so hard to make docbook to pdf transformation work.
Comments are welcome.
Gabriele Domenichini
References:
To use different xslt processors or different behaviour of the same:
http://xml.apache.org/cocoon/snippet/snippet-xslt-options.html
To use saxon in alternative the mail from which I took the solution is:
(http://www.mail-archive.com/cocoon-users@xml.apache.org/msg15968.html) which
tell exactly what to do:
To change the behavior of saxon there's a mail
(http://sources.redhat.com/ml/docbook-apps/2002-q2/msg00397.html) which
explain three workaround. I have choosen the third
-
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]
C2 2.0.3 docbook pdf transformation problem
Please tell me if I'm wrong but I think there is something wrong in cocoon transformation with Norman Walsh Docbook Stylesheet. I have tried wiith xalan and it transform perfectly from the commandline but When you use the actual version in cocoon it produces wrong xmlfo (it doesn't even close the markup!). I have tried with Saxon and it produces the pdf but without the title of the sect1 (sect1/title). I have done many experiments one of which is to turn incremental processing off and it doesn't seem to help. Has somebody the same problem? I begin to think that is a matter of cocoon version. OS: windows NT 4.0 SP5 Tomcat: 4.0.4 cocoon 2.0.3 Xalan 2.4.0 | saxon 6.5.2 - 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]
R: the problem of nbsp
The correct way of manageing %nbsp and the other entity is in an article at www.xml.com. You can try with the search function, searching for unparsed entities or something similar -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Inviato: lunedì 4 giugno 2001 19.13 A: [EMAIL PROTECTED] Oggetto: the problem of nbsp hi, I use the nbsp; to define a empty roll or column, but it result a error(The entity nbsp was referenced, but not declared) when the xsl is parsed. May I know how to solve this problem ? Thank you. Kok Choon E-mail: [EMAIL PROTECTED] Date: 06/05/01 Time: 01:12:52 This message was sent by Z-Mail Pro - from NetManage NetManage - delivers Standards Based IntraNet Solutions - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
