eclipse中server.xml配置Oracle

本文介绍了如何配置Oracle和MySQL数据库连接,包括配置文件的具体参数设置,如路径、用户名、密码及数据库URL等关键信息。

配置Oracle

<Context docBase="G:/workspace/gxt20140714/WebContent" path="/gxt20140714" reloadable="true">

<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/myoracle" password="bilin" type="javax.sql.DataSource" url="jdbc:oracle:thin:@192.168.0.15:1521:ora" username="bilin"/>

 </Context>


配置mysql

<Context crossContext="true" debug="0" docBase="G:/workspace/aivideoconsole/WebContent" path="/aivideoconsole" privileged="true" reloadable="true">
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/mysql" password="123456" privileged="true" type="javax.sql.DataSource" url="jdbc:mysql://192.168.0.2:3306/billionsource?characterEncoding=gb2312" username="root"/>
 </Context>

ay14 03:39:46 Error MS2 WebLogicServer [STUCK] ExecuteThread: '141' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "619" seconds working on the request "Http Request Information: weblogic.servlet.internal.ServletRequestImpl@545919db[POST /lkmpmi/standardplateprocess/standardplate.jsf] ", which is more than the configured time (StuckThreadMaxTime) of "600" seconds in "server-failure-trigger". Stack trace: java.base@11.0.15.1/java.lang.Object.wait(Native Method) weblogic.transaction.internal.XAResourceDescriptor.startResourceUse(XAResourceDescriptor.java:744) weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1394) weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1327) weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:298) weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:686) weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:505) weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:362) weblogic.jdbc.jts.Driver.connect(Driver.java:175) weblogic.jdbc.common.internal.WLDataSourceImpl.getConnectionInternal(WLDataSourceImpl.java:655) weblogic.jdbc.common.internal.WLDataSourceImpl.getConnection(WLDataSourceImpl.java:611) weblogic.jdbc.common.internal.WLDataSourceImpl.getConnection(WLDataSourceImpl.java:604) weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:108) org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:138) org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:172) org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:348) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:316) org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:583) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1665) org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:323) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:622) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567) org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2099) org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:764) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2822) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2775) org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:561) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1232) org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911) org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1191) org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:447) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1279) org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2983) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1830) org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:1012) org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternal(EntityManagerImpl.java:954) org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:830) org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:696) jdk.internal.reflect.GeneratedMethodAccessor766.invoke(Unknown Source) java.base@11.0.15.1/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base@11.0.15.1/java.lang.reflect.Method.invoke(Method.java:566) weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:97) weblogic.persistence.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:164) weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:86) com.sun.proxy.$Proxy1325.find(Unknown Source) com.lkm.ejb.ncoperation.local.NcOperationDbEjb.getDetailEntity2(NcOperationDbEjb.java:996) com.lkm.ejb.ncoperation.local.NcOperationDbEjb.getDetailEntity(NcOperationDbEjb.java:1002) com.lkm.ejb.ncoperation.local.NcOperationDbEjb.getDetail(NcOperationDbEjb.java:1010) jdk.internal.reflect.GeneratedMethodAccessor3991.invoke(Unknown Source) java.base@11.0.15.1/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base@11.0.15.1/java.lang.reflect.Method.invoke(Method.java:566) com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101) com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:101) com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101) org.jboss.weld.module.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:72) org.jboss.weld.module.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52) jdk.internal.reflect.GeneratedMethodAccessor325.invoke(Unknown Source) java.base@11.0.15.1/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base@11.0.15.1/java.lang.reflect.Method.invoke(Method.java:566) com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:94) com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136) com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) com.sun.proxy.$Proxy1332.getDetail(Unknown Source) 什么意思
最新发布
06-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值