Am 15.05.2011 16:04, schrieb Christoph P.U. Kukulies:
> I keep getting an SQL error
> "unable to open database file"
>
> after doing some 20 inserts into two tables of my database in a loop
> in a java function.
>
> In the main code I have
> String sql="INSERT INTO part(name,md5sum,size,pfad) VALUES (?,?,?,?)";
> String sql1="INSERT INTO
> candidate(md5sum,basename,prob_ref,suite,tag,customer) VALUES
> (?,?,?,?,?,?)";
> pstmnt = conn.prepareStatement(sql);
> pst1 = conn.prepareStatement(sql1);
>
> Furtherdown in a loop I'm doing
> try {
> pst1.setString(1, md5);
> pst1.setString(2, file.getName());
> pst1.setString(3, p_r);
> pst1.setString(4, suite);
> pst1.setString(5, mmp);
> pst1.setString(6, customer);
> pst1.executeUpdate();
> }
> and subsequently in the same inner loop another try
> with INSERTS in another table.
>
> and
> try {
> pstmnt.setString(1, file.getName());
> pstmnt.setString(2, md5);
> pstmnt.setLong(3, file.length());
> pstmnt.setString(4,s);
> pstmnt.executeUpdate();
>
> }
>
> I have no clue ay to why the program chokes with that error.
>
> --
> Christoph
>
Do I need some Autocommit?
This is under Win7/64.
I read somewhere that this message can have many meanings. One cause
could be /var/tmp
not being writable.
--
Christoph
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
