Ate Douma (JIRA)
Fri, 01 Apr 2005 07:16:11 -0800
[ http://issues.apache.org/jira/browse/JS2-152?page=history ] Ate Douma closed JS2-152: ------------------------- Resolution: Won't Fix Fix Version: 2.0-dev/cvs 2.0-M2 This was a problem with Tomcat 5.5 deployment which requires a different Datasource configuration than Tomcat 5.0. Since the latest Jetspeed-2 in cvs now supports Tomcat 5.5 (with using a different Datasource condiguration) this problem is no longer valid. I suggest testing this out again with the latest cvs source (or the M2 release which we will be preparing this weekend) and create a new issue if you still have problems. > org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager > instance could not obtain a connection > --------------------------------------------------------------------------------------------------------------- > > Key: JS2-152 > URL: http://issues.apache.org/jira/browse/JS2-152 > Project: Jetspeed 2 > Type: Bug > Reporter: Paulo Martins > Fix For: 2.0-dev/cvs, 2.0-M2 > > 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 > # ------------------------------------------------------------------------- > # configure MSSQL Test DB > # ------------------------------------------------------------------------- > 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 = ??? > # ------------------------------------------------------------------------- > # configure MSSQL Production DB > # ------------------------------------------------------------------------- > 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 = ??? > # ------------------------------------------------------------------------- > # MS SQL Driver Path Example, test and production > # ------------------------------------------------------------------------- > 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 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]