thinkphp3.2连接oracle查询出错 5C

1thinkphp3.2.2多数据库连接,一个是mysql,一个是oracle。mysql连接正常。在测试oracle连接时,写了查询语句报错。

2.报错信息

图片说明

3我写的oracle查询代码

图片说明

求大佬指点!!!

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
oracle异构连接mysql查询出错
现在想要用oracle连接一个mysql数据库,现在已经配置成功,但是在查询mysql数据库的数据时,有错误:rnoracle与mysql在同一台服务器上hp 11.23 64位rnoracle:oracle 10.2.0.1 64位rnmysql:4.0 64位rnrn问题:rnrn在查询mysql数据库中的数据时,当查询一个数据量比较大的表(20亿条记录以上),[color=#FF0000]第一次查询不会出现错误[/color],但是在间隔时间比较短(10秒以内),再用同一条SQL语句去查询mysql时,就会出现以下错误:rnrnERROR at line 1:rnORA-28500: connection from ORACLE to a non-Oracle system returned this message:rn[Generic Connectivity Using ODBC][MySQL][ODBC 3.51rnDriver][mysqld-4.0.24.4(+)-log]无法打开文件: './test/test123.frm'rn(错误号: 24) (SQL State: S0002; SQL Code: 1017)rnORA-02063: preceding 2 lines from DDDrnrnrn请问各位,是哪个值设置小了,还是哪里出错了。rn
ThinkPHP3.2查询表结构
查询所有表(记录数,数据大小,索引大小) M()->query('SHOW TABLE STATUS'); 查询表sql。 M()->query("show create table sc_name"); 查询表结构。 M()->query("show columns from sc_name");  ...
thinkphp3.2 or 查询 (同字段)
不同字段在手册中以及有详细的说明 此处也是直接拿过来本文主要讲解的是同字段 or 查询 (毕竟or 查询速度是优于 in的)$map['id'] = array(array('gt',3),array('lt',10), 'or') ;结果为 id<100 or id>500希望本文章能帮到大家 ^ _ ^...
ODBC连接ORACLE出错
客户端工作站要访问ORACLE数据库的话都的安装ORACLE客户端组件rn我单位所有的机都装了,通过ORACLE的开发工作DEVELOPER访问数据库都没问题,但通过ODBC连接访问的话,有些机会报错,说缺少了组件,有些机又不会rn不管那种操作系统都会出现这样的情况,就是有些机无问题有些机不行,rn具体报错是:rnThe Oracle(tm) client and networking components were not found.rnThese components are supplied by Oracle Corporation and are part ofrnthe Oracle Version 7.3 (or greater) client software installation.rnYou will be unable to use this driver until these components have beenrninstalled.rn
java 连接oracle 出错
我用JAVA远程连接ORACLE 8I 时出现异常,下面是连接代码和出错报告请高手帮忙看看。rnpublic static Connection dbConn(String name,String pass) rntry rn Class.forName("oracle.jdbc.OracleDriver");rn catch (ClassNotFoundException e) rne.printStackTrace();rnrntry rnconn =DriverManager.getConnection("jdbc:oracle:thin:@10.53.23.11:1521:xMFY",name,pass);rn catch (SQLException e1) rne1.printStackTrace();rnrnreturn conn;rnrnpublic static void main(String[] args)rn rntryrnconn=dbConn("btsrmis","btsrmis");rnif(conn==null)rnSystem.out.println("ORACLE DB connect failed!");rnSystem.exit(0);rnrnSystem.out.println("ORACLE DB connect success!");rnconn.close();rncatch(Exception e)rne.printStackTrace();rn rnrnrnORACLE驱动CLASSES12.JAR都装好了。运行出错:rnrnjava.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)rn at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:263)rn at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)rn at java.sql.DriverManager.getConnection(Unknown Source)rn at java.sql.DriverManager.getConnection(Unknown Source)rn at db.oracle.util.DBConn.dbConn(DBConn.java:16)ORACLE DB connect failed!rnrn at db.oracle.util.DBConn.main(DBConn.java:25)rn会不会是远程数据库问题?rn
连接oracle出错!!
刚刚开始学习oracle,用ECLIPSE连接oracle 9i时,提示以下错误:rnSQLState:nullrnMessage:Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))rnVendor:17002rn看了半天也没看懂是什么错误,望高人指点
连接Oracle出错,why?
ado2.5的版本rn使用以下连接语句,可以连接,但是无法显示图片,提示不支持数据格式rnProvider=OraOledb.Oracle.1;Password=xxx;User ID=xxx;Data Source=xxx;Persist Security Info=Truernrn使用以下连接语句,无法连接(某些机器),可以显示图片rnMSDAORA.1;User ID=xxx;password=xxx;Data Source=xxx;Persist Security Info=Falsernrn如果安装了网站的oracle9,就可以,如果用迷你客户端,就不行rnrnrnwho给我一个答案
Java连接 oracle出错
Java web程序出现下面的错误rnjdk1.6 tomcat6.0 myeclipse6.0 oracle9.1 rnrn使用 ojdbc14和 ojdbc6总是出现一下错误rnrn我把程序改为普通Java就用ojdbc14可以 用ojdbc6也出错 rn怎么回事啊rnHTTP Status 500 - rnrn--------------------------------------------------------------------------------rnrntype Exception reportrnrnmessage rnrndescription The server encountered an internal error () that prevented it from fulfilling this request.rnrnexception rnrnjavax.servlet.ServletException: Servlet execution threw an exceptionrnrnrnroot cause rnrnjava.lang.UnsupportedClassVersionError: Bad version number in .class filern java.lang.ClassLoader.defineClass1(Native Method)rn java.lang.ClassLoader.defineClass(Unknown Source)rn java.security.SecureClassLoader.defineClass(Unknown Source)rn org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1819)rn org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:872)rn org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1327)rn org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206)rn java.lang.ClassLoader.loadClassInternal(Unknown Source)rn java.lang.Class.forName0(Native Method)rn java.lang.Class.forName(Unknown Source)rn com.v512.guestbook.AddMessageServlet.doPost(AddMessageServlet.java:52)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:710)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:803)rnrnrnnote The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.rnrnrn--------------------------------------------------------------------------------rnrnApache Tomcat/6.0.16
asp.net连接oracle出错
1。数据库和web服务器不是安装在同一台服务器上rn2。web服务器已安装oracle9.1客户端rn3。采用System.Data.OracleClientrn4。连接字符串为 string strConn="Data source=数据库名称;user id=用户名;password=密码;server=服务器ip地址";rn5。给了asp.net和network services对oracle/bin目录的所有权限rnrnrn连接时还是出错:OCIEnvCreate failded with return code -1 error message.....
连接oracle出错
test_oracle.jsp<%@ page contentType="text/html;charset=gb2312"%> rn<%@ page import="java.sql.*"%> rn rn rn<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); rnString url="jdbc:oracle:thin:@localhost:1521:mao"; rn//orcl为你的数据库的SID rnString user="mwy"; rnString password="oracle"; rnConnection conn= DriverManager.getConnection(url,user,password); rnStatement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rnString sql="select * from md"; rnResultSet rs=stmt.executeQuery(sql); rnwhile(rs.next()) %> rn您的第一个字段内容为:<%=rs.getString(1)%> rn您的第二个字段内容为:<%=rs.getString(2)%> rn<%%> rn<%out.print("数据库操作成功,恭喜你");%> rn<%rs.close(); rnstmt.close(); rnconn.close(); rn%> rn rn rn出错信息rnHTTP Status 500 - rnrn--------------------------------------------------------------------------------rnrntype Exception reportrnrnmessage rnrndescription The server encountered an internal error () that prevented it from fulfilling this request.rnrnexception rnrnjavax.servlet.ServletException: oracle.jdbc.driver.OracleDriverrn org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:682)rn org.apache.jsp.Metadata.test_005foracle_jsp._jspService(test_005foracle_jsp.java:76)rn org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:856)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:320)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:856)rnrnrnroot cause rnrnjava.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverrn org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1373)rn org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1220)rn org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:188)rn org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:114)rn java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)rn java.lang.Class.forName0(Native Method)rn java.lang.Class.forName(Class.java:141)rn org.apache.jsp.Metadata.test_005foracle_jsp._jspService(test_005foracle_jsp.java:45)rn org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:856)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:320)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:856)rnrnrnnote The full stack trace of the root cause is available in the Tomcat logs.rnrnrn--------------------------------------------------------------------------------rnrnApache Tomcat/5.0.9
连接oracle出错?
Invalid length for connection option 'data source', maximum length is 128. rnrnstring ora_myConnection;rn ora_myConnection = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=vetan)))"; rn ora_myConnection += "User Id=system;Password=jv2rwc8;";rn OracleConnection myConnection = new OracleConnection(ora_myConnection);rnrnmyConnection.open();rnrn请各位大侠指教rn
java连接oracle出错
[color=red]java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection[/color]rn用plsql developer能连接上,但是在程序里面出错了rn[code="java"]java.sql.SQLException: Io 异常: The Network Adapter could not establish the connectionrn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)rn at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)rn at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:413)rn at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:164)rn at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)rn at java.sql.DriverManager.getConnection(DriverManager.java:582)rn at java.sql.DriverManager.getConnection(DriverManager.java:185)rn at com.test.DB.getConn(DB.java:37)rn at com.test.DB.main(DB.java:60)rn[/code]
java连接Oracle出错
import java.sql.*;rnrnpublic class JdbcExample rn rn public static void main(String[] args)rn String serverName = "localhost";rn try rn Class.forName("oracle.jdbc.driver.OracleDriver");rn String url = "jdbc:oracle:thin:@"+serverName+":1521:ora9";rn Connection conn = DriverManager.getConnection(url,"scott","tiger");rn Statement stmt = conn.createStatement();rn ResultSet rs = stmt.executeQuery("select * from dept");rn while(rs.next())rn System.out.print("DeptNo: "+rs.getInt(1));rn System.out.print("\tDname: " + rs.getString(2));rn System.out.println("\tLoc: " + rs.getString(3));rn rn rs.close();rn stmt.close();rn conn.close();rn rn catch (Exception e) rn e.printStackTrace();rn rn rnrn提示Class.forName("oracle.jdbc.driver.OracleDriver");rn出错,rnClassNotFoundExceptionrn
Oracle 8.1.7连接出错!?
ASP.NET与Oracle8.1.7连接时提示没有找到Oracle客户端,可是我的WEB服务器上已经安装Oracle8.1.7的客户端了呀,并且tnsping已经Ping通了服务名了!rn我的WEB服务器为Win2000,数据库服务器是WEB2000和Oracle8.1.7。rn同一个应用在我自己的计算机上运行成功,并到WEB服务器上就出了这个问题!我在WEB服务器上已经安装了微软.NET与Oracle连接的补丁。rn提示信息为:rnrn“/yyweb”应用程序中的服务器错误。 rn没有发现 Oracle 客户端和网络组件。这些组件由 Oracle 公司提供,是 Oracle 7.3.3版(或更新)客户端软件安装的一部分。 提供者将无法使用直到这些组件被安装为止。 rn说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 rn异常详细信息: System.Data.OleDb.OleDbException: 没有发现 Oracle 客户端和网络组件。这些组件由 Oracle 公司提供,是 Oracle 7.3.3版(或更新)客户端软件安装的一部分。 提供者将无法使用直到这些组件被安装为止。rn源错误: rn执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。 rn堆栈跟踪: rn[OleDbException (0x80004005): 没有发现 Oracle 客户端和网络组件。这些组件由 Oracle 公司提供,是 Oracle 7.3.3版(或更新)客户端软件安装的一部分。rn提供者将无法使用直到这些组件被安装为止。]rn System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20rn System.Data.OleDb.OleDbConnection.InitializeProvider() +57rn System.Data.OleDb.OleDbConnection.Open() +203rn sgyweb.aspx.CaiXun.yyGhqk(String yyDm, String yyMc)rn sgyweb.aspx.CaiXun.Page_Load(Object sender, EventArgs e)rn System.Web.UI.Control.OnLoad(EventArgs e) +67rn System.Web.UI.Control.LoadRecursive() +35rn System.Web.UI.Page.ProcessRequestMain() +731rn版本信息: Microsoft .NET Framework 版本:1.1.4322.573; ASP.NET 版本:1.1.4322.573rnrn大家帮忙看看是什么问题,谢谢!
JSP连接ORACLE出错
<%@ page contentType="text/html;charset=gb2312"%> rn  <%@ page import="java.sql.*"%> rn   rn   rn  <%rn Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); rn  String url="jdbc:oracle:thin:@192.168.0.1:1521:shu"; rn  //orcl为你的数据库的SID rn  String user="zhang"; rn  String password="san"; rn  Connection conn= DriverManager.getConnection(url,user,password); rn  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rn  String sql="select * from sale01"; rn  ResultSet rs=stmt.executeQuery(sql); rn  while(rs.next()) %> rn  您的第一个字段内容为:<%=rs.getString(1)%> rn  您的第二个字段内容为:<%=rs.getString(2)%> rn  <%rn rn %> rn  <%out.print("数据库操作成功,恭喜你");%> rn  <%rs.close(); rn  stmt.close(); rn  conn.close(); rn  %> rn   rn  
jsp连接oracle出错
所装软件rnTomcat4.1.31rnJ2SDK1.4.2rnOracle 9irn在oracle文件夹里搜索classes12.jar文件,放到tomcat\common\lib目录下,然后在系统变量classpash中添加rn.;C:\Tomcat 4.1\common\lib\classes12.jarrnrnrnrnrn java_home: C:\j2sdk1.4.2rnrnrnrn运行出错rnrnrnrntype Exception reportrnrnmessage rnrndescription The server encountered an internal error () that prevented it from fulfilling this request.rnrnexception rnrnjavax.servlet.ServletException: org/bouncycastle/jce/provider/BouncyCastleProviderrn at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:498)rn at org.apache.jsp.get_0002dEP_jsp._jspService(get_0002dEP_jsp.java:196)rn at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)rn at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)rn at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)rn at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)rn at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)rn at java.lang.Thread.run(Thread.java:534)rnrnrnroot cause rnrnjava.lang.NoClassDefFoundError: org/bouncycastle/jce/provider/BouncyCastleProviderrn at org.apache.jsp.get_0002dEP_jsp._jspService(get_0002dEP_jsp.java:65)rn at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)rn at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)rn at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)rn at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)rn at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)rn at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)rn at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)rn at java.lang.Thread.run(Thread.java:534)rn
连接oracle 9i出错!!
我在安装时设置sys和system的用户名和密码都是testrn但是我打开oracle管理工具,并点击初始数据库test时,出现连接数据库的对话框,在这个对话框中,用户名和密码我都输入test.结果出错,请问怎么回事?还要什么设置吗?谢谢!!
asp连接oracle出错
我在网上看到很多取BLOB图片的方法,都用到下面两句:rnSet OraSession=CreateObject("OracleInProcServer.XOraSession")rnSet OraDatabase=OraSession.DbOpenDatabase("autop","system/manager",0)rn"autop"是否为TNS文件中设置的服务名?后面的参数0又是什么意思?rn我用了以后出错:rnrn错误类型:rnOracle Automation (0x800A01B8)rnrn是什么原因?是不是ADO的版本太低?如何是的话怎样升级?
连接Oracle出错
代码:rnif (!IsPostBack)rn rn OracleConnection OConn = new OracleConnection("Data Source=J6Relati;User ID=System;Password=manager");rn OracleDataAdapter OAdapter = new OracleDataAdapter("select * from TreeTest", OConn);rn DataSet DS = new DataSet();rn OAdapter.Fill(DS, "TreeTest");rn ASPxTreeList1.DataSource = DS.Tables[0];rn ASPxTreeList1.DataBind();rn rn提示:rn OAdapter.Fill(DS, "TreeTest");rn这一行:System.Data.OracleClient.OracleException: ORA-01017: invalid username/password; logon deniedrn怎么解决?
oledb连接oracle出错
连接代码如下:rnConnStr = "Provider=OraOLEDB.Oracle.1;User ID=CK;password=K1112;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST =192.168.5.31)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=K1112)));Persist Security Info=false"rncon.ConnectionString = ConnStrrncon.CursorLocation = adUseClientrncon.Openrn一执行到con.Open就出现如下的错误提示:rn未找到提供程序,该程序可能未正确安装rnrn请问是什么问题?
PHP 连接Oracle 出错
rnrn报以下错误:rnWarning: ocilogon(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in D:\PHP\b.php on line 4 fail
java连接ORACLE出错
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)rn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)rn at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:361)rn at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)rn at java.sql.DriverManager.getConnection(DriverManager.java:582)rn at java.sql.DriverManager.getConnection(DriverManager.java:185)rn at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:117)rn at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:94)rn at util.JdbcUtil4.getConnection(JdbcUtil4.java:27)rn at util.JdbcUtil4.main(JdbcUtil4.java:67)rn*******************************************************************************************************rn请问这是为什么?
.NET连接oracle出错
[code=vb]Imports System.Data.OleDbrnImports System.DatarnrnPublic Class Form1rnrn Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Clickrnrn Dim OleDbConnection1 As OleDb.OleDbConnectionrn Dim conString = "Provider=MSDAORA;Data Source=XE;User ID=admuser;Password=admuser;"rn Dim sqlCommond = "select * from account"rn OleDbConnection1 = New OleDbConnection(conString)rnrn Dim oracleAdpter = New OleDbDataAdapter(sqlCommond, OleDbConnection1)rn Dim oracleDataSet As New DataSetrn oracleAdpter.Fill(oracleDataSet, "account")rn DataGridView1.DataSource = oracleDataSet.Tables("account")rn End SubrnEnd Classrn[/code]rn代码就是上面的,在fill的时候就报错了,怎么个问题呢,求教了![img=https://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/003/monkey/2.gif][/img]
vs2010连接oracle出错
rnrn 我的vs2010无法连接到远程oracle11数据库?错误是ora-12154rnrn oracle 11g安装在一台台式机上,系统是windows7,rn vs2010安装在我的笔记本上,系统也是windows7,我安装了ODTwithODAC1120320_32bit,rnrn [img=http://img.my.csdn.net/uploads/201304/01/1364812063_9411.png][/img]
ADO连接ORACLE出错
连接的时候总是提示:rn---------------------------rnMicrosoft 数据链接错误rn---------------------------rn测试连接失败,因为初始化提供程序时发生错误。未指定的错误rn---------------------------rn确定 rn---------------------------rn重新安装MDAC2.7以后也还是这样的错误,这是什么原因啊,我都开始怀疑是不是当时系统没有装好啊?rn
weblogic 连接 Oracle 出错 ?
java.sql.SQLException: ORA-00600: 内部错误代码,参数: [ttcgcshnd-1], [0], [], []rn, [], [], [], []rnrn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)rn at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)rn at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)rn at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)rn at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)rn at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.javrna:1681)rn at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatemernnt.java:1870)rn at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:rn538)rn at weblogic.jdbc.pool.Statement.executeQuery(Statement.java:850)rn at weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(StatementImpl.jrnava:79)rn at weblogic.jdbc.rmi.SerialStatement.executeQuery(SerialStatement.java:8rn0)rn at weblearn.webtest.ServletTest.doGet(ServletTest.java:40)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)rn at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImrnpl.java:265)rn at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImrnpl.java:200)rn at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSernrvletContext.java:2495)rn at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImrnpl.java:2204)rn at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)rn at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)rn
cognos连接oracle出错
[启动服务]rn10:13:40, 'LogService', 'StartService', 'Success'.rn10:13:40, CAF-WRN-0010 CAF input validation enabled.rn10:13:40, CAF-WRN-0021 CAF Third Party XSS checking disabled.rn10:13:53, CM-SYS-2215 已启动 Content Manager 内部PRECACHEINITACTIONS任务。rn10:13:53, CM-SYS-2093 Content Manager 高速缓存初始化已完成。已在 0.06 秒内加载 1 个对象。rn10:13:53, CM-SYS-2215 已启动 Content Manager 内部POSTINITACTIONS任务。rn10:13:53, 'ContentManagerService', 'StartService', 'Failure'.rnrn10:13:53, CM-SYS-5099 IBM Cognos Access Manager 安全子系统未正确配置。Content Manager 无法获得安全名称空间列表。 CM-REQ-4252 找不到对象“/directory”。rn10:13:53, CM-CFG-5064 创建初始内容对象时检测到 Content Manager 配置错误。 CM-REQ-4332 无法创建安全对象代理。检索不到所需的用户信息,无法为对象“::Anonymous”创建帐户代理对象。rn10:13:53, CM-SYS-2216 已完成 Content Manager 内部PRECACHEINITACTIONS任务。rn10:13:53, CM-SYS-2216 已完成 Content Manager 内部POSTINITACTIONS任务。rn10:13:58, 'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo', 'Failure'.rnDPR-DPR-1035 分派器检测到错误。rnnullrn10:13:58, 'ContentManager', 'getActiveContentManager', 'Failure'.rnDPR-CMI-4006 无法确定活动的 Content Manager。将定期重试。rn10:14:43, 'Dispatcher', 'Stop', 'Success'.rn10:14:43, 'ContentManagerService', 'StopService', 'Success'.rn10:14:43, 'AnnotationService', 'StopService', 'Success'.rn10:14:43, 'DimensionManagementService', 'StopService', 'Success'.rn10:14:43, 'MetadataService', 'StopService', 'Success'.rn10:14:43, 'CPS Producer Registration Service', 'StopService', 'Success'.rn10:14:43, 'HumanTaskService', 'StopService', 'Success'.rn10:14:43, 'DeliveryService', 'StopService', 'Success'.rn10:14:43, 'IndexSearchService', 'StopService', 'Success'.rn10:14:43, 'IndexUpdateService', 'StopService', 'Success'.rn10:14:43, 'JobService', 'StopService', 'Success'.rn10:14:43, 'IndexDataService', 'StopService', 'Success'.rn10:14:43, 'ReportService', 'StopService', 'Success'.rn10:14:43, 'camAsyncAA', 'StopService', 'Success'.rn10:14:43, 'AgentService', 'StopService', 'Success'.rn10:14:43, 'Fragment Server Service', 'StopService', 'Success'.rn10:14:43, 'EventService', 'StopService', 'Success'.rn10:14:43, 'MonitorService', 'StopService', 'Success'.rn10:14:43, 'GraphicsService', 'StopService', 'Success'.rn10:14:43, rn10:14:43, 'SystemService', 'StopService', 'Success'.rn10:14:43, 'idVizService', 'StopService', 'Success'.rn10:14:43, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.rnDPR-DPR-1035 分派器检测到错误。rnnullrn10:14:43, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.rnDPR-DPR-1035 分派器检测到错误。rnnullrn10:14:43, 'burstDistributionService', 'StopService', 'Success'.rn10:14:43, 'BUX Service', 'StopService', 'Success'.rn10:14:43, 'visualisationGalleryService', 'StopService', 'Success'.rn10:14:43, 'ContentManagerCacheService', 'StopService', 'Success'.rn10:14:43, 'BatchReportService', 'StopService', 'Success'.rn10:14:43, 'RepositoryService', 'StopService', 'Success'.rn10:14:43, 'QueryService', 'StopService', 'Success'.rn10:14:43, 'relationalMetadataService', 'StopService', 'Success'.rn10:14:43, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.rnDPR-DPR-1035 分派器检测到错误。rnnullrn10:14:43, 'CacheService', 'StopService', 'Success'.rn10:14:43, 'PDC', 'StopService', 'Success'.rn10:14:43, 'ReportDataService', 'StopService', 'Success'.rn10:14:43, 'SACamSrvc', 'StopService', 'Success'.rn10:14:43, 'IBM Cognos Enhanced Search Service', 'StopService', 'Success'.rn10:14:43, 'LogService', 'StopService', 'Success'.rnrn[启动服务]rn[错误] CFG-ERR-0103 无法启动 IBM Cognos 服务。rn执行外部进程后返回值为“-1”的错误代码。rn
vs 连接oracle 出错
[img=https://img-bbs.csdn.net/upload/201704/12/1491961836_142481.png][/img]rn安装了odp.net,已经能选择oracle连接了,测试连接也成功了,可以连得上,但确定按钮一直不可用,无法建立连接,是什么情况?有人知道么rn用ef连接oracle,.net4.0的,nuget里面的包装不上,都是4.5的,有人知道有什么好办法么?
jsp连接oracle出错!
我的机子是win2000,用resin解析jsp,我把原来连接mysql成功的程序改为连接oracle,出现了非常奇怪的问题,特请教高手!rn 有一插入语句rnString sql="INSERT INTO content(idno,colid,classid,title,ddate,manager,content,type,sj)";rnsql=sql+" VALUES('"+idno+"','"+colid+"','"+classid+"','"+str.strtochn(title)+"','"+ddate+"','";rnsql=sql+str.strtochn(manager)+"','"+str.strtochn(contents)+"','"+type_value+"','"+sj+"')";rnconn.executeUpdate(sql);rn 在页面上没有显示错误,但是记录没有插入进去。我看到resin服务器出现了如下问题rnjava.lang.NullPointerExceptionrnaq2.executeQuery: ORA-01401: 插入的值对于列过大rn 不知有没有人遇到过这个问题,如何解决?rnrnrnrnrnrn
Oracle 连接出错!
代码rn<%@ page contentType="text/html;charest=gb2312"%>rn<%@ page import="java.sql.*"%>rnrn<%rnClass.forName("oracle.jdbc.driver.OracleDriver").newInstance();rnString url="jdbc:oracle:thin:@128.3.0.16:1521:huayang";rnString user="huayang";rnString password="password";rnConnecton conn=DriverManager.getConnection(url,user,password);rnStatement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);rnString sql="select * from sysuser00";rnResultSet rs=stmt.executeQuery(sql);rnwhile(rs.next())rnrn<%=rs.getString(1)%>rn<%=rs.getString(2)%>rnrn%>rn<%out.print("數據庫操作成功,恭喜你");%>rn<%rs.close();stmt.close();conn.close();%〉rnrnrn服务器报错:rntype Exception reportrnrnmessage rnrndescription The server encountered an internal error () that prevented it from fulfilling this request.rnrnexception rnrnorg.apache.jasper.JasperException: Unable to load class for JSPrn org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:564)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:353)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:319)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:802)rnrnrnroot cause rnrnorg.apache.jasper.JasperException: Unable to load class for JSPrn org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:159)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:319)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:802)rnrnrnroot cause rnrnorg.apache.jasper.JasperException: Unable to load class for JSPrn org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:599)rn org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:319)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:802)rnrnrnroot cause rnrnjava.lang.ClassNotFoundException: org.apache.jsp.querysysuser_jsprn java.net.URLClassLoader$1.run(Unknown Source)rn java.security.AccessController.doPrivileged(Native Method)rn java.net.URLClassLoader.findClass(Unknown Source)rn org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:133)rn org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)rn org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:597)rn org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:319)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:802)rnrnrnnote The full stack trace of the root cause is available in the Apache Tomcat/6.0.0 logs.rnrn
CodeSmith连接Oracle出错
CodeSmith 6.5有了Oracle支持,在用CodeSmith创建数据库连接的时候,因为我本机是64为win7旗舰版,而oracle装的是32位10G,所以在连接oralce时报错:rnAttempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.rnrnAn error of type "InvalidOperationException" occurred while attempting to populate schema information. Please check your data source settings and try again.rnrn请问有没有什么解决办法呢
WEB连接ORACLE出错
(1937 ms) [main] INFO : org.hibernate.connection.ConnectionProviderFactory#newConnectionProvider : Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProviderrn(2219 ms) [main] WARN : org.hibernate.util.JDBCExceptionReporter#logExceptions : SQL Error: 0, SQLState: nullrn(2219 ms) [main] ERROR: org.hibernate.util.JDBCExceptionReporter#logExceptions : Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:rnORA-12505, TNS:listener does not currently know of SID given in connect descriptorrnThe Connection descriptor used by the client was:rnlocalhost:1521:orclrn)rn(2234 ms) [main] WARN : org.hibernate.cfg.SettingsFactory#buildSettings : Could not obtain connection metadatarnorg.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:rnORA-12505, TNS:listener does not currently know of SID given in connect descriptorrnThe Connection descriptor used by the client was:rnlocalhost:1521:orclrn)rn at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)rn at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)rn at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)rn at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)rn at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)rn at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)rn at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)rn at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)rn at java.security.AccessController.doPrivileged(Native Method)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)rn at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)rn at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)rn at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)rn at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)rn at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)rn at java.security.AccessController.doPrivileged(Native Method)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)rn at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)rn at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)rn at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)rn at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)rn at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)rn at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)rn at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)rn at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)rn at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)rn at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)rn at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)rn at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)rn at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)rn at org.apache.catalina.core.StandardService.start(StandardService.java:516)rn at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)rn at org.apache.catalina.startup.Catalina.start(Catalina.java:578)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:597)rn at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)rn at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)rnCaused by: java.sql.SQLException: Listener refused the connection with the following error:rnORA-12505, TNS:listener does not currently know of SID given in connect descriptorrnThe Connection descriptor used by the client was:rnlocalhost:1521:orclrnrn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)rn at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)rn at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:344)rn at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:148)rn at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)rn at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)rn at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)rn at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)rn at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)rn ... 54 morern(2672 ms) [main] INFO : org.hibernate.dialect.Dialect# : Using dialect: org.hibernate.dialect.Oracle9iDialectrnrnrnrnrn可能数据库出问题了,别的机子上能运行rn高手看一下什么问题
asp连接oracle出错???
以下代码:rnpublic DataSet getrelt(String str,String tablename)rn rn tryrn rn OracleConnection cnn=new OracleConnection(cnnstr);rn cnn.Open();rn OracleDataAdapter da=new OracleDataAdapter(str,cnn);rn DataSet ds =new DataSet();rn da.Fill(ds,tablename);rn cnn.Close();rn return ds;rn rn rn catchreturn null;rn为什么执行到cnn.Open();一行后,就不往下执行了,转到catch了,怎么办啊?rn
连接ORACLE出错
在ASP.NET中,我用OleDb方式连接ORACLE,但是在测试查询中出错:rnora-00936 :missing expression
连接Oracle怎么出错?
我编写了一点代码,是数据库的,连接Oracle,一点代码如下: rnCString str; rn if(m_pSet->IsOpen()) rn m_pSet->Close(); rn m_pSet->Open(CRecordset::forwardOnly,"select 列1 from 表1"); rn while(!m_pSet->IsEOF()) rn rn m_pSet->GetFieldValue("列1",str); rn 组合框1.AddString(str); rn m_pSet->MoveNext(); rn rn m_pSet->Close(); rn在组合框里显示记录。我用的是Oracle做后台,编译没有问题,可是一运行,出现一个窗口“Invalid Column number <1>",我又用相同的代码连接到Access,但是没有一点的错误,我怀疑是不是Oracle哪里出了问题,请问各位大佬,欢迎指正!!!
连接oracle出错?!~~
连接oracle8数据库时捕获rnrnSQLState:nullrnrnMessage :Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))rnrnVendor :17002rnrn rnrn
请问连接oracle出错
语句:SELECT * FROM OPENDATASOURCE('MSDAORA','Data Source=DB.ORACLE;User ID=AAA;Password=PWD')..AAA.usertbrn出错:rnOLE DB 提供程序 'MSDAORA' 报错。 rn[OLE/DB provider returned message: 发生了一个 Oracle 错误,但无法从 Oracle 中检索错误信息。]rnOLE DB 错误跟踪[OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]。
hibernate连接oracle出错
![图片说明](https://img-ask.csdn.net/upload/201704/24/1493008625_109352.png)n 登录的时候一直报这个错误,然后在网上搜了之后说是,oracle中用户被锁,然后我按照“ALTER USER amaker ACCOUNT UNLOCK;”解锁,将连接设置为unlimited,仍然有这个错误。![图片说明](https://img-ask.csdn.net/upload/201704/24/1493008776_593478.png)
Oracle连接出错
写了一个工具打包成Exe, 测试一切正常。交付客户后客户连接自己的Oracle提示错误,报错信息没见过啊。rn有没有大神遇到过这种情况。rn提示以下错误:[code=sql]ORA-00604: error occurred at recursive SQL level 1rnORA-20000: …˯܊****許可された接続方法以外では利用できません…˯܊***!EORA-06512: at line 25[/code]rnrn现在猜测会不会是客户自己的触发器在连接的时候对连接方法等进行了检测之类的。rn
jsp连接oracle出错!!!
程序内容如下rnrn rnrn<%@ page contentType="text/html;charset=gb2312" %>rn<%@ page import="java.sql.*" %>rn<%@ page import="oracle.jdbc.driver.*" %>rn<%rn DriverManager.registerDriver(new OracleDriver());rn Connection conn = DriverManager.getConnection("java:oracle:thin:@localhost:1521:orl","adm","123"); rn Statement stmt = conn.createStatement();rn ResultSet rs = stmt.executeQuery("select city_name_cn from city where rownum<3" );rn while( rs.next() )rn rn String name = rs.getString("city_name_cn");rn out.println(name);rn rn%> rnrnrnrnrn运行后,系统提示rnrnrnorg.apache.jasper.JasperException: Unable to compile class for JSPrnrnAn error occurred at line: 5 in the jsp file: /test/orlc.jsprnrnGenerated servlet error:rn [javac] Compiling 1 source filernrnD:\Tomcat 4.1\work\Standalone\localhost\_\test\orlc_jsp.java:8: package oracle.jdbc.driver does not existrnimport oracle.jdbc.driver.*;rn^rnD:\Tomcat 4.1\work\Standalone\localhost\_\test\orlc_jsp.java:49: cannot resolve symbolrnsymbol : class OracleDriver rnlocation: class org.apache.jsp.orlc_jsprn DriverManager.registerDriver(new OracleDriver());rn ^rn2 errorsrnrnrn我的配置为windows200server、jdk1.5、tomcat4.1,其他jsp程序都可以运行rn目录为 D:\j2sdk1.4.2_05 D:\Tomcat 4.1rn我的机子上装有oracle9,目录 D:\oracle\ora90rn同时,已经将D:\oracle\ora90\jdbc\lib下的classes12.jar、classes12.ziprn拷贝到了D:\j2sdk1.4.2_05\lib和D:\Tomcat 4.1\common\lib下rn也将上述加入环境变量,但是D:\Tomcat 4.1\common\lib下classes12.jar、classes12.zip没有加入(网上查资料好像不要)rnD:\j2sdk1.4.2_05\lib\classes12.jar;D:\j2sdk1.4.2_05\lib\classes12.zip;D:\oracle\ora90\jdbc\lib\classes12.jar;D:\oracle\ora90\jdbc\lib\classes12.ziprnrn请大家看看这是什么回事rn我的环境变量配置是否正确rn谢谢了rnrn
相关热词 c#检测非法字符 c#双屏截图 c#中怎么关闭线程 c# 显示服务器上的图片 api嵌入窗口 c# c# 控制网页 c# encrypt c#微信网页版登录 c# login 居中 c# 考试软件