Upgrading your iTouch or iPhone’s firmware from 1.1.2 to 1.1.3 is easy, thanks to the jailbreak team’s easy upgrade installer.

Open your installer.app and make sure that it’s version 3. If it’s not, upgrade it first. Once done, go to the sources icon, tap any source item in your list and tap on the add button on the top right. Add this link, http://www.touchrepo.com/repo.xml

Go to the install icon below and tap on it. Look for the iphone packages and select 1.1.3

Exit installer.app and look for the apple icon with prison bars behind it broken. Tap on that icon and let it do the rest for you (downloading the package, decompressing and installing). Automatic reboot will take place after installation is done and your firmware version will then be 1.1.3. Make sure your wifi connection is on or else it wont download the package upgrade installer.

Note: Be patient when the installer upgrades itself. it may take awhile. And makre sure you back up all your source list as the upgrade cleans everything including your installed 3rd party apps.

Configuring Apache HTTP Server with SSL is very easy. This post assumes that you already have a certificate file generated and signed. I will not discuss here how to generate your own one using the open source OpenSSL. This guide is intended for people who already have signed certificates from a security certificate company to be used in their websites.

First off, you must download the binary of Apache HTTP Server with SSL. Install/extract it to your desired folder. Now it’s time for some configuration. Go to the folder conf/ in your Apache folder and open the file httpd.conf . Look for this string LoadModule ssl_module modules/mod_ssl.so and remove the # sign to uncomment it.

Next, place these lines anywhere in the file.

<IfModule mod_ssl.c>
  Include conf/httpd-ssl.conf
</IfModule>

The file httpd-ssl.conf (or ssl.conf) is found in the extra/ folder in your conf/ folder. You can either move this file to your preferred directory or have it stay as is. You would have to change the path in the above tag to point it to the right path.

Now, let’s open up httpd-ssl.conf. Look for the following strings:
SSLCertificateFile
SSLCertificateKeyFile

Change the path to where you stored your .crt file and .key file. Sometimes your host provider may require you to also set a certificate chain file in order for SSL to work. Just look for the string SSLCertificateChainFile and change the path. The file usually has a substring of the word “bundle”.

Next, we set the DocumentRoot, ServerName, and ServerAdmin values. Look for this string VirtualHost and change the values. Your DocumentRoot must be the same path as the DocumentRoot path in httpd.conf if you wish to have the same pages in SSL. Your ServerName should point to your domain url e.g. www.domain.com. ServerAdmin can be left out as it is.

Save the files and restart Apache and point your site to https://domain:443/

If in case your server doesnt start because of this error:
Error: Init: SSLPassPhraseDialog builtin is not supported on Win32

Copy your encrypted key file using this command:
openssl rsa -in file1.key -out file2.key

file2.key will contain your unencrypted key. Use that key file in your httpd-ssl.conf settings.

Database connection pooling is not a new concept. Typically, one would want to apply this concept into their application when dealing with database connections. The old style of creating database connections from scratch, maintaining them and closing them upon finishing the request is a very expensive process and takes a heavy load on the server itself.

Apache Tomcat supports connection pooling. One advantage of pooling is that it reduces the garbage collection load. Using connections objects that are in the pool, we do not need to worry about memory leaks of sort.

Once we request a connection and close it, the connection object will be sent back to the pool and wait for other requests. Hence, we are actually going to use existing connection objects. If the pool has ran out of connection objects, it will create a new one and adds it up to the total number of connections inside the pool.

To enable connection pooling in java, you only need to add this tag in the context.xml in the conf/ folder of apache tomcat’s working folder.

<Resource name="jdbc/dbname"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
username="micmic"
password="micmic"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/dbname"
maxWait="1000"
removeAbandoned="true"
maxActive="30"
maxIdle="10"
removeAbandonedTimeout="60"
logAbandoned="true"/>

This tag must be inside the <context> tag.

To use this connection, you can have a method that looks similar to this

public static Connection getConnection() throws Exception {
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/dbname");
ds.getConnection();
}

And use that same method to get a connection object from the pool:

Connection con = getConnection();

When you close this connection object after use, it will not close the object and garbage collect. Rather, it puts it back in the pool for the next use.

Please note that this sample code uses the MySQL Database. If you use other databases, check the appropriate driver class for the JDBC driver and make sure that you include the JDBC driver library in Apache Tomcat’s lib/ folder.

Related Posts Plugin for WordPress, Blogger...