Today we shall look into a nice feature on how to secure our JDBC connections. It’s generally a standard to make JDBC connections in java applications to connect to database. We mostly have web applications running in a web container. These web applications make JDBC connections to the databases to retrieve data for the applications. [...]
Archive for August, 2008
Network Data Encryption and Integrity for Thin JDBC Clients
Posted in JAVA, JDBC, tagged data encryption, encryption, JAVA, JDBC, security on August 29, 2008 | 6 Comments »
.Net Encryption and Oracle Decryption
Posted in .Net, PL/SQL, tagged .Net, C#, decryption, encryption, Oracle, PL/SQL, TripleDES on August 24, 2008 | 8 Comments »
Performing encryption and decryption using the same language might be straight forward and many resources can be found in this regard. But when it comes to across languages, mismatches appear even if you are using the same algorithm to encrypt and decrypt. One of the reasons for this is that each language has its own [...]
Encryption/Decryption in PL/SQL
Posted in PL/SQL, tagged dbms_obfuscation_toolkit, decryption, encryption, PL/SQL on August 21, 2008 | 2 Comments »
This may sound dumb and easy. However, I am sharing my experiences with encrypting data because it might be of help to someone.
The Oracle packages that can be used for encryption/decryption varies on the Oracle version.
DBMS_OBFUSCATION_TOOLKIT – Oracle 8i and above
DBMS_CRYPTO – Oracle 10.1 and above
I have recently used DBMS_OBFUSCATION_TOOLKIT and will [...]
“ROWNUM” in Oracle is equivalent to “TOP N” is SQLServer
Posted in SQL, tagged Oracle, rownum, SQL, SQLServer, top n on August 12, 2008 | 6 Comments »
Today a colleague of mine was trying to pick the top row in a result set on SQLServer, and we being Oracle Database fans could only think of ROWNUM. So here is what we found out after digging for some time.
Rownum is used in Oracle to retrieve the N-top records.
SELECT * FROM TABLENAME
WHERE ROWNUM<2
Note: Some [...]
MyEclipse and OC4J Container
Posted in MyEclipse, Oracle AS, tagged deployment, JAVA, MyEclipse, oc4j, web application on August 11, 2008 | 2 Comments »
One of the days at work, we had some requirements to deploy a java web application in an OC4J container (Oracle Container for Java). We are using MyEclipse as our development tool. We had easily integrated it with Tomcat for all the previous deployments. So, we thought it is going to be a cake walk. [...]
Journey of Mayhem
Posted in Random on August 10, 2008 | 2 Comments »
Today we start are journey of mayhem, learning and sharing our experiences in the ever growing field of technology. This blog was born with a purpose in mind to provide a centralized repository of knowledge which can be easily accessed and counted on at desperate times. We would like to share as we too have [...]
