Re: No valid JdbcConnection class available with MySQL
On Monday, June 2, 2003, at 07:47 AM, Geoff Howard wrote: Not even by the name of the jar? For instance, in 2.0.x for jdk1.4 the excalibur datasource jar is called excalibur-datasource-vm14-20021121.jar. The vm14 stands for virtual machine version 1.4 and I think the other is called *vm12*. You're right. I don't know how I missed that. That's the only one that's different though. Does that mean the rest of the libraries are the same? It would sure have been a lot easier to swap one .jar file than to reinstall Cocoon. Thanks again, -- Austin = Things that never before had names are now easily described. Makes conversation easy! --David Byrne, True Stories - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: No valid JdbcConnection class available with MySQL
At 01:39 PM 6/2/2003, you wrote: On Monday, June 2, 2003, at 07:47 AM, Geoff Howard wrote: Not even by the name of the jar? For instance, in 2.0.x for jdk1.4 the excalibur datasource jar is called excalibur-datasource-vm14-20021121.jar. The vm14 stands for virtual machine version 1.4 and I think the other is called *vm12*. You're right. I don't know how I missed that. That's the only one that's different though. Does that mean the rest of the libraries are the same? It would sure have been a lot easier to swap one .jar file than to reinstall Cocoon. I'm not certain but don't think that it's the only difference. It should be the only different jar in the lib directory - but at various points there has been conditional compilation in the cocoon classes themselves. It wasn't always so, and I don't think it's so now (in 2.1 HEAD). If you're curious though, I'd love to find out what happens if you take that route! Geoff - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
No valid JdbcConnection class available with MySQL
I'm just getting started with Cocoon and trying to get the database connectivity part working with MySQL. I set up the database, set up the configurations in web.xml and cocoon.conf and installed the MySQL driver, but when I try to run it I get the following error: org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get the datasource org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class available I do have the driver in the WEB-INF/lib folder. I've tried two different versions (mm.mysql-2.0.12-bin.jar and mysql-connector-java-3.0.6-stable-bin.jar), both of which work with other Tomcat webapps on the same machine. I have also checked to see if there is a JdbcConnection class in the classpath, and found it to be in the same jar file as the NoValidConnectionException class that is returning the error, so I really can't see how the JdbcConnection class could be unavailable. If I enter the wrong password in the datasource description in cocoon.xconf, I get an Invalid authorization specification error instead. It seems to me that in order to get this type of error, cocoon must be talking to the database, but that would be impossible if it had no valid JdbcConnection class, right? Or am I misunderstanding how these things work? I'm running this on Mac OS X, 10.2.6, JDK 1.4.1, MySQL 4.0.12, Cocoon 2.0.4, Tomcat 4.1.18, Apache 1.3.27. -- Austin Money isn't the most important thing in the world, but it's way ahead of whatever's in third. --Dick Messenger - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: No valid JdbcConnection class available with MySQL
check through the logs in WEB-INF/logs and the tomcat logs as well for errors reported in instantiating the connection at startup. Typically this problem has come down to one of the following: - permissions in mysql (is your user permitted to connect from localhost/ip?) - the driver not being declared in web.xml - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa - something else that escapes me Any of that help? Geoff Howard -Original Message- From: Austin Tashis [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2003 9:31 AM To: [EMAIL PROTECTED] Subject: No valid JdbcConnection class available with MySQL I'm just getting started with Cocoon and trying to get the database connectivity part working with MySQL. I set up the database, set up the configurations in web.xml and cocoon.conf and installed the MySQL driver, but when I try to run it I get the following error: org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get the datasource org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class available I do have the driver in the WEB-INF/lib folder. I've tried two different versions (mm.mysql-2.0.12-bin.jar and mysql-connector-java-3.0.6-stable-bin.jar), both of which work with other Tomcat webapps on the same machine. I have also checked to see if there is a JdbcConnection class in the classpath, and found it to be in the same jar file as the NoValidConnectionException class that is returning the error, so I really can't see how the JdbcConnection class could be unavailable. If I enter the wrong password in the datasource description in cocoon.xconf, I get an Invalid authorization specification error instead. It seems to me that in order to get this type of error, cocoon must be talking to the database, but that would be impossible if it had no valid JdbcConnection class, right? Or am I misunderstanding how these things work? I'm running this on Mac OS X, 10.2.6, JDK 1.4.1, MySQL 4.0.12, Cocoon 2.0.4, Tomcat 4.1.18, Apache 1.3.27. -- Austin Money isn't the most important thing in the world, but it's way ahead of whatever's in third. --Dick Messenger - 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: No valid JdbcConnection class available with MySQL
On Sunday, June 1, 2003, at 01:57 PM, Geoff Howard wrote: check through the logs in WEB-INF/logs and the tomcat logs as well for errors reported in instantiating the connection at startup. The cocoon error log just contains the same error message that's displayed in the browser. Tomcat is not having a problem with the database as other webapps are currently using it with no difficulty. Typically this problem has come down to one of the following: - permissions in mysql (is your user permitted to connect from localhost/ip?) Yes, I am using the same username/password as the other webapps, and they are working fine. Also, I can change the user info and produce an authentication error, so this is clearly a different problem. - the driver not being declared in web.xml It is. - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa This is a possibility. I'm pretty sure I downloaded the right one, but I could be wrong--at least it's something I can double-check. Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ - something else that escapes me Let me know if you recapture it. ;-) Any of that help? Possibly. I'll let you know. At any rate, thank you very much for replying! -- Austin The goal of Computer Science is to build something that will last at least until we've finished building it. --Unknown - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: No valid JdbcConnection class available with MySQL
check through the logs in WEB-INF/logs and the tomcat logs as well for errors reported in instantiating the connection at startup. If it's not already, you may want to set error level to info or debug - you may see more information. The cocoon error log just contains the same error message that's displayed in the browser. Tomcat is not having a problem with the database as other webapps are currently using it with no difficulty. But cocoon could be causing tomcat to log there during its startup. Unless you're trying to use a tomcat-managed database pool -- that would be a different set of things to look at. - the driver not being declared in web.xml It is. Can you paste your snippet? - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa This is a possibility. I'm pretty sure I downloaded the right one, but I could be wrong--at least it's something I can double-check. Yes, check. Which jdk are you using? I guess this also means that you're using 2.0.x, since 2.1 doesn't have a binary options (precisely because of problems like this among other reasons) Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ You may need to delete the cocoon stuff out of tomcat's work directory. Geoff - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: No valid JdbcConnection class available with MySQL
Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ Try using the web-based manager. First remove it, then delete the dir. The manager is at /manager/html. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: No valid JdbcConnection class available with MySQL
On Sunday, June 1, 2003, at 03:53 PM, Scott McClure wrote: Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ Try using the web-based manager. First remove it, then delete the dir. The manager is at /manager/html. Okay, I tried removing it: http://localhost:8080/manager/remove?path=/cocoon -- OK - Removed application at context path /cocoon Then I removed the old war file, removed the directories from webapps and work, put the new cocoon.war file in the webapps folder, restarted Tomcat and requested the application. The request timed out and nothing happened in the webapps folder--no new cocoon folder. So I tried to install it from the manager: http://localhost:8080/manager/install?path=/cocoonwar=file:/cocoon.war -- FAIL - Application already exists at path /cocoon So I ran the remove command again: http://localhost:8080/manager/remove?path=/cocoon -- OK - Removed application at context path /cocoon Then ran the install command: http://localhost:8080/manager/install?path=/cocoonwar=file:/cocoon.war OK - Installed application at context path /cocoon But nothing seemed to happen in the webapps folder. So I requested it again. The request timed out again. -- Austin = I think a good gift for the president would be a chocolate revolver. And since he's so busy, you'd probably have to run up to him and hand it to him. -- Jack Handey - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: No valid JdbcConnection class available with MySQL
On Sunday, June 1, 2003, at 03:14 PM, Geoff Howard wrote: If it's not already, you may want to set error level to info or debug - you may see more information. It is, but there are no database related messages The cocoon error log just contains the same error message that's displayed in the browser. Tomcat is not having a problem with the database as other webapps are currently using it with no difficulty. But cocoon could be causing tomcat to log there during its startup. Unless you're trying to use a tomcat-managed database pool -- that would be a different set of things to look at. I don't see anything unusual in the logs, except that HSQLDB is running. I had assumed it wasn't working because I couldn't connect to it either. - the driver not being declared in web.xml It is. Can you paste your snippet? init-param param-nameload-class/param-name param-value !-- For MySQL Driver: -- com.mysql.jdbc.Driver !-- org.gjt.mm.mysql.Driver -- /param-value /init-param The one that's commented out is for the older driver. I've tried both of them with the newer driver with the same result. - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa This is a possibility. I'm pretty sure I downloaded the right one, but I could be wrong--at least it's something I can double-check. Yes, check. Which jdk are you using? 1.4.1 I guess this also means that you're using 2.0.x, since 2.1 doesn't have a binary options (precisely because of problems like this among other reasons) Yes, I'm using 2.0.4. If I were using 2.1 I'd probably be asking for help getting it to build. :-/ Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ You may need to delete the cocoon stuff out of tomcat's work directory. It didn't help. -- Austin = A Jedi's strength flows from The Source. But beware of the dark side. COM... DCOM... VB... ActiveX... ADO... ASP... .NET The dark side of The Source are they. Easily they flow, quick to join you in a project. If once you start down the dark path, forever will it dominate your destiny, consume you it will. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: No valid JdbcConnection class available with MySQL
Are the samples still in tact (I assume they are since this is binary dist)? If so, can you confirm that the database samples (which use hsql) are working, or do you get the same error? If so, I'd guess that you may be using a jdk 1.2/3 version of the excalibur database package. Do a directory listing of your WEB-INF/lib - any jdk dependant jars should give some clue as to which version they are. Geoff -Original Message- From: Austin Tashis [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2003 8:26 PM To: [EMAIL PROTECTED] Subject: Re: No valid JdbcConnection class available with MySQL On Sunday, June 1, 2003, at 03:14 PM, Geoff Howard wrote: If it's not already, you may want to set error level to info or debug - you may see more information. It is, but there are no database related messages The cocoon error log just contains the same error message that's displayed in the browser. Tomcat is not having a problem with the database as other webapps are currently using it with no difficulty. But cocoon could be causing tomcat to log there during its startup. Unless you're trying to use a tomcat-managed database pool -- that would be a different set of things to look at. I don't see anything unusual in the logs, except that HSQLDB is running. I had assumed it wasn't working because I couldn't connect to it either. - the driver not being declared in web.xml It is. Can you paste your snippet? init-param param-nameload-class/param-name param-value !-- For MySQL Driver: -- com.mysql.jdbc.Driver !-- org.gjt.mm.mysql.Driver -- /param-value /init-param The one that's commented out is for the older driver. I've tried both of them with the newer driver with the same result. - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa This is a possibility. I'm pretty sure I downloaded the right one, but I could be wrong--at least it's something I can double-check. Yes, check. Which jdk are you using? 1.4.1 I guess this also means that you're using 2.0.x, since 2.1 doesn't have a binary options (precisely because of problems like this among other reasons) Yes, I'm using 2.0.4. If I were using 2.1 I'd probably be asking for help getting it to build. :-/ Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ You may need to delete the cocoon stuff out of tomcat's work directory. It didn't help. -- Austin = A Jedi's strength flows from The Source. But beware of the dark side. COM... DCOM... VB... ActiveX... ADO... ASP... .NET The dark side of The Source are they. Easily they flow, quick to join you in a project. If once you start down the dark path, forever will it dominate your destiny, consume you it will. - 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: No valid JdbcConnection class available with MySQL
On Sunday, June 1, 2003, at 09:19 PM, Geoff Howard wrote: Are the samples still in tact (I assume they are since this is binary dist)? If so, can you confirm that the database samples (which use hsql) are working, or do you get the same error? If so, I'd guess that you may be using a jdk 1.2/3 version of the excalibur database package. I don't remember what the error was, but I never did manage to get the HSQLDB examples to work before, but I didn't worry too much about it because I needed to get JDBC working anyway. Anyway, I finally got the newer version to install and copied all the files I'd changed into it, and now it's WORKING! Both the HSQLDB examples and the MySQL example. So it must have been the JDK 1.3 version I'd been using. Good call. Do a directory listing of your WEB-INF/lib - any jdk dependant jars should give some clue as to which version they are. Now that I've got both versions here, I don't see any way to tell the two apart by inspecting the .jar files in WEB-INF/lib. It might be a good idea to write up a FAQ and make the two lib versions available for download. It would sure be easier to replace the lib directory than try to reinstall Cocoon. That was a real pain! Thanks very much for your help, and Scott too. You've been very helpful. -- Austin = A computer lets you make mistakes faster than any other invention in human history, with the possible exception of handguns and tequila. --D.W. McArthur - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: No valid JdbcConnection class available with MySQL
Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ I ran into this problem, too. I finally found it was only a permissions problem. You should check, if you granted read and execute rights on the war to your tomcat process. Maybe just chown it to the tomcat user. -- _ Alexander Czernay IT-Consulting Media Development fon +49-40-41096742 fax +49-40-41096743 icq 4773650 [EMAIL PROTECTED] www.czernay.com _ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: No valid JdbcConnection class available with MySQL
On Monday, June 2, 2003, at 05:28 AM, Alexander Czernay wrote: Is there any trick to un-installing cocoon? I tried removing all its folders from Tomcat, but when I put the new cocoon.war file in there it didn't do anything. :-/ I ran into this problem, too. I finally found it was only a permissions problem. You should check, if you granted read and execute rights on the war to your tomcat process. Maybe just chown it to the tomcat user. I don't think that was the problem. It eventually did install, and while I'm not sure exactly what I did (I was trying a lot of different things and suddenly there it was), but it never occurred to me to change the owner of the file. -- Austin == I've decided that egg nog is my very favorite kind of nog. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: No valid JdbcConnection class available with MySQL
At 10:53 PM 6/1/2003, you wrote: On Sunday, June 1, 2003, at 09:19 PM, Geoff Howard wrote: Are the samples still in tact (I assume they are since this is binary dist)? If so, can you confirm that the database samples (which use hsql) are working, or do you get the same error? If so, I'd guess that you may be using a jdk 1.2/3 version of the excalibur database package. I don't remember what the error was, but I never did manage to get the HSQLDB examples to work before, but I didn't worry too much about it because I needed to get JDBC working anyway. Anyway, I finally got the newer version to install and copied all the files I'd changed into it, and now it's WORKING! Both the HSQLDB examples and the MySQL example. So it must have been the JDK 1.3 version I'd been using. Good call. For future reference: hsqldb _is_ jdbc. If it's not working, then other databases probably won't either because of the exact problem you found - the break between jdk1.4 and previous versions that affects the excalibur datasource component. Do a directory listing of your WEB-INF/lib - any jdk dependant jars should give some clue as to which version they are. Now that I've got both versions here, I don't see any way to tell the two apart by inspecting the .jar files in WEB-INF/lib. It might be a good idea to write up a FAQ and make the two lib versions available for download. It would sure be easier to replace the lib directory than try to reinstall Cocoon. That was a real pain! Not even by the name of the jar? For instance, in 2.0.x for jdk1.4 the excalibur datasource jar is called excalibur-datasource-vm14-20021121.jar. The vm14 stands for virtual machine version 1.4 and I think the other is called *vm12*. Glad things worked out, Geoff - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]