Java

SQuirreL is a 100% pure-Java implementation of a generic SQL client. You can browse and analyse any database which provides a JDBC driver. You can execute any kind of SQL statements. SQuirreL provides a plugin mechanism to hook in additional features. The default installation comes with a lot of plugins, for example MySQL-specific plugins, code completion, data import plugins and more.



In this article, I'd like to show you how to write your own plugin for SQuirreL and what you need to do to set up your development environment. I'll implement two features for indexing tables and their content into an Apache Lucene index and to make it searchable using full-text search.

• Comments (0)
• Trackbacks (0)
• Continue reading "Extending SQuirreL with plugins"

To validate an XML document against an XSD Schema, Java 5 offers standard functionality with the built-in JAXP API. To do that, first create the Schema object as follows:

URL resource = getClass().getResource( SCHEMA_FILE );
SchemaFactory factory = SchemaFactory.newInstance( XMLConstants.W3C_XML_SCHEMA_NS_URI );
Schema schema = factory.newSchema( resource );

• Comments (0)
• Trackbacks (0)
• Continue reading "XML Schema Validation done right"