Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Help needed for creating table in xaction

  1. #1
    Join Date
    May 2008
    Posts
    1

    Default Help needed for creating table in xaction

    Hi all,

    I am trying to create a table by writing a query in xaction. For fetching data the query is like : -
    <action-definition>
    <component-name>SQLLookupRule</component-name>
    <action-inputs>
    </action-inputs>

    <action-outputs>
    </action-outputs>

    <component-definition>
    <!-- Define the datasource for the query -->
    <jndi><![CDATA[SampleData]]></jndi>
    <source>sql</source>
    <!-- Define the query to execute. -->
    <query>
    <![CDATA[select ...QUERY GOES HERE....
    ]]>
    </query>
    </component-definition>
    </action-definition>




    Now instead of select query if I write CREATE table query then SQL throws error as

    Can not issue data manipulation statements with executeQuery().

    How can I do the same.
    Thanks & Regard
    Ashutosh Kumar Nirala

  2. #2

    Default

    I expect thats cause its expecting a resultset returned which it doesn't get. I do recall a different SQL step though that should do the job. Search a bit harder :P

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3

    Default HI

    Hi

    I Think The Error Is Thrown Because Of Oracle Which Says That You Can Not Execute A Dml That Commits In Select Statement.

    So I Think There Might Be Different Way To Achieve This.

    Thanks
    Nik

  4. #4

    Default

    Do execute -> SQL Commands.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  5. #5
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi,

    Tom was right. You are using the wrong action. SQL Lookup Rule is for SELECT-statements only. There is als a execute SQL action. That's the one you need to use.

    Regards,
    Ingo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.