Here, you had done two wrongs
1) The IDENTITY_VAL_LOCAL function has no input parameters.
But, you have tried to set parameters -- That is why you get exception.
2) You have called it in db report mediator. DB report mediator use
to add /update record ...simply uses executeUpdate(). But values
IDENTITY_VAL_LOCAL() is for retrieving latest inserted record identity
and will throws errors.
Please use values IDENTITY_VAL_LOCAL() with DB LookUp mediator
Thanks
Indika
Schmilinsky, Remsy wrote:
Thanks. I am trying to get the generated id after insert, I'm using
derby, with 'values IDENTITY_VAL_LOCAL()' in a second sql but doesn't
work, are these incompatible functions ?
2008-10-01 13:47:14,790 [169.254.7.221-WH24CU6052] [jms-Worker-1]
ERROR DBReportMediator Error execuring insert statement : values
IDENTITY_VAL_LOCAL() against DataSource :
jdbc:derby://localhost:1527/esbdb;create=false
java.sql.SQLException: The column position '1' is out of range. The
number of columns for this ResultSet is '0'.
at
org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at
org.apache.derby.client.am.ColumnMetaData.getColumnType(Unknown Source)
the insert statement alone works though.
here dbreport config, for the moment I assign value 1 to test it out:
<syn:dbreport>
<syn:connection>
<syn:pool>
<syn:driver>org.apache.derby.jdbc.ClientDriver</syn:driver>
<syn:password>esb</syn:password>
<syn:user>esb</syn:user>
<syn:url>jdbc:derby://localhost:1527/esbdb;create=false</syn:url>
</syn:pool>
</syn:connection>
<syn:statement>
<syn:sql><![CDATA[insert into sample values (DEFAULT,
?)]]></syn:sql>
<syn:parameter
xmlns:ns1="http://org.apache.synapse/xsd";
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";
expression="//*/*" type="VARCHAR"/>
</syn:statement>
<syn:statement>
<syn:sql><![CDATA[values IDENTITY_VAL_LOCAL()]]></syn:sql>
<syn:parameter value="1" type="INTEGER"/>
</syn:statement>
</syn:dbreport>
remsy
-----Original Message-----
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of *Indika Kumara
*Sent:* October 1, 2008 1:21 PM
*To:* [email protected]
*Subject:* Re: [esb-java-user] dbreport question
Hi Remsy
All the samples in [1] show a scenario somewhat similar to your
scenario (I believe). In those samples, get an ID from DB and set
it as message context property
and then perform conditional switching based on the value of that
property. On the out path, some result form response is stored in
the DB too.
By going through [2], it will be easy to understand the current
behavior of the DB -mediators
[1]
http://wso2.org/project/esb/java/1.7.1/docs/ESB_Samples.html#DBMediators
[2]
http://wso2.org/project/esb/java/1.7.1/docs/ESB_Configuration_Language.html#dblookup
Thanks
Indika
Schmilinsky, Remsy wrote:
I need ro propagate the result of a query (id number) from dbreport to the mediators along with the message.
The idea is that the mediators will perform some actions on the message and
then log results in the db, so we need the id to reference the original data.
is this possible ? how ?
thanks
Remsy
_______________________________________________
Esb-java-user mailing list
[email protected]
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.173 / Virus Database: 270.7.5/1698 - Release Date: 9/29/2008 7:25 PM
------------------------------------------------------------------------
_______________________________________________
Esb-java-user mailing list
[email protected]
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.173 / Virus Database: 270.7.5/1698 - Release Date: 9/29/2008 7:25 PM
_______________________________________________
Esb-java-user mailing list
[email protected]
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
