|
Home > Archive > Sybase Database > March 2006 > Use of "DbParm" String
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Use of "DbParm" String
|
|
|
| All - I've been trying to get more info. on the Sybase "DBParm" string that can be configured with
connectioin info when connecting to ASE 12.5.x. I have the basic docs from Sybase on this string,
but what I need to know is if there are ways to populate it from JDBC, Jconnect, Weblogic etc, as
well as supply the same or similar info when using ISQL for batch SQL or stored proc processing.
We want to take advantage of such parameters as "Application Name" and "Host" by supplying them,
and having them viewable when looking at the "sysprocesses" table during diagnostics.
Has anyone had success in using it in Java based services and from ISQL?
Any and all help appreciated.
Regards,
Arnold.
____________________
____________________
____
Regards,
Arnold
| |
| joeNOSPAM@BEA.com 2006-03-30, 8:23 pm |
|
mag3 wrote:
> All - I've been trying to get more info. on the Sybase "DBParm" string that can be configured with
> connectioin info when connecting to ASE 12.5.x. I have the basic docs from Sybase on this string,
> but what I need to know is if there are ways to populate it from JDBC, Jconnect, Weblogic etc, as
> well as supply the same or similar info when using ISQL for batch SQL or stored proc processing.
>
> We want to take advantage of such parameters as "Application Name" and "Host" by supplying them,
> and having them viewable when looking at the "sysprocesses" table during diagnostics.
>
> Has anyone had success in using it in Java based services and from ISQL?
>
> Any and all help appreciated.
>
> Regards,
> Arnold.
>
> ____________________
____________________
____
> Regards,
Hi. With WebLogic, you would simply add the appropriate jconnect driver
properties
to the properties list for the pool. For instance:
Properties=" user=sa;APPLICATIONN
AME=myWebLogicApp"
Then your query to sysdatabases should list every pool connection's
session's application name as 'myWebLogicApp'.
HTH,
Joe Weinstein at BEA Systems
> Arnold
|
|
|
|
|