myappsv2.4.0.4617更改连接数据库问题

myappsv2.4.0.4617

proxool.properties

更改

jdbc-0.proxool.alias=pool1

## MySQL

#jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
#jdbc-0.proxool.driver-url=jdbc:mysql://localhost:3306/obpm?useUnicode=true&characterEncoding=utf8
#jdbc-0.user=root
#jdbc-0.password=

## Oracle

jdbc-0.proxool.driver-class=oracle.jdbc.driver.OracleDriver
jdbc-0.proxool.driver-url=jdbcracle:thinlocalhost:1521rcl
jdbc-0.user=obpm_xt
jdbc-0.password=obpm_xt


hibernate.properties
更改

## auto schema export

#hibernate.hbm2ddl.auto create-drop
hibernate.hbm2ddl.auto create
#hibernate.hbm2ddl.auto update
#hibernate.hbm2ddl.auto validate


启动tomcat报错

如下


        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.sql.SQLException: ORA-00933: SQL 命令未正确结束

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
dStatement.java:796)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
nt.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
redStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:3329)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:
100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.ja
va:57)
        at $java.sql.Wrapper$$EnhancerByProxool$$54215f55.executeQuery(<generate
d>)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
        at org.hibernate.loader.Loader.doQuery(Loader.java:662)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2211)
        ... 48 more
08:55:18,796  INFO Logger:51 - Logging using commons-logging.
Pushlet[INFO] Config: loading pushlet.properties from classpath
Pushlet[INFO] Config: loaded values={pull.refresh.wait.max.millis=10000, subscri
ber.class=cn.myapps.core.pushlet.OBPMSubscriber, session.timeout.mins=5, log.lev
el=4, config.version=1.0.2, sessionmanager.class=nl.justobjects.pushlet.core.Ses
sionManager, queue.size=24, listen.force.pull.all=false, queue.read.timeout.mill
is=1000, poll.refresh.wait.max.millis=10000, listen.force.pull.agents=safari, pu
ll.refresh.timeout.millis=300000, subscription.class=nl.justobjects.pushlet.core
.Subscription, queue.write.timeout.millis=20, logger.class=nl.justobjects.pushle
t.util.Log4jLogger, session.class=nl.justobjects.pushlet.core.Session, session.i
d.generation=randomstring, dispatcher.class=nl.justobjects.pushlet.core.Dispatch
er, poll.refresh.wait.min.millis=6000, poll.refresh.timeout.millis=60000, pull.r
efresh.wait.min.millis=5000, session.id.size=10, controller.class=nl.justobjects
.pushlet.core.Controller, sources.activate=true}
08:55:20,343  INFO pushlet:79 - Logging intialized logger class=class nl.justobj
ects.pushlet.util.Log4jLogger
08:55:20,343  INFO pushlet:79 - init() Pushlet Webapp - version=2.0.4 built=2010
0205-1406
08:55:20,343  INFO pushlet:79 - SessionManager created className=class nl.justob
jects.pushlet.core.SessionManager
08:55:20,359  INFO pushlet:79 - SessionManager: Tue Mar 29 08:55:20 CST 2011 sta
rted; interval=60000ms
08:55:20,359  INFO pushlet:79 - Dispatcher created className=class nl.justobject
s.pushlet.core.Dispatcher
08:55:20,359  INFO pushlet:79 - Dispatcher started
08:55:20,359  INFO pushlet:79 - EventSourceManager: start
08:55:20,359  INFO pushlet:79 - Activating 0 EventSources
08:55:20,359  INFO pushlet:79 - EventSources activated
2011-3-29 8:55:21 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2011-3-29 8:55:21 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2011-3-29 8:55:21 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/47  config=null
2011-3-29 8:55:21 org.apache.catalina.startup.Catalina start
信息: Server startup in 24145 ms


数据初始化只生成了部分表

回复 1# oneyufeng
楼主应该如下修改：