No subject

   JobQueue jq = getJobQueueEntry();
   String uid = jq.getField("ExpUid");
   User oneUser = new User();
   oneUser.setUid(uid);
   oneUser.setDBName(getDBName());
   oneUser.retrieve();
   Vector allUsers = oneUser.getAllUsers();

The call to getAllUsers creates this SQL error:

ORA-01861: literal does not match format string

Oracle is complaining since the select is being formatted with the where
clause including:

    CreateDate = '2000-04-16 06:57:42.0' AND
    UpdateDate = '2000-04-16 06:57:42.0' AND


Somehow how the timedateupdateformat is not being used.

It should have a TO_DATE wrapped around it.. Correct?

Its specified as

        dateTimeUpdateFormat="yyyy-MM-dd HH mm ss"
        dateTimeUpdateFunction="TO_DATE(%s,'YYYY-MM-DD HH24 MI SS')"
        dateUpdateFormat="yyyy-MM-dd"
        dateUpdateFunction="TO_DATE(%s,'YYYY-MM-DD')"
        timeUpdateFormat="HH mm ss"
        timeUpdateFunction="TO_DATE(%s,'HH24 MI SS')"

I read somewhere that about a year a ago the job handler was using the
configuration from the command line and not what was specified in
expresso-config.xml?????





_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com