In spite of the test failures. soci_oracle seems to work. So I guess it is the tests that are broken (or my build).
----- Original Message ---- > From: Bruce Adams <[email protected]> > To: General-purpose list for SOCI users. <[email protected]> > Sent: Thu, July 7, 2011 6:14:23 PM > Subject: Re: [SOCI-users] Test Failures on RHEL5 (was Re: Questions) > > > > > > ----- 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 >o > > > 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 > ------------------------------------------------------------------------------ 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
