Sorry, should have added that I'm aiming to replace RexxSQL with ooSQLite.
On Fri, Sep 14, 2012 at 8:08 PM, CVBruce <cvbr...@gmail.com> wrote:
> What version of ooRexx are you using. I see you are compiling a 32 bit
> version os ooSQLite, are you also using a 32bit version of ooRexx?
>
> Bruce
> On Sep 14, 2012, at 9:55 AM, Staffan Tylen wrote:
>
> > 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
>
>
>
> ------------------------------------------------------------------------------
> 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
>
------------------------------------------------------------------------------
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
