Rhu
|
| Posted: 05/15/2003, 2:52 PM |
|
Hi
i downloaded the open-source jsp forum u have on this site n i managed to make it work with a mysql database. However when i configured the forum with an oracle database,i got the following error when i tried to post a message:
ORA-01861: literal does not match format string
i've found out that this is due to the fact that oracle uses different date formats from mysql.when i created the tables for the forum database, i had to use date format instead of datetimeformat which is supported in mysql but not in oracle.
does someone know how to solve this problem please?
|
|
|
 |
RonB
|
| Posted: 05/17/2003, 11:05 PM |
|
set the dateformat for the the oracle connection under settings. That should work.
Ron
|
|
|
|
Rhu
|
| Posted: 05/18/2003, 3:10 AM |
|
i quite new to all this and i don't really understand what u mean.could u please give me some details abt what has to be done?what settings are u referring to?
thanx
|
|
|
|
|
