Avalon Apache Database configuration

[Priya Soparkar]

Hi,
Can someone send me the detailed configuration required for logging messages into 
MySQL database using Avalon logkit  ? 
 
I could successfully log messages into file .
 
When i specify 
 
<target>
 <jdbc id="database">
        <datasource>java:/LogTargetDataSource</datasource>
        <normalized>true</normalized>
        <table name="log">
       <time>TIME</time>
       <priority>PRIORITY</priority>
       <category>CATEGORY</category>
       <message>MESSAGE</message>
       <throwable>THROWABLE</throwable>      
       <hostname>HOSTNAME</hostname>
     </table>
  </jdbc>
</target>
It gives me "org.apache.avalon.framework.configuration.ConfigurationException: Cannot 
lookup data source"  Exception .
 
I have already created a table named "log" in my "MySQL" database.
 

Please correct me if i am missing some settings of setting something wrong .
Any pointers on this will be a great help .
 
 
Thanks,
Priya
 





                
---------------------------------
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger