Hi there, I am getting a appache logfile so I have to parse the file and and store it in a database table what are the steps involved here... i mean how to parse the log file. sample line from my log file. 220.127.116.11 - - [11/Mar/2005:11:05:27 -0500] "GET /tracker.html?retailer=Test+Retailer&order=xyz123&uniqueId=12345&sku=sku-00005&prodName=the%20greatest%20product%20in%20all%20the%20world&qty=1&unitPrice=15.25 HTTP/1.0" 200 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)"
Thanks,<br />Ranga.<br />Life is precious so enjoy the life each moment and utilise it at the same time.
Ranga, Before you go about trying to do this yourself, take a look at log4j's database appender. It looks like this is from a web server access log, rather than log4j, but you can still get some ideas.
Then you can decide on what your schema should be. For example, it looks like it would be useful to store the IP address, date/time, etc.