jdbc-query tracing/logging

There are a lot of solutions given in this group but I think they are
not exactly what I need/want.

I have a Linuxserver (Ingres 2.6). A remote client can query the
databases on this server through a JDBC-connection.
This client is a complete blackbox. I only know that it can shoot
queries. I do not have any idea what kind of queries.
Now they want me to limit the output so that the client can't select
the whole 3,5 GB dataset.

The problem is offcourse that I first have to know what kind of queries
the client is going to shoot at my databases before I can decide if a
limit has to be set at all. And if a limit has to be set I want to be
able to decide what kind of limit I have to set.

The JDBC-connection is only possible through one user.

What is the best way to trace al the queries this client shoots at the
server?

printqry and use a pipe to redirect all the sessions to one file?
(where do I have to set up the pipe? In the .bashrc from the user the
JDBC-connection uses? I'm used to VMS, so Linux is a bit new)

use some kind of audting?

Thanks for any advice!

Erwin

.

Relevant Pages

  • Re: Can I AutoSize (or Fit) merged, variable data within a text bo
    ... for the messages as these are created through the queries in the background. ... message" directly in a small font, each designed to fit the text. ... The problem became a problem when my client decided that they no longer ... PrintShop Mail is made for this kind of gig but it's ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Performance Improvements: Hardware vs. DB Design
    ... > I recently designed & developed a data warehouse for a client of ours. ... > database with a substantial amount of data, ... I think many companies are inclined to add more server ... the queries, revise the indexes if necessary, and verify the reporting ...
    (microsoft.public.sqlserver.server)
  • Re: Can I AutoSize (or Fit) merged, variable data within a text bo
    ... If you are getting the texts through queries, you may be able to get the ... message" directly in a small font, each designed to fit the text. ... needed to change these to my PrintShop Mail software. ... The problem became a problem when my client decided that they no longer ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Speed problem
    ... only at one client, their several invoices, etc. ... However, on the network, some things are happening at ... they do bring together a buncha tables via queries). ... mostly on the terminals). ...
    (comp.databases.ms-access)
  • Re: Travel days and rates
    ... client had booked in the past, but had a history of moving their dates ... On the friday afternoon before we were to start production, ... day cancellation fee, and hung up to salvage as many of the passed-on ... decided they needed to shoot next week after all. ...
    (rec.arts.movies.production.sound)