Re: esql not working at all, no connection ever created!
I think it was there in his original posting. -Christopher |-+-- | | Christian Haul | | | [EMAIL PROTECTED]| | | rmstadt.de| | | | | | 04/02/2003 02:52 AM| | | Please respond to | | | cocoon-users | | | | |-+-- --| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: esql not working at all, no connection ever created! | --| On 01.Apr.2003 -- 01:48 PM, Christopher Painter-Wakefield wrote: Is this the whole XSP program? If so, the problem is that you don't have the required single non-xsp child node of xsp:page. E.g., you have: xsp:page ... esql:connection ... /esql:connection /xsp:page but you need to have: xsp:page ... some-node esql:connection ... /esql:connection /some-node /xsp:page If that isn't the problem, write back and we'll try something else. Another one is the missing esql:execute-query tag. 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: esql not working at all, no connection ever created!
Perhaps this message is inappropriate for this
mailing list,
but what I want to say is that I wonder why people
would
participate without showing their real names, but
instead
conceal their identity by means of fake yahoo or
hotmail
addresses.
I joined recently, so maybe this has always been a
common
practice anyway.
I think there are occasions whenconcealing
the identityis
appropriate, but this mailing list is composed of frank,
honest and motivated individuals that give their best to
advance technology.
In my opinion, not showing the real name is a lack
of
respect to the rest of the participants, especially
those
that have consistently given their
best.
Again, sorry for this e-mail not beingabout
Cocoon...
Thanks for your attention.
Julio Lerm
(Yes, that's my real name, and I am not ashamed
or
affraid of showing it...)
- Original Message -
From:
Not
Available
To: [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 12:28
PM
Subject: Re: esql not working at all, no
connection ever created!
Here is my xsp code:
xsp:page language="java" xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
esql:connectionesql:pooldb_pool/esql:pool
esql:execute-queryesql:queryselect
* from
antiques/esql:query
esql:results
esql:row-results
esql:get-int
column="id"/
esql:get-string
column="name"/
/esql:row-results
/esql:results
/esql:execute-query/esql:connection/xsp:page
Here is my web.xml:
init-param
param-nameload-class/param-name
param-value !-- For
IBM WebSphere:
com.ibm.servlet.classloader.Handler --
!-- For Database Driver:
--
org.hsqldb.jdbcDrivercom.mysql.jdbc.Driver
!-- For parent ComponentManager
sample:
org.apache.cocoon.samples.parentcm.Configurator
--
/param-value /init-param
Here is my cocoon.config:
jdbc name="antiques"
pool-controller min="5" max="10"/
dburljdbc:mysql://localhost/databasename?autoReconnect=true/dburl
usermyusername/user
passwordmypassword/password /jdbc
Here is my pipeline for testing:
map:pipelinemap:match
pattern="content/*.xml"map:generate
type="xsp"
src=""/map:serialize
type="xml"//map:match/map:pipeline
Thanks again
Christopher Painter-Wakefield
[EMAIL PROTECTED] wrote:
Please
post your xsp code, or at least the portion with esql in it. Veryhard to
help,
otherwise.-Christopher|-+|
| Not Available || | <[EMAIL PROTECTED]|| | hoo.com || |
|| | 04/01/2003 03:47 || | AM || | Please respond to|| |
cocoon-users || |
||-+--||
|| To: [EMAIL PROTECTED] || cc: || Subject: esql not
working at all, no connection ever created!
|--|I
have been trying to get esql to work now for about 3 days with no luck.
Ibeleive i have configured everything correctly but when I run any xsp
pagewith esql it returns a duplicated page of my xsp page except that it
stopsat the esql:connection tag. When I look at the error log it says
there wasa null pointer exception. After examining the generated java
file I thinkit is because a connection object is always null (never set
to a validconnection). However I am pretty confident my pool is set up
correctly andthe drivers are being loaded ok.Here is the
code that it points to in the java file:_esql_query = new
EsqlQuery( _esql_connection, String.valueOf(""+ " select *
from antiques "+ " ") );No where above this code is the
_esql_connection every initialized with aconnection.I am
using the latest release for java 1.4.1 and running windows me
withmysql.Thanks,Kris-To
unsubscribe, e-mail: [EMAIL PROTECTED] pache.or gFor
additional commands, e-mail: [EMAIL PROTECTED]
Do you Yahoo!?Yahoo! Tax
Center - File online, calculators, forms, and
more
Re: esql not working at all, no connection ever created!
Is this the whole XSP program? If so, the problem is that you don't have
the required single non-xsp child node of xsp:page. E.g., you have:
xsp:page ...
esql:connection
...
/esql:connection
/xsp:page
but you need to have:
xsp:page ...
some-node
esql:connection
...
/esql:connection
/some-node
/xsp:page
If that isn't the problem, write back and we'll try something else.
-Christopher
|-+
| | Not Available|
| | [EMAIL PROTECTED]|
| | hoo.com |
| ||
| | 04/01/2003 01:28 |
| | PM |
| | Please respond to|
| | cocoon-users |
| ||
|-+
--|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: esql not working at all, no connection ever created!
|
--|
Here is my xsp code:
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
esql:connection
esql:pooldb_pool/esql:pool
esql:execute-query
esql:query
select * from antiques
/esql:query
esql:results
esql:row-results
esql:get-int column=id/
esql:get-string column=name/
n! bsp;/esql:row-results
/esql:results
/esql:execute-query
/esql:connection
/xsp:page
Here is my web.xml:
init-param
param-nameload-class/param-name
param-value
!-- For IBM WebSphere:
com.ibm.servlet.classloader.Handler --
!-- For Database Driver: --
org.hsqldb.jdbcDriver
com.mysql.jdbc.Driver
!-- For parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator
--
/param-value
/init-param
Here is my cocoon.config:
jdbc name=antiques
pool-controller min=5 max=10/
dburljdbc:mysql://localhost/databasename?autoReconnect=true/dburl
usermyusername/user
passwordmypassword/password
/jdbc
Here is my pipeline for testing:
map:pipeline
map:match pattern=content/*.xml
map:generate type=xsp src=content/{1}.xsp/
map:serialize type=xml/
/map:match
/map:pipeline
Thanks again
Christopher Painter-Wakefield [EMAIL PROTECTED] wrote:
Please post your xsp code, or at least the portion with esql in it. Very
hard to help, otherwise.
-Christopher
|-+
| | Not Available |
| | | | hoo.com |
| | |
| | 04/01/2003 03:47 |
| | AM |
| | Please respond to|
| | cocoon-users |
| | |
|-+
--|
| |
| To: [EMAIL PROTECTED] |
| cc: |
| Subject: esql not working at all, no connection ever created! |
--|
I have been trying to get esql to work now for about 3 days with no luck.
I
beleive i have configured ever! ything correctly but when I run any xsp
page
with esql it returns a duplicated page of my xsp page except that it stops
at the esql:connection tag. When I look at the error log it says there was
a null pointer exception. After examining the generated java file I think
it is because a connection object is always null (never set to a valid
connection). However I am pretty confident my pool is set up correctly and
the drivers are being loaded ok.
Here is the code that it points to in the java file:
_esql_query = new EsqlQuery( _esql_connection, String.valueOf(
+ select * from antiques
+
) );
No where above this code is the _esql_connection every initialized with a
connection.
I am using the latest release for java 1.4.1 and running windows me with
mysql.
Thanks,
Kris
--! ---
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: esql not working at all, no connection ever created!
Haha, I'm sorry about that. My normal email account was down last night and I needed to ask a question quick. My real name is Kris as I have been signing my emails with.
I'll unsubscribe from this account and use my regular account in the future ;)
Kris
jcplerm [EMAIL PROTECTED] wrote:
Perhaps this message is inappropriate for this mailing list,
but what I want to say is that I wonder why people would
participate without showing their real names, but instead
conceal their identity by means of fake yahoo or hotmail
addresses.
I joined recently, so maybe this has always been a common
practice anyway.
I think there are occasions whenconcealing the identityis
appropriate, but this mailing list is composed of frank,
honest and motivated individuals that give their best to
advance technology.
In my opinion, not showing the real name is a lack of
respect to the rest of the participants, especially those
that have consistently given their best.
Again, sorry for this e-mail not beingabout Cocoon...
Thanks for your attention.
Julio Lerm
(Yes, that's my real name, and I am not ashamed or
affraid of showing it...)
- Original Message -
From: Not Available
To: [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 12:28 PM
Subject: Re: esql not working at all, no connection ever created!
Here is my xsp code:
xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2" esql:connectionesql:pooldb_pool/esql:pool esql:execute-queryesql:queryselect * from antiques/esql:query esql:results esql:row-results esql:get-int column="id"/ esql:get-string column="name"/ /esql:row-results /esql:results /esql:execute-query/esql:connection/xsp:page
Here is my web.xml:
init-param param-nameload-class/param-name param-value !-- For IBM WebSphere: com.ibm.servlet.classloader.Handler --
!-- For Database Driver: -- org.hsqldb.jdbcDrivercom.mysql.jdbc.Driver !-- For parent ComponentManager sample: org.apache.cocoon.samples.parentcm.Configurator -- /param-value /init-param
Here is my cocoon.config:
jdbc name="antiques" pool-controller min="5" max="10"/ dburljdbc:mysql://localhost/databasename?autoReconnect=true/dburl usermyusername/user passwordmypassword/password /jdbc
Here is my pipeline for testing:
map:pipelinemap:match pattern="content/*.xml"map:generate type="xsp" src=""/map:serialize type="xml"//map:match/map:pipeline
Thanks again
Christopher Painter-Wakefield [EMAIL PROTECTED] wrote:
Please post your xsp code, or at least the portion with esql in it. Veryhard to help, otherwise.-Christopher|-+| | Not Available || | <[EMAIL PROTECTED]|| | hoo.com || | || | 04/01/2003 03:47 || | AM || | Please respond to|| | cocoon-users || | ||-+--|| || To: [EMAIL PROTECTED] || cc: || Subject: esql not working at all, no connection ever created! |--|I have been trying to get esql to work now for about 3 days with no luck. Ibeleive i have configured everything correctly but when I run any xsp pagewith esql it returns a duplicated page of my xsp page except that it stopsat the esql:connection tag. When I look at the error log it says there wasa null pointer exception. After examining the generated java file I thinkit is because a connection object is always null (never set to a validconnection). However I am pretty confident my pool is set up correctly andthe drivers are being loaded ok.Here is the code that it points to in the java file:_esql_query = new EsqlQuery( _esql_connection, String.valueOf(""+ " select * from antiques "+ " ") );No where above this code is the _esql_connection every initialized with aconnection.I am using the latest release for java 1.4.1 and running windows me withmysql.Thanks,Kris-To unsubscribe, e-mail: [EMAIL PROTECTED] pache.or gFor additional commands, e-mail: [EMAIL PROTECTED]
Do you Yahoo!?Yahoo! Tax Center - File online, calculators, forms, and moreDo you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
Re: esql not working at all, no connection ever created!
On 01.Apr.2003 -- 01:48 PM, Christopher Painter-Wakefield wrote: Is this the whole XSP program? If so, the problem is that you don't have the required single non-xsp child node of xsp:page. E.g., you have: xsp:page ... esql:connection ... /esql:connection /xsp:page but you need to have: xsp:page ... some-node esql:connection ... /esql:connection /some-node /xsp:page If that isn't the problem, write back and we'll try something else. Another one is the missing esql:execute-query tag. 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
