cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Liqiao Han <milk...@winlab.rutgers.edu>
Subject Re: NullPointerException @ cocoon+ mysql //thank you!
Date Sat, 28 Feb 2004 22:19:18 GMT
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.

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
16:10:46.023181 IP my-Domain.1473 > boss-domain.3306: S 61218
3295:612183295(0) win 64240 <mss 1460,nop,nop,sackOK> (DF)
16:10:46.023324 IP boss-domain.3306 > my-Domain.1473: R 0:0(0
) ack 1 win 0
16:10:46.524041 IP my-Domain.1473 > boss-domain.3306: S 61218
3295:612183295(0) win 64240 <mss 1460,nop,nop,sackOK> (DF)
16:10:46.524320 IP boss-domain.3306 > my-Domain.1473: R 0:0(0
) ack 1 win 0
16:10:50.530703 IP my-Domain.1474 > boss-domain.3306: S 61348
8978:613488978(0) win 64240 <mss 1460,nop,nop,sackOK> (DF)
16:10:50.530851 IP boss-domain.3306 > my-Domain.1474: R 0:0(0
) ack 613488979 win 0
16:10:51.030467 IP my-Domain.1474 > boss-domain.3306: S 61348
8978:613488978(0) win 64240 <mss 1460,nop,nop,sackOK> (DF)
16:10:51.030657 IP boss-domain.3306 > my-Domain.1474: R 0:0(0
) ack 1 win 0
16:10:51.531735 IP my-Domain.1474 > boss-domain.3306: S 61348
8978:613488978(0) win 64240 <mss 1460,nop,nop,sackOK> (DF)
16:10:51.531869 IP boss-domain.3306 > my-Domain.1474: R 0:0(0
) ack 1 win 0

----- Original Message ----- 
From: "Johannes Textor" <jc.textor@gmx.de>
To: <users@cocoon.apache.org>
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
> >   <!-- For MySQL Driver: -->
> >        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: users-unsubscribe@cocoon.apache.org
> >For additional commands, e-mail: users-help@cocoon.apache.org
> >
> >
> >  
> >
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message