验证C++连接ORACLE数据库的时候报错（已经解决）

zhanhorse

验证C++连接ORACLE数据库的时候报错，不知道什么原因！
服务器：
HP-UX B.11.31 U ia64 (ta)

$ cat Makefile
includepath=${ORACLE_HOME}/rdbms/public
libpath=${ORACLE_HOME} b
libfile=-L ${libpath} -L libocci -L libclntsh
incfile=-I ${includepath}

occiselect:select.cpp
        aCC -g -o occiselect select.cpp  ${libfile} ${incfile}
clean:
        rm occiselect


$ cat select.cpp
#include <iostream>   
#include <occi.h>   
using namespace std;   
using namespace oracle:cci;   
main()   
{   
        Environment *env=Environment::createEnvironment();//create succ   
   
        string name = "name";   
        string pwd = "pwd";   
        string dbname = "DBDEMO";   
   
        try   
        {   
                Connection *conn=env->createConnection(name,pwd,dbname);//   
                cout<<"conn succ!"<<endl;   
                env->terminateConnection(conn);//   
        }   
        catch(SQLException e)   
        {   
                cout<<e.what()<<endl;//   
        }   
            
        Environment::terminateEnvironment(env);//   
        cout<<"end!"<<endl;   
}  

$
$ make occiselect
aCC -g -o occiselect select.cpp  -L /home/oracle/product/10.2.0 b -L libocci -L libclntsh -I /home/oracle/product/10.2.0/rdbms/public
"/home/oracle/product/10.2.0/rdbms/public/occiData.h", line 503: warning #2815-D:
          type qualifier on return type is meaningless
    const int sign() const ;
    ^

ld: Unsatisfied symbol "oracle:cci::Environment::createEnvironment(oracle:cci::Environment::Mode,void*,void* (*)(void*,unsigned long),void* (*)(void*,void*,unsigned long),void (*)(void*,void*))" in file select.o
ld: Unsatisfied symbol "oracle:cci::SQLException::SQLException(oracle:cci::SQLException const&(complete)" in file select.o
ld: Unsatisfied symbol "oracle:cci::SQLException::what() const" in file select.o
ld: Unsatisfied symbol "oracle:cci::SQLException::~SQLException()(complete)" in file select.o
ld: Unsatisfied symbol "oracle:cci::Environment::terminateEnvironment(oracle:cci::Environment*)" in file select.o
ld: Unsatisfied symbol "type info of oracle:cci::SQLException" in file select.o
6 errors.

正确的Makefile：
$ cat Makefile
includepath=${ORACLE_HOME}/rdbms/public
libpath=${ORACLE_HOME}/lib
libfile=-L ${libpath} -locci -lclntsh
incfile=-I ${includepath}

occiselect:select.cpp
        aCC +DD64 -g -o occiselect select.cpp  ${libfile} ${incfile}
clean:
        rm occiselect

$

hellioncu

-l libocci -l libclntsh

zhanhorse

回复 2# hellioncu

还是报错了，下面是日志
$ make occiselect
aCC -g -o occiselect select.cpp  -L /home/oracle/product/10.2.0/lib -l libocci -l libclntsh -I /home/oracle/product/10.2.0/rdbms/public
"/home/oracle/product/10.2.0/rdbms/public/occiData.h", line 503: warning #2815-D:
          type qualifier on return type is meaningless
    const int sign() const ;
    ^

ld: Can't find library for -llibocci
Fatal error.
make: *** [occiselect] Error 1
$
$ cat Makefile
includepath=${ORACLE_HOME}/rdbms/public
libpath=${ORACLE_HOME}/lib
libfile=-L ${libpath} -l libocci -l libclntsh
incfile=-I ${includepath}

occiselect:select.cpp
        aCC -g -o occiselect select.cpp  ${libfile} ${incfile}
clean:
        rm occiselect

$
$ ls -lrt ${ORACLE_HOME}bbocci*
-rw-r--r--   1 oracle10   dba              0 Dec 22  2005 /home/oracle/product/10.2.0bbocci10_296.so.10.1
-rw-r--r--   1 oracle10   dba              0 Dec 22  2005 /home/oracle/product/10.2.0bbocci10_296.a
-rw-r--r--   1 oracle10   dba        10200886 Apr 23  2008 /home/oracle/product/10.2.0bbocci10.a
-r-xr-xr-x   1 oracle10   dba        3254168 Apr 23  2008 /home/oracle/product/10.2.0bbocci.so.10.1
lrwxrwx---   1 oracle10   dba             15 Jun 24  2010 /home/oracle/product/10.2.0bbocci.so -> libocci.so.10.1
$ ls -lrt ${ORACLE_HOME}bbclntsh*  
-rw-r--r--   1 oracle10   dba              0 Jun 11  2010 /home/oracle/product/10.2.0bbclntsh.sl
-rwxr-xr-x   1 oracle10   dba        36877088 Jun 11  2010 /home/oracle/product/10.2.0bbclntsh.so.10.1
lrwxrwx---   1 oracle10   dba             17 Jun 24  2010 /home/oracle/product/10.2.0bbclntsh.so -> libclntsh.so.10.1



   

hellioncu

zhanhorse 发表于 2013-07-29 11:31
回复 2# hellioncu

还是报错了，下面是日志

-l occi -l clntsh

zhanhorse

回复 4# hellioncu


    不好意思了，还是报错！很郁闷。

$ make occiselect
aCC -g -o occiselect select.cpp  -L /home/oracle/product/10.2.0/lib -l occi -l clntsh -I /home/oracle/product/10.2.0/rdbms/public
"/home/oracle/product/10.2.0/rdbms/public/occiData.h", line 503: warning #2815-D:
          type qualifier on return type is meaningless
    const int sign() const ;
    ^

ld: Mismatched ABI for -locci, found /home/oracle/product/10.2.0/lib/libocci.so
Fatal error.
make: *** [occiselect] Error 1
$
$
$ cat Makefile   
includepath=${ORACLE_HOME}/rdbms/public
libpath=${ORACLE_HOME}/lib
libfile=-L ${libpath} -l occi -l clntsh
incfile=-I ${includepath}

occiselect:select.cpp
        aCC -g -o occiselect select.cpp  ${libfile} ${incfile}
clean:
        rm occiselect

$

hellioncu

zhanhorse 发表于 2013-07-29 15:13
回复 4# hellioncu

可能是程序和库 32/64位不匹配，aCC后面指定   +DD32 或者   +DD64 试试

zhanhorse

回复 6# hellioncu


    终于正确了，超级感谢！这下我就可以好好研究数据转换代码模块的开发。)
$ cat Makefile
includepath=${ORACLE_HOME}/rdbms/public
libpath=${ORACLE_HOME}/lib
libfile=-L ${libpath} -locci -lclntsh
incfile=-I ${includepath}

occiselect:select.cpp
        aCC +DD64 -g -o occiselect select.cpp  ${libfile} ${incfile}
clean:
        rm occiselect

$