[Solved] Problems building Oracle Call Interface (OCI) Plugin on Windows
-
So you did try this in a plain main function with a dummy select like "SELECT SYSDATE FROM DUAL"?
Doing a quick grep, I cannot find any thread related code in the SQL modules and the OCI drivers.
-
Now when you mentioned it I tried to execute the addDatabase function and the mentioned dummy select in main, and it seems that it actually works there way or another. I was getting lost on all the complicated issues so that I couldn't see this simple solution on where to start finding the actual problem, thanks!
I haven't wrote a single line of any thread related code in this program and I have no idea where it originates from, but at least now I know the problem is somewhere in my code and not the drivers as I first suspected.
I'll report in on when I find any solutions or clues where this problem comes from.
-
Okay, I found out where the problem was some time ago but I didn't have any time to write it here.
So, I was able to build a working plugin as mentioned above. The last problem was that I was calling a member function of a class that handles the database before I called the constructor of the class.
Feeling a bit shamed here about that :PSo the problem and solution was rather trivial here, I just didn't notice it. The problem with noticing this problem is that the compiler or builder doesn't think that calling member functions of a not-constructed class is actually an error (C++, that is).
-
[quote author="ionwind" date="1307431973"]
So the problem and solution was rather trivial here, I just didn't notice it. The problem with noticing this problem is that the compiler or builder doesn't think that calling member functions of a not-constructed class is actually an error (C++, that is).[/quote]If you have pointers, the compiler can't know. You might have initialized that pointer somewhere in a plugin or a lib, which the compiler doesn't even see on compile time.
So, this happens from time to time - good to know that the solution is that easy and that it is not a bug in the libs :)
-
Hi,
I am slogging with the OCI plugin for Qt4.7.3.
After completing all the steps mentioned by ionwind when I execute nmake I get the following error:
@g++ -enable-stdcall-fixup -Wl,-enable-auto-import -Wl,-enable-runtime-ps
eudo-reloc -mthreads -Wl -shared -Wl,--out-implib,debug\libqsqlocid4.a -o debug
qsqlocid4.dll debug/main.o debug/qsql_oci.o debug/moc_qsql_oci.o -L"c:\QtSDK
Desktop\Qt\4.7.3\mingw\lib" debug\qsqlocid_resource_res.o -loci -lQtSqld4 -lQtCo
red4
c:/qtsdk/mingw/bin/../lib/gcc/mingw32/4.4.0/../../../../mingw32/bin/ld.exe: cannot find -loci
collect2: ld returned 1 exit status
NMAKE : fatal error U1077: 'C:\QtSDK\mingw\bin\g++.EXE' : return code '0x1'
Stop.
NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual Studio 10.0\VC\bi
n\nmake.exe"' : return code '0x2'
Stop.@The compiler says -loci can't be found.
I am running Oracle Express 10g on a Windows 7 Ultimate machine.
What is that I am missing here?
-
I found the problem. OCI.dll path was missing in environment variable.
Once updated I was able to compile the driver.
-
how did you add oci.dll path
-
Adding the path to environment variable depends on the system you're using. Try searching the web with "add environment variable to path".
I'd gladly give more specific advice if I could remember better how I did things back then. -
I have added to PATH variable this C:\XEClient\bin\oci.dll
But how to use it? -
And when I perform mingw32-make i get error that -loci is missing
-
Avoid giving specific file path in environment variable, so update the path variable with C:\XEClient\bin
If you still get the -loci missing error, try copying the dll to system directory (eg. C:\windows\system32) and your make should find it without any problem.
-
You mean like perform this line : set PATH=%PATH%;c:\Windows\System32
before nmake?
If that's what I need to do then it's not working still.
Any other suggestion -
Use set PATH = %PATH%;c:\XEClient\bin & then run nmake or copy the DLL file to windows\system32
Another option is to edit the environment variable in system properties dialog to make it accessible from all locations.
[Control Panel -> System -> Advanced System Settings -> Advanced Tab -> Environment Variable]Sometimes a system restart is required for the changes to become effective.
-
nothing seems to be working
i have done what you have said, even went to enviroment dialog and make new user variable
PATH c:\XEClient\bin
and system variable had path already so I added c:\XEClient\bin and c:\windows\system32 and it's not working -
Can you mail me the nmake output? May help in solving the issue.
-
@mingw32-make -f Makefile.Debug
mingw32-make[1]: Entering directoryC:/QtSDK/QtSources/4.7.4/src/plugins/sqldrivers/oci' g++ -mthreads -shared -Wl,--out-implib,debug\libqsqlocid4.a -o debug\qsqlocid4.dll debug/main.o debug/qsql_oci.o debug/moc_qsql_oci.o -L"c:\QtSDK\Desktop\Qt\4.7.4\mingw\lib" debug\qsqlocid_resource_res.o -loci -lQtSqld4 -lQtCored4 mingw32-make[1]: Leaving directory
C:/QtSDK/QtSources/4.7.4/src/plugins/sqldrivers/oci'
@
I didn't get all code from output hmm strange -
is this helping or you need all that is on screen, because i am using this command nmake > c:\cmd.txt and I don't get all code from it
-
from the above i can't make out if there's an error, it appears that make has found the dependency and driver has been compiled.
What is there in your QTDIR\src\plugins\sqldrivers\oci\debug directory? if possible send the full debug to nilotpal2007[AT]gmail[DOT]com
-
To those who might have problems with -loci, try replacing -loci with the path to oci.dll (like C:\XEClient\bin\oci.dll) in the both Makefile.Release and Makefile.Debug files on LIBS section.