Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remote PID and process name for FB 2.1 monitoring tables [JDBC118] #158

Closed
firebird-automations opened this issue Jul 15, 2008 · 5 comments

Comments

@firebird-automations
Copy link

Submitted by: Thomas Steinmaurer (tsteinmaurer)

Assigned to: Roman Rokytskyy (rrokytskyy)

Is duplicated by JDBC334
Relate to JDBC225

Discussed with Roman in Firebird-java. Thread "Process name in monitoring tables with Jaybird?" from July 15th, 2008.

Jaybird should set the proper DPB so that the remote process ID and the remote process name is shown for Jaybird applications in FB 2.1 monitoring tables (MON$ATTACHMENTS). Regarding the remote process name, we came to the following solution:

* If a particular -D parameter is present, use this one

* If this particular -D parameter is NOT present:

- Use the classname with the entire package information, if it fits into DPB / VARCHAR(253).
- If it doesn't fit into that, make a substring of the class name from right to left.

Commits: 59d59e2

@firebird-automations
Copy link
Author

Modified by: Roman Rokytskyy (rrokytskyy)

Fix Version: Jaybird 2.1.6 [ 10285 ]

@firebird-automations
Copy link
Author

Commented by: Roman Rokytskyy (rrokytskyy)

The only platform independent solution turns out to be via the -D property, therefore two new properties: org.firebirdsql.jdbc.pid and org.firebirdsql.jdbc.processName. If they are specified, values are passed to Firebird 2.1. Also the behavior with previous versions of FB is undefined, so use them with care.

@firebird-automations
Copy link
Author

Modified by: Roman Rokytskyy (rrokytskyy)

status: Open [ 1 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Link: This issue is duplicated by JDBC334 [ JDBC334 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Link: This issue relate to JDBC225 [ JDBC225 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant