Kavathekar, Sunit wrote:
Sorry about the html. It was not intentional. The "module logon" I mentioned is just a stored procedure call that identifies the session to the db owner (who may be monitoring usage).
For example :
private void logon(int db) throws SQLException { String appName = System.getProperty("appName", "UnknownApp"); String programName = DB_MODULE_PREFIX + appName; String programParentName = ""; String programArguments = "";
CallableStatement logon = connections[db].prepareCall("begin module_logon(? , ? , ? , ? , ? , ?); end;");
logon.setString(1, programName); logon.setString(2, programParentName); logon.setString(3, programArguments); logon.registerOutParameter(4, java.sql.Types.INTEGER); logon.registerOutParameter(5, java.sql.Types.INTEGER); logon.registerOutParameter(6, java.sql.Types.INTEGER);
logon.execute();
etc...........
Sunit,
If you just need a java.sql.Connection, this is attainable from the Castor Database object like so:
Connection conn = (Connection) ((DatabaseImpl)_db).getConnection();
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\\"F9E<G)E=\\$\\!F<FEI+F-O;0\\`\\`");'
The Castor Project http://www.castor.org/
Apache Geronimo http://incubator.apache.org/projects/geronimo.html
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
