Subject: Re: no module name sqlite - msg#00009

Previous Message by Date: click to view message preview

Re: undefined symbol: sqlite3_bind_blob Problem

I reinstalled everything from scratch, and it works now fine :) Here is a good lookig output: agreif@confer11:~/opt/pysqlite-2.1.3/build/lib.linux-i686-2.4 > ldd pysqlite2/_sqlite.so libsqlite3.so.0 => /home/agreif/opt/lib/libsqlite3.so.0 (0x4000d000) libc.so.6 => /lib/libc.so.6 (0x4006b000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) thanks for the help!! Alex. On 3/3/06, Christian Boos <cboos-8puV8OjpVw0@xxxxxxxxxxxxxxxx> wrote: > Alex Greif wrote: > > Hi Christian, here is the output you asked for: > > > > agreif@confer11:~/opt/pysqlite-2.1.3 > nm pysqlite2/_sqlite.so | grep > > sqlite3 > > U sqlite3_aggregate_context > > U sqlite3_bind_blob > > (snip) > > > > On 2/8/06, Christian Boos <cboos-8puV8OjpVw0@xxxxxxxxxxxxxxxx> wrote: > > > >> Alex Greif wrote: > >> > >>> Hi Christian, > >>> this seems to be strange: > >>> > >>> agreif@confer11:~/opt/pysqlite-2.1.3 > ldd pysqlite2/_sqlite.so > >>> libc.so.6 => /lib/libc.so.6 (0x40019000) > >>> /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) > >>> > >>> > >> Ah, this means that you've linked the _sqlite.so with the static > >> sqlite.a library, > >> > > I was wrong, your _sqlite.so hasn't been linked statically with SQLite. > But in this case, the output of ldd is strange, as explained in my > previous mails, you should have something like: > > dserver:/packages/pysqlite/trunk # ldd ./pysqlite2/_sqlite.so > libsqlite3.so.0 => /opt/sqlite-3.2.8/lib/libsqlite3.so.0 > (0x0000002a95667000) > libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x0000002a957dc000) > libc.so.6 => /lib64/tls/libc.so.6 (0x0000002a958f0000) > /lib64/ld-linux-x86-64.so.2 (0x000000552aaaa000) > > i.e. you have to have libsqlite3.so.0 in the list. > > Another try: > Go in your source directory, do 'rm -fr build', then 'python setup.py build' > (send that output), then do a ldd on the _sqlite.so just produced, i.e. > after the > -o on the last line of the output above). > > -- Christian > > _______________________________________________ > Pysqlite mailing list > Pysqlite-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx > http://lists.initd.org/mailman/listinfo/pysqlite >

Next Message by Date: click to view message preview

number of matches to an sql query

This is not a particularly sqlite or python related sql question, but what is the most optimal way of getting the number of matches to a query without being interested in the actual results? At the moment I have cur.execute( query ) x = len( cur.fetchall() ) but I guess there are better ways, since in this variant the whole result set is loaded into memory and I'm only interested in their number.

Previous Message by Thread: click to view message preview

Re: no module name sqlite

Brad Allen wrote: ... Thanks...now I'm getting different tracebacks, now that I've moved outside the source dir. ... ImportError: Shared object "libsqlite3.so.8" not found Ok, this one is easy, simply add the folder where your libsqlite3.so.8 is located to your LD_LIBRARY_PATH (hope it's this environment variable on FreeBSD). Hopefully the other error you had was just a side effect of the above. Thanks! That worked.

Next Message by Thread: click to view message preview

Re: undefined symbol: sqlite3_bind_blob Problem

Hi Christian, here is the output you asked for: agreif@confer11:~/opt/pysqlite-2.1.3 > nm pysqlite2/_sqlite.so | grep sqlite3 U sqlite3_aggregate_context U sqlite3_bind_blob U sqlite3_bind_double U sqlite3_bind_int64 U sqlite3_bind_null U sqlite3_bind_parameter_count U sqlite3_bind_parameter_name U sqlite3_bind_text U sqlite3_busy_timeout U sqlite3_changes U sqlite3_close U sqlite3_column_blob U sqlite3_column_bytes U sqlite3_column_count U sqlite3_column_decltype U sqlite3_column_double U sqlite3_column_int64 U sqlite3_column_name U sqlite3_column_text U sqlite3_column_type U sqlite3_complete U sqlite3_create_function U sqlite3_data_count U sqlite3_enable_shared_cache U sqlite3_errcode U sqlite3_errmsg U sqlite3_finalize U sqlite3_last_insert_rowid U sqlite3_libversion U sqlite3_open U sqlite3_prepare U sqlite3_reset U sqlite3_result_blob U sqlite3_result_double U sqlite3_result_int64 U sqlite3_result_null U sqlite3_result_text U sqlite3_step U sqlite3_transfer_bindings U sqlite3_user_data U sqlite3_value_blob U sqlite3_value_bytes U sqlite3_value_double U sqlite3_value_int64 U sqlite3_value_text U sqlite3_value_type cu ALex On 2/8/06, Christian Boos <cboos-8puV8OjpVw0@xxxxxxxxxxxxxxxx> wrote: > Alex Greif wrote: > > Hi Christian, > > this seems to be strange: > > > > agreif@confer11:~/opt/pysqlite-2.1.3 > ldd pysqlite2/_sqlite.so > > libc.so.6 => /lib/libc.so.6 (0x40019000) > > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) > > > Ah, this means that you've linked the _sqlite.so with the static > sqlite.a library, > and then, yes, it seems quite strange that you miss some symbols. > Please send the output of `nm pysqlite2/_sqlite.so | grep sqlite3`. > > -- Christian > _______________________________________________ > Pysqlite mailing list > Pysqlite-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx > http://lists.initd.org/mailman/listinfo/pysqlite >