Kotlin新手：安卓二维码项目使用Exposed连接PostgreSQL失败求助

Hey there! As someone new to Kotlin and Exposed, it’s totally normal to hit a snag with database connections. Let’s walk through the most common fixes to get your QR code data saving smoothly:

1. Confirm Your Dependencies Are Correct #

First, make sure you’ve got all the right libraries in your build file. Exposed needs both its own core/JDBC modules and the PostgreSQL JDBC driver. Here’s what you should add (adjust versions to the latest if needed):

// Exposed core and JDBC
implementation "org.jetbrains.exposed:exposed-core:0.41.1"
implementation "org.jetbrains.exposed:exposed-jdbc:0.41.1"

// PostgreSQL JDBC driver
implementation "org.postgresql:postgresql:42.6.0"

If the driver is missing, Exposed won’t know how to talk to PostgreSQL at all.

2. Verify Your Connection Parameters #

Typos here are super common—triple-check these values:

• JDBC URL: Should follow the format jdbc:postgresql://<host>:<port>/<database_name>. For a local DB, this is usually jdbc:postgresql://localhost:5432/your_qr_db (default port is 5432).
• Username/Password: Make sure these match the credentials you use to log into PostgreSQL (e.g., the default postgres user’s password you set during installation).
• Driver Class: Exposed needs the PostgreSQL driver class name: org.postgresql.Driver—don’t misspell this!

3. Ensure Your PostgreSQL Instance Is Accessible #

• If it’s a local DB: Open your PostgreSQL service manager and confirm the server is running.
• If it’s a remote DB: Check that your firewall allows traffic on port 5432, and that the PostgreSQL server is configured to accept connections from your IP (more on that below).

4. Check Your Exposed Connection Setup #

Make sure you’re initializing the database correctly before running any transactions. Here’s a simple working example:

fun connectToDb() {
    val dbUrl = "jdbc:postgresql://localhost:5432/your_qr_db"
    val dbUser = "postgres"
    val dbPassword = "your_secure_password"

    try {
        Database.connect(
            url = dbUrl,
            driver = "org.postgresql.Driver",
            user = dbUser,
            password = dbPassword
        )
        println("Successfully connected to PostgreSQL!")
    } catch (e: Exception) {
        // Print the full error to see exactly what's wrong
        e.printStackTrace()
        println("Connection failed: ${e.message}")
    }
}

Call this function early in your app (like when it starts) to ensure the connection is established before you try to save QR code data.

5. Dig Into PostgreSQL’s Access Config #

If you’re connecting to a remote DB (or even local and still having issues), check the pg_hba.conf file in your PostgreSQL installation directory. You’ll need to add a rule to allow your client to connect. For example, to allow all IPs (not recommended for production):

host    all             all             0.0.0.0/0               scram-sha-256

After editing this file, restart your PostgreSQL service for changes to take effect.

6. Use Error Messages to Narrow It Down #

The biggest help here is looking at the actual exception thrown when the connection fails. Wrap your connection code in a try-catch (like the example above) and read the stack trace—it’ll tell you exactly what’s wrong:

• No suitable driver found: Missing the PostgreSQL driver dependency.
• FATAL: password authentication failed: Wrong username/password.
• FATAL: database "your_qr_db" does not exist: You haven’t created the database yet.

If you can share the specific error message, we can pinpoint the issue even faster!

内容的提问来源于stack exchange，提问作者swaters