连接oracle的平台部署

目前tomcat启动后，可以打开admin登陆界面，但是用admin/teemlink登陆，报错“*用户不存在！;”

1.Java环境变量，cmd中查看java_home,path,classpath，均已配置正常，测试可见图片
C:\Documents and Settings\Administrator>echo %OS%
Windows_NT

C:\Documents and Settings\Administrator>java -version
java version "1.6.0_10-rc2"
Java(TM) SE Runtime Environment (build 1.6.0_10-rc2-b32)
Java HotSpot(TM) Client VM (build 11.0-b15, mixed mode, sharing)

C:\Documents and Settings\Administrator>javac test.java

C:\Documents and Settings\Administrator>java test
This is a test!

C:\Documents and Settings\Administrator>echo %JAVA_HOME%
C:\Program Files\Java\jdk1.6.0_10

C:\Documents and Settings\Administrator>echo %PATH%
C:\Program Files\Java\jdk1.6.0_10\bin;E:\BizFiles\oracle\oracle11.2.0\dbhome\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem

C:\Documents and Settings\Administrator>echo %CLASSPATH%
.;C:\Program Files\Java\jdk1.6.0_10\lib\dt.jar;C:\Program Files\Java\jdk1.6.0_10\lib\tools.jar;


2.数据库配置  oracle 11g,本机安装，用户名/密码 myapp/1
YAOXG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = yaoxg)
      (SERVER = DEDICATED)
    )
  )
能正常链接，并可见表，测试可见图片。

3.tomcat环境
试用产品自带

您好，能把您的tomcat启动的服务贴图出来吗？看下是否报错。

tomcat有报错的

ader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2211)
        ... 47 more
12:16:00,562  INFO AutoAuditJobManager:136 - ********************* Auto Audit Jo
b Manager Init Jobs End ********************
org.hibernate.exception.SQLGrammarException: could not execute query        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2214)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at cn.myapps.base.dao.HibernateBaseDAO.getDatas(HibernateBaseDAO.java:23
7)
        at cn.myapps.base.dao.HibernateBaseDAO.getDatas(HibernateBaseDAO.java:16
4)
        at cn.myapps.base.dao.HibernateBaseDAO.getDatas(HibernateBaseDAO.java:11
1)
        at cn.myapps.base.dao.HibernateBaseDAO.simpleQuery(HibernateBaseDAO.java
:677)
        at cn.myapps.base.ejb.AbstractDesignTimeProcessBean.doSimpleQuery(Abstra
ctDesignTimeProcessBean.java:330)
        at cn.myapps.core.task.ejb.TaskProcessBean$$EnhancerByCGLIB$$738b5193.CG
LIB$doSimpleQuery$8(<generated>)
        at cn.myapps.core.task.ejb.TaskProcessBean$$EnhancerByCGLIB$$738b5193$$F
astClassByCGLIB$$e84e9a0.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:182)
        at cn.myapps.core.task.ejb.TaskProcessBean$$EnhancerByCGLIB$$738b5193.do
SimpleQuery(<generated>)
        at cn.myapps.base.web.listener.StartupListener.contextInitialized(Startu
pListener.java:102)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3830)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
337)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

        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.PreparedStatement$$EnhancerByProxool$$9ae7fd79.executeQuery
(<generated>)
        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)
        ... 42 more
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}
12:16:01,328  INFO pushlet:79 - Logging intialized logger class=class nl.justobj
ects.pushlet.util.Log4jLogger
12:16:01,328  INFO pushlet:79 - init() Pushlet Webapp - version=2.0.4 built=2010
0205-1406
12:16:01,343  INFO pushlet:79 - SessionManager created className=class nl.justob
jects.pushlet.core.SessionManager
12:16:01,343  INFO pushlet:79 - SessionManager: Wed Dec 14 12:16:01 CST 2011 sta
rted; interval=60000ms
12:16:01,343  INFO pushlet:79 - Dispatcher created className=class nl.justobject
s.pushlet.core.Dispatcher
12:16:01,343  INFO pushlet:79 - Dispatcher started
12:16:01,343  INFO pushlet:79 - EventSourceManager: start
12:16:01,343  INFO pushlet:79 - Activating 0 EventSources
12:16:01,343  INFO pushlet:79 - EventSources activated
2011-12-14 12:16:01 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2011-12-14 12:16:01 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2011-12-14 12:16:01 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/15  config=null
2011-12-14 12:16:01 org.apache.catalina.startup.Catalina start
信息: Server startup in 12501 ms
org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2214)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at cn.myapps.base.dao.HibernateBaseDAO.getData(HibernateBaseDAO.java:83)

at cn.myapps.core.deploy.application.dao.HibernateApplicationDAO.getAppl
icationByDomainName(HibernateApplicationDAO.java:32)
        at cn.myapps.core.deploy.application.ejb.ApplicationProcessBean.getAppli
cationByDomainName(ApplicationProcessBean.java:45)
        at cn.myapps.core.deploy.application.ejb.ApplicationProcessBean$$Enhance
rByCGLIB$$78bb0bd5.CGLIB$getApplicationByDomainName$8(<generated>)
        at cn.myapps.core.deploy.application.ejb.ApplicationProcessBean$$Enhance
rByCGLIB$$78bb0bd5$$FastClassByCGLIB$$f5f96be7.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:174)
        at cn.myapps.core.deploy.application.ejb.ApplicationProcessBean$$Enhance
rByCGLIB$$78bb0bd5.getApplicationByDomainName(<generated>)
        at org.apache.jsp.index_jsp._jspService(index_jsp.java:264)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:393)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
20)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:177)
        at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDis
patcher.java:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiL
anguageFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilte
r.java:25)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java
:85)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java
:27)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在

        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.PreparedStatement$$EnhancerByProxool$$9ae7fd79.executeQuery
(<generated>)
        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)
        ... 50 more
12:18:16,828  INFO MultiLanguageProperty:48 - Initializing property multiLanguag
e_i18n_CN.properties
12:18:16,828  INFO MultiLanguageProperty:48 - Initializing property multiLanguag
e_i18n_EN.properties
12:18:16,828  INFO MultiLanguageProperty:48 - Initializing property multiLanguag
e_i18n_RU.properties
12:18:16,843  INFO MultiLanguageProperty:48 - Initializing property multiLanguag
e_i18n_TW.properties

您好，您加我QQ:568601086.下午远程帮你看下

跟客户沟通原因是因为配置oracle数据库后第一次启动数系统表没有生成完全以及数据盘配置链接问题。问题已解决。具体关于数据库配置请参看平台打包发布的《MyApps配置说明书V2.5.doc》文档。里面有关于数据库更改的详细说明。

....啥意思，问题还没解决呢。我加上面的qq也没人理我啊

不好意思，同事记错了，由于论坛整理，您的图片丢失了，所以目前还不太清楚您的问题，请问现在解决了吗，没有的话，请留下您的QQ，我加您，晚点远程帮您看一下。

qq:47800606 垚