You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by su...@talkin2u.com on 2005/02/23 19:58:55 UTC
Database parameters missing.
Hi,
I using Tomcat 5.5.7 and jetspeed on jdk 1.5 on a windows xp platform. I'm
running hsql by using the command "maven start.production.server" then in
another window I run "maven quickStart". Except when I deploy the
jetspeed binary. In this case I reinstall Tomcat then copy the binary
folders over to the appropriate directories under Tomcat and I get the
same errors.
What is not configured properly? I understand that I may have
misconfigured something with the source build but the binary I imagined
would work.
I appreciate any insights,
Chris
I'm getting the errors while accessing jetspeed at
http://localhost:8080/jetspeed.
With the source build, I had to change the build.properties paths to use
\\ instead of / to satisfy the windows environment.
I had to modify 4 files during the source build to accomodate "enum" since
it is a reserved word in jdk 1.5.
After these adjustments the source compiles and deploys as planned. But
when I type http://localhost:8080/jetspeed I get the following error
whether I deploy the source build or the binary.
[org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR:
SQLException thrown while trying to get Connection from Datasource
(java:comp/env/jdbc/jetspeed)
Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
of class '' for connect URL 'null'
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDataSource(ConnectionFactoryAbstractImpl.java:204)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:112)
at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:105)
at
org.springframework.orm.ojb.PersistenceBrokerTransactionManager.doBegin(PersistenceBrokerTransactionManager.java:187)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:269)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:201)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:49)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
at $Proxy7.createNode(Unknown Source)
at
org.apache.jetspeed.prefs.impl.PreferencesImpl.<init>(PreferencesImpl.java:96)
at
org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(PreferencesFactoryImpl.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:114)
at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:96)
at
org.apache.jetspeed.components.SpringComponentManager.<init>(SpringComponentManager.java:44)
at
org.apache.jetspeed.engine.SpringEngine.initComponents(SpringEngine.java:108)
at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:135)
at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64)
at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:590)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
... 58 more
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'java.util.prefs.PreferencesFactory' defined in URL
[file:/D:/apps/Tomcat-5.5/webapps/jetspeed/WEB-INF/assembly/jetspeed-spring.xml]:
Initialization of bean failed; nested exception is
org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs
api. org.springframework.transaction.CannotCreateTransactionException:
Could not create OJB transaction; nested exception is
org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
while trying to get Connection from Datasource
(java:comp/env/jdbc/jetspeed)
org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs
api. org.springframework.transaction.CannotCreateTransactionException:
Could not create OJB transaction; nested exception is
org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
while trying to get Connection from Datasource
(java:comp/env/jdbc/jetspeed)
at
org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(PreferencesFactoryImpl.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:114)
at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:96)
at
org.apache.jetspeed.components.SpringComponentManager.<init>(SpringComponentManager.java:44)
at
org.apache.jetspeed.engine.SpringEngine.initComponents(SpringEngine.java:108)
at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:135)
at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64)
at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:590)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
org.apache.jetspeed.exception.JetspeedException: Jetspeed Initialization
exception!
at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:155)
at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64)
at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:590)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'java.util.prefs.PreferencesFactory' defined in
URL
[file:/D:/apps/Tomcat-5.5/webapps/jetspeed/WEB-INF/assembly/jetspeed-spring.xml]:
Initialization of bean failed; nested exception is
org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs
api. org.springframework.transaction.CannotCreateTransactionException:
Could not create OJB transaction; nested exception is
org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
while trying to get Connection from Datasource
(java:comp/env/jdbc/jetspeed)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:300)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:114)
at
org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:96)
at
org.apache.jetspeed.components.SpringComponentManager.<init>(SpringComponentManager.java:44)
at
org.apache.jetspeed.engine.SpringEngine.initComponents(SpringEngine.java:108)
at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:135)
... 28 more
Caused by: org.apache.jetspeed.prefs.PreferencesException: Failed to
initialize prefs api.
org.springframework.transaction.CannotCreateTransactionException: Could
not create OJB transaction; nested exception is
org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
while trying to get Connection from Datasource
(java:comp/env/jdbc/jetspeed)
at
org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(PreferencesFactoryImpl.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
... 38 more
FATAL: Jetspeed: init() failed:
org.apache.jetspeed.exception.JetspeedException: Unable to create Engine
at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:76)
at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by "Scott T. Weaver" <sc...@binary-designs.net>.
IIRC, quickStart does all the copying/DB ops, not allBuild. allBuild
just basically builds J2 sans any deployment.
Regrads,
Marina wrote:
>ooh, I feel so bad... :)
>I knew it was something very stupid - I did not run
>the 'maven quickStart'. For some reason I thought it
>was intended for the HSQLDB only...
>
>Sorry for wasting so much of your time!
>
>Thanks, Randy,
>Marina
>
>--- watler@wispertel.net wrote:
>
>
>
>>Marina:
>>
>>If your j2 DB is not setup, nothing will work
>>anyway, so we are back to
>>the failing maven build... you did use "maven
>>quickStart", no?
>>
>>Also, your DB URL probably needs to be
>>
>>jdbc:mysql://127.0.0.1:3306/j2
>>
>>or
>>
>>jdbc:mysql://localhost/j2,
>>
>>(mysql can be picky about IP usage and I am not sure
>>about the port you
>>specified).
>>
>>Randy
>>
>>
>>
>>>Thanks, Randy :)
>>>I modified jetspeed.xml file using the one from a
>>>working HSQL J2M2 installation as an example and
>>>copied it into the
>>><TOMCAT_HOME>/conf/Catalina/localhost dir.
>>>I also copied a security.xml file from the HSQLDB
>>>
>>>
>>J2M2
>>
>>
>>>installation and adjusted the docBase value.
>>>
>>>Unfortunately, when I started Tomcat, I've got the
>>>same error:
>>>
>>>Caused by:
>>>org.apache.jetspeed.prefs.PreferencesException:
>>>
>>>
>>Failed
>>
>>
>>>to initialize prefs
>>>
>>>
>>>
>api.org.springframework.transaction.CannotCreateTransactionException:
>
>
>>>Could not create OJB transaction; nested exception
>>>
>>>
>>is
>>
>>
>>>org.apache.ojb.broker.accesslayer.LookupException:
>>>SQLException thrown while trying to get Connection
>>>from Datasource (java:comp/env/jdbc/jetspeed) at
>>>
>>>
>>>
>org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(Preference
>
>
>>>sFactoryImpl.java:70) at
>>>
>>>
>>>
>sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
>
>
>>>at
>>>
>>>
>>>
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>
>
>>>...
>>>
>>>And in the J2's log file:
>>>2005-02-27 18:24:24
>>>
>>>
>>>
>>StandardContext[/jetspeed]StandardWrapper.Throwable
>>
>>
>>>java.lang.NullPointerException
>>> at
>>>
>>>
>>>
>org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137)
>
>
>>> at
>>>
>>>
>>>
>org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
>
>
>>> at
>>>
>>>
>>>
>org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876)
>
>
>>> at
>>>
>>>
>>>One thing that puzzles me (among others, of
>>>
>>>
>>course) is
>>
>>
>>>that the 'j2' DB did not get populated while
>>>
>>>
>>'j2test'
>>
>>
>>>did...
>>>
>>>Here is my jetspeed.xml - lines that I changed:
>>> <!-- HSQL dB username and password for dB
>>>connections -->
>>> <parameter>
>>> <name>username</name>
>>> <value>admin</value>
>>> </parameter>
>>> <parameter>
>>> <name>password</name>
>>> <value>admin</value>
>>> </parameter>
>>>
>>> <!-- Class name for HSQL JDBC driver -->
>>> <parameter>
>>> <name>driverClassName</name>
>>> <value>org.gjt.mm.mysql.Driver</value>
>>> </parameter>
>>>
>>> <!-- The JDBC connection url for connecting to
>>>your HSQL dB. -->
>>> <parameter>
>>> <name>url</name>
>>> <value>jdbc:mysql://127.0.0.1:3306</value>
>>> </parameter>
>>> </ResourceParams>
>>>
>>>Thanks for looking into this!
>>>Marina
>>>
>>>--- watler@wispertel.net wrote:
>>>
>>>
>>>
>>>>Marina,
>>>>
>>>>
>>>>
>>>>>3. jetspeed.xml
>>>>>there was no jetspeed.xml in the
>>>>>=<TOMCAT_HOME>/conf/Catalina/localhost dir
>>>>>The only jetspeed.xml files in the
>>>>>
>>>>>
>>J2-project-home
>>
>>
>>>>>directory that I found were:
>>>>>
>>>>>
>>>>>
>maven-plugin/target/classes/plugin-resources/jetspeed.xml
>
>
>>>>>portal/src/resources/jetspeed.xml
>>>>>Should I manually edit one of them and copy
>>>>>
>>>>>
>>into
>>
>>
>>>>><TOMCAT_HOME>/conf/Catalina/localhost dir ?
>>>>>
>>>>>
>>>>Since you manually copied the jetspeed.war into
>>>>webapps, I assume you will
>>>>need to do the same thing with the
>>>>portal/src/resources/jetspeed.xml file.
>>>>It is certainly simple enough to try!
>>>>
>>>>
>>>>
>>>>>Is not it supposed to be done by the maven
>>>>>
>>>>>
>>>>'allBuild'
>>>>
>>>>
>>>>>goal?
>>>>>
>>>>>
>>>>Well, so is copying jetspeed.war into webapps! :)
>>>>Something is broken for
>>>>sure, but I am just interesting in seeing if you
>>>>
>>>>
>>can
>>
>>
>>>>get it to run at all
>>>>since you have taken it almost this far already.
>>>>Yes, we are in the weeds
>>>>at this point!
>>>>
>>>>Randy
>>>>
>>>>
>>>>
>>>>
>>>>
>---------------------------------------------------------------------
>
>
>>>>To unsubscribe, e-mail:
>>>>jetspeed-user-unsubscribe@jakarta.apache.org
>>>>For additional commands, e-mail:
>>>>jetspeed-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>---------------------------------------------------------------------
>
>
>>>To unsubscribe, e-mail:
>>>
>>>
>>jetspeed-user-unsubscribe@jakarta.apache.org
>>
>>
>>>For additional commands, e-mail:
>>>
>>>
>>jetspeed-user-help@jakarta.apache.org
>>
>>
>>>
>>>
>>
>>
>>
>---------------------------------------------------------------------
>
>
>>To unsubscribe, e-mail:
>>jetspeed-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail:
>>jetspeed-user-help@jakarta.apache.org
>>
>>
>>
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>
>
>
--
"Great minds discuss ideas. Average minds discuss events. Small minds discuss people." - Admiral Hyman Rickover
*******************************************
* Scott T. Weaver *
* <we...@apache.org> *
* <http://www.einnovation.com> *
* -------------------------------------- *
* Apache Jetspeed Enterprise Portal *
* Apache Pluto Portlet Container *
* *
* OpenEdit, Website Content Management *
* <http://www.openedit.org> *
*******************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by Marina <pp...@yahoo.com>.
ooh, I feel so bad... :)
I knew it was something very stupid - I did not run
the 'maven quickStart'. For some reason I thought it
was intended for the HSQLDB only...
Sorry for wasting so much of your time!
Thanks, Randy,
Marina
--- watler@wispertel.net wrote:
> Marina:
>
> If your j2 DB is not setup, nothing will work
> anyway, so we are back to
> the failing maven build... you did use "maven
> quickStart", no?
>
> Also, your DB URL probably needs to be
>
> jdbc:mysql://127.0.0.1:3306/j2
>
> or
>
> jdbc:mysql://localhost/j2,
>
> (mysql can be picky about IP usage and I am not sure
> about the port you
> specified).
>
> Randy
>
> > Thanks, Randy :)
> > I modified jetspeed.xml file using the one from a
> > working HSQL J2M2 installation as an example and
> > copied it into the
> > <TOMCAT_HOME>/conf/Catalina/localhost dir.
> > I also copied a security.xml file from the HSQLDB
> J2M2
> > installation and adjusted the docBase value.
> >
> > Unfortunately, when I started Tomcat, I've got the
> > same error:
> >
> > Caused by:
> > org.apache.jetspeed.prefs.PreferencesException:
> Failed
> > to initialize prefs
> >
>
api.org.springframework.transaction.CannotCreateTransactionException:
> > Could not create OJB transaction; nested exception
> is
> > org.apache.ojb.broker.accesslayer.LookupException:
> > SQLException thrown while trying to get Connection
> > from Datasource (java:comp/env/jdbc/jetspeed) at
> >
>
org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(Preference
> > sFactoryImpl.java:70) at
> >
>
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
> > at
> >
>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > ...
> >
> > And in the J2's log file:
> > 2005-02-27 18:24:24
> >
> StandardContext[/jetspeed]StandardWrapper.Throwable
> > java.lang.NullPointerException
> > at
> >
>
org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137)
> > at
> >
>
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
> > at
> >
>
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876)
> > at
> >
> >
> > One thing that puzzles me (among others, of
> course) is
> > that the 'j2' DB did not get populated while
> 'j2test'
> > did...
> >
> > Here is my jetspeed.xml - lines that I changed:
> > <!-- HSQL dB username and password for dB
> > connections -->
> > <parameter>
> > <name>username</name>
> > <value>admin</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value>admin</value>
> > </parameter>
> >
> > <!-- Class name for HSQL JDBC driver -->
> > <parameter>
> > <name>driverClassName</name>
> > <value>org.gjt.mm.mysql.Driver</value>
> > </parameter>
> >
> > <!-- The JDBC connection url for connecting to
> > your HSQL dB. -->
> > <parameter>
> > <name>url</name>
> > <value>jdbc:mysql://127.0.0.1:3306</value>
> > </parameter>
> > </ResourceParams>
> >
> > Thanks for looking into this!
> > Marina
> >
> > --- watler@wispertel.net wrote:
> >
> >> Marina,
> >>
> >> > 3. jetspeed.xml
> >> > there was no jetspeed.xml in the
> >> > =<TOMCAT_HOME>/conf/Catalina/localhost dir
> >> > The only jetspeed.xml files in the
> J2-project-home
> >> > directory that I found were:
> >> >
> >>
> >
>
maven-plugin/target/classes/plugin-resources/jetspeed.xml
> >> > portal/src/resources/jetspeed.xml
> >> > Should I manually edit one of them and copy
> into
> >> > <TOMCAT_HOME>/conf/Catalina/localhost dir ?
> >>
> >> Since you manually copied the jetspeed.war into
> >> webapps, I assume you will
> >> need to do the same thing with the
> >> portal/src/resources/jetspeed.xml file.
> >> It is certainly simple enough to try!
> >>
> >> > Is not it supposed to be done by the maven
> >> 'allBuild'
> >> > goal?
> >>
> >> Well, so is copying jetspeed.war into webapps! :)
> >> Something is broken for
> >> sure, but I am just interesting in seeing if you
> can
> >> get it to run at all
> >> since you have taken it almost this far already.
> >> Yes, we are in the weeds
> >> at this point!
> >>
> >> Randy
> >>
> >>
> >>
> >
>
---------------------------------------------------------------------
> >> To unsubscribe, e-mail:
> >> jetspeed-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail:
> >> jetspeed-user-help@jakarta.apache.org
> >>
> >>
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
> >
> >
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by wa...@wispertel.net.
Marina:
If your j2 DB is not setup, nothing will work anyway, so we are back to
the failing maven build... you did use "maven quickStart", no?
Also, your DB URL probably needs to be
jdbc:mysql://127.0.0.1:3306/j2
or
jdbc:mysql://localhost/j2,
(mysql can be picky about IP usage and I am not sure about the port you
specified).
Randy
> Thanks, Randy :)
> I modified jetspeed.xml file using the one from a
> working HSQL J2M2 installation as an example and
> copied it into the
> <TOMCAT_HOME>/conf/Catalina/localhost dir.
> I also copied a security.xml file from the HSQLDB J2M2
> installation and adjusted the docBase value.
>
> Unfortunately, when I started Tomcat, I've got the
> same error:
>
> Caused by:
> org.apache.jetspeed.prefs.PreferencesException: Failed
> to initialize prefs
> api.org.springframework.transaction.CannotCreateTransactionException:
> Could not create OJB transaction; nested exception is
> org.apache.ojb.broker.accesslayer.LookupException:
> SQLException thrown while trying to get Connection
> from Datasource (java:comp/env/jdbc/jetspeed) at
> org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(Preference
> sFactoryImpl.java:70) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> ...
>
> And in the J2's log file:
> 2005-02-27 18:24:24
> StandardContext[/jetspeed]StandardWrapper.Throwable
> java.lang.NullPointerException
> at
> org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
> at
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876)
> at
>
>
> One thing that puzzles me (among others, of course) is
> that the 'j2' DB did not get populated while 'j2test'
> did...
>
> Here is my jetspeed.xml - lines that I changed:
> <!-- HSQL dB username and password for dB
> connections -->
> <parameter>
> <name>username</name>
> <value>admin</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>admin</value>
> </parameter>
>
> <!-- Class name for HSQL JDBC driver -->
> <parameter>
> <name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
>
> <!-- The JDBC connection url for connecting to
> your HSQL dB. -->
> <parameter>
> <name>url</name>
> <value>jdbc:mysql://127.0.0.1:3306</value>
> </parameter>
> </ResourceParams>
>
> Thanks for looking into this!
> Marina
>
> --- watler@wispertel.net wrote:
>
>> Marina,
>>
>> > 3. jetspeed.xml
>> > there was no jetspeed.xml in the
>> > =<TOMCAT_HOME>/conf/Catalina/localhost dir
>> > The only jetspeed.xml files in the J2-project-home
>> > directory that I found were:
>> >
>>
> maven-plugin/target/classes/plugin-resources/jetspeed.xml
>> > portal/src/resources/jetspeed.xml
>> > Should I manually edit one of them and copy into
>> > <TOMCAT_HOME>/conf/Catalina/localhost dir ?
>>
>> Since you manually copied the jetspeed.war into
>> webapps, I assume you will
>> need to do the same thing with the
>> portal/src/resources/jetspeed.xml file.
>> It is certainly simple enough to try!
>>
>> > Is not it supposed to be done by the maven
>> 'allBuild'
>> > goal?
>>
>> Well, so is copying jetspeed.war into webapps! :)
>> Something is broken for
>> sure, but I am just interesting in seeing if you can
>> get it to run at all
>> since you have taken it almost this far already.
>> Yes, we are in the weeds
>> at this point!
>>
>> Randy
>>
>>
>>
> ---------------------------------------------------------------------
>> To unsubscribe, e-mail:
>> jetspeed-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail:
>> jetspeed-user-help@jakarta.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by Marina <pp...@yahoo.com>.
Thanks, Randy :)
I modified jetspeed.xml file using the one from a
working HSQL J2M2 installation as an example and
copied it into the
<TOMCAT_HOME>/conf/Catalina/localhost dir.
I also copied a security.xml file from the HSQLDB J2M2
installation and adjusted the docBase value.
Unfortunately, when I started Tomcat, I've got the
same error:
Caused by:
org.apache.jetspeed.prefs.PreferencesException: Failed
to initialize prefs
api.org.springframework.transaction.CannotCreateTransactionException:
Could not create OJB transaction; nested exception is
org.apache.ojb.broker.accesslayer.LookupException:
SQLException thrown while trying to get Connection
from Datasource (java:comp/env/jdbc/jetspeed) at
org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(Preference
sFactoryImpl.java:70) at
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
...
And in the J2's log file:
2005-02-27 18:24:24
StandardContext[/jetspeed]StandardWrapper.Throwable
java.lang.NullPointerException
at
org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876)
at
One thing that puzzles me (among others, of course) is
that the 'j2' DB did not get populated while 'j2test'
did...
Here is my jetspeed.xml - lines that I changed:
<!-- HSQL dB username and password for dB
connections -->
<parameter>
<name>username</name>
<value>admin</value>
</parameter>
<parameter>
<name>password</name>
<value>admin</value>
</parameter>
<!-- Class name for HSQL JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<!-- The JDBC connection url for connecting to
your HSQL dB. -->
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1:3306</value>
</parameter>
</ResourceParams>
Thanks for looking into this!
Marina
--- watler@wispertel.net wrote:
> Marina,
>
> > 3. jetspeed.xml
> > there was no jetspeed.xml in the
> > =<TOMCAT_HOME>/conf/Catalina/localhost dir
> > The only jetspeed.xml files in the J2-project-home
> > directory that I found were:
> >
>
maven-plugin/target/classes/plugin-resources/jetspeed.xml
> > portal/src/resources/jetspeed.xml
> > Should I manually edit one of them and copy into
> > <TOMCAT_HOME>/conf/Catalina/localhost dir ?
>
> Since you manually copied the jetspeed.war into
> webapps, I assume you will
> need to do the same thing with the
> portal/src/resources/jetspeed.xml file.
> It is certainly simple enough to try!
>
> > Is not it supposed to be done by the maven
> 'allBuild'
> > goal?
>
> Well, so is copying jetspeed.war into webapps! :)
> Something is broken for
> sure, but I am just interesting in seeing if you can
> get it to run at all
> since you have taken it almost this far already.
> Yes, we are in the weeds
> at this point!
>
> Randy
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by wa...@wispertel.net.
Marina,
> 3. jetspeed.xml
> there was no jetspeed.xml in the
> =<TOMCAT_HOME>/conf/Catalina/localhost dir
> The only jetspeed.xml files in the J2-project-home
> directory that I found were:
> maven-plugin/target/classes/plugin-resources/jetspeed.xml
> portal/src/resources/jetspeed.xml
> Should I manually edit one of them and copy into
> <TOMCAT_HOME>/conf/Catalina/localhost dir ?
Since you manually copied the jetspeed.war into webapps, I assume you will
need to do the same thing with the portal/src/resources/jetspeed.xml file.
It is certainly simple enough to try!
> Is not it supposed to be done by the maven 'allBuild'
> goal?
Well, so is copying jetspeed.war into webapps! :) Something is broken for
sure, but I am just interesting in seeing if you can get it to run at all
since you have taken it almost this far already. Yes, we are in the weeds
at this point!
Randy
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by Marina <pp...@yahoo.com>.
Randy,
I double checked my config files and verified the
following:
Verified:
1.
JVM version used by maven - added 'java -version'
command to the 'show.maven.props' goal:
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL>maven
show.maven.props
__ __
| \/ |__ _Apache__ ___
| |\/| / _` \ V / -_) ' \ ~ intelligent projects ~
|_| |_\__,_|\_/\___|_||_| v. 1.0.2
build:start:
show.maven.props:
[echo] maven.home.local = C:/Marina/MyWork/Maven
[echo] maven.repo.local =
C:/Marina/MyWork/Maven/maven_repository
[echo] checking JRE version:
[exec] java version "1.4.2_06"
[exec] Java(TM) 2 Runtime Environment, Standard
Edition (build 1.4.2_06-b03)
[exec] Java HotSpot(TM) Client VM (build
1.4.2_06-b03, mixed mode)
BUILD SUCCESSFUL
Total time: 2 seconds
Finished at: Sun Feb 27 11:54:13 EST 2005
2. 'admin' user has rights to the 'j2' and 'j2test'
tables in MySQL:
logged into MySQL as 'admin', created and dropped test
tables in both 'j2' and 'j2test' DBs:
>>>>>
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3 to server version:
4.1.7. Type 'help;' or '\h' for help. Type '\c' to
clear the buffer.
mysql> use j2test
Database changed
mysql> create table MyTest( id int );
Query OK, 0 rows affected (0.10 sec)
mysql> drop table MyTest;
Query OK, 0 rows affected (0.00 sec)
mysql> use j2
Database changed
mysql> create table MyTest( id int );
Query OK, 0 rows affected (0.02 sec)
mysql> drop table MyTest;
Query OK, 0 rows affected (0.00 sec)
3. jetspeed.xml
there was no jetspeed.xml in the
=<TOMCAT_HOME>/conf/Catalina/localhost dir
The only jetspeed.xml files in the J2-project-home
directory that I found were:
maven-plugin/target/classes/plugin-resources/jetspeed.xml
portal/src/resources/jetspeed.xml
Should I manually edit one of them and copy into
<TOMCAT_HOME>/conf/Catalina/localhost dir ?
Is not it supposed to be done by the maven 'allBuild'
goal?
4. I checked the MySQL driver jar file itself - it
does have both com.mysql.jdbc.Driver and
org.gjt.mm.mysql.Driver. It is indeed located in the
<TOMCAT_HOME>/shared/lib dir.
Any other setup I could have missed?
Thanks!
Marina
--- watler@wispertel.net wrote:
> Marina,
>
> I know you probably have most of this down cold, but
> please verify:
>
> - you have a copy of
> mysql-connector-java-3.0.16-ga-bin.jar in
> <TOMCAT_HOME>/shared/lib.
> - that the com.mysql.jdbc.Driver class exists in
> mysql-connector-java-3.0.16-ga-bin.jar.
> - if you are manually copying the jetspeed.war into
> webapps, make sure
> that the jetspeed.xml is edited for your
> configuration and is copied to
> the correct location:
> tomcat5=<TOMCAT_HOME>/conf/Catalina/localhost or
> tomcat4=<TOMCAT_HOME>/webapps.
> - that admin/admin has access to your j2 and j2test
> databases.
> - that your java implementation is being located
> correctly and is a
> current 1.4.2 or 1.5 version... I have never seen
> those "targetting 1.4"
> messages on Linux.
>
> Randy
>
> > Thanks, Randy.
> > Something very strange is going on here...
> > I tried different variations of the
> build.properties
> > file and it comes down to the following two
> scenarios:
> >
> > 1) if I set properties to:
> > org.apache.jetspeed.test.database.url =
> > jdbc:mysql://localhost/j2test
> > org.apache.jetspeed.test.database.driver =
> > com.mysql.jdbc.Driver
> > org.apache.jetspeed.test.database.user = admin
> > org.apache.jetspeed.test.database.password = admin
> >
> >
>
org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> >
> org.apache.jetspeed.test.database.default.name=mysql
> >
> > org.apache.jetspeed.production.database.url =
> > jdbc:mysql://localhost/j2
> > org.apache.jetspeed.production.database.driver =
> > com.mysql.jdbc.Driver
> > org.apache.jetspeed.production.database.user =
> admin
> > org.apache.jetspeed.production.database.password =
> > admin
> >
> >
>
org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> >
>
org.apache.jetspeed.production.database.default.name=mysql
> >
> >
> > then I get errors running maven allBuild target::
> > jetspeed2:jar:install:
> > build:start:
> >
> > java:prepare-filesystem:
> > [mkdir] Created dir:
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
> >
> > java:compile:
> > [echo] Compiling to
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
> > [echo]
> >
>
==========================================================
> >
> > NOTE: Targetting JVM 1.4, classes
> > will not run on earlier JVMs
> >
> >
>
==========================================================
> >
> > [javac] Compiling 27 source files to
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
> >
> > BUILD FAILED
> > File......
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> > Element... maven:reactor
> > Line...... 133
> > Column.... 40
> > Unable to obtain goal [java:compile] --
> >
>
C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
> > <ant:javac> Error running javac.exe compiler
> >
> > 2) if I set driver's name to:
> >
>
org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> >
> org.apache.jetspeed.test.database.default.name=mysql
> >
>
org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
> >
>
org.apache.jetspeed.test.database.driver=org.gjt.mm.mysql.Driver
> > org.apache.jetspeed.test.database.user=admin
> > org.apache.jetspeed.test.database.password=admin
> >
>
org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> >
>
org.apache.jetspeed.production.database.default.name=mysql
> >
>
org.apache.jetspeed.production.database.url=jdbc:mysql://localhost/j2
> >
>
org.apache.jetspeed.production.database.driver=org.gjt.mm.mysql.Driver
> > org.apache.jetspeed.production.database.user=admin
> >
>
org.apache.jetspeed.production.database.password=admin
> >
> > then 'maven allBuild' finishes successfully, but:
> > -- no jetspeed.war is created in the Tomcat's
> webapp/
> > directory --> when trying to access J2 from a
> browser
> > - you get 404 error
> > -- no tables are created in the 'j2' DB schema.
> > 'j2test' schema has all tables created and
> populated.
> > -- the jetspeed.war file is created in the J2
> > project's .../portal/target/ directory though. I
> tried
> > copying it manually to the Tomcat's webapp/ dir -
> but
> > when I started tomcat, the following errors were
> > thrown when Tomcat was trying to deploy
> jetspeed.war:
> >
> > Caused by:
> >
>
org.springframework.beans.factory.BeanCreationException:
> > Error creati
> > ng bean with name
> 'java.util.prefs.PreferencesFactory'
> > defined in URL [file:/C:/
> >
>
Marina/Java/tomcat-5.0.30-j2M2-MYSQL/webapps/jetspeed/WEB-INF/assembly/jetspeed-
> > spring.xml]: Initialization of bean failed; nested
> > exception is org.apache.jetsp
> > eed.prefs.PreferencesException: Failed to
> initialize
> > prefs api. org.springframe
> > work.transaction.CannotCreateTransactionException:
> > Could not create OJB transact
> > ion; nested exception is
> > org.apache.ojb.broker.accesslayer.LookupException:
> > SQLE
> > xception thrown while trying to get Connection
> from
> > Datasource (java:comp/env/jdbc/jetspeed)
> > at
> >
>
org.springframework.beans.factory.support.AbstractAutowireCapableBean
> >
>
Factory.createBean(AbstractAutowireCapableBeanFactory.java:300)
> >
> >
> > It hunts me that it must be something very simple
> and
> > very stupid, since nobody else had these problems
> > using MySQL, but I can't find what that is...
> > Any ideas?
> >
> > Thanks!
> > Marina
> >
> >
> >
> >
> > --- watler@wispertel.net wrote:
> >
> >> Marina,
> >>
> >> These settings have always worked for me, (note
> that
> >> I do not set the
> >> ojb.platform property):
> >>
> >>
> >
>
org.apachejetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
> >>
> org.apache.jetspeed.test.database.default.name=mysql
> >>
> >
>
org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
> >>
>
=== message truncated ===
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by wa...@wispertel.net.
Marina,
I know you probably have most of this down cold, but please verify:
- you have a copy of mysql-connector-java-3.0.16-ga-bin.jar in
<TOMCAT_HOME>/shared/lib.
- that the com.mysql.jdbc.Driver class exists in
mysql-connector-java-3.0.16-ga-bin.jar.
- if you are manually copying the jetspeed.war into webapps, make sure
that the jetspeed.xml is edited for your configuration and is copied to
the correct location: tomcat5=<TOMCAT_HOME>/conf/Catalina/localhost or
tomcat4=<TOMCAT_HOME>/webapps.
- that admin/admin has access to your j2 and j2test databases.
- that your java implementation is being located correctly and is a
current 1.4.2 or 1.5 version... I have never seen those "targetting 1.4"
messages on Linux.
Randy
> Thanks, Randy.
> Something very strange is going on here...
> I tried different variations of the build.properties
> file and it comes down to the following two scenarios:
>
> 1) if I set properties to:
> org.apache.jetspeed.test.database.url =
> jdbc:mysql://localhost/j2test
> org.apache.jetspeed.test.database.driver =
> com.mysql.jdbc.Driver
> org.apache.jetspeed.test.database.user = admin
> org.apache.jetspeed.test.database.password = admin
>
> org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.test.database.default.name=mysql
>
> org.apache.jetspeed.production.database.url =
> jdbc:mysql://localhost/j2
> org.apache.jetspeed.production.database.driver =
> com.mysql.jdbc.Driver
> org.apache.jetspeed.production.database.user = admin
> org.apache.jetspeed.production.database.password =
> admin
>
> org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.production.database.default.name=mysql
>
>
> then I get errors running maven allBuild target::
> jetspeed2:jar:install:
> build:start:
>
> java:prepare-filesystem:
> [mkdir] Created dir:
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
>
> java:compile:
> [echo] Compiling to
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
> [echo]
> ==========================================================
>
> NOTE: Targetting JVM 1.4, classes
> will not run on earlier JVMs
>
> ==========================================================
>
> [javac] Compiling 27 source files to
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
>
> BUILD FAILED
> File......
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> Element... maven:reactor
> Line...... 133
> Column.... 40
> Unable to obtain goal [java:compile] --
> C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
> <ant:javac> Error running javac.exe compiler
>
> 2) if I set driver's name to:
> org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.test.database.default.name=mysql
> org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
> org.apache.jetspeed.test.database.driver=org.gjt.mm.mysql.Driver
> org.apache.jetspeed.test.database.user=admin
> org.apache.jetspeed.test.database.password=admin
> org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.production.database.default.name=mysql
> org.apache.jetspeed.production.database.url=jdbc:mysql://localhost/j2
> org.apache.jetspeed.production.database.driver=org.gjt.mm.mysql.Driver
> org.apache.jetspeed.production.database.user=admin
> org.apache.jetspeed.production.database.password=admin
>
> then 'maven allBuild' finishes successfully, but:
> -- no jetspeed.war is created in the Tomcat's webapp/
> directory --> when trying to access J2 from a browser
> - you get 404 error
> -- no tables are created in the 'j2' DB schema.
> 'j2test' schema has all tables created and populated.
> -- the jetspeed.war file is created in the J2
> project's .../portal/target/ directory though. I tried
> copying it manually to the Tomcat's webapp/ dir - but
> when I started tomcat, the following errors were
> thrown when Tomcat was trying to deploy jetspeed.war:
>
> Caused by:
> org.springframework.beans.factory.BeanCreationException:
> Error creati
> ng bean with name 'java.util.prefs.PreferencesFactory'
> defined in URL [file:/C:/
> Marina/Java/tomcat-5.0.30-j2M2-MYSQL/webapps/jetspeed/WEB-INF/assembly/jetspeed-
> spring.xml]: Initialization of bean failed; nested
> exception is org.apache.jetsp
> eed.prefs.PreferencesException: Failed to initialize
> prefs api. org.springframe
> work.transaction.CannotCreateTransactionException:
> Could not create OJB transact
> ion; nested exception is
> org.apache.ojb.broker.accesslayer.LookupException:
> SQLE
> xception thrown while trying to get Connection from
> Datasource (java:comp/env/jdbc/jetspeed)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBean
> Factory.createBean(AbstractAutowireCapableBeanFactory.java:300)
>
>
> It hunts me that it must be something very simple and
> very stupid, since nobody else had these problems
> using MySQL, but I can't find what that is...
> Any ideas?
>
> Thanks!
> Marina
>
>
>
>
> --- watler@wispertel.net wrote:
>
>> Marina,
>>
>> These settings have always worked for me, (note that
>> I do not set the
>> ojb.platform property):
>>
>>
> org.apachejetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
>> org.apache.jetspeed.test.database.default.name=mysql
>>
> org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
>>
> org.apache.jetspeed.test.database.driver=org.gjt.mm.mysql.Driver
>> org.apache.jetspeed.test.database.user=admin
>> org.apache.jetspeed.test.database.password=admin
>>
> org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
>>
> org.apache.jetspeed.production.database.default.name=mysql
>>
> org.apache.jetspeed.production.database.url=jdbc:mysql://localhost/j2
>>
> org.apache.jetspeed.production.database.driver=org.gjt.mm.mysql.Driver
>> org.apache.jetspeed.production.database.user=admin
>>
> org.apache.jetspeed.production.database.password=admin
>>
>> Randy
>>
>> > Thank you, Hema!
>> >
>> > Yes, that was it - the default name had to be set
>> to
>> > 'mysql'.
>> > Once I did that, the build script finished all DB
>> > setup work fine but it failed at a later point:
>> >
>> > java:compile:
>> > [echo] Compiling to
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
>> > [echo]
>> >
>>
> ==========================================================
>> >
>> > NOTE: Targetting JVM 1.4, classes
>> > will not run on earlier JVMs
>> >
>> >
>>
> ==========================================================
>> >
>> > [javac] Compiling 27 source files to
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
>> >
>> > BUILD FAILED
>> > File......
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
>> > Element... maven:reactor
>> > Line...... 133
>> > Column.... 40
>> > Unable to obtain goal [java:compile] --
>> >
>>
> C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
>> > <ant:javac> Error running javac.exe compiler
>> > Total time: 37 seconds
>> > Finished at: Fri Feb 25 19:23:20 EST 2005
>> >
>> >
>> > Any idea what is wrong now?
>> >
>> > Thank you!
>> > Marina
>> >
>> > --- Hema Menon <me...@gmail.com> wrote:
>> >
>> >> Marina,
>> >>
>> >> What I meant to say is that, I believe the
>> default
>> >> name should be the
>> >> type of database name, so in your build script it
>> >> should be mysql
>> >> instead of j2 and j2test. If you look at the
>> sample
>> >> build properties,
>> >> it contains hsql for both test and production
>> >> default database name.
>> >>
>> org.apache.jetspeed.test.database.default.name=hsql
>> >>
>> >
>>
> org.apache.jetspeed.test.database.ojb.platform=Hsqldb
>> >>
>> >> Hema
>> >>
>> >> >
>> >> > On Thu, 24 Feb 2005 18:37:18 -0800 (PST),
>> Marina
>> >> <pp...@yahoo.com> wrote:
>> >> > > Hi,
>> >> > >
>> >> > > I finally got around to switch from HSQLDB to
>> >> MySQL
>> >> > > and ran into a build problem.
>> >> > > I setup MySQL DB schema and users per J2
>> >> instructions
>> >> > > (created 'j2test' and 'j2' schemas and the
>> >> 'jetspeed2'
>> >> > > user that has all writes for those schemas).
>> I
>> >> have
>> >> > > also modified J2's build.properties to use
>> MySQL
>> >> (I'm
>> >> > > including a snippet below).
>> >> > >
>> >> > > After that, I do the following:
>> >> > > 1. start MySQL DB
>> >> > > 2. cd $J@_project_home
>> >> > > maven allClean - OK
>> >> > > maven allBuild - Error:
>> >> > >
>> >> > > Attempting to download
>> >> maven-torque-plugin-3.2.jar.
>> >> > > 2/6K
>> >> > > 6/6K
>> >>
>> > 6K downloaded
>> >> > > build:start:
>> >> > >
>> >> > > allBuild:
>> >> > > check.required.properties:
>> >> > >
>> >> > > torque:init:
>> >> > >
>> >> > > db.scripts.gen:
>> >> > > [echo] Generating SQL schema creation
>> >> scripts for
>> >> > > HSQLDB
>> >> > > [torque-sql] Using classpath
>> >> > > [torque-sql] Generating to file
>> >> > >
>> >>
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
>> >> > > [echo] Generating SQL schema creation
>> >> scripts for
>> >> > > MySQL
>> >> > > [torque-sql] Using classpath
>> >> > > [torque-sql] Generating to file
>> >> > >
>> >>
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
>> >> > > [echo] Generating SQL schema creation
>> >> scripts for
>> >> > > Oracle
>> >> > > [torque-sql] Using classpath
>> >> > > [torque-sql] Generating to file
>> >> > >
>> >>
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
>> >> > > [echo] Generating SQL schema creation
>> >> scripts for
>> >> > > MS SQL
>> >> > > [torque-sql] Using classpath
>> >> > > [torque-sql] Generating to file
>> >> > >
>> >>
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
>> >> > > [echo] Generating SQL schema creation
>> >> scripts for
>> >> > > Postgres
>> >> > > [torque-sql] Using classpath
>> >> > > [torque-sql] Generating to file
>> >> > >
>> >>
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
>> >> > >
>> >> > > BUILD FAILED
>> >> > > File......
>> >> > >
>> >>
>> >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
>> >> > > Element... sql
>> >> > > Line...... 355
>> >> > > Column.... 39
>> >> > > Source file does not exist!
>> >> > > Total time: 12 seconds
>> >> > > Finished at: Thu Feb 24 21:27:54 EST 2005
>> >> > >
>> >> > > Here is my build.properties (relevant parts):
>> >> > > # Override the database connection and
>> >> > > driverproperties in your
>> >> ${USER_HOME}/build.properties
>> >> > > appropriately
>> >> > > # See:
>> >> > > #
>> >>
>> http://portals.apache.org/jetspeed-2/database.html
>> >> > >
>> >> > > org.apache.jetspeed.test.database.url =
>> >> > > jdbc:mysql://localhost/j2test
>> >> > > org.apache.jetspeed.test.database.driver =
>>
> === message truncated ===
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by Marina <pp...@yahoo.com>.
Thanks, Randy.
Something very strange is going on here...
I tried different variations of the build.properties
file and it comes down to the following two scenarios:
1) if I set properties to:
org.apache.jetspeed.test.database.url =
jdbc:mysql://localhost/j2test
org.apache.jetspeed.test.database.driver =
com.mysql.jdbc.Driver
org.apache.jetspeed.test.database.user = admin
org.apache.jetspeed.test.database.password = admin
org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
org.apache.jetspeed.test.database.default.name=mysql
org.apache.jetspeed.production.database.url =
jdbc:mysql://localhost/j2
org.apache.jetspeed.production.database.driver =
com.mysql.jdbc.Driver
org.apache.jetspeed.production.database.user = admin
org.apache.jetspeed.production.database.password =
admin
org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
org.apache.jetspeed.production.database.default.name=mysql
then I get errors running maven allBuild target::
jetspeed2:jar:install:
build:start:
java:prepare-filesystem:
[mkdir] Created dir:
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
java:compile:
[echo] Compiling to
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
[echo]
==========================================================
NOTE: Targetting JVM 1.4, classes
will not run on earlier JVMs
==========================================================
[javac] Compiling 27 source files to
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
BUILD FAILED
File......
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
Element... maven:reactor
Line...... 133
Column.... 40
Unable to obtain goal [java:compile] --
C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
<ant:javac> Error running javac.exe compiler
2) if I set driver's name to:
org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
org.apache.jetspeed.test.database.default.name=mysql
org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
org.apache.jetspeed.test.database.driver=org.gjt.mm.mysql.Driver
org.apache.jetspeed.test.database.user=admin
org.apache.jetspeed.test.database.password=admin
org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16-ga-bin.jar
org.apache.jetspeed.production.database.default.name=mysql
org.apache.jetspeed.production.database.url=jdbc:mysql://localhost/j2
org.apache.jetspeed.production.database.driver=org.gjt.mm.mysql.Driver
org.apache.jetspeed.production.database.user=admin
org.apache.jetspeed.production.database.password=admin
then 'maven allBuild' finishes successfully, but:
-- no jetspeed.war is created in the Tomcat's webapp/
directory --> when trying to access J2 from a browser
- you get 404 error
-- no tables are created in the 'j2' DB schema.
'j2test' schema has all tables created and populated.
-- the jetspeed.war file is created in the J2
project's .../portal/target/ directory though. I tried
copying it manually to the Tomcat's webapp/ dir - but
when I started tomcat, the following errors were
thrown when Tomcat was trying to deploy jetspeed.war:
Caused by:
org.springframework.beans.factory.BeanCreationException:
Error creati
ng bean with name 'java.util.prefs.PreferencesFactory'
defined in URL [file:/C:/
Marina/Java/tomcat-5.0.30-j2M2-MYSQL/webapps/jetspeed/WEB-INF/assembly/jetspeed-
spring.xml]: Initialization of bean failed; nested
exception is org.apache.jetsp
eed.prefs.PreferencesException: Failed to initialize
prefs api. org.springframe
work.transaction.CannotCreateTransactionException:
Could not create OJB transact
ion; nested exception is
org.apache.ojb.broker.accesslayer.LookupException:
SQLE
xception thrown while trying to get Connection from
Datasource (java:comp/env/jdbc/jetspeed)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:300)
It hunts me that it must be something very simple and
very stupid, since nobody else had these problems
using MySQL, but I can't find what that is...
Any ideas?
Thanks!
Marina
--- watler@wispertel.net wrote:
> Marina,
>
> These settings have always worked for me, (note that
> I do not set the
> ojb.platform property):
>
>
org.apachejetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
> org.apache.jetspeed.test.database.default.name=mysql
>
org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
>
org.apache.jetspeed.test.database.driver=org.gjt.mm.mysql.Driver
> org.apache.jetspeed.test.database.user=admin
> org.apache.jetspeed.test.database.password=admin
>
org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
>
org.apache.jetspeed.production.database.default.name=mysql
>
org.apache.jetspeed.production.database.url=jdbc:mysql://localhost/j2
>
org.apache.jetspeed.production.database.driver=org.gjt.mm.mysql.Driver
> org.apache.jetspeed.production.database.user=admin
>
org.apache.jetspeed.production.database.password=admin
>
> Randy
>
> > Thank you, Hema!
> >
> > Yes, that was it - the default name had to be set
> to
> > 'mysql'.
> > Once I did that, the build script finished all DB
> > setup work fine but it failed at a later point:
> >
> > java:compile:
> > [echo] Compiling to
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
> > [echo]
> >
>
==========================================================
> >
> > NOTE: Targetting JVM 1.4, classes
> > will not run on earlier JVMs
> >
> >
>
==========================================================
> >
> > [javac] Compiling 27 source files to
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
> >
> > BUILD FAILED
> > File......
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> > Element... maven:reactor
> > Line...... 133
> > Column.... 40
> > Unable to obtain goal [java:compile] --
> >
>
C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
> > <ant:javac> Error running javac.exe compiler
> > Total time: 37 seconds
> > Finished at: Fri Feb 25 19:23:20 EST 2005
> >
> >
> > Any idea what is wrong now?
> >
> > Thank you!
> > Marina
> >
> > --- Hema Menon <me...@gmail.com> wrote:
> >
> >> Marina,
> >>
> >> What I meant to say is that, I believe the
> default
> >> name should be the
> >> type of database name, so in your build script it
> >> should be mysql
> >> instead of j2 and j2test. If you look at the
> sample
> >> build properties,
> >> it contains hsql for both test and production
> >> default database name.
> >>
> org.apache.jetspeed.test.database.default.name=hsql
> >>
> >
>
org.apache.jetspeed.test.database.ojb.platform=Hsqldb
> >>
> >> Hema
> >>
> >> >
> >> > On Thu, 24 Feb 2005 18:37:18 -0800 (PST),
> Marina
> >> <pp...@yahoo.com> wrote:
> >> > > Hi,
> >> > >
> >> > > I finally got around to switch from HSQLDB to
> >> MySQL
> >> > > and ran into a build problem.
> >> > > I setup MySQL DB schema and users per J2
> >> instructions
> >> > > (created 'j2test' and 'j2' schemas and the
> >> 'jetspeed2'
> >> > > user that has all writes for those schemas).
> I
> >> have
> >> > > also modified J2's build.properties to use
> MySQL
> >> (I'm
> >> > > including a snippet below).
> >> > >
> >> > > After that, I do the following:
> >> > > 1. start MySQL DB
> >> > > 2. cd $J@_project_home
> >> > > maven allClean - OK
> >> > > maven allBuild - Error:
> >> > >
> >> > > Attempting to download
> >> maven-torque-plugin-3.2.jar.
> >> > > 2/6K
> >> > > 6/6K
> >> > > 6K downloaded
> >> > > build:start:
> >> > >
> >> > > allBuild:
> >> > > check.required.properties:
> >> > >
> >> > > torque:init:
> >> > >
> >> > > db.scripts.gen:
> >> > > [echo] Generating SQL schema creation
> >> scripts for
> >> > > HSQLDB
> >> > > [torque-sql] Using classpath
> >> > > [torque-sql] Generating to file
> >> > >
> >>
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
> >> > > [echo] Generating SQL schema creation
> >> scripts for
> >> > > MySQL
> >> > > [torque-sql] Using classpath
> >> > > [torque-sql] Generating to file
> >> > >
> >>
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
> >> > > [echo] Generating SQL schema creation
> >> scripts for
> >> > > Oracle
> >> > > [torque-sql] Using classpath
> >> > > [torque-sql] Generating to file
> >> > >
> >>
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
> >> > > [echo] Generating SQL schema creation
> >> scripts for
> >> > > MS SQL
> >> > > [torque-sql] Using classpath
> >> > > [torque-sql] Generating to file
> >> > >
> >>
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
> >> > > [echo] Generating SQL schema creation
> >> scripts for
> >> > > Postgres
> >> > > [torque-sql] Using classpath
> >> > > [torque-sql] Generating to file
> >> > >
> >>
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
> >> > >
> >> > > BUILD FAILED
> >> > > File......
> >> > >
> >>
> >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> >> > > Element... sql
> >> > > Line...... 355
> >> > > Column.... 39
> >> > > Source file does not exist!
> >> > > Total time: 12 seconds
> >> > > Finished at: Thu Feb 24 21:27:54 EST 2005
> >> > >
> >> > > Here is my build.properties (relevant parts):
> >> > > # Override the database connection and
> >> > > driverproperties in your
> >> ${USER_HOME}/build.properties
> >> > > appropriately
> >> > > # See:
> >> > > #
> >>
> http://portals.apache.org/jetspeed-2/database.html
> >> > >
> >> > > org.apache.jetspeed.test.database.url =
> >> > > jdbc:mysql://localhost/j2test
> >> > > org.apache.jetspeed.test.database.driver =
>
=== message truncated ===
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by wa...@wispertel.net.
Marina,
These settings have always worked for me, (note that I do not set the
ojb.platform property):
org.apache.jetspeed.test.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
org.apache.jetspeed.test.database.default.name=mysql
org.apache.jetspeed.test.database.url=jdbc:mysql://localhost/j2test
org.apache.jetspeed.test.database.driver=org.gjt.mm.mysql.Driver
org.apache.jetspeed.test.database.user=admin
org.apache.jetspeed.test.database.password=admin
org.apache.jetspeed.production.jdbc.drivers.path=${org.apache.jetspeed.server.shared}/mysql-connector-java-3.0.16.jar
org.apache.jetspeed.production.database.default.name=mysql
org.apache.jetspeed.production.database.url=jdbc:mysql://localhost/j2
org.apache.jetspeed.production.database.driver=org.gjt.mm.mysql.Driver
org.apache.jetspeed.production.database.user=admin
org.apache.jetspeed.production.database.password=admin
Randy
> Thank you, Hema!
>
> Yes, that was it - the default name had to be set to
> 'mysql'.
> Once I did that, the build script finished all DB
> setup work fine but it failed at a later point:
>
> java:compile:
> [echo] Compiling to
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
> [echo]
> ==========================================================
>
> NOTE: Targetting JVM 1.4, classes
> will not run on earlier JVMs
>
> ==========================================================
>
> [javac] Compiling 27 source files to
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
>
> BUILD FAILED
> File......
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> Element... maven:reactor
> Line...... 133
> Column.... 40
> Unable to obtain goal [java:compile] --
> C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
> <ant:javac> Error running javac.exe compiler
> Total time: 37 seconds
> Finished at: Fri Feb 25 19:23:20 EST 2005
>
>
> Any idea what is wrong now?
>
> Thank you!
> Marina
>
> --- Hema Menon <me...@gmail.com> wrote:
>
>> Marina,
>>
>> What I meant to say is that, I believe the default
>> name should be the
>> type of database name, so in your build script it
>> should be mysql
>> instead of j2 and j2test. If you look at the sample
>> build properties,
>> it contains hsql for both test and production
>> default database name.
>> org.apache.jetspeed.test.database.default.name=hsql
>>
> org.apache.jetspeed.test.database.ojb.platform=Hsqldb
>>
>> Hema
>>
>> >
>> > On Thu, 24 Feb 2005 18:37:18 -0800 (PST), Marina
>> <pp...@yahoo.com> wrote:
>> > > Hi,
>> > >
>> > > I finally got around to switch from HSQLDB to
>> MySQL
>> > > and ran into a build problem.
>> > > I setup MySQL DB schema and users per J2
>> instructions
>> > > (created 'j2test' and 'j2' schemas and the
>> 'jetspeed2'
>> > > user that has all writes for those schemas). I
>> have
>> > > also modified J2's build.properties to use MySQL
>> (I'm
>> > > including a snippet below).
>> > >
>> > > After that, I do the following:
>> > > 1. start MySQL DB
>> > > 2. cd $J@_project_home
>> > > maven allClean - OK
>> > > maven allBuild - Error:
>> > >
>> > > Attempting to download
>> maven-torque-plugin-3.2.jar.
>> > > 2/6K
>> > > 6/6K
>> > > 6K downloaded
>> > > build:start:
>> > >
>> > > allBuild:
>> > > check.required.properties:
>> > >
>> > > torque:init:
>> > >
>> > > db.scripts.gen:
>> > > [echo] Generating SQL schema creation
>> scripts for
>> > > HSQLDB
>> > > [torque-sql] Using classpath
>> > > [torque-sql] Generating to file
>> > >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
>> > > [echo] Generating SQL schema creation
>> scripts for
>> > > MySQL
>> > > [torque-sql] Using classpath
>> > > [torque-sql] Generating to file
>> > >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
>> > > [echo] Generating SQL schema creation
>> scripts for
>> > > Oracle
>> > > [torque-sql] Using classpath
>> > > [torque-sql] Generating to file
>> > >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
>> > > [echo] Generating SQL schema creation
>> scripts for
>> > > MS SQL
>> > > [torque-sql] Using classpath
>> > > [torque-sql] Generating to file
>> > >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
>> > > [echo] Generating SQL schema creation
>> scripts for
>> > > Postgres
>> > > [torque-sql] Using classpath
>> > > [torque-sql] Generating to file
>> > >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
>> > >
>> > > BUILD FAILED
>> > > File......
>> > >
>>
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
>> > > Element... sql
>> > > Line...... 355
>> > > Column.... 39
>> > > Source file does not exist!
>> > > Total time: 12 seconds
>> > > Finished at: Thu Feb 24 21:27:54 EST 2005
>> > >
>> > > Here is my build.properties (relevant parts):
>> > > # Override the database connection and
>> > > driverproperties in your
>> ${USER_HOME}/build.properties
>> > > appropriately
>> > > # See:
>> > > #
>> http://portals.apache.org/jetspeed-2/database.html
>> > >
>> > > org.apache.jetspeed.test.database.url =
>> > > jdbc:mysql://localhost/j2test
>> > > org.apache.jetspeed.test.database.driver =
>> > > com.mysql.jdbc.Driver
>> > > org.apache.jetspeed.test.database.user =
>> jetspeed2
>> > > org.apache.jetspeed.test.database.password =
>> jetspeed2
>> > >
>> > >
>>
> org.apache.jetspeed.test.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
>> > >
>>
> org.apache.jetspeed.test.database.default.name=j2test
>> > >
>> org.apache.jetspeed.test.database.ojb.platform=mysql
>> > >
>> > > org.apache.jetspeed.production.database.url =
>> > > jdbc:mysql://localhost/j2
>> > > org.apache.jetspeed.production.database.driver =
>> > > com.mysql.jdbc.Driver
>> > > org.apache.jetspeed.production.database.user =
>> > > jetspeed2
>> > > org.apache.jetspeed.production.database.password
>> =
>> > > jetspeed2
>> > >
>> > >
>>
> org.apache.jetspeed.production.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
>> > >
>>
> org.apache.jetspeed.production.database.default.name=j2
>> > >
>>
> org.apache.jetspeed.production.database.ojb.platform=mysql
>> > >
>> > > (I am not sure about the ojb.platform property,
>> there
>> > > were no directions on what it should be set to
>> for
>> > > MySQL, so I decided to set it to 'mysql' instead
>> of
>> > > keeping the default value of 'Hsqldb' ...)
>> > >
>> > > Any idea what I did wrong?
>> > >
>> > > Thanks!
>> > > Marina
>> > >
>> > >
>>
> ---------------------------------------------------------------------
>> > > To unsubscribe, e-mail:
>> jetspeed-user-unsubscribe@jakarta.apache.org
>> > > For additional commands, e-mail:
>> jetspeed-user-help@jakarta.apache.org
>> > >
>> > >
>> >
>> > --
>> >
>> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> > Hema Menon
>> >
>>
>>
>> --
>>
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Hema Menon
>>
>>
> ---------------------------------------------------------------------
>> To unsubscribe, e-mail:
>> jetspeed-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail:
>> jetspeed-user-help@jakarta.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by Marina <pp...@yahoo.com>.
Thank you, Hema!
Yes, that was it - the default name had to be set to
'mysql'.
Once I did that, the build script finished all DB
setup work fine but it failed at a later point:
java:compile:
[echo] Compiling to
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api/target/classes
[echo]
==========================================================
NOTE: Targetting JVM 1.4, classes
will not run on earlier JVMs
==========================================================
[javac] Compiling 27 source files to
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\portlet-api\target\classes
BUILD FAILED
File......
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
Element... maven:reactor
Line...... 133
Column.... 40
Unable to obtain goal [java:compile] --
C:\Marina\MyWork\Maven\cache\maven-java-plugin-1.5\plugin.jelly:63:48:
<ant:javac> Error running javac.exe compiler
Total time: 37 seconds
Finished at: Fri Feb 25 19:23:20 EST 2005
Any idea what is wrong now?
Thank you!
Marina
--- Hema Menon <me...@gmail.com> wrote:
> Marina,
>
> What I meant to say is that, I believe the default
> name should be the
> type of database name, so in your build script it
> should be mysql
> instead of j2 and j2test. If you look at the sample
> build properties,
> it contains hsql for both test and production
> default database name.
> org.apache.jetspeed.test.database.default.name=hsql
>
org.apache.jetspeed.test.database.ojb.platform=Hsqldb
>
> Hema
>
> >
> > On Thu, 24 Feb 2005 18:37:18 -0800 (PST), Marina
> <pp...@yahoo.com> wrote:
> > > Hi,
> > >
> > > I finally got around to switch from HSQLDB to
> MySQL
> > > and ran into a build problem.
> > > I setup MySQL DB schema and users per J2
> instructions
> > > (created 'j2test' and 'j2' schemas and the
> 'jetspeed2'
> > > user that has all writes for those schemas). I
> have
> > > also modified J2's build.properties to use MySQL
> (I'm
> > > including a snippet below).
> > >
> > > After that, I do the following:
> > > 1. start MySQL DB
> > > 2. cd $J@_project_home
> > > maven allClean - OK
> > > maven allBuild - Error:
> > >
> > > Attempting to download
> maven-torque-plugin-3.2.jar.
> > > 2/6K
> > > 6/6K
> > > 6K downloaded
> > > build:start:
> > >
> > > allBuild:
> > > check.required.properties:
> > >
> > > torque:init:
> > >
> > > db.scripts.gen:
> > > [echo] Generating SQL schema creation
> scripts for
> > > HSQLDB
> > > [torque-sql] Using classpath
> > > [torque-sql] Generating to file
> > >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
> > > [echo] Generating SQL schema creation
> scripts for
> > > MySQL
> > > [torque-sql] Using classpath
> > > [torque-sql] Generating to file
> > >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
> > > [echo] Generating SQL schema creation
> scripts for
> > > Oracle
> > > [torque-sql] Using classpath
> > > [torque-sql] Generating to file
> > >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
> > > [echo] Generating SQL schema creation
> scripts for
> > > MS SQL
> > > [torque-sql] Using classpath
> > > [torque-sql] Generating to file
> > >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
> > > [echo] Generating SQL schema creation
> scripts for
> > > Postgres
> > > [torque-sql] Using classpath
> > > [torque-sql] Generating to file
> > >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
> > >
> > > BUILD FAILED
> > > File......
> > >
>
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> > > Element... sql
> > > Line...... 355
> > > Column.... 39
> > > Source file does not exist!
> > > Total time: 12 seconds
> > > Finished at: Thu Feb 24 21:27:54 EST 2005
> > >
> > > Here is my build.properties (relevant parts):
> > > # Override the database connection and
> > > driverproperties in your
> ${USER_HOME}/build.properties
> > > appropriately
> > > # See:
> > > #
> http://portals.apache.org/jetspeed-2/database.html
> > >
> > > org.apache.jetspeed.test.database.url =
> > > jdbc:mysql://localhost/j2test
> > > org.apache.jetspeed.test.database.driver =
> > > com.mysql.jdbc.Driver
> > > org.apache.jetspeed.test.database.user =
> jetspeed2
> > > org.apache.jetspeed.test.database.password =
> jetspeed2
> > >
> > >
>
org.apache.jetspeed.test.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> > >
>
org.apache.jetspeed.test.database.default.name=j2test
> > >
> org.apache.jetspeed.test.database.ojb.platform=mysql
> > >
> > > org.apache.jetspeed.production.database.url =
> > > jdbc:mysql://localhost/j2
> > > org.apache.jetspeed.production.database.driver =
> > > com.mysql.jdbc.Driver
> > > org.apache.jetspeed.production.database.user =
> > > jetspeed2
> > > org.apache.jetspeed.production.database.password
> =
> > > jetspeed2
> > >
> > >
>
org.apache.jetspeed.production.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> > >
>
org.apache.jetspeed.production.database.default.name=j2
> > >
>
org.apache.jetspeed.production.database.ojb.platform=mysql
> > >
> > > (I am not sure about the ojb.platform property,
> there
> > > were no directions on what it should be set to
> for
> > > MySQL, so I decided to set it to 'mysql' instead
> of
> > > keeping the default value of 'Hsqldb' ...)
> > >
> > > Any idea what I did wrong?
> > >
> > > Thanks!
> > > Marina
> > >
> > >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
> > >
> > >
> >
> > --
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Hema Menon
> >
>
>
> --
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Hema Menon
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by Hema Menon <me...@gmail.com>.
Marina,
What I meant to say is that, I believe the default name should be the
type of database name, so in your build script it should be mysql
instead of j2 and j2test. If you look at the sample build properties,
it contains hsql for both test and production default database name.
org.apache.jetspeed.test.database.default.name=hsql
org.apache.jetspeed.test.database.ojb.platform=Hsqldb
Hema
>
> On Thu, 24 Feb 2005 18:37:18 -0800 (PST), Marina <pp...@yahoo.com> wrote:
> > Hi,
> >
> > I finally got around to switch from HSQLDB to MySQL
> > and ran into a build problem.
> > I setup MySQL DB schema and users per J2 instructions
> > (created 'j2test' and 'j2' schemas and the 'jetspeed2'
> > user that has all writes for those schemas). I have
> > also modified J2's build.properties to use MySQL (I'm
> > including a snippet below).
> >
> > After that, I do the following:
> > 1. start MySQL DB
> > 2. cd $J@_project_home
> > maven allClean - OK
> > maven allBuild - Error:
> >
> > Attempting to download maven-torque-plugin-3.2.jar.
> > 2/6K
> > 6/6K
> > 6K downloaded
> > build:start:
> >
> > allBuild:
> > check.required.properties:
> >
> > torque:init:
> >
> > db.scripts.gen:
> > [echo] Generating SQL schema creation scripts for
> > HSQLDB
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > MySQL
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > Oracle
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > MS SQL
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
> > [echo] Generating SQL schema creation scripts for
> > Postgres
> > [torque-sql] Using classpath
> > [torque-sql] Generating to file
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
> >
> > BUILD FAILED
> > File......
> > C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> > Element... sql
> > Line...... 355
> > Column.... 39
> > Source file does not exist!
> > Total time: 12 seconds
> > Finished at: Thu Feb 24 21:27:54 EST 2005
> >
> > Here is my build.properties (relevant parts):
> > # Override the database connection and
> > driverproperties in your ${USER_HOME}/build.properties
> > appropriately
> > # See:
> > # http://portals.apache.org/jetspeed-2/database.html
> >
> > org.apache.jetspeed.test.database.url =
> > jdbc:mysql://localhost/j2test
> > org.apache.jetspeed.test.database.driver =
> > com.mysql.jdbc.Driver
> > org.apache.jetspeed.test.database.user = jetspeed2
> > org.apache.jetspeed.test.database.password = jetspeed2
> >
> > org.apache.jetspeed.test.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> > org.apache.jetspeed.test.database.default.name=j2test
> > org.apache.jetspeed.test.database.ojb.platform=mysql
> >
> > org.apache.jetspeed.production.database.url =
> > jdbc:mysql://localhost/j2
> > org.apache.jetspeed.production.database.driver =
> > com.mysql.jdbc.Driver
> > org.apache.jetspeed.production.database.user =
> > jetspeed2
> > org.apache.jetspeed.production.database.password =
> > jetspeed2
> >
> > org.apache.jetspeed.production.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> > org.apache.jetspeed.production.database.default.name=j2
> > org.apache.jetspeed.production.database.ojb.platform=mysql
> >
> > (I am not sure about the ojb.platform property, there
> > were no directions on what it should be set to for
> > MySQL, so I decided to set it to 'mysql' instead of
> > keeping the default value of 'Hsqldb' ...)
> >
> > Any idea what I did wrong?
> >
> > Thanks!
> > Marina
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
> >
> >
>
> --
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Hema Menon
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hema Menon
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: using MySQL with J2 - setup problem
Posted by Hema Menon <me...@gmail.com>.
Marina,
Shouldn't there be a default name entry in your build.properties file?
I have used it with Sybase and I have the following entry in my
build.properties.
org.apache.jetspeed.test.database.default.name = sybase
Hema
On Thu, 24 Feb 2005 18:37:18 -0800 (PST), Marina <pp...@yahoo.com> wrote:
> Hi,
>
> I finally got around to switch from HSQLDB to MySQL
> and ran into a build problem.
> I setup MySQL DB schema and users per J2 instructions
> (created 'j2test' and 'j2' schemas and the 'jetspeed2'
> user that has all writes for those schemas). I have
> also modified J2's build.properties to use MySQL (I'm
> including a snippet below).
>
> After that, I do the following:
> 1. start MySQL DB
> 2. cd $J@_project_home
> maven allClean - OK
> maven allBuild - Error:
>
> Attempting to download maven-torque-plugin-3.2.jar.
> 2/6K
> 6/6K
> 6K downloaded
> build:start:
>
> allBuild:
> check.required.properties:
>
> torque:init:
>
> db.scripts.gen:
> [echo] Generating SQL schema creation scripts for
> HSQLDB
> [torque-sql] Using classpath
> [torque-sql] Generating to file
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
> [echo] Generating SQL schema creation scripts for
> MySQL
> [torque-sql] Using classpath
> [torque-sql] Generating to file
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
> [echo] Generating SQL schema creation scripts for
> Oracle
> [torque-sql] Using classpath
> [torque-sql] Generating to file
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
> [echo] Generating SQL schema creation scripts for
> MS SQL
> [torque-sql] Using classpath
> [torque-sql] Generating to file
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
> [echo] Generating SQL schema creation scripts for
> Postgres
> [torque-sql] Using classpath
> [torque-sql] Generating to file
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
>
> BUILD FAILED
> File......
> C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
> Element... sql
> Line...... 355
> Column.... 39
> Source file does not exist!
> Total time: 12 seconds
> Finished at: Thu Feb 24 21:27:54 EST 2005
>
> Here is my build.properties (relevant parts):
> # Override the database connection and
> driverproperties in your ${USER_HOME}/build.properties
> appropriately
> # See:
> # http://portals.apache.org/jetspeed-2/database.html
>
> org.apache.jetspeed.test.database.url =
> jdbc:mysql://localhost/j2test
> org.apache.jetspeed.test.database.driver =
> com.mysql.jdbc.Driver
> org.apache.jetspeed.test.database.user = jetspeed2
> org.apache.jetspeed.test.database.password = jetspeed2
>
> org.apache.jetspeed.test.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.test.database.default.name=j2test
> org.apache.jetspeed.test.database.ojb.platform=mysql
>
> org.apache.jetspeed.production.database.url =
> jdbc:mysql://localhost/j2
> org.apache.jetspeed.production.database.driver =
> com.mysql.jdbc.Driver
> org.apache.jetspeed.production.database.user =
> jetspeed2
> org.apache.jetspeed.production.database.password =
> jetspeed2
>
> org.apache.jetspeed.production.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
> org.apache.jetspeed.production.database.default.name=j2
> org.apache.jetspeed.production.database.ojb.platform=mysql
>
> (I am not sure about the ojb.platform property, there
> were no directions on what it should be set to for
> MySQL, so I decided to set it to 'mysql' instead of
> keeping the default value of 'Hsqldb' ...)
>
> Any idea what I did wrong?
>
> Thanks!
> Marina
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hema Menon
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
using MySQL with J2 - setup problem
Posted by Marina <pp...@yahoo.com>.
Hi,
I finally got around to switch from HSQLDB to MySQL
and ran into a build problem.
I setup MySQL DB schema and users per J2 instructions
(created 'j2test' and 'j2' schemas and the 'jetspeed2'
user that has all writes for those schemas). I have
also modified J2's build.properties to use MySQL (I'm
including a snippet below).
After that, I do the following:
1. start MySQL DB
2. cd $J@_project_home
maven allClean - OK
maven allBuild - Error:
Attempting to download maven-torque-plugin-3.2.jar.
2/6K
6/6K
6K downloaded
build:start:
allBuild:
check.required.properties:
torque:init:
db.scripts.gen:
[echo] Generating SQL schema creation scripts for
HSQLDB
[torque-sql] Using classpath
[torque-sql] Generating to file
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\hsql\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for
MySQL
[torque-sql] Using classpath
[torque-sql] Generating to file
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mysql\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for
Oracle
[torque-sql] Using classpath
[torque-sql] Generating to file
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\oracle\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for
MS SQL
[torque-sql] Using classpath
[torque-sql] Generating to file
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\mssql\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for
Postgres
[torque-sql] Using classpath
[torque-sql] Generating to file
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\target\src\sql\postgres\report.portal.sql.generation
BUILD FAILED
File......
C:\Marina\Harvard\Projects\jakarta-jetspeed-2-MYSQL\maven.xml
Element... sql
Line...... 355
Column.... 39
Source file does not exist!
Total time: 12 seconds
Finished at: Thu Feb 24 21:27:54 EST 2005
Here is my build.properties (relevant parts):
# Override the database connection and
driverproperties in your ${USER_HOME}/build.properties
appropriately
# See:
# http://portals.apache.org/jetspeed-2/database.html
org.apache.jetspeed.test.database.url =
jdbc:mysql://localhost/j2test
org.apache.jetspeed.test.database.driver =
com.mysql.jdbc.Driver
org.apache.jetspeed.test.database.user = jetspeed2
org.apache.jetspeed.test.database.password = jetspeed2
org.apache.jetspeed.test.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
org.apache.jetspeed.test.database.default.name=j2test
org.apache.jetspeed.test.database.ojb.platform=mysql
org.apache.jetspeed.production.database.url =
jdbc:mysql://localhost/j2
org.apache.jetspeed.production.database.driver =
com.mysql.jdbc.Driver
org.apache.jetspeed.production.database.user =
jetspeed2
org.apache.jetspeed.production.database.password =
jetspeed2
org.apache.jetspeed.production.jdbc.drivers.path=C:/Marina/MySQL/mysql-connector-java-3.0.16-ga/mysql-connector-java-3.0.16-ga-bin.jar
org.apache.jetspeed.production.database.default.name=j2
org.apache.jetspeed.production.database.ojb.platform=mysql
(I am not sure about the ojb.platform property, there
were no directions on what it should be set to for
MySQL, so I decided to set it to 'mysql' instead of
keeping the default value of 'Hsqldb' ...)
Any idea what I did wrong?
Thanks!
Marina
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: Database parameters missing.
Posted by Unmesh Kulkarni <un...@gmail.com>.
Hi,
Evidenly, your Jetspeed is missing the DB parameters. When you copied
the binary folders, did you copy jetspeed.xml?
Please verify that the jetspeed.xml file is available under
%tomcat_home%/conf/localhost directory.
cheers,
Unmesh
On Wed, 23 Feb 2005 10:58:55 -0800 (PST), superman@talkin2u.com
<su...@talkin2u.com> wrote:
> Hi,
>
> I using Tomcat 5.5.7 and jetspeed on jdk 1.5 on a windows xp platform. I'm
> running hsql by using the command "maven start.production.server" then in
> another window I run "maven quickStart". Except when I deploy the
> jetspeed binary. In this case I reinstall Tomcat then copy the binary
> folders over to the appropriate directories under Tomcat and I get the
> same errors.
>
> What is not configured properly? I understand that I may have
> misconfigured something with the source build but the binary I imagined
> would work.
>
> I appreciate any insights,
>
> Chris
>
> I'm getting the errors while accessing jetspeed at
> http://localhost:8080/jetspeed.
>
> With the source build, I had to change the build.properties paths to use
> \\ instead of / to satisfy the windows environment.
> I had to modify 4 files during the source build to accomodate "enum" since
> it is a reserved word in jdk 1.5.
>
> After these adjustments the source compiles and deploys as planned. But
> when I type http://localhost:8080/jetspeed I get the following error
> whether I deploy the source build or the binary.
>
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR:
> SQLException thrown while trying to get Connection from Datasource
> (java:comp/env/jdbc/jetspeed)
> Cannot create JDBC driver of class '' for connect URL 'null'
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
> of class '' for connect URL 'null'
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDataSource(ConnectionFactoryAbstractImpl.java:204)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:112)
> at
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:105)
> at
> org.springframework.orm.ojb.PersistenceBrokerTransactionManager.doBegin(PersistenceBrokerTransactionManager.java:187)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:269)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:201)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:49)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
> at $Proxy7.createNode(Unknown Source)
> at
> org.apache.jetspeed.prefs.impl.PreferencesImpl.<init>(PreferencesImpl.java:96)
> at
> org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(PreferencesFactoryImpl.java:64)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
> at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
> at
> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:114)
> at
> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:96)
> at
> org.apache.jetspeed.components.SpringComponentManager.<init>(SpringComponentManager.java:44)
> at
> org.apache.jetspeed.engine.SpringEngine.initComponents(SpringEngine.java:108)
> at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:135)
> at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64)
> at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:590)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)
> at org.apache.catalina.core.StandardService.start(StandardService.java:450)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> Caused by: java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getDriver(Unknown Source)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
> ... 58 more
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'java.util.prefs.PreferencesFactory' defined in URL
> [file:/D:/apps/Tomcat-5.5/webapps/jetspeed/WEB-INF/assembly/jetspeed-spring.xml]:
> Initialization of bean failed; nested exception is
> org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs
> api. org.springframework.transaction.CannotCreateTransactionException:
> Could not create OJB transaction; nested exception is
> org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
> while trying to get Connection from Datasource
> (java:comp/env/jdbc/jetspeed)
> org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs
> api. org.springframework.transaction.CannotCreateTransactionException:
> Could not create OJB transaction; nested exception is
> org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
> while trying to get Connection from Datasource
> (java:comp/env/jdbc/jetspeed)
> at
> org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(PreferencesFactoryImpl.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
> at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
> at
> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:114)
> at
> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:96)
> at
> org.apache.jetspeed.components.SpringComponentManager.<init>(SpringComponentManager.java:44)
> at
> org.apache.jetspeed.engine.SpringEngine.initComponents(SpringEngine.java:108)
> at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:135)
> at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64)
> at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:590)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)
> at org.apache.catalina.core.StandardService.start(StandardService.java:450)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> org.apache.jetspeed.exception.JetspeedException: Jetspeed Initialization
> exception!
> at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:155)
> at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64)
> at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:590)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)
> at org.apache.catalina.core.StandardService.start(StandardService.java:450)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> Caused by: org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'java.util.prefs.PreferencesFactory' defined in
> URL
> [file:/D:/apps/Tomcat-5.5/webapps/jetspeed/WEB-INF/assembly/jetspeed-spring.xml]:
> Initialization of bean failed; nested exception is
> org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs
> api. org.springframework.transaction.CannotCreateTransactionException:
> Could not create OJB transaction; nested exception is
> org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
> while trying to get Connection from Datasource
> (java:comp/env/jdbc/jetspeed)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:300)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
> at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
> at
> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:114)
> at
> org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:96)
> at
> org.apache.jetspeed.components.SpringComponentManager.<init>(SpringComponentManager.java:44)
> at
> org.apache.jetspeed.engine.SpringEngine.initComponents(SpringEngine.java:108)
> at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:135)
> ... 28 more
> Caused by: org.apache.jetspeed.prefs.PreferencesException: Failed to
> initialize prefs api.
> org.springframework.transaction.CannotCreateTransactionException: Could
> not create OJB transaction; nested exception is
> org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown
> while trying to get Connection from Datasource
> (java:comp/env/jdbc/jetspeed)
> at
> org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(PreferencesFactoryImpl.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
> ... 38 more
> FATAL: Jetspeed: init() failed:
> org.apache.jetspeed.exception.JetspeedException: Unable to create Engine
> at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:76)
> at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: Database parameters missing.
Posted by David Sean Taylor <da...@bluesunrise.com>.
superman@talkin2u.com wrote:
> Hi,
>
> I using Tomcat 5.5.7 and jetspeed on jdk 1.5 on a windows xp platform. I'm
5.5 doesn't run with Jetspeed-2 unfortunately
http://issues.apache.org/jira/browse/JS2-187
--
David Sean Taylor
Bluesunrise Software
david@bluesunrise.com
[office] +01 707 773-4646
[mobile] +01 707 529 9194
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org