Contributions
Insert a character stream into a CLOB column data (Oracle 9.x)
Hi, to store the response (22534 bytes) of a soap request in the database into a CLOB column I used the following code in my groovy script: // get the request object def request = testRunner.testCase.testSteps["REQUEST"].testRequest // get the actual messages def requestContent = request.requestContent def responseContent = request.response.contentAsString // Update der Tabelle log um den Request sql.executeUpdate("Update log set REQUEST = $requestContent where TRANSACTION_ID = $TRANSACTION_ID_NEW") // Update der Tabelle log um den Request sql.executeUpdate("Update log set RESPONSE = $responseContent where TRANSACTION_ID = $TRANSACTION_ID_NEW") In this case an error rises: Mon Apr 14 09:54:11 CEST 2008:ERROR:java.sql.SQLException: Datengröße größer als max. Größe für diesen Typ: 22534 This means that the string "responseContent" is too long. So I used the following code: Connection theCon = DriverManager.getConnection( database ); theStatement = theCon.prepareStatement ("Update log set RESPONSE = ? where TRANSACTION_ID = ?"); theStatement.setString(2, TRANSACTION_ID_NEW); byte[] charDataBytes = responseContent.getBytes("UTF-8"); java.io.ByteArrayInputStream byteStream = new java.io.ByteArrayInputStream (charDataBytes); theStatement.setAsciiStream(1, byteStream, byteStream.available()); rs = theStatement.executeUpdate(); With this code no error rises but the column RESPONSE in table log remains empty. I hope you have an idea, thanks Andreas4.4KViews0likes2CommentsProperty Transfer with multiple target?
Hi, I'm new in this forum and hope that you can help me. Using the Property Transfer in SoapUI 2.0.2 Pro I would like to transfer one value into two targets in the same XML. E.g. the name of a customer is selected from the database and stored in the property "NAME". The name in the test request appears twice: as shipping address and as postal address like this ... ... ... ... ? ... Is it possible to declare two targets during one transfer or must I do the transfer separately for each address? Kind regards Andreas3.5KViews0likes1Comment