Thanks. That was exactly what I was looking for.
Sunit
-----Original Message-----
From: Bruce Snyder [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 6:57 AM
To: [EMAIL PROTECTED]
Subject: Re: [castor-user] Castor connections
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
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
