Article View: cn.bbs.comp.database
Article #133SQLite�ĵ��û�����
From: ���GB3100-93���ҽа�������
Date: Sat, 24 Jul 2010 19:30
Date: Sat, 24 Jul 2010 19:30
42 lines
2628 bytes
2628 bytes
���챻����ĥ�ù�Ǻ����
��������
����:
sqlitejdbc-v056.jar(zentus.com), java ee 6, windows 7.
���⣺
1~ conn.setAutoCommit(false);
2~ prep.executeBatch();
3~ conn.commit();
4~ conn.setAutoCommit(true);
��3��?
java.sql.SQLException: SQL logic error or missing database
at org.sqlite.DB.throwex(DB.java:252)
at org.sqlite.DB.exec(DB.java:31)
at org.sqlite.Conn.commit(Conn.java:146)
ԭ��
SQLite������serverless����ֻ����ͬʱ��һ��ʵ�������ж�д����֮ǰ��
һ��ResultSetû�йص��������˴���
���
http://blog.gmane.org/gmane.comp.db.sqlite.jdbc/month=20080301
���룺
һ��ʼ����һЩ������˵�����ڶ�����Ӳ����ᵼ������������java
����class�е������ֶ�ȫ��static�����ֿ�ʼ����java������̻߳��ƣ���
���ŷ�������ΪResultSetû�ء�����~~
������������ͷ������Ҳ���˱�Թhttp://www.vijaykiran.com/2008/06/25/
sqlite3-exception-sql-logic-error-or-missing-database/
��������ƺ�û��ʲô����SQLite�Ľ���������һ���Ȼ����ƫ�浫�����ڵ�
������к�ˬ����������ˮing����������һЩ���Ի��DZȽ���Ȥ��~~
--
ì���ɣ�
һ������Ϊ�棬���������Ϊ�٣����߲�ͬ����
[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.48.3][m
Technical Details
Message-ID:
<51636D$buW@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed.straub-nv.de!open-news-network.org!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,bec470696b8e0131,start X-Google-NewGroupId: yes X-Google-Attributes: gid4df683fd51,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed.straub-nv.de!open-news-network.org!news.shec6.edu.cn!SJTU From: exaatto.bbs@bbs.sjtu.edu.cn (���GB3100-93���ҽа�������) Newsgroups: cn.bbs.comp.database Subject: SQLite�ĵ��û����� Date: 24 Jul 2010 19:30:20 GMT Organization: ��ˮ˼Դ Message-ID: <51636D$buW@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1279999021.A