Re: [sqlite] SQLite on AIX
On Thu, Sep 15, 2011 at 05:47:47AM +, Grice, Lynton (L) wrote: > Hi Ross, > > Many thanks for your response, I really appreciate it and will definitely > drop you a quick email if I have any issues with the build. > > I am going to install GCC onto the AIX 5.3 box and will give it a try. I have > never used the IBM C compiler..do you prefer it to GCC? [disclaimer - I am an IBM employee, but this is not an IBM policy statement] You might want to browse the IBM developerworks site for information on GCC and AIX. Some things you might want to bear in mind: - If using C++, mixing IBM and GCC compilers is not a good idea. If you have any third party libraries compiled using the IBM C++ compiler, you might be better off using just the IBM compiler. - You must use the AIX linker, which is the default in GCC I believe. This page: http://www.ibm.com/developerworks/aix/library/au-gnu.html gives useful information on GCC on AIX, as well as links to other useful resources such as evaluation links to XL C/C++ for AIX. My teams' products are built using a variety of compilers anyway, including GCC, IBM, HP and Oracle development suites. If your code is suffiently portable, and you stick to C, you should have no problems whatever compiler you use. We don't use GCC on AIX, however. I can't see performance being much of an issue on modern machines, in these days of multi-GHz cores. The odd micro-optimizations done by the XL compiler may look good in benchmarks, but the real world performance will more likely be dominated by IO. The last SQLite version I regularly used on AIX was 2.8.17, which is long obsolete, but we had no problems with that code. Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite on AIX
Hi Ross, Many thanks for your response, I really appreciate it and will definitely drop you a quick email if I have any issues with the build. I am going to install GCC onto the AIX 5.3 box and will give it a try. I have never used the IBM C compiler..do you prefer it to GCC? Chat soon ;-) Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ross Hayden Sent: Thursday, September 15, 2011 4:36 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite on AIX I build the latest version of SQLite on AIX regularly, using IBM's C compiler. GNU will probably work just as well. Feel free to email me directly if you have questions. I can't be much help with GNU, but perhaps I can be with problems during the SQLite build. Good luck. -- Ross On Sep 14, 2011, at 1:14 AM, Grice, Lynton (L) wrote: Hi there, I will need to get SQLite working soon on AIX. I have read the compile notes from 2003 at http://www.sqlite.org/cvstrac/wiki?p=HowToCompile but was just wondering if anyone has it running happily on AIX with the newer versions of SQLIte? Any hints or suggestions from people who have it compiled and working 100% on AIX? I will try install GCC on AIX for the compile Thanks Lynton NOTICE: Please note that this eMail, and the contents thereof, is subject to the standard Sasol eMail legal notice which may be found at: http://www.sasol.com/legalnotices If you cannot access the legal notice through the URL attached and you wish to receive a copy thereof please send an eMail to legalnot...@sasol.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite on AIX
I build the latest version of SQLite on AIX regularly, using IBM's C compiler. GNU will probably work just as well. Feel free to email me directly if you have questions. I can't be much help with GNU, but perhaps I can be with problems during the SQLite build. Good luck. -- Ross On Sep 14, 2011, at 1:14 AM, Grice, Lynton (L) wrote: Hi there, I will need to get SQLite working soon on AIX. I have read the compile notes from 2003 at http://www.sqlite.org/cvstrac/wiki?p=HowToCompile but was just wondering if anyone has it running happily on AIX with the newer versions of SQLIte? Any hints or suggestions from people who have it compiled and working 100% on AIX? I will try install GCC on AIX for the compile Thanks Lynton NOTICE: Please note that this eMail, and the contents thereof, is subject to the standard Sasol eMail legal notice which may be found at: http://www.sasol.com/legalnotices If you cannot access the legal notice through the URL attached and you wish to receive a copy thereof please send an eMail to legalnot...@sasol.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] SQLite on AIX
Hi, > ld: 0711-205 SEVERE ERROR: Archive file ./.libs/libsqlite3.a cannot be >processed completely. Offset 128, found in the global symbol >table for symbol __divss, does not match the offset of any found my real problem. Of course everthing is my fault. A GUI binutils version of ranlib was used instead of /usr/bin/ranlib. (Sqlite was compiled with cc.) Regards, Christoph Bauer
Re: [sqlite] SQLite on AIX
Your problem is probably in linking. Try compiling without debug ( no -g). That worked for me on AIX 4.2. Bauer, Christoph wrote: Hi, SQLite 3.2.8 and 3.3.2 does'nt compile on an AIX machine. I suspect libtool to call the linker with wrong arguments. /libtool --mode=link cc -g -DOS_UNIX=1 -DHAVE_USLEEP=1 -DHAVE_FDATASYNC=1 -I. -I../sqlite-3.3.2/src -DNDEBUG -I/T/tcl_tk/8.5/binaries/ibmaix5/include -DTHREADSAFE=0 -DSQLITE_OMIT_CURSOR -DHAVE_READLINE=0 \ -o sqlite3 ../sqlite-3.3.2/src/shell.c libsqlite3.la \ -lcurses cc -g -DOS_UNIX=1 -DHAVE_USLEEP=1 -DHAVE_FDATASYNC=1 -I. -I../sqlite-3.3.2/src -DNDEBUG -I/T/tcl_tk/8.5/binaries/ibmaix5/include -DTHREADSAFE=0 -DSQLITE_OMIT_CURSOR -DHAVE_READLINE=0 -o .libs/sqlite3 ../sqlite-3.3.2/src/shell.c -L./.libs -lsqlite3 -lcurses -Wl,-blibpath:/T/tools/unix/ibmaix5/lib:/usr/lpp/xlopt:/usr/lib:/lib ld: 0711-205 SEVERE ERROR: Archive file ./.libs/libsqlite3.a cannot be processed completely. Offset 128, found in the global symbol table for symbol __mull, does not match the offset of any member. ld: 0711-205 SEVERE ERROR: Archive file ./.libs/libsqlite3.a cannot be processed completely. Offset 128, found in the global symbol table for symbol __divss, does not match the offset of any member. ld: 0711-205 SEVERE ERROR: Archive file ./.libs/libsqlite3.a cannot be Any ideas? Regards, Christoph Bauer Dipl. Inf. LMS Deutschland GmbH Luxemburgerstr. 7 D-67657 Kaiserslautern T +49 631 303 22 152 mailto:[EMAIL PROTECTED] http://www.lmsintl.com
Re: [sqlite] SQLite on AIX
"Bauer, Christoph" <[EMAIL PROTECTED]> wrote: > Hi, > > SQLite 3.2.8 and 3.3.2 does'nt compile on an AIX machine. I suspect libtool > to call the linker with wrong arguments. > > Any ideas? > Do make target_source This builds processed C source files in the subdirectory named "tsrc". CD into that directory. Remove files you do not need (like shell.c and tclsqlite.c) and compile the rest using whatever commands are appropriate for your platform. -- D. Richard Hipp <[EMAIL PROTECTED]>