Hi Tommi,
thank you for your help!
I tried again with 10.2 and 11.2:
First try 10.2:
I changed in configure.ac to (so I did not checkout anything from GIT)
... if I should try this, please tell me.
AX_LIB_ORACLE_OCI([8.0])
and tested first with 10.2 beacause I saw support in configure (if
10.0 then use -lnnz10)
./configure --with-oci-include=/usr/include/oracle/10.2.0.5/client64
--with-oci-lib=/usr/lib/oracle/10.2.0.5/client64/lib
seems to work fine:
...
checking for Oracle OCI headers in
/usr/include/oracle/10.2.0.5/client64... yes
checking for Oracle OCI libraries in
/usr/lib/oracle/10.2.0.5/client64/lib... yes
checking if Oracle OCI version is >= 8.0... yes
checking for Oracle version >= 10.x to use -lnnz10 flag... yes
checking if Oracle support is enabled... yes
...
Then I called make and it failed with:
In file included from ../../include/tntdb/oracle/blob.h:37:0,
from blob.cpp:29:
../../include/tntdb/oracle/connection.h:34:17: fatal error: oci.h: No
such file or directory
#include <oci.h>
But oci.h is in /usr/include/oracle/10.2.0.5/client64.
Second try with 11.2 (it needs -lnnz11 and the macro from autoconf
archive does not add any nnz11):
checking for Oracle OCI headers in
/usr/include/oracle/11.2/client64/... yes
checking for Oracle OCI libraries in
/usr/lib/oracle/11.2/client64/lib/... yes
checking if Oracle OCI version is >= 8.0... yes
checking for Oracle version >= 10.x to use -lnnz10 flag... yes
checking if Oracle support is enabled... yes
As you can see it wants to use nnz10 which will fail. So I did not try
to call make.
I suggest to kick the macro from autoconf archive out and bring the
own macros in.
And Tommi, if you like to try on our system, feel free to come to
Taunusanlage.
There is one place with a PC free, at the moment.
CU
Andreas
Am 15.08.2014 um 11:00 schrieb Tommi Mäkitalo:
Hi,
I guess I found the problem.
First some details about the oracle support in tntdb and what has
changed recently.
Previously I used my own m4 macros in configure. But recently I found a
check for oracle in the autoconf archive, so I replaced my stuff with
those in the hope they are better. The autoconf archive is a collection
of autoconf checks. And since they are published that way, I expect them
to be written from people, who know autoconf and m4 better then me and
also much better tested.
It looks like it is not really that widespread used as I expected. If
you ask google bout the macro the first hit is the link to
autoconf-archive and the second is to tntdb. Looks like we are the top
user of that macro=-O .
You can find the used macro in tntdb/m4/ax_lib_oracle_oci.m4 with some
documentation inside. You get a usage using "./configure --help|less".
But yes, the README.git must be updated. Or as an alternative revert
back to my macros if the new ones do not work as expected.
When looking at the macro and the output it is quite obvious, that the
macro has problems with splitting the version number into major and
minor. The macro takes the expected version number as argument. And I
guess (it is not really documented) the number must be passed as
major.minor, so instead of
AX_LIB_ORACLE_OCI([8])
we need:
AX_LIB_ORACLE_OCI([8.0])
I have no oracle here but I tried to verify it in a small shell script
and it looks much better. I checked in a fix.
Tommi
Am 14.08.2014 13:41, schrieb Andreas Welchlin:
Hi List,
I am using tntdb with PostgreSQL and it works fine - out of the box.
Now I tried to switch to Oracle 11 and I installed the Oracle 11 client
basic package and the Oracle 11 development package (on Fedora).
I tried to compile it using:
./configure --with-oci-include=/usr/include/oracle/11.2/client64
--with-oci-lib=/usr/lib/oracle/11.2/client64/lib
But before I had to set the LD_LIBRARY_PATH (otherwise configure exits
with an error message):
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
Afterwards I got the error below:
checking for Oracle OCI headers in
/usr/include/oracle/11.2/client64... yes
checking for Oracle OCI libraries in
/usr/lib/oracle/11.2/client64/lib... yes
checking if Oracle OCI version is >= 8... expr: non-integer argument
expr: syntax error
no
configure: error: Oracle 11.2 found, but required version is 8
It this true? I can not imagine that Oracle 8 is required but 11 or 12
do not work.
Is there a bug in the configure script (I think yes, because it says
"expr: syntax error"?
Any hints?
Btw: I saw that the documentation (Howto and README.git) says that
configure should be called using --with-oracle. But
this seems to be an old switch. Should be changed to "configure
--with-oci-lib= .. --with-oci-include=...".
Andreas
------------------------------------------------------------------------------
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
------------------------------------------------------------------------------
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
--> but with 11.2 you needd -lnzz11 instead of nzz10.
Am 15.08.2014 um 11:00 schrieb Tommi Mäkitalo:
Hi,
I guess I found the problem.
First some details about the oracle support in tntdb and what has
changed recently.
Previously I used my own m4 macros in configure. But recently I found a
check for oracle in the autoconf archive, so I replaced my stuff with
those in the hope they are better. The autoconf archive is a collection
of autoconf checks. And since they are published that way, I expect them
to be written from people, who know autoconf and m4 better then me and
also much better tested.
It looks like it is not really that widespread used as I expected. If
you ask google bout the macro the first hit is the link to
autoconf-archive and the second is to tntdb. Looks like we are the top
user of that macro=-O .
You can find the used macro in tntdb/m4/ax_lib_oracle_oci.m4 with some
documentation inside. You get a usage using "./configure --help|less".
But yes, the README.git must be updated. Or as an alternative revert
back to my macros if the new ones do not work as expected.
When looking at the macro and the output it is quite obvious, that the
macro has problems with splitting the version number into major and
minor. The macro takes the expected version number as argument. And I
guess (it is not really documented) the number must be passed as
major.minor, so instead of
AX_LIB_ORACLE_OCI([8])
we need:
AX_LIB_ORACLE_OCI([8.0])
I have no oracle here but I tried to verify it in a small shell script
and it looks much better. I checked in a fix.
Tommi
Am 14.08.2014 13:41, schrieb Andreas Welchlin:
Hi List,
I am using tntdb with PostgreSQL and it works fine - out of the box.
Now I tried to switch to Oracle 11 and I installed the Oracle 11 client
basic package and the Oracle 11 development package (on Fedora).
I tried to compile it using:
./configure --with-oci-include=/usr/include/oracle/11.2/client64
--with-oci-lib=/usr/lib/oracle/11.2/client64/lib
But before I had to set the LD_LIBRARY_PATH (otherwise configure exits
with an error message):
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
Afterwards I got the error below:
checking for Oracle OCI headers in /usr/include/oracle/11.2/client64... yes
checking for Oracle OCI libraries in
/usr/lib/oracle/11.2/client64/lib... yes
checking if Oracle OCI version is >= 8... expr: non-integer argument
expr: syntax error
no
configure: error: Oracle 11.2 found, but required version is 8
It this true? I can not imagine that Oracle 8 is required but 11 or 12
do not work.
Is there a bug in the configure script (I think yes, because it says
"expr: syntax error"?
Any hints?
Btw: I saw that the documentation (Howto and README.git) says that
configure should be called using --with-oracle. But
this seems to be an old switch. Should be changed to "configure
--with-oci-lib= .. --with-oci-include=...".
Andreas
------------------------------------------------------------------------------
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
------------------------------------------------------------------------------
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
Am 15.08.2014 um 11:00 schrieb Tommi Mäkitalo:
Hi,
I guess I found the problem.
First some details about the oracle support in tntdb and what has
changed recently.
Previously I used my own m4 macros in configure. But recently I found a
check for oracle in the autoconf archive, so I replaced my stuff with
those in the hope they are better. The autoconf archive is a collection
of autoconf checks. And since they are published that way, I expect them
to be written from people, who know autoconf and m4 better then me and
also much better tested.
It looks like it is not really that widespread used as I expected. If
you ask google bout the macro the first hit is the link to
autoconf-archive and the second is to tntdb. Looks like we are the top
user of that macro=-O .
You can find the used macro in tntdb/m4/ax_lib_oracle_oci.m4 with some
documentation inside. You get a usage using "./configure --help|less".
But yes, the README.git must be updated. Or as an alternative revert
back to my macros if the new ones do not work as expected.
When looking at the macro and the output it is quite obvious, that the
macro has problems with splitting the version number into major and
minor. The macro takes the expected version number as argument. And I
guess (it is not really documented) the number must be passed as
major.minor, so instead of
AX_LIB_ORACLE_OCI([8])
we need:
AX_LIB_ORACLE_OCI([8.0])
I have no oracle here but I tried to verify it in a small shell script
and it looks much better. I checked in a fix.
Tommi
Am 14.08.2014 13:41, schrieb Andreas Welchlin:
Hi List,
I am using tntdb with PostgreSQL and it works fine - out of the box.
Now I tried to switch to Oracle 11 and I installed the Oracle 11 client
basic package and the Oracle 11 development package (on Fedora).
I tried to compile it using:
./configure --with-oci-include=/usr/include/oracle/11.2/client64
--with-oci-lib=/usr/lib/oracle/11.2/client64/lib
But before I had to set the LD_LIBRARY_PATH (otherwise configure exits
with an error message):
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
Afterwards I got the error below:
checking for Oracle OCI headers in /usr/include/oracle/11.2/client64... yes
checking for Oracle OCI libraries in
/usr/lib/oracle/11.2/client64/lib... yes
checking if Oracle OCI version is >= 8... expr: non-integer argument
expr: syntax error
no
configure: error: Oracle 11.2 found, but required version is 8
It this true? I can not imagine that Oracle 8 is required but 11 or 12
do not work.
Is there a bug in the configure script (I think yes, because it says
"expr: syntax error"?
Any hints?
Btw: I saw that the documentation (Howto and README.git) says that
configure should be called using --with-oracle. But
this seems to be an old switch. Should be changed to "configure
--with-oci-lib= .. --with-oci-include=...".
Andreas
------------------------------------------------------------------------------
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
------------------------------------------------------------------------------
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
------------------------------------------------------------------------------
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general
