Skip to main content

Posts

MySQL - Issues - solutions

Issue 1 - 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci' ERROR     Running: mysql.exe --defaults-file="c:\users\ishma\appdata\local\temp\tmpdj9_y0.cnf"  --protocol=tcp --host=localhost --user=root --port=3307 --default-character-set=utf8 --comments --database=sakila < "C:\\Users\\ishma\\Documents\\dumps\\Dump20201229\\sakila_address.sql" Solution Open the sql file in your text editor Find and replace all  utf8mb4_unicode_520_ci  with  utf8mb4_unicode_ci Save and upload to a fresh mySql db
Post a Comment
Read more
Recent posts

Reading IBM MQ messages and sending messages to backout queue using Java in server binding

When you are running your java client in server binding to read the messages from MQ you make sure that  your java client is running on your MQ Serever. When you are running the java client in server binding  you will get the very good performance with compare to client binding. I am able to read 500 messages in 2.2 seconds each message size is around 30KB. import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import java.util.Properties; import org.apache.log4j.Logger; import org.apache.log4j.PropertyConfigurator; import com.ibm.mq.MQException; import com.ibm.mq.MQGetMessageOptions; import com.ibm.mq.MQManagedObject; import com.ibm.mq.MQMessage; import com.ibm.mq.MQPutMessageOptions; import com.ibm.mq.MQQueue; import com.ibm.mq.MQQueueManager; import com.ibm.mq.constants.CMQC; public class QueueReader{ private MQQueueManager _queueManager = null; public String qManager = null; ...
Post a Comment
Read more

Reading (IBM) MQ messages and sending messages to backout queue Using Java in client binding

Hi, I try to share my experience/knowledge on reading the messages from (IBM) MQ in client mode, while I was working I try to gather the details through different sources but get very less information in order to finish my task on MQ part. Initially I struggle a lot it made me to write this blog, if you want read the IBM MQ messages using java client you can use this following code... Reading the MQ Messages in Client mode:   import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import java.util.Properties; import org.apache.log4j.Logger; import org.apache.log4j.PropertyConfigurator; import com.ibm.mq.MQException; import com.ibm.mq.MQGetMessageOptions; import com.ibm.mq.MQManagedObject; import com.ibm.mq.MQMessage; import com.ibm.mq.MQPutMessageOptions; import com.ibm.mq.MQQueue; import com.ibm.mq.MQQueueManager; import com.ibm.mq.constants.CMQC; public class QueueReader{ private M...
Post a Comment
Read more