Re: importing PSML into the database - where do I put the driver?
ine.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:595) === Does anyone know why? Thank you very much, Sven. --- My original mail --- Von: "Sven Richter" <[EMAIL PROTECTED]> An: "Jetspeed Users List" Betreff: Re: importing PSML into the database - where do I put the driver? Datum: Sat, 19 Mar 2005 16:05:06 +0100 Hello, I think I'm slowly getting there. At least I don't get any error message anymore. It says now: === [MyPortal]# maven import __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 build:start: import: [java] * PSML Importer * === But that's all it does. It stucks there. I waited for about 30 minutes, but nothing is happening. I also looked with an Database-Tool: it doesn't add any entries to the tables. It seems as if the ImporterService doesn't know what to add. Thank you very much, Sven. Am Fri, 18 Mar 2005 07:15:46 -0800 schrieb David Sean Taylor <[EMAIL PROTECTED]>: Sven Richter wrote: He also mentioned that I have to update the path to include the jetspeed 1.5 jar. But I don't know how. I tried several things, but I know always get the error message, that the file NULL/.../TurbineResources.properties was not found. Maven is looking in the wrong directory (in NULL). Could you (or somebody else) send me an example of this file and/or $HOME/build.properties, so that I can figure out how? Didn't you say that you created your project with the Jetspeed Plugin? If so, then it appears that you will need to copy your ./src/webapp directory to ./webapp, and you will need a TurbineResources.properties file located in ./webapp/WEB-INF/conf/TurbineResources.properties - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: importing PSML into the database - where do I put the driver?
e.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:595) === Does anyone know why? Thank you very much, Sven. --- My original mail --- Von: "Sven Richter" <[EMAIL PROTECTED]> An: "Jetspeed Users List" Betreff: Re: importing PSML into the database - where do I put the driver? Datum: Sat, 19 Mar 2005 16:05:06 +0100 Hello, I think I'm slowly getting there. At least I don't get any error message anymore. It says now: === [MyPortal]# maven import __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 build:start: import: [java] * PSML Importer * === But that's all it does. It stucks there. I waited for about 30 minutes, but nothing is happening. I also looked with an Database-Tool: it doesn't add any entries to the tables. It seems as if the ImporterService doesn't know what to add. Thank you very much, Sven. Am Fri, 18 Mar 2005 07:15:46 -0800 schrieb David Sean Taylor <[EMAIL PROTECTED]>: Sven Richter wrote: He also mentioned that I have to update the path to include the jetspeed 1.5 jar. But I don't know how. I tried several things, but I know always get the error message, that the file NULL/.../TurbineResources.properties was not found. Maven is looking in the wrong directory (in NULL). Could you (or somebody else) send me an example of this file and/or $HOME/build.properties, so that I can figure out how? Didn't you say that you created your project with the Jetspeed Plugin? If so, then it appears that you will need to copy your ./src/webapp directory to ./webapp, and you will need a TurbineResources.properties file located in ./webapp/WEB-INF/conf/TurbineResources.properties - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: importing PSML into the database - where do I put the driver?
Hello, I think I'm slowly getting there. At least I don't get any error message anymore. It says now: === [MyPortal]# maven import __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 build:start: import: [java] * PSML Importer * === But that's all it does. It stucks there. I waited for about 30 minutes, but nothing is happening. I also looked with an Database-Tool: it doesn't add any entries to the tables. It seems as if the ImporterService doesn't know what to add. Thank you very much, Sven. Am Fri, 18 Mar 2005 07:15:46 -0800 schrieb David Sean Taylor <[EMAIL PROTECTED]>: Sven Richter wrote: He also mentioned that I have to update the path to include the jetspeed 1.5 jar. But I don't know how. I tried several things, but I know always get the error message, that the file NULL/.../TurbineResources.properties was not found. Maven is looking in the wrong directory (in NULL). Could you (or somebody else) send me an example of this file and/or $HOME/build.properties, so that I can figure out how? Didn't you say that you created your project with the Jetspeed Plugin? If so, then it appears that you will need to copy your ./src/webapp directory to ./webapp, and you will need a TurbineResources.properties file located in ./webapp/WEB-INF/conf/TurbineResources.properties - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: importing PSML into the database - where do I put the driver?
Sven Richter wrote: He also mentioned that I have to update the path to include the jetspeed 1.5 jar. But I don't know how. I tried several things, but I know always get the error message, that the file NULL/.../TurbineResources.properties was not found. Maven is looking in the wrong directory (in NULL). Could you (or somebody else) send me an example of this file and/or $HOME/build.properties, so that I can figure out how? Didn't you say that you created your project with the Jetspeed Plugin? If so, then it appears that you will need to copy your ./src/webapp directory to ./webapp, and you will need a TurbineResources.properties file located in ./webapp/WEB-INF/conf/TurbineResources.properties -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: importing PSML into the database - where do I put the driver?
Hello, thanks for your response, but that wasn't the solution either, unfortunately. I don't think, it's that maven can't find the driver for MySql. I think Maven just can't find the goal 'import'. So I tried to make the tip of David Sean Taylor to work: I created a file 'maven.xml' and wrote as suggested: description="Import PSML"> He also mentioned that I have to update the path to include the jetspeed 1.5 jar. But I don't know how. I tried several things, but I know always get the error message, that the file NULL/.../TurbineResources.properties was not found. Maven is looking in the wrong directory (in NULL). Could you (or somebody else) send me an example of this file and/or $HOME/build.properties, so that I can figure out how? Thank you very much, Sven. Am Fri, 18 Mar 2005 08:19:05 +0100 schrieb Boukhalfa BRAHITI <[EMAIL PROTECTED]>: HY, I imported psml i my Postregsql yesterday. I tried several solutions and finally I put the driver in the path %JAVA_HOME%\jre\lib\ext and it works. I hope it will help you. -Message d'origine- DeÂ: Sven Richter [mailto:[EMAIL PROTECTED] EnvoyÃÂ: jeudi 17 mars 2005 17:49 ÃÂ: Jetspeed Users List ObjetÂ: Re: importing PSML into the database - where do I put the driver? Hello, First, thanks for your quick response. I did everything you mentioned there. But I still get the error message: = [MyPortal]# maven import __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 BUILD FAILED Goal "import" does not exist in this project. Total time: 4 seconds Finished at: Thu Mar 17 17:30:59 CET 2005 = That doesn't seem to be the problem. I also didn't understand where you put the mysql.xml (./etc/project-dependencies/ <= I don't have any such directory). So I added the statement directly into the project.xml. Thank you very much, Sven. Am Thu, 17 Mar 2005 15:43:59 +0100 schrieb Roel van Dijk <[EMAIL PROTECTED]>: I didn't do this, but I guess it should work. For my project I altered some of the files in the Jetspeed source directories. Read my description from earlier this week on: http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg15698.html Roel -Oorspronkelijk bericht- I works for you? Did you put it into your HOME-Directory and not into your project-root-directory (did you just create a new file or did it already exist)? Could you please post your file as an example please? >> > I did see this, but was unsure how to use it. Where do I define these >> > variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? >> >> in your $HOME/build.properties - 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: importing PSML into the database - where do I put the driver?
HY, I imported psml i my Postregsql yesterday. I tried several solutions and finally I put the driver in the path %JAVA_HOME%\jre\lib\ext and it works. I hope it will help you. -Message d'origine- De : Sven Richter [mailto:[EMAIL PROTECTED] Envoyé : jeudi 17 mars 2005 17:49 À : Jetspeed Users List Objet : Re: importing PSML into the database - where do I put the driver? Hello, First, thanks for your quick response. I did everything you mentioned there. But I still get the error message: = [MyPortal]# maven import __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 BUILD FAILED Goal "import" does not exist in this project. Total time: 4 seconds Finished at: Thu Mar 17 17:30:59 CET 2005 = That doesn't seem to be the problem. I also didn't understand where you put the mysql.xml (./etc/project-dependencies/ <= I don't have any such directory). So I added the statement directly into the project.xml. Thank you very much, Sven. Am Thu, 17 Mar 2005 15:43:59 +0100 schrieb Roel van Dijk <[EMAIL PROTECTED]>: > I didn't do this, but I guess it should work. For my project I altered > some of the files in the Jetspeed source directories. Read my > description from earlier this week on: > > http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg15698.html > > Roel > > >> -Oorspronkelijk bericht- >> I works for you? Did you put it into your HOME-Directory and not >> into your >> project-root-directory (did you just create a new file or did it already >> exist)? Could you please post your file as an example please? > >> >> > I did see this, but was unsure how to use it. Where do I define >> these >> >> > variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? >> >> >> >> in your $HOME/build.properties > > > > > - > 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: importing PSML into the database - where do I put the driver?
Hello, First, thanks for your quick response. I did everything you mentioned there. But I still get the error message: = [MyPortal]# maven import __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 BUILD FAILED Goal "import" does not exist in this project. Total time: 4 seconds Finished at: Thu Mar 17 17:30:59 CET 2005 = That doesn't seem to be the problem. I also didn't understand where you put the mysql.xml (./etc/project-dependencies/ <= I don't have any such directory). So I added the statement directly into the project.xml. Thank you very much, Sven. Am Thu, 17 Mar 2005 15:43:59 +0100 schrieb Roel van Dijk <[EMAIL PROTECTED]>: I didn't do this, but I guess it should work. For my project I altered some of the files in the Jetspeed source directories. Read my description from earlier this week on: http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg15698.html Roel -Oorspronkelijk bericht- I works for you? Did you put it into your HOME-Directory and not into your project-root-directory (did you just create a new file or did it already exist)? Could you please post your file as an example please? >> > I did see this, but was unsure how to use it. Where do I define these >> > variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? >> >> in your $HOME/build.properties - 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: importing PSML into the database - where do I put the driver?
I didn't do this, but I guess it should work. For my project I altered some of the files in the Jetspeed source directories. Read my description from earlier this week on: http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg15698.html Roel > -Oorspronkelijk bericht- > I works for you? Did you put it into your HOME-Directory and not > into your > project-root-directory (did you just create a new file or did it already > exist)? Could you please post your file as an example please? > >> > I did see this, but was unsure how to use it. Where do I define these > >> > variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? > >> > >> in your $HOME/build.properties - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: importing PSML into the database - where do I put the driver?
Hallo, I works for you? Did you put it into your HOME-Directory and not into your project-root-directory (did you just create a new file or did it already exist)? Could you please post your file as an example please? Thank you very much, Sven. Am Thu, 17 Mar 2005 08:54:04 +0100 schrieb Roel van Dijk <[EMAIL PROTECTED]>: > I did see this, but was unsure how to use it. Where do I define these > variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? in your $HOME/build.properties Excellent. Maybe it's wise to add this information to the Jetspeed-1 PSML DB page here: http://portals.apache.org/jetspeed-1/psml_db.html Or at least link to this Jetspeed-2 page, where it is described (and apparently is applicable to Jetspeed-1, too). http://portals.apache.org/jetspeed-2/database.html Roel - 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: importing PSML into the database - where do I put the driver?
> > I did see this, but was unsure how to use it. Where do I define these > > variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? > > in your $HOME/build.properties Excellent. Maybe it's wise to add this information to the Jetspeed-1 PSML DB page here: http://portals.apache.org/jetspeed-1/psml_db.html Or at least link to this Jetspeed-2 page, where it is described (and apparently is applicable to Jetspeed-1, too). http://portals.apache.org/jetspeed-2/database.html Roel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: importing PSML into the database - where do I put the driver?
Roel van Dijk wrote: I did see this, but was unsure how to use it. Where do I define these variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? in your $HOME/build.properties -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: importing PSML into the database - where do I put the driver?
> > > path="${org.apache.jetspeed.test.jdbc.j1.drivers.path}"/> > path="${org.apache.jetspeed.test.jdbc.j1.drivers.path2}"/> > path="${org.apache.jetspeed.test.jdbc.j1.drivers.path3}"/> > I did see this, but was unsure how to use it. Where do I define these variables ${org.apache.jetspeed.test.jdbc.j1.drivers.path} ? Roel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: importing PSML into the database - where do I put the driver?
Molina Pablo (teampro) wrote: Wherever it is, just add it as a dependency within the project.xml file: If the .jar file is named mysql-driver-1.0.1.jar, then mysql-driver 1.0.1 and that's it! Run maven and it will access the driver. Not sure if you are aware, but there are other databases besides MySQL that Jetspeed supports. Thus, I can't add a direct dep on MySQL to the jetspeed cvs, and that is why we have the solution with property used in the pathelement (actually 3 properties) for database drivers. Obviously, you are free to add a dep to MySQL in your custom builds. -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: importing PSML into the database - where do I put the driver?
Read my last post, it describes this in detail, I figured it out myself ;-) But thanks, anyway. Roel > -Oorspronkelijk bericht- > Van: Molina Pablo (teampro) [mailto:[EMAIL PROTECTED] > Verzonden: Wednesday, March 16, 2005 5:00 PM > Aan: 'Jetspeed Users List' > Onderwerp: RE: importing PSML into the database - where do I put the > driver? > > > Wherever it is, just add it as a dependency within the project.xml file: > > If the .jar file is named mysql-driver-1.0.1.jar, then > > > mysql-driver > 1.0.1 > > > and that's it! Run maven and it will access the driver. > > Regards, > Pablo > > -Mensaje original- > De: David Sean Taylor [mailto:[EMAIL PROTECTED] > Enviado el: miércoles, 16 de marzo de 2005 16:55 > Para: Jetspeed Users List > Asunto: Re: importing PSML into the database - where do I put the driver? > > Roel van Dijk wrote: > >>-Oorspronkelijk bericht- > >>Van: Roel van Dijk [mailto:[EMAIL PROTECTED] > >>Verzonden: Tuesday, March 15, 2005 2:03 PM > >>Aan: Jetspeed Users List > >>Onderwerp: importing PSML into the database - where do I put the driver? > >> > >> > >>So here is the big question: where should I put the MySQL-Driver > >>JAR file so that the combination of Maven and Torque can find it? > > > > > > [note: I'm using 1.6-dev from CVS] > > > org.apache.jetspeed.test.jdbc.j1.drivers.path: > >description="Import PSML"> > > classname="org.apache.jetspeed.services.psmlmanager.PsmlImporter" > > > > > > > path="${org.apache.jetspeed.test.jdbc.j1.drivers.path}"/> > path="${org.apache.jetspeed.test.jdbc.j1.drivers.path2}"/> > path="${org.apache.jetspeed.test.jdbc.j1.drivers.path3}"/> > > > > > > -- > David Sean Taylor > Bluesunrise Software > [EMAIL PROTECTED] > [office] +01 707 773-4646 > [mobile] +01 707 529 9194 > > - > 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: importing PSML into the database - where do I put the driver?
Wherever it is, just add it as a dependency within the project.xml file: If the .jar file is named mysql-driver-1.0.1.jar, then mysql-driver 1.0.1 and that's it! Run maven and it will access the driver. Regards, Pablo -Mensaje original- De: David Sean Taylor [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 16 de marzo de 2005 16:55 Para: Jetspeed Users List Asunto: Re: importing PSML into the database - where do I put the driver? Roel van Dijk wrote: >>-Oorspronkelijk bericht- >>Van: Roel van Dijk [mailto:[EMAIL PROTECTED] >>Verzonden: Tuesday, March 15, 2005 2:03 PM >>Aan: Jetspeed Users List >>Onderwerp: importing PSML into the database - where do I put the driver? >> >> >>So here is the big question: where should I put the MySQL-Driver >>JAR file so that the combination of Maven and Torque can find it? > > > [note: I'm using 1.6-dev from CVS] > org.apache.jetspeed.test.jdbc.j1.drivers.path: -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - 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: importing PSML into the database - where do I put the driver?
Roel van Dijk wrote: -Oorspronkelijk bericht- Van: Roel van Dijk [mailto:[EMAIL PROTECTED] Verzonden: Tuesday, March 15, 2005 2:03 PM Aan: Jetspeed Users List Onderwerp: importing PSML into the database - where do I put the driver? So here is the big question: where should I put the MySQL-Driver JAR file so that the combination of Maven and Torque can find it? [note: I'm using 1.6-dev from CVS] org.apache.jetspeed.test.jdbc.j1.drivers.path: -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: importing PSML into the database - where do I put the driver?
> -Oorspronkelijk bericht- > Van: Roel van Dijk [mailto:[EMAIL PROTECTED] > Verzonden: Tuesday, March 15, 2005 2:03 PM > Aan: Jetspeed Users List > Onderwerp: importing PSML into the database - where do I put the driver? > > > So here is the big question: where should I put the MySQL-Driver > JAR file so that the combination of Maven and Torque can find it? [note: I'm using 1.6-dev from CVS] I asked this question yesterday, but got no reply. I've been working on it all day yesterday, but couldn't find it. A new day, a new insight. Here is the solution to my problem. Since the PsmlImporter and related classes couldn't find the JDBC driver, I edited the PsmlImporter source file to print out the classpath it was using. Apparently it was looking in the ~/.maven/repository/ directory for all the JAR files. Looking around a bit in the Jetspeed source root directory, those directories were mentioned in a couple of files. First, in the ".classpath" file, and next in the "project.xml" file (and those included there from the ./etc/project-dependencies/ directory). First, I put the MySQL JDBC JAR file in my maven repository. Then I tried editing the .classpath file, which didn't help. Finally I added another file to the project-dependencies directory and included it in project.xml. Success! So here's what I did: 1. Add the driver JAR to your Maven repository. I made a subdir ~/.maven/repository/mysql/jars/ and copied the mysql-connector-java-3.1.7-bin.jar there. 2. Make a mysql.xml in ./etc/project-dependencies/, containing this: mysql:mysql-connector-java 3.1.7-bin true 3. Import this mysql.xml in the project.xml file by adding this line at the start of the section: &mysql; 4. Rebuild. 5. the 'maven import' command now works. I guess the same procedure works for other database drivers. Roel van Dijk Forest & Fields - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]