Archive for March, 2012

Installing Java on Linux

March 15, 2012
Installing Java on Linux

Lets see how to install Java on Ubuntu. On all other Unix flavored systems, the procedure will be more or less same as we’re using terminal Unix commands to install JDK. Download JDK from here: http://www.oracle.com/technetwork/java/archive-139210.html#javase Suppose say JDK is downloaded to ‘Downloads‘ folder Change directory to Downloads folder % cd ~/Downloads Change the execute [...]

NonUniqueResultException in Hibernate

March 6, 2012
NonUniqueResultException in Hibernate

Sometimes we will get the NonUniqueResultException when we tried to get the result-set by executing query using Hibernate. The following is the stack trace of the exception: query did not return a unique result: 2 org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899) at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) at org.bss.dao.SampleDAO.main(SampleDAO.java:84) This happens because you’re expecting [...]

Deal with Stored Procedures using phpMyAdmin

March 2, 2012
Deal with Stored Procedures using phpMyAdmin

phpMyAdmin MySQL web interface doesn’t contain any editor to manipulate or create stored procedure like all other IDEs. But you can create/modify the Stored Procedure using the queries. Example query for creating Stored Procedure ‘SP_INS_MEMBER’ is: DELIMITER $$   DROP PROCEDURE IF EXISTS `DB_NAME`.`SP_INS_MEMBER`$$   CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_INS_MEMBER`(IN subProcessId VARCHAR(100), IN storeId VARCHAR(100), IN [...]

 

If you have a Tip, Comment, Article or anything you want to share, please send it to: i@poisure.com