ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
You get the error because your allocated time to hold a DML lock in a transaction exceeds the set limit. Usually the default limit to hold a DML row lock, set by innodb_lock_wait_timeout db parameter, is 50 seconds. If your transaction doesn't commit/rollback within 50 seconds (more...)
What grabbed my attention from the many different and very useful public and private (more...)
- Not all versions of databases can be migrated to RDS. Especially if you want to do a 0 downtime migration. Make sure you know which versions are possible, at this writing Amazon announced that it will support any old version of MySQL 5.1 and above.
- In a zero downtime migration to Amazon RDS you work with mysqldump or (more...)
I have also spent time working with MySQL a relational database with open source roots, now part of Oracle. In this post I want to talk about my impressions of MySQL and some tips and tricks I learned working with it.
First and for all, you will have to be ready (more...)
Yes you have (more...)
Many times I come across the requirement of quickly propagating changes from cloud platforms like Salesforce.com to on-premise data stores. You (more...)
The company which provides these drivers is called Progress|DataDirect
Their JDBC/ODBC Salesforce Connect XE drivers, acts as translators between SQL and SOQL (The Salesforce proprietary query language). So you can write your joins, use expressions like SUBSTRING on your Salesforce data as if the data was in a relational database.
I found the concept quite interesting. If you already know SQL -and there are many people which do- you can just (more...)
Maybe the DELETE command should be banned from SQL. It was probably invented when the disks were tiny and it might not be suitable for our times, especially nowadays when we talk about things like BIG DATA.
Data is related with other data based on relations and associations. For example, as in Salesfoce's data model One Account can have Many Contacts. In the model these relationships/associations are indicated by drawing lines from one object to the others as seen in the diagram below, where (more...)
The interface enables you to put page transitions to your apps, define JQuery lists and much more. Here is the option:
I managed to create few apps on this platform. This post is about what tools I used when I was developing the apps.
Overview of using Oracle Apex and JQuery Mobile
This one was easy, just go to http://apex.oracle.com and register for a workspace. The workspace gives you an Oracle Workspace Schema, (more...)
The other day I watched the Oracle Big Data forum. Now available here. A half-day event with various speakers on the subject of BigData, including Tom Kyte , a mentor who I admire!
In the forum they have gone over Oracle's approach to Big Data and allow me to summarise it below:
- Acquire - Collect Big Data, identify it, where is it? Then store it in Oracle NoSQL - a value-pair database
- Organise - Stage Big Data in a transient elastic database. Using Oracle Data Integrator and the Oracle Hadoop connector, reduce and distil it.
- Analyse - Start Analytics on (more...)
I like to think (and
the sooner the better!)
of a cybernetic meadow
where mammals and computers
live together in mutually
like pure water
touching clear sky.
I like to think
(right now please!)
of a cybernetic forest
filled with pines and electronics
where deer stroll peacefully
as if they were flowers
with spinning blossoms.
I like to think
(it has to be!)
of a cybernetic ecology
where we are free of our labors
and joined back to nature,
returned to our mammal
brothers and sisters,
and all watched over
by machines of loving grace.
By Richard Brautigan
1.Hourly calls to Yahoo Weather API
2.Static Google map API call to show the island on the map
3.More than 1 year daily temperature records to compare with current temperature, per island o. Google charts API
4.Learn the locations of 100+ Greek islands on the map
I am thinking of enriching the database behind this app with other relevant info.
To reach the app (more...)
When you use Informatica Cloud you usually use it to do Migration, Integration and Synchronisation. That's about what it is used for, right?
It is all about moving data from point A to point B or syncing data between A and B. That is what Informatica Cloud is built for, to move/sync data from A to B and while moving it, maybe transform it as well. A is the 'source' and B is the 'target'. Correct! A can be an Oracle or ERP database and B can be a Salesforce Org. Classical use case of Informatica Cloud.
Well, not (more...)