Microsoft IIS(Internet Information Services)::Activar soporte SSL

[1]http://www.adictosaltrabajo.com/tutoriales/tutoriales.php?pagina=iisssl

JasperReport to Excel

http://p2p.wrox.com/j2ee/38785-exporting-data-into-excel-using-jasper-reports.html

Url Test Security

Sucuri Security Scanner
http://sitecheck.sucuri.net/scanner/
http://www.avgthreatlabs.com/sitereports

http://onlinelinkscan.com/

http://www.mywot.com/es (reputacion)

http://www.stopbadware.org/home/reportsearch (Indica quien te puso en la lista negra)
http://wepawet.cs.ucsb.edu

free e-commerce software

http://www.prestashop.com/

Web Capture

ScreenGrab
https://addons.mozilla.org/es-ES/firefox/addon/1146/

NHibernate works without mapping

ISQLQuery query = Session.CreateSQLQuery("SELECT p.*, c.* FROM Product p Left JOIN Product_CustomField c on p.ProductId=c.ProductId");
query.SetResultTransformer(NHibernate.Transform.Transformers.AliasToBean(typeof(Product)));
IList resultList = query.List();

Notes:
Add CusTomField1..5 into Product Class,not need declared in .hbm.xml

Combine with ScalarFields
public class SqlRepository {
...
public IList ListEmployees() {
using (ISession session = _sessionBuilder.GetSession()) {
return session
.CreateSQLQuery(@"
SELECT No_ AS EmployeeNumber, [E-mail Login] AS Username
FROM Employees")
.AddScalar("EmployeeNumber", NHibernateUtil.String)
.AddScalar("Username", NHibernateUtil.String)
.SetResultTransformer(Transformers.AliasToBean())
.List();
}
}
}


Add nHibernate mapping at run time
ISessionFactory sf = new Configuration()
.AddFile("Product.hbm.xml")
.AddFile("Category.hbm.xml")



References:
[1] http://docs.jboss.org/hibernate/core/3.3/reference/en/html/querysql.html
[2] Store procedure http://www.martinwilley.com/net/code/nhibernate/sql.html
[3] Reduced wiring code needed for native sql http://swik.net/Hibernate/Hibernate+GroupBlog/Hibernate+3.1:+Reduced+wiring+code+needed+for+native+sql
[4] AddJoin http://es.efreedom.com/Question/1-1132059/NHibernate-problema-de-AddEntity-y-AddJoin
[5] Native SQL http://knol.google.com/k/fabio-maulo/nhibernate-chapter-14-native-sql/1nr4enxv3dpeq/17#
[6]Fluent NHibernate http://wiki.fluentnhibernate.org/Auto_mapping
[7]Dynamically load .hbm.xml http://www.codeguru.com/forum/showthread.php?t=474322

How to get Machine Remote Client information

Access to the network host mac address,CPU access to suppliers,...
http://www.hackchina.com/en/cont/82131

Three ways to get your MAC address.
http://www.codeguru.com/Cpp/I-N/network/networkinformation/article.php/c5451
Enterprise Logging for Distributed J2EE Applications
http://javaboutique.internet.com/tutorials/logging/index4.html

How do I get MAC address of a host? (JAVA)
http://www.kodejava.org/examples/250.html
Extract network card address(JAVA)
http://www.rgagnon.com/javadetails/java-0369.html

References:
http://mindprod.com/project/macaddress.html

Cubecart:: Deprecated: Function eregi() is deprecated in

The latest versions of PHP 5 have deprecated a few functions, for turn off those messages as seen in CubeCart.

Edit /includes/ini.inc.php
error_reporting(E_ALL & ~(E_NOTICE | E_STRICT | E_DEPRECATED | E_USER_DEPRECATED));

Postgres save images

CREATE TABLE images (name text, img bytea);

 File file = new File("image.gif");
 FileInputStream fis = new FileInputStream(file);
 PreparedStatement ps = conn.prepareStatement("INSERT INTO images VALUES (?, ?)");
 ps.setString(1, file.getName());
 ps.setBinaryStream(2, fis, file.length());
 ps.executeUpdate();
 ps.close();
 fis.close();

setBinaryStream(), transfers a set number of bytes from a stream.
setBytes(), use this method if the contents of the image was already in a byte[].

Retrieving image

  PreparedStatement ps = conn.prepareStatement("SELECT img FROM images WHERE name=?");
  ps.setString(1, "image.gif");
  ResultSet rs = ps.executeQuery();
  if(rs.next()) {
         byte[] imgBytes = rs.getBytes(1);
  }
  rs.close();
 }
 ps.close();

You could have used a InputStream object instead.

Alternatively you could be storing a very large file and want to use the LargeObject API to store the file:

CREATE TABLE imagesLO (imgname text, imgOID OID);

To insert an image, you would use:

 conn.setAutoCommit(false); // All LargeObject API calls must be within a transaction
 
 LargeObjectManager lobj = ((org.postgresql.PGConnection)conn).getLargeObjectAPI();
 
 //create a new large object
 int oid = lobj.create(LargeObjectManager.READ | LargeObjectManager.WRITE);
 
 //open the large object for write
 LargeObject obj = lobj.open(oid, LargeObjectManager.WRITE);
 
 // Now open the file
 File file = new File("image.gif");
 FileInputStream fis = new FileInputStream(file);
 
 // copy the data from the file to the large object
 byte buf[] = new byte[2048];
 int s, tl = 0;
 while ((s = fis.read(buf, 0, 2048)) > 0)
 {
 obj.write(buf, 0, s);
 tl += s;
 }
 
 obj.close();
 
 //Now insert the row into imagesLO
 PreparedStatement ps = conn.prepareStatement("INSERT INTO imagesLO VALUES (?, ?)");
 ps.setString(1, file.getName());
 ps.setInt(2, oid);
 ps.executeUpdate();
 ps.close();
 fis.close();

Retrieving the image from the Large Object:

 conn.setAutoCommit(false);
 
 // Get the Large Object Manager to perform operations with
 LargeObjectManager lobj = ((org.postgresql.PGConnection)conn).getLargeObjectAPI();
 
 PreparedStatement ps = con.prepareStatement("SELECT imgOID FROM imagesLO WHERE imgname=?");
 ps.setString(1, "image.gif");
 ResultSet rs = ps.executeQuery();
 if (rs.next()) 
 {
  int oid = rs.getInt(1);//open the large object for reading
 LargeObject obj = lobj.open(oid, LargeObjectManager.READ);
 
 //read the data
 byte buf[] = new byte[obj.size()];
 obj.read(buf, 0, obj.size());
 //do something with the data read here
 obj.close();
 }
     rs.close();
 }
 ps.close();

JSP Pagination mySQL Postgres

Postgres
select * from ubigeos order by nombre limit 10 offset 0

mySql
select * from ubigeos order by nombre limit 0 , 10

References:
[1] http://www.easywayserver.com/blog/jsp-pagination/
[2] http://www.todoexpertos.com/categorias/tecnologia-e-internet/programacion/java/respuestas/889187/paginacion-con-jsp

JavaScript event.keyCode problem

http://bytes.com/topic/javascript/answers/648090-event-keycode-9-tab-event-doesnt-work-firefox
http://www.mozillaes.org/foros/viewtopic.php?f=13&t=7469
http://efreedom.com/Question/1-553240/Event-Defined-Mozilla-Firefox-Javascript-Function
http://www.webmasterworld.com/javascript/3488072.htm

Log Service

http://logging.apache.org/log4net/release/manual/configuration.html

Web Service tools for Social Networks

Engine for Java Web service
http://enunciate.codehaus.org/

Social Networks Api
hi5
http://api.hi5.com/
Facebook
http://developers.facebook.com/docs/reference/javascript/

JNLP vs ClickOnce

Java Web Start (Jnlp) Tutorial
http://www.mkyong.com/java/java-web-start-jnlp-tutorial-unofficial-guide/

Walkthrough: Manually Deploying a ClickOnce Application
http://msdn.microsoft.com/en-us/library/xc3tc5xx

CMS Drupal Themes (Temas)

theme developer module for drupal
http://drupal.org/node/209561

Make drupal them step by step
http://www.inmensia.com/articulos/drupal/temas.html

site info

http://www.alexa.com/siteinfo

Flash tools

Tools
http://www.taringa.net/posts/downloads/1880304/Los-mejores-programas-para-hacer-banners-y-intros-en-Flash_.html

http://www.taringa.net/posts/downloads/3122110/Sothink-Glanda-_-Crack--_1-link---Funciona_.html

Flash tools freeware

Slides/Media Slide Show
http://www.flashxml.net/
mp3 player
http://www.colewebs.org/spip.php?article24

Flash Animations with XML
http://www.flashcomponents.net/components/free_flash_files.html

Php Cms Resources

CMS without database
1) http://get-simple.info/download/  (best for me)
     Themes http://get-simple.info/extend/all_themes.php
2) Cms from Scratch http://cmsfromscratch.com/user-guide/

https://code.google.com/archive/p/cmsfromscratch/downloads (2nd)

CMS with database
1) Drupal http://drupal.org/project
1.1) Languaje http://localize.drupal.org/translate/languages

CMS Related Resources
[1]CMS without database
http://www.makeuseof.com/tag/gpeasy-simple-cms-no-database/
http://forums.digitalpoint.com/showthread.php?t=1073287
[2] Build your CMS http://css-tricks.com/php-for-beginners-building-your-first-simple-cms/


Plugins
[3] Rich text editor http://ckeditor.com/download

More resources:
https://www.cmscritic.com/top-10-simple-cms/

Cross-Domain & jsonp (java struts, php, asp.net mvc, otros )

Cross-Domain Proxy
En el caso de Ajax, por seguridad sólo se permite acceder al mismo dominio origen de la página web que realiza la petición. Si se necesita acceder a otros servicios localizados en otros dominios, se instala un Cross-Domain proxy en el dominio origen que recibe las peticiones ajax y las reenvia a los dominios externos.

Con jsonp es posible la llamada cross-domain, debido a que no es una llamada ajax sino una carga de un script js completo que lanza una función que definimos en la url y que actúa como callback.

Mientras que por motivos de seguridad es lógico que Ajax no funcione en dominios distintos al que lanza la web; con esta técnica JSON con Padding se genera un archivo JSON dinámicamente dejandolo abierto en el script que lo crea. Una variable que podemos definir nosotros mismos en la url será colocada antes del objeto Json, así al crear el script Json decidimos que variable "callback" usar.


Referencias

[1] jQuery y Strust
http://blog.pontt.com/json-con-java/generar-respuesta-en-java-struts-para-getjson-de-jquery/
[2] jQuery y php http://www.9lessons.info/2009/12/display-cross-domain-data-json-callback.html
[3] jQuery y Asp.Net Mvc (cross-domain JSON to ASP.NET MVC with jQuery)
http://www.integratedwebsystems.com/2010/07/cross-domain-jsonp-using-asp-net-mvc-and-jquery/
[4] cross-domain JSON to ASP.NET MVC with jQuery II
http://stackoverflow.com/questions/2022878/posting-cross-domain-json-to-asp-net-with-jquery
[5] Genericos(muy buenos)
http://www.ibm.com/developerworks/library/wa-aj-jsonp1/
http://ox.no/posts/ajast-cross-domain-rest-calls-using-json-injection
[6] Json to JsonP (easy)
http://www.codeproject.com/KB/aspnet/JSONToJSONP.aspx
http://www.codedigest.com/Articles/jQuery/310_Calling_a_WebService_using_jQuery_in_ASPNet.aspx
[7] Cross-site data retrieval using JSONP http://www.stpe.se/2008/10/cross-site-data-retrieval-using-jsonp/