Author: Webner
Connection Pool with Tomcat6 and Mysql
Inside $tomcat_home/conf/context.xml add this inside <Context> <Resource name=”jdbc/datasourcename” auth=”Container” type=”javax.sql.DataSource” maxActive=”100″ maxIdle=”30″ maxWait=”1000″ username=”dbuser” password=”dbpwd” driverClassName=”com.mysql.jdbc.Driver” url=”jdbc:mysql://localhost:3306/exodus”/> Now restart tomcat Inside you web.xml add this before </web-app>: <resource-ref> <description>My DB Connection</description> <res-ref-name>jdbc/datasourcename</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> Java code to connect: Context
ORA-28001: the password has expired
That’s the error you get for oracle user for whom password is expired. One Solution – Connect using sqlplus to set new password, you can even use the same password you had earlier. $ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on
Oracle Privileges to Import/Export data into any tablespace
Generally we can have a single user with DBA rights to import/export (using imp/exp utilities) data into any tablespace instead of assigning these privileges to every user account. Suppose you have an oracle user appdba. Grant DBA role to appdba
Apache Config Steps – Run multiple domains on same ip
Suppose you want to point abc.mydomain.com and mydomain.com to same machine/ip, but to different applications. There are multiple ways to achieve this (basically with same config settings but in different files). I am giving one way here that worked for me: * Go to
Generating ssh keys – steps
These are the steps: Suppose you want to connect from machine X to machine Y as userme. * login to X as userme * At /home/userme run this command: ssh-keygen -t rsa This will generate 2 files in /home/userme/.ssh folder
Send email using gmail in Perl
Here’s sample code to send email via Gmail SMTP server, which uses TLS (transport layer security): #!/usr/bin/perl -w use Net::SMTP::TLS; my $mailer = new Net::SMTP::TLS( ‘smtp.gmail.com’, Hello => ‘smtp.gmail.com’, Port => 587, User => ‘gmail userid’, Password=> ‘gmail password’); $mailer->mail(‘from@domain.com’);
Installing Perl Modules – Ubuntu
Execute this command on a command line: sudo perl -MCPAN -e shell It will install CPAN if not already installed. Then it will take you to CPAN prompt. On CPAN prompt, execute this command to install Perl module: CPAN> install
Android Jumble Challenge
Jumble Challenge has seen a really good start with more than 115 downloads in initial few days of launch. If you like to unjumble words this is the game for you. With 3 different levels Jumble Challenge is ideal for
mongod cannot execute binary file
mongod: cannot execute binary file Most probable reason – you are using 64-bit mongodb, switch to 32-bit for quick solution….or find the compatible 64 bit package