thank you!

Geoff Howard Sat, 28 Feb 2004 14:45:28 -0800

Liqiao Han wrote:

Textor, thank you for your reply, actually i set a user and password, still doesn't work I just find the message sent by my machine contains no data at all following is what I get from windump. I don't know if this has something to do with the different os of my machine and my boss' machine I am using Win-xp and my boss is using Unix.

That should have nothing to do with it. Have you set up mysql to allow connections from your ip as that user? See mysql docs.

Are you sure this has anything to do with mysql? The error you quote is about namespace - are you trying to use the sql transformer without declaring the namespace??

Geoff

16:10:45.523255 IP my-Domain.1473 > boss-domain.3306: S 61218
3295:612183295(0) win 64240 <mss 1460,nop,nop,sackOK> (DF)
16:10:45.523576 IP boss-domain.3306 > my-Domain.1473: R 0:0(0
) ack 612183296 win 0

----- Original Message ----- From: "Johannes Textor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 28, 2004 2:20 PM Subject: Re: NullPointerException @ cocoon+ mysql //thank you!

Han,

you have to setup user name and password according to the mysql user settings. The default settings are user "root" and no password (""), but I would strongly advise you to change this.

Greetings

Liqiao Han wrote:

I have struggled with cocoon+mysql for a week and failed to make

themwork!

I am new to mysql and cocoon both. now I totally have no idea what to

do.
What I did:
1. I copied the "mysql-connector-java-3.0.11-stable-bin.jar" to
$COCOON_HOME/WEB-INF/lib
2. add the following to the web.xml
 
      com.mysql.jdbc.Driver
3. add the following to the cocoon.xconf
<jdbc name="YourPoolName">
  <pool-controller min="5" max="10"/>
<dburl>jdbc:mysql://boss.mylab.org:3306/tbdb?autoReconnect=true</dburl>
  <user>YourUsername</user>
  <password>YourPassword</password>
</jdbc>
in fact I am not quite sure the database name, user name and password above. A> the database server doesn't require an user name or password to
use

the database, but it dos require an account to login in to the OS, I

don't

know how to set the user and password here? B> I am not sure the database name too. After I login on to the

server
by
ssh, I can type
           > mysql
            >use tbdb
and then, I can inquery the table I want,
so is "tbdb"  the one I should set after the port number?
4: here is what I add to the sitemap.xmap
 <map:match pattern="allUsers">
    <map:generate src="allUsers.xml" />
    <map:transform type="sql">
      <map:parameter name="use-connection" value="YourPoolName" />
      <map:parameter name="show-nr-of-rows" value="true" />
      <map:parameter name="clob-encoding" value="UTF-8" />
</map:transform>
  <map:serialize type="xml" />
</map:match>
5, here is the allUsers.xml
<?xml version="1.0" ?>
<document>
 <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
<query name="allUsers">
select uid from users;
</query>
</execute-query>
</document>
So I started the server and input the Url, the response is very veryslow(about 5 minutes) and what I got an null pointer error. I
looked

at the error log, it says: java.sql.SQLException: Failed to obtain connection. Made 5 attempts

with
5000ms interval at

org.apache.cocoon.transformation.SQLTransformer$Query.getConnection(SQLTrans

former.java:1038) at

org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.

java:326) at

org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTr
ansformer.java:493)
I used tcpdump to see the data transfer between my machine and the
server,actually the tcp messages were sent out and the server acked it.
but I doubt
if jdbc has sent out the query because according to the tcpdump the
messagecontains no data like following:
my-domainName.1234 >server-domainName.3306 S 123456:123456(0) win 6424
(mss
1460, nop,nop, sackOK) (DF)
server-domainName.3306 >my-domainName.1234 R 0:0 ack 123457 win 0
Now I totally have no idea why
Thanks for your help and time!
following is the error stack: Failed to execute pipeline. org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.NullPointerException Original Exception: java.lang.NullPointerException at
org.apache.xml.serializer.ToStream.ensurePrefixIsDeclared(ToStream.java:2675

) at org.apache.xml.serializer.ToStream.startElement(ToStream.java:1777) at

org.apache.xalan.transformer.TransformerIdentityImpl.startElement(Transforme

rIdentityImpl.java:1073) at

org.apache.cocoon.xml.AbstractXMLPipe.startElement(AbstractXMLPipe.java:130)

at

org.apache.cocoon.xml.AbstractXMLPipe.startElement(AbstractXMLPipe.java:130)

at

org.apache.cocoon.transformation.AbstractSAXTransformer.startTransformingEle

ment(AbstractSAXTransformer.java:692) at

org.apache.cocoon.transformation.SQLTransformer.start(SQLTransformer.java:80

1) at

org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.

java:340) at

org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTr

ansformer.java:493) at

org.apache.cocoon.transformation.SQLTransformer.endTransformingElement(SQLTr

ansformer.java:774) at

org.apache.cocoon.transformation.AbstractSAXTransformer.endElement(AbstractS

AXTransformer.java:358)

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: NullPointerException @ cocoon+ mysql //thank you!

Reply via email to