java sqlite driver issue

[vibeit]

Hello,

 

I need help with this java database issue. The program can't seem to locate the driver. I got the driver and code I'm testing from this site: https://bitbucket.org/xerial/sqlite-jdbc The only difference with class name but everything else is the same. I attached a picture of the problem.

 

Error:

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

    at dbtest.DBTest.main(DBTest.java:9)

 

Line 9 is the highlighted code in the attached screenshot.

 

[jslowik]

Have you tried running a clean and build since you downloaded the project?

[fizzlesticks]

Above the console, click the problems tab and post what's in there.

[rockking1379]

11 hours ago, vibeit said:

Hello,

 

I need help with this java database issue. The program can't seem to locate the driver. I got the driver and code I'm testing from this site: https://bitbucket.org/xerial/sqlite-jdbc The only difference with class name but everything else is the same. I attached a picture of the problem.

 

Error:

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

    at dbtest.DBTest.main(DBTest.java:9)

 

Line 9 is the highlighted code in the attached screenshot.

 

dont do an executeUpdate, do a straight execute. also, it should probably be "insert into person(id,name) values (1, 'leo')" same for the next line

[fizzlesticks]

1 hour ago, rockking1379 said:

also, it should probably be "insert into person(id,name) values (1, 'leo')" same for the next line

Don't need to give column names if your're inserting for all columns.