Skip to main content

putting sqlite3 on nexus s

i just notice that there is no sqlite3 on samsung nexus s (official ICS ROM) and i need it in debugging my application database. so i download it from somewhere on internet can't remember. Anyway the one that come with android sdk linux version should be fine to put it on phone. and here is what i do.
E:\android-sdk-windows-1.5_r2\platform-tools>adb shell
shell@android:/ $ su
su
shell@android:/ # mount -o remount,rw -t yaffs2 /dev/block/mtdblock3 /system
mount -o remount,rw -t yaffs2 /dev/block/mtdblock3 /system
shell@android:/ # dd if=/sdcard/sqlite3 of=/system/bin/sqlite3
dd if=/sdcard/sqlite3 of=/system/bin/sqlite3
47+1 records in
47+1 records out
24120 bytes transferred in 0.003 secs (8040000 bytes/sec)
shell@android:/ # chmod 4755 /system/bin/sqlite3
chmod 4755 /system/bin/sqlite3
shell@android:/ # mount -o remount,ro -t yaffs2 /dev/block/mtdblock3 /system
mount -o remount,ro -t yaffs2 /dev/block/mtdblock3 /system
shell@android:/ # sqlite3
sqlite3
SQLite version 3.7.4
Enter ".help" for instructions
sqlite>


notice : to do this your nexus have to root first.

Comments

Popular posts from this blog

Too many open files

Last week tomcat log file report many error about "Too many open files" when it has high traffic. Some in catalina_log say 2007-04-07 16:13:40 HttpProcessor[80][272] Starting background thread 2007-04-07 16:13:40 HttpConnector[80] accept: java.net.SocketException: Too many open files and here is from localhost_log 2007-04-07 16:13:40 StandardWrapperValve[myservlet]: Servlet.service() for servlet myservlet threw exception java.io.FileNotFoundException: /home/log/mylog_070407.log (Too many open files) This is because too many file descriptors're opened by tomcat. File descriptor can be limited in both system level and shell level. To check maximum number of fd in system type 'cat /proc/sys/fs/file-max'. In my case it is 65536(someone said it should set to 200000). Tomcat error when try to open socket number 272 so I think 65536 is ok for me for now. Anyway if u want to set it add 'fs.file-max = 200000' to /etc/sysctl.conf pnix@pnix-a7:~$ cat /proc/sys/fs/fil...

Setup MySQL with Ofbiz

Download ofbiz weekily build and extract it somewhere you want. From your ofbiz directory, edit file entityengine.xml in framework/entity/config add new datasources below localmysql datasource part <datasource name="custommysql" helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" field-type-name="mysql" check-on-start="true" add-missing-on-start="true" check-pks-on-start="false" use-foreign-keys="true" join-style="ansi-no-parenthesis" alias-view-columns="false" drop-fk-use-foreign-key-keyword="true" table-type="InnoDB" character-set="latin1" collate="latin1_general_cs"> <read-data reader-name="seed"/> <read-data reader-name="seed-initial"/> ...

Shadow Text Effect on JLabel

I found the trick to create shawdow text on JLabel from java forum . Instead of use JLabel.setText() set string to JLabel, he create Image and get Graphics2D by Image.createGraphics(). Then use TextLayout draw overlapping string on that Graphics2D. example code int w = 500; int h = 120; Font font = new Font("Lucida Bright", Font.ITALIC, 72); String text = "Shadow Text"; BufferedImage image = new BufferedImage(w,h,BufferedImage.TYPE_INT_RGB); Graphics2D g = image.createGraphics(); adjustGraphics(g); //start off all white: g.setPaint(Color.WHITE); g.fillRect(0, 0, w, h); //draw "shadow" text: to be blurred next TextLayout textLayout = new TextLayout(text, font, g.getFontRenderContext()); g.setPaint(new Color(128,128,255)); textLayout.draw(g, 15, 105); g.dispose(); //blur the shadow: result is sorted in image...