Uploaded image for project: 'Jetspeed 2 (Retired)'
  1. Jetspeed 2 (Retired)
  2. JS2-152

org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • None
    • 2.0-dev/cvs, 2.0-M2
    • None
    • None

    Description

      Hello,
      I'm trying to use jetspeed2 with tomcat 5.5, jdk 5.0 and ms sql 2000.
      I'm able to do all the steps on the web site but when I go to http://localhost:8080/jetspeed I get an empty page.

      any help would be appreciated.
      Thanks in advance,
      Paulo

      bellow you can find some of the files that I'm using:

      build.properties
      ================

      org.apache.jetspeed.project.home C:/Apps/ApacheGroup/Jetspeed/jakarta-jetspeed-2/
      org.apache.jetspeed.server.home C:/Apps/ApacheGroup/Tomcat5.5/
      org.apache.jetspeed.catalina.version.major 5
      org.apache.jetspeed.server.shared ${org.apache.jetspeed.server.home}/shared/lib/
      org.apache.jetspeed.deploy.war.dir ${org.apache.jetspeed.server.home}/webapps/
      org.apache.jetspeed.services.autodeployment.user j2deployer
      org.apache.jetspeed.services.autodeployment.password j2deployer
      maven.compile.source=1.4
      maven.compile.target=1.5

      1. -------------------------------------------------------------------------
      2. configure MSSQL Test DB
      3. -------------------------------------------------------------------------
        org.apache.jetspeed.test.database.default.name=mssql
        org.apache.jetspeed.test.database.url = jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=j2test
        org.apache.jetspeed.test.database.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
        org.apache.jetspeed.test.database.user = sa
        org.apache.jetspeed.test.database.password = ???
      4. -------------------------------------------------------------------------
      5. configure MSSQL Production DB
      6. -------------------------------------------------------------------------
        org.apache.jetspeed.production.database.default.name=mssql
        org.apache.jetspeed.production.database.url = jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=j2prod
        org.apache.jetspeed.production.database.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
        org.apache.jetspeed.production.database.user = sa
        org.apache.jetspeed.production.database.password = ???
      7. -------------------------------------------------------------------------
      8. MS SQL Driver Path Example, test and production
      9. -------------------------------------------------------------------------
        org.apache.jetspeed.test.jdbc.drivers.path=C:/Apps/JavaSoft/mssql200jdbc/lib/msbase.jar;C:/Apps/JavaSoft/mssql200jdbc/lib/mssqlserver.jar;C:/Apps/JavaSoft/mssql200jdbc/lib/msutil.jar
        org.apache.jetspeed.production.jdbc.drivers.path=C:/Apps/JavaSoft/mssql200jdbc/lib/msbase.jar;C:/Apps/JavaSoft/mssql200jdbc/lib/mssqlserver.jar;C:/Apps/JavaSoft/mssql200jdbc/lib/msutil.jar

      jetspeed.log
      ============

      2004-10-21 16:41:24,390 [Thread-1] INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Bean 'persistenceStoreTarget' instantiated via constructor [public org.apache.jetspeed.components.persistence.store.ojb.pb.PBStore(java.lang.String)]
      2004-10-21 16:41:24,625 [Thread-1] FATAL org.apache.jetspeed.prefs.impl.PreferencesProviderImpl - Failed to initialize prefs api. org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection
      org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection
      at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:641)
      at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:277)
      at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
      at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
      at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1808)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1333)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1445)
      at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
      at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
      at org.apache.jetspeed.components.persistence.store.ojb.pb.PBStore.getObjectByQuery(PBStore.java:239)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:142)
      at $Proxy0.getObjectByQuery(Unknown Source)
      at org.apache.jetspeed.prefs.impl.PreferencesImpl.getNode(PreferencesImpl.java:229)
      at org.apache.jetspeed.prefs.impl.PreferencesImpl.createPrefNode(PreferencesImpl.java:165)
      at org.apache.jetspeed.prefs.impl.PreferencesImpl.<init>(PreferencesImpl.java:114)
      at org.apache.jetspeed.prefs.impl.PreferencesProviderImpl.start(PreferencesProviderImpl.java:106)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      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:134)
      at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64)
      at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:137)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1003)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:836)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3783)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4045)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
      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:1079)
      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:1011)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:437)
      at org.apache.catalina.core.StandardService.start(StandardService.java:450)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:2009)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:538)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
      Caused by: org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown while trying to get Connection from Datasource (java:comp/env/jdbc/jetspeed)
      at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDataSource(ConnectionFactoryAbstractImpl.java:215)
      at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:112)
      at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:105)
      at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:637)
      ... 66 more
      Caused by: 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)
      ... 69 more
      Caused by: java.sql.SQLException: No suitable driver
      at java.sql.DriverManager.getDriver(DriverManager.java:243)
      at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
      ... 71 more

      Attachments

        Activity

          People

            Unassigned Unassigned
            prsmartins Paulo Martins
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: