LEI Á¬½ÓORACLE °æ±¾ÎÊÌâ
Can you connect to an Oracle database with a 64-bit Oracle client?
Technote (FAQ)
Question
You are unable to connect to an Oracle database with a 64-bit Oracle client. Does Lotus Enterprise Integrator (LEI), Lotus Domino Enterprise Connection Services (DECS), or LSX for Lotus Connectors (LSXLC) support the 64-bit Oracle client?
Answer
Beginning with Lotus Domino 8.0.1 and LEI 8.0.1, a 64-bit release now supports a connection to a 64-bit Oracle client.
Ïà¹ØÎĵµ£º
¶ÔÏó³Ö¾Ã»¯£¬Ò²¾ÍÊÇ¿ÉÒÔ°ÑÕâ¸ö¶ÔÏóÓÀÔ¶µÄ±£´æÆðÀ´£¬ÕâÀïµÄ±£´æ²»½öÊǶÔÏó±¾Éí£¬»¹°üÀ¨ËûµÄÊôÐÔºÍËùÒÀÀµµÄÆäËûÀࡣͨ³££¬¶ÔÏó¿ÉÒԳ־û¯µ½Îļþ»òÕßÊÇÊý¾Ý¿âÖС£ÎÒÕâÀïÖ»½éÉÜÈçºÎ½«¶ÔÏó´æ´¢µ½Êý¾Ý¿âÖС£Ç¡ÇÉOracleÊý¾Ý¿âΪÎÒÃÇÌṩÁËÕâÑùµÄ·½±ã¡£
ÔÚOracleÖУ¬ÓÐÒ»ÖÖblogµÄ×Ö¶ÎÀàÐÍ£¬ËüÊÇÓÃÀ´´æ´¢´óÁ¿µÄ¶ ......
import Java.io.*;
¡¡¡¡import java.util.*;
¡¡¡¡import java.sql.*;
¡¡¡¡public class LobPros
¡¡¡¡{
¡¡¡¡/**
¡¡¡¡* OracleÇý¶¯³ÌÐò
¡¡¡¡*/
¡¡¡¡private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
¡¡¡¡/**
¡¡¡¡* ORACLEÁ¬½ÓÓÃURL
¡¡¡¡*/
¡¡¡¡p ......
ÔÎijö×Ô£ºhttp://tenn.javaeye.com/blog/99339
ÔÚOracle
ÖУ¬Òª°´Ìض¨Ìõ¼þ²éѯǰNÌõ¼Ç¼£¬Óøörownum
¾Í¸ã¶¨ÁË¡£
select * from emp where rownum
<= 5
¶øÇÒÊéÉÏÒ²¸æ½ë£¬²»ÄܶÔrownum
ÓÃ">"£¬ÕâÒ²¾ÍÒâζ×Å£¬Èç¹ûÄãÏëÓÃ
select * from emp where rownum
&nbs ......
ÔÚStand aloneµÄ»·¾³Öд´½¨Oracle data source¹©²âÊÔʹÓãº
OracleDataSource dataSource = new OracleDataSource();
dataSource.setDriverType("oracle.jdbc.driver.OracleDriver");
dataSource.setURL("jdbc:oracle:thin:@localhost:1521:ORCL");
  ......