I can assure you that ORACLE_HOME is the best compromise that you can find.
I'm currently compiling a 1MLoc project on windows, ubuntu, redhat, aix and
hp-ux.
We have an internal library that abstracts mysql, odbc, db2 and oracle. I'm
looking at a substitute for it so I'm interested in seeing if soci can do
the trick.
Oracle is by far the strangest of them all as the directory structure varies
wildly. I have tested my FindOracle script with 9.2, 10.2 pro and XE,
installed in client and db form for linux aix and hp, 11 in server install
on linux and I can assure you that it's a mess!
Not to mention the corner case of DB2 that pretends to be OCI compatible
(right...)
I'm really looking forward to seeing this project mature and would like to
contribute some test builds. Is it possible to add CDash to the project's
web site?
On Thu, Jul 7, 2011 at 7:14 PM, Bruce Adams <[email protected]> wrote:
>
>
>
>
> ----- Original Message ----
> > From: Sébastien Taylor <[email protected]>
> > To: General-purpose list for SOCI users. <
> [email protected]>
> > Sent: Thu, July 7, 2011 4:25:07 PM
> > Subject: Re: [SOCI-users] Test Failures on RHEL5 (was Re: Questions)
> >
> > The libraries variable wants the actual library not the path to the
> > libraries, if you point it directly to the oracle lib it should find
> > it.
> >
> Hi,
> That's a little bizarre but it moves me along, so thanks (by the way my
> postgresql problem was missing the postgresql-devel RPM. Oops.)
>
> Given that the default install location of the oracle RPMs places the
> include
> and libraries in /usr/include/oracle and /usr/lib/oracle
> I think soci/src/cmake/modules/FindOracle.cmake should work harder and not
> really just on ORACLE_HOME.
> Its not obvious what libraries are wanted and where it is looking for them.
> To
> my mind it makes more sense to set a library directory
> than a list of libraries if you have to specify manually. Of course you
> should
> not have to set it manually.
>
> Having persuaded cmake I have Oracle, however, something is still not
> right. It
> is not linking to the oracle libraries.
> In fact it seems to be using the library path for mysql. I wonder if my
> manual
> setting of ORACLELIBS has confused it.
>
> Regards,
>
> Bruce.
>
>
> ORACLELIBS=/usr/lib/oracle/
> 10.2.0.4/client/lib/libclntsh.so:/usr/lib/oracle/10.2.0.4/client/lib/libheteroxa10.so:/usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so:/usr/lib/oracle/10.2.0.4/client/lib/libocci.so:/usr/lib/oracle/10.2.0.4/client/lib/libociei.so:/usr/lib/oracle/10.2.0.4/client/lib/libocijdbc10.so:/usr/lib/oracle/10.2.0.4/client/lib/libsqlplusic.so:/usr/lib/oracle/10.2.0.4/client/lib/libsqlplus.so
>
>
> cmake --debug -DPOSTGRESQL_VERSION:=8.1.23 -DSOCI_POSTGRESQL:=ON
> -DSOCI_ORACLE:=ON -DORACLE_INCLUDE_DIR:=/usr/include/oracle/
> 10.2.0.4/client
> -DORACLE_LIBRARIES:=$ORACLELIBS .
>
>
>
> make[2]: Entering directory `/home/brucea/download/soci/src'
> Linking CXX executable ../../../bin/soci_oracle_test
> cd /home/brucea/download/soci/src/backends/oracle/test &&
> /usr/local/bin/cmake
> -E cmake_link_script CMakeFiles/soci_oracle_test.dir/link.txt --verbose=1
> /usr/lib/ccache/c++ -fPIC -pedantic -ansi -Wall -Wpointer-arith
> -Wcast-align
> -Wcast-qual -Wfloat-equal -Wredundant-decls -Wno-long-long -std=c++98
> -fPIC
> CMakeFiles/soci_oracle_test.dir/test-oracle.cpp.o -o
> ../../../bin/soci_oracle_test -rdynamic -L/usr/lib/mysql
> ../../../lib/libsoci_core.so.3.1.0 ../../../lib/libsoci_oracle.so.3.1.0
> ../../../lib/libsoci_core.so.3.1.0 -lpthread -ldl
> -Wl,-rpath,/usr/lib/mysql:/home/brucea/download/soci/src/lib
> CMakeFiles/soci_oracle_test.dir/test-oracle.cpp.o: In function `test3()':
> test-oracle.cpp:(.text+0x8a3f): undefined reference to
> `OCILobDisableBuffering'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCIAttrSet'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCIEnvCreate'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIDescriptorAlloc'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCILobWrite'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCISessionEnd'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCILobTrim'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIHandleAlloc'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCISessionBegin'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCIStmtFetch'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIStmtPrepare'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCIErrorGet'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCIParamGet'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIBindByName'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCILobWriteAppend'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCITransCommit'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCITransRollback'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCIAttrGet'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCIBindByPos'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIDescriptorFree'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIStmtExecute'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIHandleFree'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIServerDetach'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIDefineByPos'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCIServerAttach'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to `OCILobRead'
> ../../../lib/libsoci_oracle.so.3.1.0: undefined reference to
> `OCILobGetLength'
> collect2: ld returned 1 exit status
> make[2]: *** [bin/soci_oracle_test] Error 1
> make[2]: Leaving directory `/home/brucea/download/soci/src'
> make[1]: *** [backends/oracle/test/CMakeFiles/soci_oracle_test.dir/all]
> Error 2
> make[1]: Leaving directory `/home/brucea/download/soci/src'
> make: *** [all] Error 2
>
> If I manually add "-L/usr/lib/oracle/10.2.0.4/client/lib -lclntsh" to the
> two
> failing command lines all is well.
> (The Makefiles produced by cmake are not easy to grok).
>
> Having allegedly built soci successfully. The oracle and postgresql tests
> fail.
>
> Start processing tests
> Test project /home/brucea/download/soci/src
> 1/ 14 Testing soci_empty_test Passed
> 2/ 14 Testing soci_empty_test_static Passed
> 3/ 14 Testing soci_mysql_test ***Failed
> 4/ 14 Testing soci_mysql_test_static ***Failed
> 5/ 14 Testing soci_odbc_test_access ***Failed
> 6/ 14 Testing soci_odbc_test_access_static ***Failed
> 7/ 14 Testing soci_odbc_test_postgresql ***Failed
> 8/ 14 Testing soci_odbc_test_postgresql_stat***Failed
> 9/ 14 Testing soci_oracle_test ***Failed
> 10/ 14 Testing soci_oracle_test_static ***Failed
> 11/ 14 Testing soci_postgresql_test ***Failed
> 12/ 14 Testing soci_postgresql_test_static ***Failed
> 13/ 14 Testing soci_sqlite3_test Passed
> 14/ 14 Testing soci_sqlite3_test_static Passed
>
> 29% tests passed, 10 tests failed out of 14
>
> The following tests FAILED:
> 3 - soci_mysql_test (Failed)
> 4 - soci_mysql_test_static (Failed)
> 5 - soci_odbc_test_access (Failed)
> 6 - soci_odbc_test_access_static (Failed)
> 7 - soci_odbc_test_postgresql (Failed)
> 8 - soci_odbc_test_postgresql_static (Failed)
> 9 - soci_oracle_test (Failed)
> 10 - soci_oracle_test_static (Failed)
> 11 - soci_postgresql_test (Failed)
> 12 - soci_postgresql_test_static (Failed)
> Errors while running CTest
> make[3]: *** [CMakeFiles/check] Error 8
> make[2]: *** [CMakeFiles/check.dir/all] Error 2
> make[1]: *** [CMakeFiles/check.dir/rule] Error 2
> make: *** [check] Error 2
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
>
--
Claudio Bantaloukas http://www.rdfm.org/ammuzzu/
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
