Oracle with PHP Doctrine Issues.

We had some issues with a PHP Doctrine deployment, one of which included a “ORA-01861: literal does not match format string.” message. We made a quick fix by changing the date fields into varchar but the proper fix is mentioned below:

Most likely “ORA-01861: literal does not match format string.”
happened because date format in database and doctrine is not the same.
In oracle default date format depends on your installation and most
likely it looks like this: 21-JUN-2009. So when doctrine inserts
atable object, it tries to set CREATED_AT column using ‘Y-m-d H:i:s’
format and you get an exception. To get around this problem you can
create connection listener that sets default date format on connect:
ALTER SESSION SET NLS_DATE_FORMAT=’YYYY-MM-DD HH24:MI:SS’ or
$connection->setDateFormat(). Ideally doctrine should automatically
set oracle date on connect.

Thanks Vadik56
http://groups.google.com/group/doctrine-user/browse_thread/thread/78d1d33576ab905f

Also it was pretty difficult to find the proper format of the oracle connection string, working example:

in config

dsn: oci://[user]:[password]@[server_url]/(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL=TCP)(HOST = [server_url])(PORT=1521))) (CONNECT_DATA=(SID=[namespace])))

or in code

doctrine.connection_string =
“oci://[user]:[password]@[server_url]/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[server_url])(PORT=1521))) (CONNECT_DATA=(SID=[namspace])))”

Thanks Bertrand
http://forum.symfony-project.org/index.php/m/71601/
and
http://www.doctrine-project.org/Doctrine_Connection_Oracle/1_1#method_setdateformat

To monitor queries, add an event listener:

$profiler = new Doctrine_Connection_Profiler();
$conn = Doctrine_Manager::connection();
$conn->setListener($profiler);

…
foreach ( $profiler as $event ) {
echo $event->getQuery();
}
…

http://stackoverflow.com/questions/841950/doctrine-profiler-does-not-catch-queries

How To : Reset the Validation Rules on a Dynamic Form (JQuery + Validation Plugin)

I created an application which handles requests, after choosing a request type the form fields are fetched and a form is generated. It’s completely AJAX based, thus the page is never refreshed. I ran into a problem though, rules from previous form generations persisted between request changes. The answer is simple, add an empty “rules” property to the validate() call. Note that internally the Validate plugin stores the form validation information in the JQuery data space so my first shot was to erase this data, which didn’t work.

—————- code snippet from jquery.validate.js —————-

line 35 $.data(this[0], ‘validator’, validator);

—————- code snippet —————-
…
myform.validate({
rules: {}, // REQUIRED TO RESET THE RULES LIST!!
onkeyup: false,
onfocusout: false,
onclick: false,

submitHandler: function(form) {
…

—————- ajax-based validation method example —————-

jQuery.validator.addMethod(“validatepair”, function(value, element) {

var checkresult = false;
$.ajax({

url: “validation_url”,
async: false, // important!
data: {
“value1″:$(‘#value1id’).val(),
“value2″:$(‘#value2id option:selected’).val()

},
dataType: “jsonp”,
success: function(data){
checkresult = data.valid;
}

});

return checkresult;
}, “Value1 does not match with the choosen value2 option.”);

About the Title!

A little background info on the title. I am a big fan of a British TV series called Bottom!

Eddie: Well, at least we got the duck.
Richie: The duck?
Eddie: Yeah, it’s made out of plastic.
Richie: Eddie, what in the name of Greek buggery is the use of a plastic duck??
Eddie: It floats in the bath.
Richie: Yes, but why?
Eddie: It’s hollow!
Richie: *sighs* Why the duck??
Eddie: It came free with the telly!
Richie: Eddie everything came free with the telly, we were looting! Why couldn’t you get a free telly with the telly?
Eddie: Well it would sink in the bath!

[Bottom - Episode: Carnival]