Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 13 Next capture
2021 2022 2023
1 capture
13 Jun 22 - 13 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
0
Question by zhuchun · Nov 30, 2012 at 09:54 AM · databasesqlitewcf

SQLite Except: The database file is locked

Hi

I'm developing a game with Sqlite and WCF. But they only work fine together at the first run, if I try play scene again, console show "SQLite Except: The database file is locked", Help!


Codes below

 LobbyServiceClient _client = new LobbyServiceClient(_binding,_endpoint);
 
 _client.DoSomething();
 
 try {
             if (_client.State!=CommunicationState.Faulted) {
                 //_client.Close();
                 _client.Abort();

}}catch (System.Exception ex) { _client.Abort(); }

string _sql ="Some Select Function";

SqliteHelper _db = new SqliteHelper("client.db");

         _db.Conn.Open();
         DataTable _dt=  _db.Q(_sql);
         _db.Conn.Close();
Comment
Add comment · Show 4
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image DeveshPandey · Nov 30, 2012 at 10:12 AM 0
Share

have you open your same database with "sqlite manager" at the same time?

avatar image zhuchun · Nov 30, 2012 at 12:49 PM 0
Share

Thanks for your reply Devesh.But no I didn't use it. All I do is just new a SqliteConnection(string) before open connection, and it throw this exception when next time I try to open connection(always can make it at first time).

avatar image DeveshPandey · Nov 30, 2012 at 12:57 PM 0
Share

O$$anonymous$$, close connection in finally block, may be solve your problem.

avatar image zhuchun · Nov 30, 2012 at 02:54 PM 0
Share

Find a little trick, TY!

1 Reply

· Add your reply
  • Sort: 
avatar image
0
Best Answer

Answer by zhuchun · Nov 30, 2012 at 02:54 PM

Here's a temporary solution: Put WCF codes between SqliteConnection.Open() and Close(). Thanks to Devesh! TY!

Comment
Add comment · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this Question

Answers Answers and Comments

12 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

how to access and modify my existing database made by DB browser for SQLite in unity after build 0 Answers

why sqlite can't conneted after build in PC (.exe) 0 Answers

Deleting the main database at runtime. 0 Answers

SQLite Query error 0 Answers

how to use database in unity for developing android games? 0 Answers


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges