Javaµ÷ÓÃOracleÊý¾Ý¿â±¨Òì³£
µ÷ÓôúÂëÈçÏ£º
import java.sql.*;
class MyOracle{
public static void main(String args[]) {
try{
DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver());
String url="jdbc: oracle:thin: @127.0.0.1:5500: orcl";
Connection conn=DriverManager.getConnection(url,"user1","pass1");
CallableStatement c= conn.prepareCall("{call sumeng(?,?)}");
c.setString(1,"13");
c.setString(2, "xiaomao");
c.execute();
conn.close(); }
catch(Exception ex){
System.out.println(ex);
System.exit(0); }
}
}
±¨µÄÒ쳣Ϊjava.sql.SQLException: Io Òì³£: Bad packet type
²»ÖªµÀÊÇʲôÔÒò£¬Ïë¸ßÊÖÇë½Ì~~
ÏÈ×¢Ê͵ôCallableStatement¼°ÆäºóÃæµÄ²¿·Ö£¬¿´¿´ÊÇ·ñÄÜÕý³£Á¬½Ó¡£
Èç¹û³É¹¦£¬Ôò¼ì²éÄãµÄsumeng¹ý³ÌÊÇ·ñÓÐЧ¡¢
ÏÈ×¢Ê͵ôCallableStatement¼°ÆäºóÃæµÄ²¿·Ö£¬¿´¿´ÊÇ·ñÄÜÕý³£Á¬½Ó¡£
¸Ðл´ó¼ÒµÄ°ïæ~~
ÎÊÌâ·¢ÏÖÁË£¬¶Ë¿ÚºÅ²»¶Ô£¬Ó¦¸ÃÊÇString url="jdbc:oracle:thin:@127.0.0.1:1521:orcl"£¬µÄÈ·²»
ÊÇÎÒдµÄÄǸöString url="jdbc:oracle:thin:@127.0.0.1:5500:orcl"¡£
ÁíÒ»¸öÎÊÌâÓÖ³öÏÖÁË£¬ÎÒÓÃä¯ÀÀÆ÷µÇ¼Êý¾Ý¿âʱʹÓõĵØÖ·ÊÇhttp://127.0.0.1:5500/em£¬¶ø²»ÊÇhttp://127.0.0.1:1521/em Õâ¸öµØ·½µÄ¶Ë¿ÚºÅÎÒÊÔ¹ý²»ÄÜʹÓÃ1521£¬¸ßÊÖÄܽâÊÍϲ»£¿
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¹¤×÷ÐèÒª Çó´ó¼Ò°ïæд¸ö³ÌÐò
ÎÒÊÇѧC++µÄ ²»¶®JAVA
±àдһ¸öJavaÓ¦ÓóÌÐò£¬¶ÔÓÚ¸ø¶¨µÄÒ»¸ö×Ö·û´®µÄ¼¯ºÏ£¬¸ñʽÈ磺
{aaa bbb ccc}£¬ {bbb ddd}£¬{eee fff}£¬{ggg}£¬{ddd hhh}
ÒªÇ󽫯äÖн»¼¯²»Îª¿ÕµÄ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......