linux下连接oracle数据库.docx

源代码 C+代码 1. #include 2. #include 3. #includeocci.h 4. usingnamespaceoracle:occi; 5. usingnamespacestd; 6. 7. intmain() 8. 9. stringusr=sys; 10. stringpwd=orcl; 11. stringSID=ORCL; /注意大小写 12. stringdate; 13. 14. Environment*env=Environment:createEnvironment(Environment:OBJECT); 15. Connection*conn=env-createConnection(usr,pwd,SID);/allstrings 16. if(conn) 17. coutsuccesscreateConnection!endl; 18. else 19. coutfailurecreateConnection!createStatement(); 22. stringsSQL=selectto_char(sysdate,yyyy-mm-ddhh24:mi:ss)fromdual; 23. stmt-setSQL(sSQL); 24. 25. 26. ResultSet*rs=stmt-executeQuery(); 27. if(rs-next() 28. 29. date=rs-getString(1); 30. 31. 32. coutnowtime:dateterminateConnection(conn); 35. Environment:terminateEnvironment(env); 36. 37. return0; 38. 39. #include #include #include occi.husing namespace oracle:occi;using namespace std;int main() string usr=sys; string pwd=orcl; string SID=ORCL; string date; Environment *env=Environment:createEnvironment(Environment:OBJECT); Connection *conn= env-createConnection(usr,pwd,SID);/all strings if(conn) coutsuccess createConnection!endl; else coutfailure createConnection!createStatement(); string sSQL = select to_char(sysdate,yyyy-mm-dd hh24:mi:ss) from dual; stmt-setSQL(sSQL); ResultSet *rs = stmt-executeQuery(); if(rs-next() date = rs-getString(1); coutnow time :dateterminateConnection(conn); Environment:terminateEnvironment(env); return 0; 我linux上安装oracle路径：/u01/app/oracle/product/10.2.0/db_1 编译命令：g+ -o conn -L/u01/app/oracle/product/10.2.0/db_1/lib -L/u01/oracle/product/10.2.0/db_1/rdbms/lib conn_db.cpp 问题一：编译时报如下错误： Shell代码 1. oraclelocalhostdemo$g+ -o conn -L/u01/app/oracle/product/10.2.0/db_1/lib -L/u01/oracle/product/10.2.0/db_1/rdbms/lib conn_db.cpp 2. g+:g+:Nosuchfileordirectory 3. conn_db.cpp:3:18:error:occi.h:Nosuchfileordirectory 4. conn_db.cpp:4:error:oraclehasnotbeendeclared 5. conn_db.cpp:4:error:occiisnotanamespace-name 6. conn_db.cpp:4:error:expectednamespace-namebefore;token 7. conn_db.cpp:Infunctionintmain(): 8. conn_db.cpp:14:error:Environmentwasnotdeclaredinthisscope 9. conn_db.cpp:14:error:envwasnotdeclaredinthisscope 10. conn_db.cpp:14:error:Environmentisnotaclassornamespace 11. conn_db.cpp:14:error:Environmentisnotaclassornamespace 12. conn_db.cpp:15:error:Connectionwasnotdeclaredinthisscope 13. conn_db.cpp:15:error:connwasnotdeclaredinthisscope 14. conn_db.cpp:21:error:Statementwasnotdeclaredinthisscope 15. conn_db.cpp:21:error:stmtwasnotdeclaredinthisscope 16. conn_db.cpp:26:error:ResultSetwasnotdeclaredinthisscope 17. conn_db.cpp:26:error:rswasnotdeclaredinthisscope 18. conn_db.cpp:35:error:Environmentisnotaclassornamespace 19. oraclelocalhost demo$ g+ g+ -o conn -L/opt/app/oracle/product/10.2.0/db_1/lib -L/opt/oracle/product/10.2.0/db_1/rdbms/lib -lclntsh -locci /usr/lib/libstdc+.so.5 conn_db.cpp -gg+: g+: No such file or directoryconn_db.cpp:3:18: error: occi.h: No such file or directoryconn_db.cpp:4: error: oracle has not been declaredconn_db.cpp:4: error: occi is not a namespace-nameconn_db.cpp:4: error: expected namespace-name before ; tokenconn_db.cpp: In function int main():conn_db.cpp:14: error: Environment was not declared in this scopeconn_db.cpp:14: error: env was not declared in this scopeconn_db.cpp:14: error: Environment is not a class or namespaceconn_db.cpp:14: error: Environment is not a class or namespaceconn_db.cpp:15: error: Connection was not declared in this scopeconn_db.cpp:15: error: conn was not declared in this scopeconn_db.cpp:21: error: Statement was not declared in this scopeconn_db.cpp:21: error: stmt was not declared in this scopeconn_db.cpp:26: error: ResultSet was not declared in this scopeconn_db.cpp:26: error: rs was not declared in this scopeconn_db.cpp:35: error: Environment is not a class or namespace 解决：编译时没有引入OCCI库文件路径(oracle安装时候这个库已经附带装好了)路径：/u01/app/oracle/product/10.2.0/db_1/rdbms/public 编译命令增加OCCI库：g+ -o conn -I/u01/app/oracle/product/10.2.0/db_1/rdbms/public -L/opt/app/oracle/product/10.2.0/db_1/lib -L/opt/oracle/product/10.2.0/db_1/rdbms/lib conn_db.cpp 问题2：找不到对应函数 Shell代码 1. oraclelocalhostdemo$g+-oconn-I/home/oracle/oracle/include-L/opt/app/oracle/product/10.2.0/db_1/lib-L/opt/oracle/product/10.2.0/db_1/rdbms/libconn_db.cpp-Wall-O-g 2. /tmp/cclFs9xq.o:Infunctionmain: 3. /home/oracle/oracle/demo/conn_db.cpp:14:undefinedreferencetooracle:occi:Environment:createEnvironment(oracle:occi:Environment:Mode,void*,void*(*)(void*,unsignedint),void*(*)(void*,void*,unsignedint),void(*)(void*,void*) 4. /home/oracle/oracle/demo/conn_db.cpp:35:undefinedreferencetooracle:occi:Environment:terminateEnvironment(oracle:occi:Environment*) 5. collect2:ldreturned1exitstatus 6. oraclelocalhost demo$ g+ -o conn -I/home/oracle/oracle/include -L/opt/app/oracle/product/10.2.0/db_1/lib -L/opt/oracle/product/10.2.0/db_1/rdbms/lib conn_db.cpp -Wall -O -g/tmp/cclFs9xq.o: In function main:/home/oracle/oracle/demo/conn_db.cpp:14: undefined reference to oracle:occi:Environment:createEnvironment(oracle:occi:Environment:Mode, void*, void* (*)(void*, unsigned int), void* (*)(void*, void*, unsigned int), void (*)(void*, void*)/home/oracle/oracle/demo/conn_db.cpp:35: undefined reference to oracle:occi:Environment:terminateEnvironment(oracle:occi:Environment*)collect2: ld returned 1 exit status 解决：增加libocci.so和libclntsh.so（它们既为OCCI库文件）指定编译 修改后的编译命令： g+ -o conn -I/u01/app/oracle/product/10.2.0/db_1/rdbms/public -L/app/oracle/product/10.2.0/db_1/lib -L/u01/app/oracle/product/10.2.0/db_1/rdbms/lib -lclntsh -locci conn_db.cpp 另外可能在引入-lclntsh -locci编译时可能会报找不到以下错误： Shell代码 1. oraclelocalhostdemo$ g+ -o conn -I/u01/app/oracle/product/10.2.0/db_1/rdbms/public -L/app/oracle/product/10.2.0/db_1/lib -L/u01/app/oracle/product/10.2.0/db_1/rdbms/lib -lclntsh -locci conn_db.cpp2. /usr/bin/ld:cannotfind-lclntsh 3. collect2:ldreturned1exitstatus 4. oraclelocalhostdemo$ 5. oraclelocalhost demo$ g+ -o conn -I/home/oracle/oracle/include -L/opt/app/oracle/product/10.2.0/db_1/lib -L/opt/oracle/product/10.2.0/db_1/rdbms/lib conn_db.cpp -lclntsh -locci /usr/lib/libstdc+.so.5 -Wall -O -g/usr/bin/ld: cannot find -lclntshcollect2: ld returned 1 exit statusoraclelocalhost demo$ 解决：这是因为没有找到libclntsh.so和libocci.so链接库,将libclntsh.so和libocci.so拷贝到/usr/lib目录下就可以了 补充：完成后改写环境变量：vi ./bash_profile问题三：occi在linux编译运行时报libstdc+.so.6冲突的问题 Java代码 1. oraclelocalhostdemo$ g+ -o conn -I/u01/app/oracle/product/10.2.0/db_1/rdbms/public -L/app/oracle/product/10.2.0/db_1/lib -L/u01/app/oracle/product/10.2.0/db_1/rdbms/lib -lclntsh -locci conn_db.cpp 2. /usr/bin/ld:warning:libstdc+.so.5,neededby/opt/app/oracle/product/10.2.0/db_1/lib/libocci.so,mayconflictwithlibstdc+.so.6 oraclelocalhost demo$ g+ -o conn -I/home/oracle/oracle/include -L/opt/app/oracle/product/10.2.0/db_1/lib -L/opt/oracle/product/10.2.0/db_1/rdbms/lib conn_db.cpp -lclntsh -locci -Wall -O -g/usr/bin/ld: warning: libstdc+.so.5, needed by /opt/app/oracle/product/10