You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by "Ignacio J. Ortega" <na...@siapi.es> on 2001/08/01 08:16:36 UTC
[C2][PATCH] Making SQLTranformer with Interbase 1.6 JDBC Drivers
Hola a Todos:
Got some time to do it ..
This patch adds a Sitemap.xmap component config for SQLtransformer ..
called <old-driver/> ( bad name change it as you like ) setting this
element to true makes SQLtranformer to use the old fashioned
conn.prepareStatement(query); instead the of the JDBC2 ones..
In addition when <old-driver/> is true the rowcount is not calculated
and uses a -1 value instead the number of rows.. This something hard but
was the only solution i found to make SQLtransformer accept the nr-rows
parameter without producing and NonImplemented Exception..
With this 3 changes SQLtransformer will work fine with the interbase
JDBC 1.6 drivers..
Some more comment on excalibur pool and Interbase ..
It seems that the beacon SQL command that excalibur uses to test
connections is failing in interbase because of the ";" included.. but
found some workaround for that problem .. was to use the oradb="true"
attribute when creating the pool in cocoon.xconf and then create a
"DUAL" table in Interbase with 1 row ( to simulate the DUAL oracle table
).. with this 2 measures the excalibur pool works well with interbase..
perhaps this need some clarification or is meat for the faq of Avalon.
Thanks..
Saludos ,
Ignacio J. Ortega
Re: Patch to HttpEnvironment.java
Posted by Christian Schmitt <cs...@ffzj0ia9.bank.dresdner.net>.
Vadim,
hmmm, I must have missed a couple of weeks of updates :-(
Somehow my version of HttpEnvironment.java is waaaaaaay old and qs
has been removed for some weeks now.
Sorry for the unnecessary traffic.
Christian
On Wed, Aug 01, 2001 at 09:47:37AM -0400, Vadim Gritsenko wrote:
> I can't find where "qs" is defined. May be you missed something?
>
> Vadim
>
> > -----Original Message-----
> > From: Christian Schmitt [mailto:cs@ffzj0ia9.bank.dresdner.net]
> > Sent: Wednesday, August 01, 2001 9:27 AM
> > To: 'cocoon-dev@xml.apache.org'
> > Subject: Patch to HttpEnvironment.java
> >
> >
> > Hi y'all,
> > for reasons beyond my control I have to do something like this in
> > the sitemap:
> >
> > <map:match pattern="somewhere.xsp">
> > <map:redirect-to url="somewhere-else.xsp?param2=value2"/>
> > </map:match>
> >
> > Now, I know it's ugly, but I can't do anything about it right now.
> >
> > So, that brings me to the point...
> > When there were already CGI parameters present in the original
> > requested URL (e.g. somewhere.xsp?param1=value1) the new
> > parameter (param2=value2) is appended using the "?" character.
> > This produces an incorrect URL in the form of:
> >
> > somewhere-else.xsp?param1=value1?param2=value2
> >
> > The second question mark should be an ampersand (&).
> >
> > Now, attached is a patch to HttpEnvironment.java that should do
> > the trick. If someon with commit rights thinks it's worthy, please
> > check it in.
> >
> > Thanks,
> > Christian Schmitt
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
RE: Patch to HttpEnvironment.java
Posted by Vadim Gritsenko <va...@ionidea.com>.
I can't find where "qs" is defined. May be you missed something?
Vadim
> -----Original Message-----
> From: Christian Schmitt [mailto:cs@ffzj0ia9.bank.dresdner.net]
> Sent: Wednesday, August 01, 2001 9:27 AM
> To: 'cocoon-dev@xml.apache.org'
> Subject: Patch to HttpEnvironment.java
>
>
> Hi y'all,
> for reasons beyond my control I have to do something like this in
> the sitemap:
>
> <map:match pattern="somewhere.xsp">
> <map:redirect-to url="somewhere-else.xsp?param2=value2"/>
> </map:match>
>
> Now, I know it's ugly, but I can't do anything about it right now.
>
> So, that brings me to the point...
> When there were already CGI parameters present in the original
> requested URL (e.g. somewhere.xsp?param1=value1) the new
> parameter (param2=value2) is appended using the "?" character.
> This produces an incorrect URL in the form of:
>
> somewhere-else.xsp?param1=value1?param2=value2
>
> The second question mark should be an ampersand (&).
>
> Now, attached is a patch to HttpEnvironment.java that should do
> the trick. If someon with commit rights thinks it's worthy, please
> check it in.
>
> Thanks,
> Christian Schmitt
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Patch to HttpEnvironment.java
Posted by Christian Schmitt <cs...@ffzj0ia9.bank.dresdner.net>.
Hi y'all,
for reasons beyond my control I have to do something like this in
the sitemap:
<map:match pattern="somewhere.xsp">
<map:redirect-to url="somewhere-else.xsp?param2=value2"/>
</map:match>
Now, I know it's ugly, but I can't do anything about it right now.
So, that brings me to the point...
When there were already CGI parameters present in the original
requested URL (e.g. somewhere.xsp?param1=value1) the new
parameter (param2=value2) is appended using the "?" character.
This produces an incorrect URL in the form of:
somewhere-else.xsp?param1=value1?param2=value2
The second question mark should be an ampersand (&).
Now, attached is a patch to HttpEnvironment.java that should do
the trick. If someon with commit rights thinks it's worthy, please
check it in.
Thanks,
Christian Schmitt