OpenVINOTM,给你看得见的未来!>>
电子产品世界 » 论坛首页 » 综合技术 » 物联网技术 » 在redhat linux 9上交叉编译sqlite-3.3.6 (ZT)

共1条 1/1 1 跳转至

在redhat linux 9上交叉编译sqlite-3.3.6 (ZT)

助工
2008-08-02 15:41:34    评分
Compile SQLite using the cross-compiler such as arm-linux-gcc

first, get sqlite-3.3.6.tar.gz from www.sqlite.org

unzip it,

#tar -zxvf sqlite-3.3.6.tar.gz

change into the sqlite-3.3.6 directory

cd sqlite-3.3.6

make a new directory such as 'build' under sqlite-3.3.6 directory,

open the configure-script using your favorite text-editor ,such as:

#vi configure

I recomamnd that you make a copy of configure before editing the configure file

cp configure configure.old

and edit the configure.

Comment out the following commands by putting a '#' in front of them(looks like):


#if test "$cross_compiling" = "yes"; then


# { { echo "$as_me:$LINENO:: error: unable to find a compiler for building build tools" >&5


#echo "$as_me: error: unable to find a compiler for building build tools" >&2;}


# { (exit 1); exit 1; }; }


#fi


. . .


#else


# test "$cross_compiling" = yes &&


# { { echo "$as_me:$LINENO:: error: cannot check for file existence when cross compiling"


>&5


#echo "$as_me: error: cannot check for file existence when cross compiling" >&2;}


# { (exit 1); exit 1; }; }


. . .


#else


# test "$cross_compiling" = yes &&


# { { echo "$as_me:$LINENO:: error: cannot check for file existence when cross compiling"


>&5


#echo "$as_me: error: cannot check for file existence when cross compiling" >&2;}


# { (exit 1); exit 1; }; }


 


Save the configure script, change into the build directory you created and call the edited


configure script from the sqlite


directory by using the following option:


../sqlite/configure --disable-tcl --host=arm-linux


After that configure should have created a Makefile and a libtool script in your build


directory.

Open the Makefile using your favorite text editor and find the following lines:

BCC = arm-linux-gcc -g -O2

change to

BCC = gcc -g -O2


The reason for these changes is that the created files have to be executed on the PC during


the compilation, so we have to


compile them with the standard gcc and not the arm-linux-gcc.


if you want compile static library version of sqlite3(only one execute file for


distribution) on ARM, edit Makefile ,

find

sqlite3$(TEXE): $(TOP)/src/shell.c .libs/libsqlite3.la sqlite3.h

change to

sqlite3$(TEXE): $(TOP)/src/shell.c .libs/libsqlite3.a sqlite3.h


find

-o $@ $(TOP)/src/shell.c .libs/libsqlite3.la \

change to

-o $@ $(TOP)/src/shell.c .libs/libsqlite3.a \


save and quit editor

run 'make' command to create the sqlite3 execute file, after a successful compile,Now you


should find a hiden “.libs”


directory in your build directory containing sqlite shared object files, like libsqlite.so


or static libray files like


libsqlite3.a .

run 'arm-linux-strip sqlite3' to decrease the execute file size.

upload the sqlite3 to target ARM9 board by any FTP client and make it executive:

on ARM9 board with terminal or telnet ,run

chmod 775 sqlite3

and then run sqlite3 like this

sqlite3 ex2

,if you see the following messages:

SQLite version 3.3.6

Enter ".help" for instructions

sqlite>


input some commands to do something,

sqlite> create table tbl(one varchar(10),two smallint);

sqlite> insert into tbl values('hello',10);

sqlite> insert into tbl values('goodbye',20);

sqlite> .quit

more commands , please visit www.sqlite.org for details

then use 'ls ex2' to list files in currect directory,

if you see 'ex2' file,

congratulations,you have successfully making a standalone 'sqlite3'.


next step we should compile the example code on www.sqlite.org's quickstart page

make a 'test.c' file in 'build' directory, content as showed:

#include <stdio.h>

#include "sqlite3.h" /* orignal is <sqlite3.h> */


static int callback(void *NotUsed, int argc, char **argv, char **azColName){

int i;

for(i=0; i<argc; i++){

printf("%s = %s\n", azColName, argv ? argv : "NULL");

}

printf("\n");

return 0;

}


int main(int argc, char **argv){

sqlite3 *db;

char *zErrMsg = 0;

int rc;


if( argc!=3 ){

fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);

exit(1);

}

rc = sqlite3_open(argv[1], &db);

if( rc ){

fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));

sqlite3_close(db);

exit(1);

}

rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);

if( rc!=SQLITE_OK ){

fprintf(stderr, "SQL error: %s\n", zErrMsg);

sqlite3_free(zErrMsg);

}

sqlite3_close(db);

return 0;

}

save and quit editor,




#arm-linux-gcc test.c -L.libs -lsqlite3 -static

explaination: -L.libs show that the lib searching path is '.libs'

'-lsqlite3 -static' show that the lib name is libsqlite3.a,the 'lib' and '.a' is added by


linker.

with the above command ,we can compile a standalone application with sql databse supported.

use arm-linux-strip to decrease its size:

arm-linux-strip a.out

upload to ARM9 board, make it runable and test it:

[root@fa fa]# a.out ex "select * from tbl"

one = hello

two = 10


one = goodbye

two = 20

[root@fa fa]#

if you see the above result , ok you make it.

over.

wish the article is usefull for you!

本文章来自中国IT实验室http://embed.chinaitlab.com/




关键词: redhat     linux     交叉     编译     sqlite    

共1条 1/1 1 跳转至

回复

匿名不能发帖!请先 [ 登陆 注册 ]