Monthly Archives: February 2011

unknown-table-engine-innodb

http://www.osterman.com/wordpress/2007/12/23/unknown-table-engine-innodb   I was getting the error “ERROR 1286 (42000): Unknown table engine ‘InnoDB’” when trying to create/alter tables with the InnoDB engine. You can check for this warning by issuing the create or alter statements and then running show … Continue reading

Posted in database, mysql | Leave a comment

test integration at spring and Eclipse

right click on test class and select ran as->run configuration-> select argument tab and add in vm -javaagent:/home/admin/org.springframework.instrument-3.0.5.RELEASE.jar where /home/admin/ is the path for org.springframework.instrument-3.0.5.RELEASE.jar

Posted in spring | Leave a comment

Facebook RSS feeds – what is available?

http://www.kristi-barrow.com/facebook-rss-feeds-what-is-available/

Posted in Uncategorized | Leave a comment

Install Apache and Enable mod_rewrite Ubuntu Linux

http://xmodx.com/install-apache-and-enable-mod_rewrite-ubuntu-linux/

Posted in linux, Uncategorized | Leave a comment

amazing application on MVC with Spring

http://appfuse.org/display/APF/Using+Spring+MVC

Posted in Uncategorized | Leave a comment

amazing rankinig tool

http://www.woorank.com/

Posted in Uncategorized | Leave a comment

How to Install phpmyadmin on Ubuntu 10.04 LTS Server

phpmyadmin is a web interface to your MySQL databases. It makes managing, creating and configuring your MySQL database a breeze. It is a very common tool and is often installed by default by many web host. In this article we … Continue reading

Posted in linux | Leave a comment

How to install LAMP on Ubuntu (Linux, Apache, MySQL and PHP) in one command

Lamp stands for Linux, Apache, MySQL and PHP. These tools are very common for running many websites such as WordPress, Drupal, Joomla, Collabtive…etc. In Ubuntu we can easily install Apache2, MySQL and PHP with one simple command. In later articles … Continue reading

Posted in linux | Leave a comment

20 Linux System Monitoring Tools Every SysAdmin Should Know

Need to monitor Linux server performance? Try these built-in command and a few add-on tools. Most Linux distributions are equipped with tons of monitoring. These tools provide metrics which can be used to get information about system activities. You can … Continue reading

Posted in linux | Leave a comment

how to call mysql function from java

Class.forName(“com.mysql.jdbc.Driver”); Connection con=DriverManager.getConnection(“”,””,””); String stmt = “{? = CALL ISLSTDB.fn_amz_GetFinalPrice1(?,?,?)}”; CallableStatement cs = con.prepareCall(stmt); cs.registerOutParameter(1, java.sql.Types.FLOAT); cs.setString(2,”MBT”); cs.setString(3, “000799100721”); cs.setInt(4,5); cs.execute();//call the routine System.out.println(cs.getFloat(1)); another way String sql=”SELECT ISLSTDB.fn_amz_GetFinalPrice1(‘”+skucmb+”‘,’”+upc+”‘,”+Integer.parseInt(getdomaincode(domaincmb))+”)”; //System.out.println(sql); Statement s=conn.createStatement(); ResultSet rs1= s.executeQuery(sql); while (rs1.next()) { Float type … Continue reading

Posted in Uncategorized | Leave a comment