RE: Getting the URL of a DataSource
Phil, I switched over to using BasicDataSource instead of DataSource and I'm able to get everything I need. I've tested it against 10 different Data Bases and everything seems to work wonderfully. Thank you for your response and help. I hope some day I can also help you! Regards, jfk. -Original Message- From: Phil Steitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:41 PM To: Tomcat Users List Subject: Re: Getting the URL of a DataSource On Mon, Mar 3, 2008 at 2:08 PM, Katilie, John [EMAIL PROTECTED] wrote: All, this may be a dumb question but I've exhausted my research and just wondering what other users out there are doing. I would like to get the URL for a DataSource to display for debugging and/or Informational reasons. I know I can get the URL after I get the DataSource and get a connection from the connection metadata. My problem is what if the Connection fails? It seems without the connection I can not get the URL for the DataSource. This is an application running under Tomcat 6.0.14. I guess I could get the URL from the JMX DataSource objects created by Tomcat (I can see them with jconsole). But is there another way? Am I missing something? I hope this question makes sense... I may get flamed for condoning hacking here, but there is a too-fragile-to-depend-on way to do this for debugging / testing. If the DataSource implementation that you are using exposes a getUrl method, and you really want to get this (or any other extended property) in application code, you can get the URL by specializing the cast on your JNDI lookup and then invoking that method. For example, if you are using the tomcat-provided DBCP DataSource, org.apache.tomcat.dbcp.dbcp.BasicDataSource ds = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) initContext.lookup(java:/comp/env/jdbc/yourDB); String urlString = ds.getUrl(); That obiously only works if you are using BasicDataSource bundled with Tomcat or if whatever datasource you use supports something like this (If you are using Commons DBCP directly, just change tomcat.dbcp to commons). It is not something you want to depend on, though, as all Tomcat or your DS provider really promises you is a javax.sql.DataSource. In particular, there is no guarantee that code such as the above will not start generating ClassCastExceptions or ClassNotFound when the container (Tomcat) or datasource provider release new versions. Phil Thanks for any and all comments. Regards, John. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Getting the URL of a DataSource
Phil, Thanks.. I'll take a look. jfk -Original Message- From: Phil Steitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:41 PM To: Tomcat Users List Subject: Re: Getting the URL of a DataSource On Mon, Mar 3, 2008 at 2:08 PM, Katilie, John [EMAIL PROTECTED] wrote: All, this may be a dumb question but I've exhausted my research and just wondering what other users out there are doing. I would like to get the URL for a DataSource to display for debugging and/or Informational reasons. I know I can get the URL after I get the DataSource and get a connection from the connection metadata. My problem is what if the Connection fails? It seems without the connection I can not get the URL for the DataSource. This is an application running under Tomcat 6.0.14. I guess I could get the URL from the JMX DataSource objects created by Tomcat (I can see them with jconsole). But is there another way? Am I missing something? I hope this question makes sense... I may get flamed for condoning hacking here, but there is a too-fragile-to-depend-on way to do this for debugging / testing. If the DataSource implementation that you are using exposes a getUrl method, and you really want to get this (or any other extended property) in application code, you can get the URL by specializing the cast on your JNDI lookup and then invoking that method. For example, if you are using the tomcat-provided DBCP DataSource, org.apache.tomcat.dbcp.dbcp.BasicDataSource ds = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) initContext.lookup(java:/comp/env/jdbc/yourDB); String urlString = ds.getUrl(); That obiously only works if you are using BasicDataSource bundled with Tomcat or if whatever datasource you use supports something like this (If you are using Commons DBCP directly, just change tomcat.dbcp to commons). It is not something you want to depend on, though, as all Tomcat or your DS provider really promises you is a javax.sql.DataSource. In particular, there is no guarantee that code such as the above will not start generating ClassCastExceptions or ClassNotFound when the container (Tomcat) or datasource provider release new versions. Phil Thanks for any and all comments. Regards, John. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Getting the URL of a DataSource
On Mon, Mar 3, 2008 at 2:08 PM, Katilie, John [EMAIL PROTECTED] wrote: All, this may be a dumb question but I've exhausted my research and just wondering what other users out there are doing. I would like to get the URL for a DataSource to display for debugging and/or Informational reasons. I know I can get the URL after I get the DataSource and get a connection from the connection metadata. My problem is what if the Connection fails? It seems without the connection I can not get the URL for the DataSource. This is an application running under Tomcat 6.0.14. I guess I could get the URL from the JMX DataSource objects created by Tomcat (I can see them with jconsole). But is there another way? Am I missing something? I hope this question makes sense... I may get flamed for condoning hacking here, but there is a too-fragile-to-depend-on way to do this for debugging / testing. If the DataSource implementation that you are using exposes a getUrl method, and you really want to get this (or any other extended property) in application code, you can get the URL by specializing the cast on your JNDI lookup and then invoking that method. For example, if you are using the tomcat-provided DBCP DataSource, org.apache.tomcat.dbcp.dbcp.BasicDataSource ds = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) initContext.lookup(java:/comp/env/jdbc/yourDB); String urlString = ds.getUrl(); That obiously only works if you are using BasicDataSource bundled with Tomcat or if whatever datasource you use supports something like this (If you are using Commons DBCP directly, just change tomcat.dbcp to commons). It is not something you want to depend on, though, as all Tomcat or your DS provider really promises you is a javax.sql.DataSource. In particular, there is no guarantee that code such as the above will not start generating ClassCastExceptions or ClassNotFound when the container (Tomcat) or datasource provider release new versions. Phil Thanks for any and all comments. Regards, John. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
