File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Oracle identify sql statement from servlet or jsp
Joined: Oct 11, 2009
Mar 13, 2010 03:43:45
that does someting in database(dml) be written in such a manner that i can identify from database the source of the sql?
Joined: Sep 29, 2008
Mar 13, 2010 06:29:51
SQL is SQL. If you want something different to happen depending on where something is being executed from you'd have to write it that way.
Joined: Oct 08, 2003
Mar 13, 2010 12:03:00
There's nothing to stop you from putting whatever you like into a comment as part of the SQL staements being issued:
SELECT /* This is freds SQL */ * FROM emp;
If you can get access to the SQL statements the database knows about you can find *your* sql fairly easy.
If your database is Oracle you should google the following:
Orinda Software, Dublin Ireland.
Web Service Generator for Oracle.
I agree. Here's the link:
subject: Oracle identify sql statement from servlet or jsp
Marcus Green: incorrect answer?
calling bean in servlet
Error java.sql.SQLException: ORA-00923
OLAP - how to ?
None of my servlets are available
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015