-
The ibatis documentation provides a sample on how to call a procedure, but how do you call a function in Oracle? The code sample shows it. <parameterMap id=”getSomeFunction” class=”java.util.Map” > <parameter property=”question1″ jdbcType=”INTEGER” javaType=”java.lang.String” mode=”OUT”/> <parameter
-
This tutorial is based on the “send mail with PHP” tutorial is basic and the dispatch to the BCC and CC recipients explain. Furthermore, additional header information such as sender, reply-to address or specifying a destination address for errors when sending mail addressed. As in the tutorial Basic to read the features expected for at least
-
Encryption methods such as RSA, only to protect the confidentiality of a message. In addition to the actual signature to protect the confidentiality you need another method, the author of a message proved to be documented. Usually this is done using cryptographic checksums, so-called hash functions. These are mathematical methods, from any plaintext
New features are on the way!
Never fear, D.J. here, and I’d like to announce some of the new things coming up at quadzilla.com. First and foremost, I’d like to thank the thousands of web developers who have visited my site. What started out as a list of links to other sites has evolved into what I’d like to think is one of the best HTML resources on the Net. MORE…
Quick Reference
Here is quick reference of Style Sheet Definitions. Here some mostly used attributes are mentioned. MORE…
Colors/Margins/Alignment/Indentation
Colors
This sets the type to a named color or RGB value:
{color: #33CC00}
or
{color: name}
The names are:
| Black | Maroon | Green | Olive |
| Navy | Purple | Teal | Gray |
| Silver | Red | Lime | Yellow |
| Blue | Fuchsia | Aqua | White |
Saving precious build time
Normally before deploying(copying) an app to the server to view changes/testing using ant, there are lots of stuffs being done. A lot of them might not been necessary since only a small change has been made in a file, therefore only that file need to be uploaded. If you are using xdoclet for struts, hibernate or other autogeneration needs, changes not related to the latter shouldn’t trigger all the xdoclet ‘magic’ stuff. MORE…
Email server IMAP, POP & SMTP
Just finished setting up my old pc to windows xp which i used for the whole duration in university. I want my own mail, ftp, ssh, cvs and web server. I just got mail server installed. After googling around, i saw pegasus, but dismissed it thinking it was only a mail client and Mecury, was only a MTA like sendmail. After googling more, about.com had a comparison on pegagus listing smtp, pop and imap support.
Upgraded to Roller 1.0
just upgraded to roller 1.0, the site was down quite a while, thought it was a temporary shutdown due to technical issue, and suddenly today,
whoa! new roller app :). Cool!
MORE…
J2EE container marking a class as unavailable, good or bad?
I spent another frustrating 1/2 day trying to fix a ‘problem’ , a NoClassDefFound. Initially was only deploying the class to web directory then decided it need to be in the ejb classpath too, put it there, still to no avail, touched the file so that it will be updated and hope that it works, to no avail. I must have a missed an ibatis misconfiguration done by a new developer in the office but showed when i was running the app, because using oc4j, it will only show once the error and ‘marks’ the class as unavailable. Subsequently running the app, bloody NoClassDefFound error keeps coming up. Looked at log files, seeing the last few lines, it was the reporting the same thing as the error page generated by oracle.
MORE…
Home renovation [not Java]
Been busy last week and this week preparing the house. Removing parquet from the bedroom, it’s quite hot at night, because of the direct sun coming through the windows of the bedrooms and the wood soaking the heat. Started removing parquet on wednesday night, slowly prying it off from the floor. However couldn’t do much because they were quite firmly stuck to the ground. Soaked the floor with water, for a few days, then on saturday from 10am to 2.30 pm managed to remove about 2/3 of the master bedroom parquet. I wanted to get all parquet removed by evening however the progress was too slow, it wouldn’t have finished even by sunday evening with my hand swollen a little. Called my uncle to get a couple of his workers on sunday afternoon, we did the whole removing thing , which finished at 6 in the evening.
Calling an Oracle procedure function using Ibatis
The ibatis documentation provides a sample on how to call a procedure, but how do you call a function in Oracle? The code sample shows it.
<parameterMap id=”getSomeFunction” class=”java.util.Map” >
<parameter property=”question1″ jdbcType=”INTEGER” javaType=”java.lang.String” mode=”OUT”/>
<parameter property=”question2″ jdbcType=”VARCHAR” javaType=”java.lang.String” mode=”IN”/>
<parameter property=”question3″ jdbcType=”INTEGER” javaType=”java.lang.String” mode=”IN”/>
<parameter property=”question54″ jdbcType=”VARCHAR” javaType=”java.lang.String” mode=”IN”/>
<parameter property=”question5″ jdbcType=”VARCHAR” javaType=”java.lang.String” mode=”IN”/>
</parameterMap>
<procedure id=”getSomeFunction” parameterMap=”getSomeFunction”>
{? = call FNC_EXECUTE_SOME_FUNCTION(?, ?, ?, ?)}
</procedure>
Net8 Connection Manager to connect to Remote Database
Finally I managed to connect to the remote database using Oracle Connection Manager, after struggling for almost a week. The requirement requires the Oracle connection and firewalls. A remote Oracle client making a connection to an Oracle database can fail if there is a firewall installed between the client and the server if port redirection is taking place.The firewall will block the connection to the new port when the Oracle client connects to the database ORA12203 or ORA-12535 or ORA-12564. The client connection failure is due to port redirection from the Database Server‘s operating system. Port redirection requires the client to connect to the database using a different port than originally configured in the configuration files. Actually, it is not difficult if you know but overall took me few days ding dong here and there trial and error where to place the CMAN and wat IP address to use. Many thanks to Prince Amin who show me the Network Structure and advice me to place the CMAN at the Remote Site. I was blur at that time. Two heads is better than One !!!! Prince Amin, I owe you dude…..
MORE…