File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes parsing logfile Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "parsing logfile" Watch "parsing logfile" New topic

parsing logfile

ranga shreya

Joined: Mar 05, 2005
Posts: 20
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. - - [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.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: parsing logfile
It's not a secret anymore!