Cause: More than one long buffer in the bind list.
Action: Change the buffer size to be less than 4000 for the bind variable bound
to a normal column.
Action: Change the buffer size to be less than 4000 for the bind variable bound
to a normal column.
解决方案 »
- 求助大神:oracle biee11 analytics登陆不进,怎么重置biee密码?
- 如何根据“列名”查询索引名 或者根据 “索引名 查询 列名
- 请问怎么在触发器里得到触发该触发器的sql语句
- ORACLE表的字段名允许有符号“.”么?
- SQL 查询显示冒号以后内容
- Oracle 触发器的问题:我的表有个字段datetime(Date类型),记录该记录插入表的时间,怎么实现??
- 我想把oracle10g中的数据导入到oracle9i中去,应该怎么做呢?
- 存储过程如何返回值?
- 关于可连续重用程序包和非连续重用程序包的区别
- rollback_segments=(r01,r03)中r01,r03是在哪里建的?
- export时出现exp-00024的错误?
- 权限的问题
Author: [email protected]
In Reply To: Java.SQL.Exception The Network Adapter could not establish the connection Jul 11, 2003 7:24 AM Reply 8 of 8
Hi Guys,I have seen this problem in almost all the forums.Now a solution is achieved.Try this.This problem is mainly due to the connection URL specified for the Oracle thin driver.
Few steps to debug this scenario...1) Check for the class path frst.
2) Check whether the listner is running.
Linux or Solaris check --> ORA_HOME/bin/lsnrctrl.sh
Windows -->ORA_HOME/bin/lsnrctrl.exe
3) If these are Okay, the problem is with your Connection URL. Check the following.In case of Linux or Solaris Use the below code:DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Host_name)(PORT=1521)))(CONNECT_DATA=(SID=service_name)(SERVER=DEDICATED)))", "usernam", "password"); In the above URL SERVER = DEDICATED is mandatory for Linux or Solaris.In case of WINDOWS Use the below code:DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=1521)))(CONNECT_DATA=(SID=service_name)(SERVER=DEDICATED)))", "username", "password"); In the above URL (SERVER = DEDICATED) is optional for Windows.If you still dont get a solution please let me know.