SQLite: near "DATABASE": syntax error

Question

When I try to create a database programatically in SQLite using java, it generates the following error in console.

java.sql.SQLException: near "DATABASE": syntax error
    at org.sqlite.DB.throwex(DB.java:288)
    at org.sqlite.NativeDB.prepare(Native Method)
    at org.sqlite.DB.prepare(DB.java:114)
    at org.sqlite.PrepStmt.<init>(PrepStmt.java:37)
    at org.sqlite.Conn.prepareStatement(Conn.java:224)
    at org.sqlite.Conn.prepareStatement(Conn.java:217)
    at org.sqlite.Conn.prepareStatement(Conn.java:206)
    at com.mmcal.build.BuildDB.executeQuery(BuildDB.java:46)
    at com.mmcal.build.BuildDB.createDB(BuildDB.java:19)
    at MainGen.main(MainGen.java:16)

My code is :

public class BuildDB {
Connection connection;
PreparedStatement ps;
ResultSet rs;
String qry;

public void createDB() {
    qry = "CREATE DATABASE IF NOT EXISTS myDb";
    executeQuery(qry);
}
public boolean executeQuery(String qry) {
    int cnt = 0;
    boolean flag = false;
    connection = ConnectionMaster.connectDb();
    try {
        ps = connection.prepareStatement(qry);
        cnt = ps.executeUpdate();
        System.out.println(flag);
    } catch (SQLException e) {
        e.printStackTrace();
    }
    if (cnt == 0) {
        flag = true;
    }

    return flag;

}
}

What's the problem in my code or is this the correct way to create database in SQLite via programatically?

Doon · Accepted Answer · 2012-11-15 12:35:52Z

8

With SQLite you just open the database. If it doesn't exist it will be created for you automatically. Then you can check if your tables exist and create them as required.

answered Nov 15, 2012 at 12:35

Doon

20.3k3 gold badges42 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Trausti Thor · Accepted Answer · 2012-11-15 12:36:28Z

6

SQLite doesn't create database, if the file doesn't exist that you assign to, it gets created.

You just assign a file. It doesn't have the command to create database, only create table

answered Nov 15, 2012 at 12:36

Trausti Thor

3,77436 silver badges43 bronze badges

Comments

jokernate · Accepted Answer · 2022-07-08 08:29:02Z

-1

you have to create tables only, is it? Databases are already created in sqlite.online.com eg. CREATE TABLE products ( id INT NOT NULL, price MONEY, PRIMARY KEY (id) );

//I got the same error while trying the website to run sql code for the first time but maybe my post might help u.

answered Jul 8, 2022 at 8:29

jokernate

1

2 Comments

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Japhei Over a year ago

This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review

Collectives™ on Stack Overflow

SQLite: near "DATABASE": syntax error

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related