JDBCÁ¬½ÓoracleÊý¾Ý¿âÎÊÌâ
Java code:
import java.sql.*;
class xt{
public static void main(String in[]){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException cnfe){
System.out.println("can not found!");
}
try{
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.5.160:1521:orcl","system","manager");
Statement stat=con.createStatement();
//ResultSet res=stat.executeQuery("select * from students;"); //#
//res.next();
//System.out.println(res.getString(1));
}catch(SQLException sqle){
System.out.println("sql error");
}
}
}
ÒÔÉÏ´úÂëÖ´ÐÐ䱨ÈκÎÒì³£.
µ«Ö»ÒªÖ´ÐÐ×¢ÊÍΪ#µÄÄǾä,¾Í»á´òÓ¡"sql error",
Õâô¿´À´,Á¬½ÓÃ²ËÆÃ»ÎÊÌâ,ΪºÎÒ»Ö´ÐÐsqlÓï¾ä¾Í±¨´íÄØ?
Çë¸÷λ°ïæ¿´¿´,лл!
Java code:
¿´´úÂëûʲô´í°É. Êý¾Ý¿â·þÎñÆô¶¯ÁËô?±í´æÔÚô? ǰºóSystem´òÓ¡Ï¿´¿´ ÄľäÈÓµÄÒì³£.
Java code
{{--
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôÔÒò,ÇëÖ¸½Ì.... лл'
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39016: Operation not supported when job is in EXECUTING ......