Integrating FCKEditor in MediaWiki
Mar 31, 08 by Juan Lebrijo about blog, Wiki
The target for this post is to embed at our MediaWiki an editor as Wordpress wysiwyg editor. For editing visual and no-problem with the back language. With Wiki applications this language is not HTML, because of the complexity or the reference systems used. They use a tagged language, Wikitext, which we could do not need or do not our users learn. In my opinion the FCKEditor is the best choice. We based on the following guide: FCKEditor Integration Guide. Download the package: mediawiki_fckeditor_ext_N.tar.gz. Unzip it and copy to the extensions directory of your MediaWiki Installation folder:
tar -zxvf mediawiki_fckeditor_ext_N.tar.gz
cp -r extensions/* /var/www/wiki/extensions/
chown -R www-data:www-data /var/www/wiki/extensions/
Finally notify to MediaWiki for loading this extension at the begining, at file LocalSettings.php:
# EXTENSIONES: Aquí incluimos las extensiones incrustadas en MediaWiki:
require_once $IP . "/extensions/FCKeditor/FCKeditor.php";
Then our edito is embebed. Refresh the cache in your browser to ensure that there is nothing cached. If you want to change the language of the interface editor, I could change modifying the following lines in the cofiguration file (fckeditor_config.js):
FCKConfig.AutoDetectLanguage    = false ;
FCKConfig.DefaultLanguage       = 'es' ;
Then we can enjoy our wiki with an easy editor.
Connecting Netbeans to your Data Base
Mar 26, 08 by Juan Lebrijo about Database, blog, NetBeans
At this post we are going to see how to connect Netbeans IDE to your Database. In my case I work over Oracle SGBD, then I will access to this SGBD. We will use the JDBC standar, java based for remote DDBB connections purposes. Let's see two base links for the purpose of this post::
  • This is a Netbenas wiki post where are written links to all SGBD drivers supported. Then, if you are searching for PosgreSQL, MySQL, M$, DB2,.. you can try it.
  • Here we have the Oracle JDBC driver. I can afirm that it would run for any Oracle version up to 9i.
In the second link I downloaded the driver in the file: ojdbc14.jar. The installation is at the tab Services --> clicking the right mouse button over Drivers --> New Driver ...
NB_SGBD_01.JPG 33.9 KB
We look for the driver downloaded in our system, and install it. To create a new connection, we will do at tab Services --> clicking the right mouse button over DataBases --> New Connection ...
NB_SGBD_02.JPG 35.5 KB
We must make our connection URL with the following model:
jdbc:oracle:thin:@{HOST}:{PORT}:{SID}
You can probe the connection making queries in the front window:
NB_SGBD_03.JPG 63.8 KB
Obviously, with a JDBC preinstalled in Netbeans as MySQL driver, would be easier create a connection. You can see a MySQL example at the image:
NB_SGBD_04.JPG 44.6 KB
Conectar Netbeans a una BBDD
Mar 26, 08 by Juan Lebrijo about Database, blog, NetBeans
En esta entrada veremos como podemos conectar Netbeans a una Base de Datos, en mi caso trabajo con Oracle, por tanto la tomaremos de ejemplo. Utilizaremos el estándar JDBC, basado en java para conexiones remotas de BBDD. Para empezar le echaremos un vistazo a un par de enlaces:
  • Este es una entrada de la wiki de Netbeans donde tenemos enlaces a todos los drivers SGBDs que soporta. Por tanto si estás buscando algo para PosgreSQL, MySQL, M$, DB2,.. puedes intentarlo en este enlace.
  • Aquí tenemos el driver JDBC para Oracle concretamente. En principio debería valer para acualquier versión de Oracle a partir de la 9i.
Del segundo enlace descargué el driver contenido en el fichero ojdbc14.jar. Este será el que hay qhe instalar en la pestaña Services --> Botón derecho sobre Drivers --> New Driver ...
NB_SGBD_01.JPG 33.9 KB
Buscamos el driver que hemos descargado en nuestro sistema, y lo instalamos. Para crear la nueva conexión lo hacemos en la pestaña Services --> Botón derecho sobre DataBases --> New Connection ...
NB_SGBD_02.JPG 35.5 KB
Tenemos que construir nuestra URL de conexión con el siguiente modelo:
jdbc:oracle:thin:@{HOST}:{PORT}:{SID}
En la ventana principal se pueden sacar conultas directas para probar:
NB_SGBD_03.JPG 63.8 KB
Naturalmente, con un driver JDBC preinstalado en Netbeans como el de MySQL sería más inmediato crear una conexión. Podeis tener en cuenta la configuración de la imagen:
NB_SGBD_04.JPG 44.6 KB