Go Lang Oracle – ORA-00933: SQL command not properly ended

While building some migrations with Goose I had some strange (for me) error, for which you can find a lot of different stuff on Google but nothing helped.

The error was like in the title: “ORA-00933: SQL command not properly ended” for this query


UPDATE table1 SET title = CONCAT('FORMER-', title) WHERE id < = 500;

This query will work without problems in SQL editor like Oracle SQL Developer but not in the GO adapter

Continue reading “Go Lang Oracle – ORA-00933: SQL command not properly ended”

PHP SoapClient() gives error 500 and cannot catch the error

Went to an error 500 in production server while using PHP SoapClient library to connect to some third-party API. The error was really strange, just error 500 and nothing more, even if you are using try catch, you won’t be able to catch and see the error.

The Example:


try{
    $client = new SoapClient("https://api.thirdparty.com/some/service?wsdl", ['exceptions' => true, 'trace' => true]);
} catch(SoapFault $fault) {
    trigger_error("SOAP Fault: (faultcode: " . $fault->faultcode . ", faultstring: " . $fault->faultstring . ")", E_USER_ERROR);
} catch(Exception $e) {
    trigger_error("SOAP Error: " . $e->getMessage(), E_USER_ERROR);
}

Continue reading “PHP SoapClient() gives error 500 and cannot catch the error”

Arduino UNO WiFi R3 WiFi Firmware updater – IDE 1.8.2+

I was trying to connect to my new Arduino UNO WiFi R3 to my WiFi network in home and had to spend big amount of time in searching of errors like Can't communicate with programmer!; programmer is not responding; WiFi shield not present OR cc.arduino.plugins.unowifi.UpdaterImpl$2.run(UpdaterImpl.java:112)
Continue reading “Arduino UNO WiFi R3 WiFi Firmware updater – IDE 1.8.2+”

How to integrate Amazon AWS SQS

SQS stands for Simple Queue Service, is a highly scalable and reliable distributed queueing system, which can be used to make applications asynchronous.

I will show you the simplest way of integrating the SQS, installing AWS SDK, Creating a Queue and a Worker to manage the queues and push tasks to Queues.
Continue reading “How to integrate Amazon AWS SQS”