[SQL]One sql transformer can only use one connection?

[Christina <le...@hotmail.com>]

BlankI tried to create a database and create a table in the new database. 
But it turned out the new table is created in the database "oldone", which is the first connection., 
even though I have changed the dburl in the second query to new database "newone"
Would anybody tell me how to fix it except using two pipelines to do this?
Thank you for your help!


<page>
   <content>
    <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"> 
 <dburl>jdbc:mysql://127.0.0.1:3306/oldone</dburl>
 <username>root</username>
 <password/>
  <query name="newDB">
          create database newone         
     </query>
    </execute-query>
    <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"> 
 <dburl>jdbc:mysql://127.0.0.1:3306/newone?autoReconnect=true</dburl>
 <username>root</username>
 <password/>
  <query name="newTable">
          create table test (test_id varchar(32))
     </query>
    </execute-query>
   </content>
  </page>