🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #133

SQLite�ĵ��û�����

#133
From: ���GB3100-93���ҽа�������
Date: Sat, 24 Jul 2010 19:30
42 lines
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Ƚ���Ȥ��~~

--



ì���ɣ�
һ������Ϊ�棬���������Ϊ�٣����߲�ͬ����

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.48.3]
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!SJTU

Show 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