[MonoDevelop] Sqlite issue

[Ian Norton-Badrul]

You need to ensure that the folder is writeable too.

I believe sqlite creates a lock file in the same folder

On 7 Jul 2009, at 17:30, "Dan Winslow" <DWinslow at aiminstitute.org<mailto:DWinslow at aiminstitute.org>> wrote:

(Code follows question)

This code raises

Unhandled Exception: Mono.Data.Sqlite.SqliteException: Attempt to write a read-only database
attempt to write a readonly database
  at Mono.Data.Sqlite.Sqlite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x0007b] in /builddir/build/BUILD/mono-2.4/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLite3.cs:210
  at Mono.Data.Sqlite.Sqlite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0002c] in /builddir/build/BUILD/mono-2.4/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLite3.cs:139
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00026] in /builddir/build/BUILD/mono-2.4/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLiteCommand.cs:558
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand:ExecuteNonQuery ()
  at logsharp.MainClass.Main (System.String[] args) [0x001c0] in /home/dwinslow/Desktop/metrix/logsharp/Main.cs:45

Does anyone know why? The file permissions are fine.

(CODE)

  StreamReader re = File.OpenText("/home/dwinslow/Desktop/metrix/200926.sorted.log");
             string input = null;
                                     int linecount=0;

                                     SqliteConnection dbh=new SqliteConnection("URI=file:/home/dwinslow/Desktop/metrix/weblog.db");
                                     SqliteCommand cmd=new SqliteCommand("");

                                     dbh.Open();
                                     cmd.Connection=dbh;

             while ((input = re.ReadLine()) != null)
             {
                //Console.WriteLine(input);
                                                string[] parts=input.Split(' ');
                                                linecount++;
                                                StringBuilder[] S=new StringBuilder[10];
                                                S[0]=new StringBuilder(parts[0]);
                                                S[1]=new StringBuilder(parts[1]);
                                                S[2]=new StringBuilder(parts[4].TrimStart('['));
                                                S[2][S[2].ToString().IndexOf(':')]=' ';
                                                S[3]=new StringBuilder(parts[6].TrimStart('"'));
                                                S[4]=new StringBuilder(parts[7].Trim('"'));
                                                S[5]=new StringBuilder(parts[9].Trim('"'));
                                                S[6]=new StringBuilder(parts[10].Trim('"'));
                                                S[7]=new StringBuilder(parts[11].Trim('"'));
                                                S[8]=new StringBuilder(parts[12].Trim('"'));



            cmd.CommandText=String.Format(
            "insert into log values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')",
                                                S[0],S[1],S[2],S[3],S[4],S[5],S[6],S[7],S[8]);
            Console.WriteLine(cmd.CommandText);
            cmd.ExecuteNonQuery();

Dan Winslow
Director of Information Technology, AIM INSTITUTE
1905 Harney Street, Suite 700
Omaha, NE 68102
402-345-5025 x156
<mailto:dwinslow at aiminstitute.org>dwinslow at aiminstitute.org<mailto:dwinslow at aiminstitute.org>
<http://www.aiminstitute.org>www.aiminstitute.org<http://www.aiminstitute.org>

_______________________________________________
Monodevelop-list mailing list
Monodevelop-list at lists.ximian.com<mailto:Monodevelop-list at lists.ximian.com>
http://lists.ximian.com/mailman/listinfo/monodevelop-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/monodevelop-list/attachments/20090707/098df216/attachment-0001.html