How To Remove Foreign Keys In MySQL

Today i have a problem when trying to delete some tables that had circular reference (one was FK NULL) but the way is that you can not drop the table until you drop the foreign key reference for example:

ALTER TABLE myTable DROP FOREIGN KEY FK_nameDefinition;

You can check for more information with the ALTER TABLE instrucction on:
http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

But browsing i have find a really cool solution to drop all foreign Keys or just get the names of this
foreign keys in the following blog:

http://www.justin-cook.com/wp/2006/05/09/how-to-remove-foreign-keys-in-mysql/

I have found it in a commet by "Jason" he recommends this cool query:

select concat('alter table ',table_schema,'.',table_name,' DROP FOREIGN KEY ',constraint_name,';') from information_schema.table_constraints;

Try out... see you... MySQL still Rules !!!

NetBeans IDE 6.7.1

Ruby is Supported on the NetBeans IDE 6.7.1 too the JavaFX the new rival for AdobeFlash. If you want to try it download from the official site: http://www.netbeans.org/downloads/index.html

ALTER TABLE ON MYSQL

If you have constantly changes in your DB and don't want to make remake TEST DB to your
developers, on MYSQL, you should try using the ALTER TABLE.

Check the documentation on: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Making an NO AJAX H:INPUT AN AJAX COMPONENT !

<h:outputText value="#{messages['batch.detail.filter.lastname']}" />
<h:inputText id="lastNameFilter"
value="#{batchOrderItemListView.batchOrderItemFilter.lastName}">
<a4j:support event="onchange" reRender="lastNameFilter" ajaxSingle="true" limitToList="true" />
</h:inputText>

Hibernate Controlling POJO Generation

This features for HIBERNATE are really amazing, you can read the nice documentation on the hibernate site at:

http://docs.jboss.org/tools/2.1.0.Beta1/hibernatetools/html/codegen.html

TAG References for Java Developers

I have found a really good site, to get help about the Tags and Controls references...

• http://www.jsftoolbox.com/documentation/
• JSF Tag Reference
• Facelets Tag Reference
• Seam Tag Reference
• ICEFaces Tag Reference

DZone RefCards

http://refcardz.dzone.com/

FREE Cheat Sheets for Developers
Save time and stay well-informed

* Written by bestselling authors and leading experts
* Reliable information on major developer topics
* Filled with useful tips and source code examples
* PDF looks great on-screen or printed from your printer

Tortoise Tools for Merging in Windows

A good friend of the work recommend me Winmerge for making the merges more easier while working with tortoise on windows... You can read more about it on the following link:

http://www.ridgesolutions.ie/index.php/2008/12/18/thanks-winmerge/

Java Glossary

Really good site, with not only code, too there are some commets...

• http://mindprod.com/jgloss/jgloss.html
  

Java Code Examples

This is a god site for finding java code examples or inspiration:

http://www.java2s.com/Code/Java/CatalogJava.htm