求熟知sae功能的大哥大姐帮忙看下,代码部署到sae上去后,提示404,看了jvm日志后,提示如下,应该是数据库没连接上,我使用的是spring mvc+hibernate+spring的架构
- [19/Jun/2014:13:16:47 +0800] JAVA_SAE_Fatal_error: HHH000299: Could not complete schema updateorg.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (access deny)org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:194)org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:505)org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1760)org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1798)org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:242)org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:372)org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:357)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$6.run(AbstractAutowireCapableBeanFactory.java:1535)java.security.AccessController.doPrivileged(Native Method)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1533)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1483)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory. yq37.javaruntime
- [19/Jun/2014:13:16:47 +0800] JAVA_SAE_Fatal_error: HHH000319: Could not get database metadataorg.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (access deny)org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:194)org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:505)org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1760)org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1798)org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:242)org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:372)org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:357)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$6.run(AbstractAutowireCapableBeanFactory.java:1535)java.security.AccessController.doPrivileged(Native Method)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1533)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1483)org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.j yq37.javaruntime
以下是我的数据库配置,应该也没问题(用户名,密码的星号是我加上去防止资料泄露,^_^)
url=jdbc:mysql://w.rdc.sae.sina.com.cn:3307/app_daizhiquan
driverClassName=com.mysql.jdbc.Driver
user=ll******yoj
password=zzzjk1wl34h2j23***************m2wx23xj
maxActive=8
minIdle=3
maxIdle=8
maxWait=40000
#++
initialSize=2
logAbandoned=true
removeAbandoned=true
removeAbandonedTimeout=30
timeBetweenEvictionRunsMillis=10000
numTestsPerEvictionRun=8
--转自