HOW TO Subversion+Apache on Fedora
January 29th, 20093 Comments | Filed Under: Tutorials
HOW TO Subversion+Apache on Fedora
To learn or use Subversion, please read the book.
To install subversion run below commands:
# yum install subversion
# yum install mod_dav_svn
Then you need to setup at least one repository to test it.
Here create the folders..
# mkdir /svn
# mkdir /svn/repos
# mkdir /svn/users
# mkdir /svn/permissions
repos – will contain all the projects
users – will contain all the user configs
permissions – will contain all the user permissions
We need to give these folders the proper permissions apache user permissions so that apache can write files on repos.
# chown -R apache.apache /svn
Then you can create repository using subversion cmd svnadmin.
# svnadmin create /svn/repos/project1
You can create multiple project repos under repos folder.
To setup apache server.
You may already have this subversion config file installed in conf.d folder otherwise you can create a new apache include file that will hold all configurations.
# vi /etc/httpd/conf.d/subversion.conf
This file need to contain something like this to serve the repository through apache:
LoadModule dav_svn_module modules/mod_dav_svn.so
LoadModule authz_svn_module modules/mod_authz_svn.so
<Location /svn/>
DAV svn
SVNPath /svn/repos
AuthType Basic
AuthName “Subversion Repository”
AuthUserFile /svn/users/passwords
Require valid-user
AuthzSVNAccessFile /svn/permissions/svnauthz.conf
</Location>
We need to create some files so that this config will work properly. The first is htpasswd file which will contain all the usernames nad passwords which i named “/svn/users/passwords”.
# htpasswd -cb /svn/users/passwords username password
Next you need to create the svnauth file.
# vi /svn/permissions/svnauthz.conf
Inside place a list of users who have access to files:
[/]
username = rw
The “rw” states that this user has read/write access to the root repository /.
Restart your web server and you should be done.
service httpd restart
Now you should access subversion repos as below.
http://www.websitename.com/svn/repos/
how to find the last insert id in java+mysql?
January 23rd, 2009One Comment | Filed Under: Tutorials
JDBC 3.0 (MySQL has a JDBC 3 compliant driver) method as such:
Stat.executeUpdate("Some insert statement here");
ResultSet rs = stat.getGeneratedKeys();
Int insertedKeyValue = rs.getInt(1);
Rs.close();
Stat.close();
How to Remove jsessionid from URL
December 31st, 20082 Comments | Filed Under: Tutorials
A "JSESSIONID" is the unique id of the http session – see the javadoc here.
When you start a HTTP session, the session ID is appended to the URL and a cookie is set. If the browser has cookies enabled, the JSESSIONID is not used on subsequent requests.
Here is a urlrewrite rule to get rid of it, substitute JSESSIONID for
the name of the parameter your app server uses to track sessions.
<name>Strip URL Session ID’s</name>
<from>^(.*?)(?:\;JSESSIONID=[^\?#]*)?(\?[^#]*)?(#.*)?
$</from>
<to encode="false">$1$2$3</to>
</outbound-rule>
Just be aware that removing the session id will make sessions not work
for clients that do not support cookies.