RE: Problem configuring a global resource to be linked from Context elements ....
Hi, I think it is because of the way Tomcat classloaders work. Classes in common\lib or common\classes cannot see classes in WEB-INF\lib. DBCP looks for the JDBC Driver class and it cannot read it from WEB-INF\lib. This is the answer I got when I had similar problem. For further info on this you need help from experts in this list. If the problem is not solved please reply. Your thought is right -- the above is a good description. The ClassLoader hierarchy is just that, a hierarchy, meaning different visibility for different classloaders. It's described in detail the ClassLoader how-to, which I might rank at the #1 document all developers using Tomcat should read and understand. Yoav This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem configuring a global resource to be linked from Context elements ....
Thanks to all. The resource link problem has been solve with this recommendations you gave me, at the end I copied my database .jar to common/lib so all web application and the server can see it, what seems strange to me is that it used to work on Tomcat 4 without any copy task, but the solution you gave me goes according to the ClassLoader documentation so you were just rigth.. Thanks to all of you... Regards Jonathan M. Rengifo On Fri, 17 Sep 2004 08:10:13 -0400, Shapira, Yoav [EMAIL PROTECTED] wrote: Hi, I think it is because of the way Tomcat classloaders work. Classes in common\lib or common\classes cannot see classes in WEB-INF\lib. DBCP looks for the JDBC Driver class and it cannot read it from WEB-INF\lib. This is the answer I got when I had similar problem. For further info on this you need help from experts in this list. If the problem is not solved please reply. Your thought is right -- the above is a good description. The ClassLoader hierarchy is just that, a hierarchy, meaning different visibility for different classloaders. It's described in detail the ClassLoader how-to, which I might rank at the #1 document all developers using Tomcat should read and understand. Yoav This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Problem configuring a global resource to be linked from Context elements ....
Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Problem configuring a global resource to be linked from Context elements ....
Hi, Yoav. I have not yet solved my Tomcat 5.0.27 CP configuration problem. Yesterday, you said that the Tomcat log should not show it looked for MySQL driver when I am trying to connect to the Oracle 9i driver. It turned out that there is another application in the webapps looking for the MySQL driver. My current application does not look for the MySQL driver. A nice person really look into my configuration and my code and he said he does not see any obvious mistakes that other people have made. He is still helping digging into my CP configuration connection to the Oracle 9i. --- Shapira, Yoav [EMAIL PROTECTED] wrote: Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem configuring a global resource to be linked from Context elements ....
Had you tried it with inside Context element. If it doesn't work it means the JDBC driver is not found when Tomcat starts up. You have to put JDBC jar in CATALINA_HOME\common\lib. It can be placed in WEB-INF\lib if you place dbcp.jar too there. rgds Antony Paul - Original Message - From: Shapira, Yoav [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED]; Jonathan Rengifo [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 6:02 PM Subject: RE: Problem configuring a global resource to be linked from Context elements Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem configuring a global resource to be linked from Context elements ....
Hi all, and thanks for your support. I am using Tomcat 5.0.28, this is the latest version, so I really don't know if this is a real bug. Like I early wrote, I try to cut and paste the configured database resource from the GlobalNamingResources element to every context in which I need that database resource, and it just work fine, but I guess this is not the best way to do it, because I have a considerable amount of context and virtual host, I have the database .jar inside WEB-INF\lib inside my applications. Why this works when I copy the resource to every context, and doesn't work as a global resource when I link it through the ResourceLink element, like this: ResourceLink name=jdbc/app global=jdbc/app type=javax.sql.DataSource/ inside every context element I need... Thanks to all... Regards Jonathan On Thu, 16 Sep 2004 18:35:51 +0530, Antony Paul [EMAIL PROTECTED] wrote: Had you tried it with inside Context element. If it doesn't work it means the JDBC driver is not found when Tomcat starts up. You have to put JDBC jar in CATALINA_HOME\common\lib. It can be placed in WEB-INF\lib if you place dbcp.jar too there. rgds Antony Paul - Original Message - From: Shapira, Yoav [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED]; Jonathan Rengifo [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 6:02 PM Subject: RE: Problem configuring a global resource to be linked from Context elements Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem configuring a global resource to be linked from Context elements ....
Hi again and thanks to all... :D Antony, please can you tell what is dbcp.jar and where I can find it? so I can try your recommendation... Thanks... Jonathan On Thu, 16 Sep 2004 18:35:51 +0530, Antony Paul [EMAIL PROTECTED] wrote: Had you tried it with inside Context element. If it doesn't work it means the JDBC driver is not found when Tomcat starts up. You have to put JDBC jar in CATALINA_HOME\common\lib. It can be placed in WEB-INF\lib if you place dbcp.jar too there. rgds Antony Paul - Original Message - From: Shapira, Yoav [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED]; Jonathan Rengifo [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 6:02 PM Subject: RE: Problem configuring a global resource to be linked from Context elements Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem configuring a global resource to be linked from Context elements ....
Hi to all... Antony, sorry I have already found dbcp.jar and know what it does, but don't understand why I should copy it to my WEB-INF/lib application source ? On Thu, 16 Sep 2004 11:06:53 -0400, Jonathan Rengifo [EMAIL PROTECTED] wrote: Hi again and thanks to all... :D Antony, please can you tell what is dbcp.jar and where I can find it? so I can try your recommendation... Thanks... Jonathan On Thu, 16 Sep 2004 18:35:51 +0530, Antony Paul [EMAIL PROTECTED] wrote: Had you tried it with inside Context element. If it doesn't work it means the JDBC driver is not found when Tomcat starts up. You have to put JDBC jar in CATALINA_HOME\common\lib. It can be placed in WEB-INF\lib if you place dbcp.jar too there. rgds Antony Paul - Original Message - From: Shapira, Yoav [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED]; Jonathan Rengifo [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 6:02 PM Subject: RE: Problem configuring a global resource to be linked from Context elements Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem configuring a global resource to be linked from Context elements ....
The correct file name is commons-dbcp-1.1.jar and is found in CATALINA_HOME\common\lib directory. rgds Antony Paul - Original Message - From: Jonathan Rengifo [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 8:36 PM Subject: Re: Problem configuring a global resource to be linked from Context elements Hi again and thanks to all... :D Antony, please can you tell what is dbcp.jar and where I can find it? so I can try your recommendation... Thanks... Jonathan On Thu, 16 Sep 2004 18:35:51 +0530, Antony Paul [EMAIL PROTECTED] wrote: Had you tried it with inside Context element. If it doesn't work it means the JDBC driver is not found when Tomcat starts up. You have to put JDBC jar in CATALINA_HOME\common\lib. It can be placed in WEB-INF\lib if you place dbcp.jar too there. rgds Antony Paul - Original Message - From: Shapira, Yoav [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED]; Jonathan Rengifo [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 6:02 PM Subject: RE: Problem configuring a global resource to be linked from Context elements Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem configuring a global resource to be linked from Context elements ....
I think it is because of the way Tomcat classloaders work. Classes in common\lib or common\classes cannot see classes in WEB-INF\lib. DBCP looks for the JDBC Driver class and it cannot read it from WEB-INF\lib. This is the answer I got when I had similar problem. For further info on this you need help from experts in this list. If the problem is not solved please reply. rgds Antony paul - Original Message - From: Jonathan Rengifo [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 8:48 PM Subject: Re: Problem configuring a global resource to be linked from Context elements Hi to all... Antony, sorry I have already found dbcp.jar and know what it does, but don't understand why I should copy it to my WEB-INF/lib application source ? On Thu, 16 Sep 2004 11:06:53 -0400, Jonathan Rengifo [EMAIL PROTECTED] wrote: Hi again and thanks to all... :D Antony, please can you tell what is dbcp.jar and where I can find it? so I can try your recommendation... Thanks... Jonathan On Thu, 16 Sep 2004 18:35:51 +0530, Antony Paul [EMAIL PROTECTED] wrote: Had you tried it with inside Context element. If it doesn't work it means the JDBC driver is not found when Tomcat starts up. You have to put JDBC jar in CATALINA_HOME\common\lib. It can be placed in WEB-INF\lib if you place dbcp.jar too there. rgds Antony Paul - Original Message - From: Shapira, Yoav [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED]; Jonathan Rengifo [EMAIL PROTECTED] Sent: Thursday, September 16, 2004 6:02 PM Subject: RE: Problem configuring a global resource to be linked from Context elements Hi, Maybe there really is a bug in the Tomcat release you're using: which one are you trying? Yoav Shapira Millennium Research Informatics -Original Message- From: Jonathan Rengifo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:08 PM To: Tomcat User List Subject: Problem configuring a global resource to be linked from Context elements Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e
Problem configuring a global resource to be linked from Context elements ....
Hi all This is the third time I've write a message to the list asking for the same issue, but didn't solve it, I am starting to think about this is a really bug in Tomcat 5. My question is ... Why when I configure a Resource inside the GlobalNamingResources element just to ResourceLink it inside the context it just doesn't work, throwing an exception like this ... org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' This means to me that the oracle driver I am using is could no be found, but then, why when I cut the Resource and paste it inside every Context I use it just work fine???... Please help How do I configure this global resource?? Here is how I am setting this up... GlobalNamingResources Resource name=jdbc/app auth=Container scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/app parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@myDatabaseServer:port:user/value /parameter parameter namepassword/name valuemyPassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxWait/name value-1/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameusername/name valuemyUser/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams /GlobalNamingResources Thanks .. Jonathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]