tomcat连接不上oracle数据库了

tomcat连接不上oracle数据库了 但是plsql能连接上 别人用电脑也能连接上 就是自己连接不上图片说明

11个回答

主要是看报错的,不一定是因为tomcat连接不上数据库的问题。看到报异常的这个情况分析一下, 从语义上看像是数据库死锁了,创建了一个紧急线程。然后看是C3P0那个使用的dataSource 数据库连接。
我们就去C3P0去看一看有没有该数据源连接配置。如果实在找不到解决方案,网上搜索一下,看了一下这个链接提供了很不错的解决方案:https://blog.csdn.net/songwenbinasdf/article/details/12433643。
确实如下:
图片说明

设置一下c3p0.maxStatements=0 就可以了。
我觉得
估计是c3p0在很多跟数据库交互很频繁并短促的情况下,c3p0 cache住了准备语句,造成了close时
死锁,死锁的是c3p0内部线程池,并不是数据库

syso_love
syso_love 说实话我是重新配置了一下tomcat就好啦 大佬下次采用你的
一年多之前 回复

怎么是sqlserver的jdbc?

仔细看看你程序连接数据库的配置文件
驱动、连接url、账号、密码。这四项最重要。
再者就是查看数据库服务是否启动 连接url和数据库是否输入错误。
如果都对,那就换一个版本的 数据库连接的jar包

数据库驱动弄错了,应该是oracle.jdbc.driver.OracleDriver,
ojdbc7.jar
Java classes when using the JDBC Thin and OCI client-side driver - with Java 7.0 VM.
ojdbc6.jar
Java classes when using the JDBC Thin and OCI client-side driver - with Java 6.0 VM.

检查防火墙的端口规则

sqlserver连oracle数据库的驱动程序版本要一致

之前有链接过吗? 如果需要你重新设置,数据库访问包,数据库密码,用户名等

以前是不是连接的sqlserver 啊?

有可能是下面三个地方出错了,你好好检查一下;
1、请求地址错了
2、对方服务端当了
3、对方服务端的逻辑有类似死循环之类的

共11条数据 1 尾页
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
连接不上oracle数据库
当连接不上时,先ping一下ip,看看能不能ping通,然后把实例换成ip:端口
连接不上ORACLE数据库
在vs的服务管理器中建立一个数据连接,数据连接的提供者是Oracle Provider for OLE DB,结果不能建立,信息提示是:OraOLEDBpus.dll 未能找到指定的模块,请问大家应怎么解决rn
c#连接不上oracle数据库
我的oracle数据库本地使用是OK的,可以正常使用,但是用C#程序连接不上,代码如下rn[code=C#]rn public OracleConnection GetOracleConnection() //在程序中写死连接信息rn rn this.serverIp = "localhost";rn this.port = "1521";rn this.serverName = "TEST";rn this.userName = "fym";rn this.password = "testtest";rnrn string connectionString = @"Server =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)" +rn "(HOST =" + serverIp + ")(PORT = " + port + "))) (CONNECT_DATA = (SERVICE_NAME =" + serverName + ") ) )" +rn ";uid=" + userName + ";pwd=" + password + ";Persist Security Info=True";rnrn OracleConnection connection=new OracleConnection(connectionString);rn if (connection.State == ConnectionState.Closed)rn rn connection.Open();rn rn return connection;rn [/code]rnconnection.Open();报错,请帮忙解决,谢谢!rn
plsql连接不上Oracle数据库
(1)提示没用监听,如果是本机Oracle可以查看Oracle服务和监听是否启动;如果是远程机器也可以查看一下;如果启动,而且手里又有之前连接成功的程序,可以测试一下,看是否成功。也可以用MyEclipse data explorer 新建一个连接数据库看是否成功,如果不成功,则可能是plsql环境变量配置的问题,可以写一个脚本,设置变量(网上说的设置变量,有些没有说明清楚,而且也不好去查那些变量
.net连接不上oracle数据库
本人刚弄oracle数据库,想在.net项目中配置oracle数据库,有没有图解说明的?文字可能描述不清楚,谢谢啊。
vc++ 在win7系统上连接不上oracle数据库
1.vc++写得服务器程序在XP 系统上[color=#FF0000]能联接[/color]本机的oracle数据库。(代码是在XP系统上VS平台编译的) rn但是同样的程序部署在win7系统上[color=#FF0000]却连接不上[/color]本机oracle数据库。(oracle 服务,监听已开,经测试也成功,PlSQL也能访问)。rn有什么解决的方法,是跟操作系统的数据库驱动有关吗。(XP系统上装的10g版本的oracle ,window7系统上装的是 11g 的版本)rnrn难道是要代码放在window7系统上重新编译代码吗?
eclipse连接不上TOMCAT????
我把eclipse和tomcat,lomboz,jdk都配置好了,也可以在eclipse中创建项目及编写jsp了。但在eclipse中启动tomcat后,在浏览器内输入网址却找不到/eclipse没能把文件包自动在tomcat的工作目录下产生。。怎么办?请教各位。。。
tomcat下如何连接oracle数据库?
连接池应该怎么配置,jdbc for oracle从哪里下载阿,高手帮忙!
tomcat怎么连接oracle数据库
我安装了tomcat,配了一个数据源(名称:oracleJNDI)rn怎么用这个数据源连接数据库?rnrn是不是这样:rn InitialContext ctx = new InitialContext();rn String dataSourceName="oracleJNDI";rn DataSource ds=null;rn ds=(DataSource)ctx.lookup(dataSourceName); rn Connection con=ds.getConnection("tmp","123");rn Statement sta = con.createStatement();rn ResultSet rs = sta.executeQuery("select * from tmp");rnrn while (rs.next())rn out.println(rs.getString(1));rn rn我这样试了一下,报错如下:rnorg.apache.jasper.JasperException: Name oracleJNDI is not bound in this Contextrn at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)rnrnrn先谢谢大虾了!!!!
weblogic连接不上oracle数据库,解决方案
大佬们,weblogic连接不上oracle数据库。 plsql能连接上 mysql也可以连接,唯独oracle连接不上。报错信息如下: 跪求解决方案啊,在线等。急!!!!!!! ...
Navicat连接不上Oracle数据库解决方法
我用的Navicat Premium 12,数据库是Orcale 11g  连接时连接不上是因为   navicat中文件oci.dll引起的 ,Navicat premium下载时会自动下载一个oci.dll文件,但是可能是版本不对的问题,所以连接时,会出现连接不上的问题,所以要替换oci.dll.   需要替换navciat的选项下的instantclient-basic-win-x86...
oracle数据库,客户端连接不上远程数据库
我是这样建立配置服务器和客户端的。rn服务器:在本机上装了虚拟机,os:linux db:oracle92 全局数据库名:ora92 tuxedo8.1 ip:192.168.122.3 (hostonly连接)rn客户端:本机 os:windows xp oracle92 client(只装了客户端) tuxedo8.1客户端 ip:192.168.122.1rn配置监听:监听1521端口,用system用户测试结果为成功。rn但是我用plsql去连全局数据库ora92却弹出错误“ORA-12535: TNS: 操作超时”(密码肯定是正确的,数据库名ora92和tnsnames.ora一致),而且我的tuxedo服务是可以使用的,也就是说通过tuxedo的服务我可以访问oracle的后台数据,但就是不知道为什么在windows下访问不了虚拟机下ora92。rn请教各位了,谢谢!rn
项目生成的exe连接不上oracle数据库
安装了Windows server 2008系统,然后装了oracle10,plsql可以连接成功,但是运行项目生成的exe文件连不上oracle数据库,请各位帮帮忙。谢谢
新人求助---BDE连接不上ORACLE数据库
在安装BDE后,在DATABASE处新建ORACLE,之后再SERVIER NAME选择下拉框报处“invalid filename”,我手动输入我的数据库名称,在USER NAME那里输入用户名,保存后,点右边的ORACLE右边的+号连接数据库,报错"ORA-03114:not connected to oracle". 请问这个要怎么配置才能弄好呢?rn我的数据库是10.1.0版本,client是10.2.0版本,另外,我在client文件夹下没有找到tnsnames.ora文件。
jboss数据源配置连接不上oracle数据库
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connectionrn at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)rn at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)rn at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)rn at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)rn at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)rn at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)rn at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)rn at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)rn at org.hibernate.loader.Loader.doQuery(Loader.java:673)rn at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)rn at org.hibernate.loader.Loader.doList(Loader.java:2220)rn at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)rn at org.hibernate.loader.Loader.list(Loader.java:2099)rn at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)rn at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)rn at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)rn at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)rn at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)rn at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)rn at com.ecore.services.ejb.common.impl.BaseDaoImpl.readByQL(BaseDaoImpl.java:111)rn at com.ecore.services.ejb.common.impl.BaseDaoImpl.readByCondition(BaseDaoImpl.java:101)rn at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)rn at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)rn at com.ecore.dao.util.finder.impl.FinderIntroductionInterceptor.invoke(FinderIntroductionInterceptor.java:34)rn at sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)rn at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)rn at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.aspects.remoting.ReplicantsManagerInterceptor.invoke(ReplicantsManagerInterceptor.java:51)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)rn at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)rn at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)rn at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:304)rn at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)rn at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)rn at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:809)rn at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:608)rn at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:406)rn at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:173)rnCaused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Io 异常: Socket is not connected); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io 异常: Socket is not connected))rn at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)rn at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)rn at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)rn ... 55 morernCaused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io 异常: Socket is not connected)rn at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:155)rn at org.jboss.resourcern2016-12-08 13:04:36,984 INFO [STDOUT] .connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)rn at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)rn at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:613)rn at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)rn at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)rn at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)rn at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)rn at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)rn ... 57 morernCaused by: java.sql.SQLException: Io 异常: Socket is not connectedrn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)rn at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)rn at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:441)rn at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)rn at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)rn at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)rn at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:472)rn at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:159)rn at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:107)rn at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:137)rn ... 65 more
我的怎么连接不上oracle数据库呀!
我的oracle连数据库的时候报:rnORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect Descriptor.rn可我用的是本机连接呀,不用装客户端吧rn我怎么知道服务器端的SERVICE_NAME呀,好像只有一个tnsnames.ora文件,要在那里找呀?
PL/SQL Developer连接不上oracle数据库
我安装的是oracle 10g Release2数据库,ora文件均已配置正确,oracle自带工具SQL Plus可以正常连接使用;我的PL/SQL Developer版本是5.1.3,始终无法连接上,请教各位高手为什么,如何解决?
SQLserver连接不上tomcat,寻求解决方法
在tomcat 中的问题提示rnjava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establisrnhing socket.rn at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Sourcern)rn at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)rn at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)rn at com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown Source)rnrn at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sournrce)rn at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Srnource)rn at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)rn at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)rn at java.sql.DriverManager.getConnection(Unknown Source)rn at java.sql.DriverManager.getConnection(Unknown Source)rn at org.apache.jsp.jsp_files._1_jsp._jspService(org.apache.jsp.jsp_files.rn_1_jsp:65)rn at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)rn at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapperrn.java:322)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2rn91)rn at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplrnicationFilterChain.java:252)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFrnilterChain.java:173)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVrnalve.java:213)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVrnalve.java:178)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jrnava:126)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jrnava:105)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValrnve.java:107)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.javrna:148)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.javarn:856)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.procernssConnection(Http11Protocol.java:744)rn at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpornint.java:527)rn at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFolrnlowerWorkerThread.java:80)rn at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPrnool.java:684)rn at java.lang.Thread.run(Unknown Source)rn
Ubuntu tomcat部署项目连接不上mys…
第一次下载安装了Ubuntu,之后按照顺序安装了jdk,tomcat。 接下来就步入mysql的安装(http://blog.csdn.net/fighter_yy/article/details/40753889): ubuntu上安装MySQL非常简单只需要几条命令就可以完成。   1. sudo apt-get install mysql-server     2. apt-g
Finereport部署tomcat 连接不上mysql数据库
datasource.xmlrnrnrn rn rnrn rn rn rn rnrn
在tomcat下部署opencms,连接oracle数据库
之前本机上面已经安装了opencms。(tomcat5.5+mysql+apache) 现在应项目需要,将数据库更改为oracle,因此需要重新安装opencms。但是不想再在其它机器上安装。 故现在将在本机上再安装一个opencms。同样适用tomcat应用服务器。则将opencms.war包重新命名后部署在tomcat下面。重启机器。重新安装。这里参照之前安装mysql时的样式。这里不再啰...
tomcat中连接oracle数据库的问题
我想用jsp + tomcat + oracle做一个小的论坛学习一下。请问如何配置tomcat才能连接到oracle,我用的是orcale自带jdbc,不想用jdbc-odbc桥。rn谢谢
本地没有oracle数据库 连接远程服务器上的oracle数据库
由于项目开发测试,需要在本地连接远程的Oracle数据库 连接远程Oracle需要两个软件: 一个Oracle客户端,instantclient-basic-win32-11.2.0.1.0.zip 备用连接 链接:https://pan.baidu.com/s/1V81_tv8OsPW0WC_12myzCA 提取码:290j 一个PL/SQL开发环境plsqldevelo...
安装不上tomcat
昨天重装了XP系统,但发现安装TOMCAT出问题.rn操作系统:WINDOWS XP;rn系统安装在D盘rnJDK:jdk-1_5_0_12-windows-i586-p.exernjdk安装路径为:D:\JavarnTOMCAT:jakarta-tomcat-5.5.7.exernJDK已经安装并且环境变量也已经配置好了,可以正常的调试运行JAVA程序.rn但是安装TOMCAT时显示No Java Virtual Machine found in folder:D:\Java\jre1.5.0_12.rn
tomcat 连接远程数据库掉线后就连接不上的问题
tomcat 连接远程数据库掉线后就连接不上的问题:rntomcat 连接远程数据库,正常情况没有问题,rn如果过程中掉线个1,2分钟,后面就算是物理连接意见正常了。但是TOMCAT的数据库连接也连接不上了,需要重新启动TOMCAT才能解决,请问如何处理这个情况。
怎样连接服务器上的ORACLE数据库
我的机器是局域网内部的,数据库服务器装在服务器上,我的机器上装得数据库的客户端。数据库名:ooa密码:ppt主机字符串:clse服务器地址192。168。50。10rn我用ORACLE的SQLPLUS可以访问数据库服务器。用DELPHI怎样连接上去呀,ADO的CONNECTION怎么设置?rn
如何连接服务器上的ORACLE数据库
如何连接服务器上的ORACLE数据库?假如服务器的IP为:192.168.0.1rn数据库的名字为computerrnrn还有,程序里面的语句是不是跟以前连SQL SERVER数据库的语句不一样呢rn比如说查找啊,删除啊等等之类的
怎样连接linux上oracle数据库
请问怎样在VB中连接安装在linux上oracle数据库? 谢谢
Java连接远程服务器上的oracle数据库
以连接腾讯云上的oracle服务器为例介绍连接方法。1、首先需要将给你的oracle服务器添加监听。这里我自己新建了一个数据库实例“testorcl”,需要他被外部客户端访问,所以给他加一个监听地址。2、这样就可以通过代码连接了Oracle数据库先创建一个表和添加一些数据1.先在Oracle数据库中创建一个student表:1 create table student 2 ( 3 i...
在本机连接服务器上的Oracle数据库
NULL 博文链接:https://harryalex.iteye.com/blog/1003455
为什么连接不到Oracle数据库上?
我的程序是这样的:rnClass.forName("oracle.jdbc.driver.OracleDriver")rncnn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.110:1521:ias", "scott", "tiger");rn一执行getConnection()就出现异常,大家给我分析一下问题出在哪,好吗?
求助,oracle数据库登不上
在cmd控制台上 用sysdba登录rn然后导入外部文件rn给我报sp2-0640 :未连接 rnshow user 为" "空的rn执行任何sql都是未连接rnrn我用plsql develpoerrn根本登不进去rnORA-12514:TNS:监听程序无法识别连接描述符中请求的服务rn怎么回事啊rnrn
PL/SQL连接不上oracle数据库
我的机子是win7 64位的,安装的是Oracle - OraClient11g_home1 然后安装了pl/sql。但是在连接的时候出现错误:rninitialization errorrncould not initializern"f:\app\Adiministrator\product\11.2.0\client_1\bin\oci.dll"rnMake sur you have the 32 bits oracle client installed.rnrnOCIDLL forced tornf:\app\Adiministrator\product\11.2.0\client_1\bin\oci.dllrnLoadLibrary(f:\app\Adiministrator\product\11.2.0\client_1\bin\oci.dll)rnreturn 0rnrnrn以上是错误信息。从网上查有的说安装32位oracle,但是本机子装32位的装不上,只能装64位的。还有的说修改这个plsql里的default.ini,我也不会修改。default.ini里的内容如下:rnID=PL/SQL Developer Preference Filernrn[General]rnName=System DefaultrnEnabled=TruernOrder=0rnRules=rnrn[Preferences]rnrnrnrnrn请大家帮帮忙,真地很急!谢谢了!到底该怎样才能连上数据库呢?
联不上oracle数据库,为什么
在SQLPLUS里面联不上数据库rnrn语句如下,错误如下rnSQL> connect sde/sde@beijing;rnERROR:rnORA-12543: TNS: 无法到达目的地主机
as连接不上手机
1、找到自己的SDK目录-platform-tools-adb.exe 2、输入命令  adb shell 3、会出现这个错误   error: cannot parse version string: kg01 4、cmd里运行一下这个命令就行了:adb kill-server
连接不上SQL2005...
“/Bookshop”应用程序中的服务器错误。rn--------------------------------------------------------------------------------rnrn在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接) rn说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 rnrn异常详细信息: System.Data.SqlClient.SqlException: 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)rnrn源错误: rnrnrn行 24: SqlConnection myconn = new SqlConnection(settings);rn行 25: //打开数据库连接rn行 26: [color=#FF0000]myconn.Open();[/color]rn行 27: rn行 28: SqlCommand mycmd = new SqlCommand("MostSoldBooks", myconn);rn rnrn源文件: c:\Inetpub\wwwroot\Bookshop\Default.aspx.cs 行: 26 rnrn堆栈跟踪: rnrnrn[SqlException (0x80131904): 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)]rn System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734915rn System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188rn System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820rn System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628rn System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170rn System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359rn System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28rn System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424rn System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66rn System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496rn System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82rn System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105rn System.Data.SqlClient.SqlConnection.Open() +111rn _Default.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\Bookshop\Default.aspx.cs:26rn System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15rn System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34rn System.Web.UI.Control.OnLoad(EventArgs e) +99rn System.Web.UI.Control.LoadRecursive() +47rn System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061rnrn rn--------------------------------------------------------------------------------rn版本信息: Microsoft .NET Framework 版本:2.0.50727.42; ASP.NET 版本:2.0.50727.42 rnrnrn----------------rnrnSQL Server (SQLEXPRESS)服务已经启动rn本地连接和远程连接中已经选定 同时使用TCP/IP和named pipesrnSQLBrowser服务已经启动rnrn附上Web.config中一段rn rn rn rn
oracle连接不上
各位兄弟:快帮帮忙,兄弟在这谢谢了rn这是我的程序抛出的异常:rn18079 [main] ERROR util.JDBCExceptionReporter - Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'rn18079 [main] WARN cfg.SettingsFactory - Could not obtain connection metadatarnorg.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver', cause: rnjava.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverrn at java.net.URLClassLoader$1.run(URLClassLoader.java:200)rn at java.security.AccessController.doPrivileged(Native Method)rn at java.net.URLClassLoader.findClass(URLClassLoader.java:188)rn at java.lang.ClassLoader.loadClass(ClassLoader.java:306)rn at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)rn at java.lang.ClassLoader.loadClass(ClassLoader.java:251)rn at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)rn at java.lang.Class.forName0(Native Method)rn at java.lang.Class.forName(Class.java:164)rn at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:730)rn at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)rn at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)rn at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)rn at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)rn at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactoryrn at cn.com.mstar.web.listener.StartupListener.contextInitialized(StartupListener.java:50)rn at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)rn at org.apache.catalina.core.StandardContext.start(StandardContext.java:4336)rn at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)rn at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)rn at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)rn at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)rn at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)rn at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)rn at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)rn at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)rn at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023)rn at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015)rn at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)rn at org.apache.catalina.core.StandardService.start(StandardService.java:448)rn at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)rn at org.apache.catalina.startup.Catalina.start(Catalina.java:552)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:585)rn at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)rn at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)rnorg.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver', cause: oracle.jdbc.driver.OracleDriverrnorg.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver', cause: oracle.jdbc.driver.OracleDriverrnorg.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver', cause: rnjava.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver rn我程序没有问题,那odbc14.jar包也加上去了rn
sqlserver 连接不上
求助:rn服务器是win2000操作系统,装了sqlserver2000,有一个客户机是winxprn访问服务器时候总是连接不上数据库,可是访问服务器上的共享文件时,输入guest用户名,只要这样访问一次,就能访问数据库了,请问这是为什么?如何才能直接访问数据库?rn我现在已经升级了sp4 ,
gssftp 连接不上
redhat enterprise 5 gssftp 连接不上rngoogle搜过了,答案都试过都不行.rnrn[seh@localhost xinetd.d]$ cat gssftprn# default: offrn# description: The kerberized FTP server accepts FTP connections \rn# that can be authenticated with Kerberos 5.rnservice ftprnrn flags = REUSErn socket_type = streamrn wait = norn user = rootrn server = /usr/kerberos/sbin/ftpdrn server_args = -lrn log_on_failure += USERIDrn disable = nornrnrnseh@localhost xinetd.d]$ cat krb5-telnetrn# default: offrn# description: The kerberized telnet server accepts normal telnet sessions, \rn# but can also use Kerberos 5 authentication.rnservice telnetrnrn flags = REUSErn socket_type = streamrn wait = norn user = rootrn server = /usr/kerberos/sbin/telnetdrn log_on_failure += USERIDrn disable = nornrnservice telnetrnrn flags = REUSErn socket_type = streamrn wait = norn user = rootrn server = /usr/sbin/in.telnetdrn log_on_failure += USERIDrn disable = nornrnrn[seh@localhost xinetd.d]$ netstat -a |grep ftprntcp 0 0 *:ftp *:* LISTENrn[seh@localhost xinetd.d]$rnrn[root@localhost xinetd.d]# netstat -tlnup |grep 21rntcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN 4265/xinetdrntcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 2144/sendmail: accerntcp 0 0 :::22 :::* LISTEN 2111/sshdrnrn[root@localhost xinetd.d]# ftp 192.168.0.4rnConnected to 192.168.0.4.rn220 localhost.localdomain FTP server (Version 5.60) ready.rn334 Using authentication type GSSAPI; ADAT must followrnGSSAPI accepted as authentication typernGSSAPI error major: An invalid name was suppliedrnGSSAPI error minor: Cannot determine realm for numeric host addressrnGSSAPI error: initializing contextrnGSSAPI authentication failedrn334 Using authentication type KERBEROS_V4; ADAT must followrnKERBEROS_V4 accepted as authentication typernKerberos V4 krb_mk_req failed: You have no tickets cachedrnrnName (192.168.0.4:seh): rootrn331 Password required for root.rnPassword:rn530 Login incorrect.rnLogin failed.rnRemote system type is UNIX.rnUsing binary mode to transfer files.rnftp>rn
连接不上
谁能给我一个测试数据库是否连接上的程序rn看下面的程序有问题rn<%rnset conn=server.createobject("adodb.connection")rnconn.open "driver=sql server;dsn=tongxun;server=(local);uid=use;pwd=123;database=tongxun"rnstrsql="insert into tongxun(姓名,性别,年龄,电话,地址) values('"&request.form("name")&"', '"&request.form("sex")&"','"&request.form("age")&"','"&request.form("tel")&"')"rnconn.execute strsqlrn set conn=nothingrn response.write"已输入完毕!"rn %>rn上满的程序在conn.execute strsql出有问题rn
相关热词 c# stream 复制 android c# c#监测窗口句柄 c# md5 引用 c# 判断tabtip 自己写个浏览器程序c# c# 字符串变成整数数组 c#语言编程写出一个方法 c# 转盘抽奖 c#选中treeview