Re: ApplicationName and WorkstationID

Wes Clark said (on or about) 12/18/2006 10:36:
In Java, how can I dynamically modify the applicationName property of the connection after the connection is established, and after I get it from the connection pool?


something like

public class MyConnection implements Connection{
private Connection myConn = null;
private String applicationName;
public MyConnection ( String driverClassName, String login){
// construct myConn using driverClassName, login, etc
}

public void setApplicationName(String appName){
applicationName = appName;
}

//=== implement all the methods of the Connection interface
// by passing them down to myConn


}

You would also need to implement the special methods to use the application name.

Then in your application you can have
Connection appConn = new MyConnection(params...);
And use appConn just as you would any other implementation of the
Connection interface


"DGA" wrote:

Wes Clark said (on or about) 12/17/2006 15:01:
I see how I can set the application name and workstation ID in the JDBC URL. I'd like to be able to supply information such as end user name and workstation ID dynamically to the connection I get from the connection pool. I'm pretty sure you can do this in .Net. Is there any way now, or planned, to extend the JDBC Connection class to support this?
The java.sql.Connection interface specification is part of the JDBC
specification. Modifications to the specification are handled via
the Java Community Process -- you can get all the details at:
http://java.sun.com/products/jdbc/download.html

If you have a need for a Java class that provides that functionality,
you might consider implementing your own WesConnection wrapper class
around whatever underlying Connection implementation you are using.

Or you can make it part of your application's code.

.

Relevant Pages

  • Re: Using a Linked Table
    ... > myConn is a connection object. ... connection was opened before attempting the link I get the same error. ... Set objCat = New ADOX.Catalog ... Set objTbl = New ADOX.Table ...
    (microsoft.public.vb.database.ado)
  • Re: How to close connection?
    ... If you are going to dispose the connection, then that will cause it to be ... Dim myConn As New SqlConnection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection Problem
    ... with the friend modifier which is visible thoroout the assembly, ... local one with the CreateConnection subroutine which goes out of scope after ... myConn = New SqlConnection) ... > establish a connection to an SQL Server from an ASP.NET page ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DB connections not closed fast enough?
    ... Connection 50 times inside a loop. ... Connection class is still re-created each time through the loop. ... > StringBuilder sbsql = new StringBuilder; ... > MySqlConnection myConn; ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO connections question
    ... Function CreateADOObjects(ConnectionString as string) ... you'll see this error if the connection has not been ... I have a specific login form that calls the dbLogin function as shown ... Dim strCriteria As String ...
    (microsoft.public.access.adp.sqlserver)
Loading