Over the last 2 days I've tried to compile and link my own version of
ooSQLite.dll using MinGW GCC but when I try to load it using ::REQUIRE it
fails with:
1 *-* ::REQUIRES "oosqlite" LIBRARY
Error 98 running C:\...\bin\testdll.rex line 1: Execution error
Error 98.903: Unable to load library "oosqlite"
The bin folder contains:
oosqlite3.exe
oosqlite.dll
testdll.cmd
testdll.rex
testdll.cmd contains:
path %CD%;%PATH%
rexx testdll.rex
testdll.rex contains:
::requires 'oosqlite' library
In comparison, I've successfully compiled and linked SQLite (not ooSQLite)
using the following cmd file:
@rem ------------- Compile SQLite (32-bit)
mkdir temp
path \mingw\bin;%PATH%
@rem ------------- Create sqlite3.dll
gcc -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_RTREE -D
SQLITE_ENABLE_COLUMN_METADATA -D SQLITE_ENABLE_MEMORY_MANAGEMENT -O2 -o
temp/sqlite3.o -c sqlite3.c
gcc -o sqlite3.dll -s -shared temp/sqlite3.o -W1,--subsystem,windows
@rem ------------- Create sqlite3.exe
gcc -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_RTREE -D
SQLITE_ENABLE_COLUMN_METADATA -D SQLITE_ENABLE_MEMORY_MANAGEMENT -O2 -o
temp/shell.o -c shell.c
gcc -o sqlite3.exe -s temp/shell.o -L. -l sqlite3 -W1,--subsystem,windows
@rem del temp\*.* /Q
@rem rmdir temp
I've verified that the SQLite DLL is working using the following Rexx/SQL
statements:
Call RXFuncAdd "SQLLoadFuncs", "rexxsql", "SQLLoadFuncs"
Call SQLLoadFuncs
say sqlconnect("s1","","","")
say sqlcommand(c1,"CREATE TABLE AA (A,B);")
Return code 0 is returned in all cases.
ooSQLite seems to be a different beast and maybe it's because there is a
mixture of C and C++ code, I don't know. (Please note that I have no C or
C++ background whatsoever so this is all new to me.)
This is the compile suite that I'm running (I've created a copy of the SVN
source tree in SVN32 where I've applied the source changes mentioned below.
I've also copied the ooRexx API folder into the SVN32\src folder):
rem ============================= ooSQLite compile
============================
path C:\MinGW\bin
mkdir temp
rem ============== Compile 'APICommon.cpp' ====================
g++ -O2 -m32 -c SVN32\src\APICommon.cpp -o temp/APICommon.o -I
SVN32/src/ -I SVN32/src/sqlite/ -I SVN32/src/platform/windows/ -I
SVN32/src/ooRexxAPI/ -D W3 -D _CRT_SECURE_NO_DEPRECATE -D
_CRT_NONSTDC_DEPRECATE -D OOSQLITE_VER_MAJOR=1 -D OOSQLITE_VER_MINOR=0 -D
OOSQLITE_VER_LEVEL=0 -D OOSQLITE_VER_BUILD=0 -D OOSQLITE_VER_STR="1.0.0" -D
OOSQLITE_COPYRIGHT_YEAR="2012-2012"
rem ============== Compile 'ooSQLite.cpp' =====================
g++ -O2 -m32 -c SVN32\src\ooSQLite.cpp -o temp/ooSQLite.o -I
SVN32/src/ -I SVN32/src/sqlite/ -I SVN32/src/ooRexxAPI/ -D
SQLITE_THREADSAFE=1 -D SQLITE_ENABLE_FTS4 -D SQLITE_ENABLE_RTREE -D
SQLITE_ENABLE_COLUMN_METADATA -D SQLITE_ENABLE_MEMORY_MANAGEMENT -D W3 -D
_CRT_SECURE_NO_DEPRECATE -D _CRT_NONSTDC_DEPRECATE -D OOSQLITE_VER_MAJOR=1
-D OOSQLITE_VER_MINOR=0 -D OOSQLITE_VER_LEVEL=0 -D OOSQLITE_VER_BUILD=0 -D
OOSQLITE_VER_STR="1.0.0" -D OOSQLITE_COPYRIGHT_YEAR="2012-2012"
rem ============== Compile 'SQLite.c' =====================
gcc -O2 -m32 -c SVN32\src\sqlite\sqlite3.c -o temp/sqlite.o -I
SVN32/src/ -I SVN32/src/sqlite/ -I SVN32/src/ooRexxAPI/ -D
SQLITE_THREADSAFE=1 -D SQLITE_ENABLE_FTS4 -D SQLITE_ENABLE_RTREE -D
SQLITE_ENABLE_COLUMN_METADATA -D SQLITE_ENABLE_MEMORY_MANAGEMENT
rem ============== Compile 'shell.c' =====================
gcc -O2 -m32 -c SVN32\src\sqlite\shell.c -o temp/shell.o -I
SVN32/src/ -I SVN32/src/sqlite/ -I SVN32/src/ooRexxAPI/ -D
SQLITE_THREADSAFE=1 -D SQLITE_ENABLE_FTS4 -D SQLITE_ENABLE_RTREE -D
SQLITE_ENABLE_COLUMN_METADATA -D SQLITE_ENABLE_MEMORY_MANAGEMENT
rem ============== Create 'libooSQLite.a' ==============
ar rcs temp/liboosqlite.a temp/*.o
rem ============== Create 'bin\ooSQLite.dll' ==============
gcc -m32 -o bin\oosqlite.dll -s -shared -Ltemp -l ooSQLite
rem ============== Create 'bin\ooSQLite3.exe' ===============
gcc -m32 -o bin\ooSQLite3.exe -s -Ltemp -l ooSQLite
del temp\*.* /Q
rmdir temp
I should mention here that I've had to make some modifications to a few
files in order to get a clean compile:
APICommon.cpp:
Added the following declaration to the rxStr2Number function:
unsigned __int64 _strtoui64(
const char *nptr,
char **endptr,
int base
);
rexxapitypes.h:
#include <ctype.h> /*
<<<<<<<<<<<<<<<<<<< added this include */
/*typedef SSIZE_T ssize_t; <<<<<<<<<<<<<<<<<<<
commented out */
/*#define SSIZE_MAX ((ssize_t)(SIZE_MAX >> 1))
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< commented out */
winOS.hpp:
/* #define _WIN32_WINNT 0x0600 <<<<<<<<<<<<<<<<<< commented out
*/
/* #define WINVER 0x0501 <<<<<<<<<<<<<<<<<< commented out
*/
Again I try to verify the resulting DLL by running the following:
testdll.cmd:
path %CD%;%PATH%
rexx testdll.rex
testdll.rex:
::requires "oosqlite" library
But I keep getting the error stated at the beginning of this (unfortunately
long) note. (BTW the oosqlite3.exe file works fine.)
objdump -f shows the following:
oosqlite.dll: file format pei-i386
architecture: i386, flags 0x00000103:
HAS_RELOC, EXEC_P, D_PAGED
start address 0x6ca41058
objdump -f against the working sqlite3.dll shows:
sqlite3.dll: file format pei-i386
architecture: i386, flags 0x00000103:
HAS_RELOC, EXEC_P, D_PAGED
start address 0x6b0c1058
I can hear the question: why not use Visual C++? The answer is that without
any C/C++ background it complicates things for me even more.
I've tried to use MSYS but with no success there either so I just go for
the raw g++ and gcc commands. After all, I'm developing in Rexx, not C.
Anybody out there who can draw a conclusion from this? I'm sure the answer
is just there right in front of me but I just can't see it.
Many thanks.
Staffan
------------------------------------------------------------------------------
Got visibility?
Most devs has no idea what their production app looks like.
Find out how fast your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219671;13503038;y?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
