Mysql | Maximum execution time of 360 seconds exceeded at data import time

| By Webner

In one of the project we had to import some .csv files into Mysql database. Files were of size 80mb and more. When we tried to upload the files through phpmyadmin it was resulting in timeout error – Maximum execution

Salesforce | How to access php code in salesforce apex class

| By Webner

We can access the php code in salesforce using @future(callout=true/false). The function we make for accessing the php code in apex class is of static type and does not return any value. Syntax: @future(callout=true) public static void function_Name() { //variable

Joomla- Database Error: Unable to connect to the database

| By Webner

While working with Joomla if you get an error – “Database Error: Unable to connect to the database:Could not connect to database”, check following properties in Joomla’s configuration.php file : //given values are sample data only. var $dbtype = ‘mysql’;

Hibernate | javax.persistence.OptimisticLockException: Row was updated or deleted by another transaction

| By Webner

You may face following exception while trying to update data in a database table using hibernate: javax.persistence.OptimisticLockException : Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.abc.pkg.db.entities.customer.CustomerOfferScheduledTask#2504849] The reason is optimistic lock is applied on

Salesforce | How to create Single Dynamic Batch Class to update multiple Sobjects in Salesforce

| By Webner

Suppose you want to update field name ‘Status’ to ‘Active’ in multiple Sobject and there are large number of records for each Sobject. Instead of writing a batch class for each Sobject you can update multiple Sobjects like this. Declare