Dart SqlJocky - No response from the database

Question

I am currently trying to setup a database connection between my server (command line server) and my localhost xampp mysql. this is running in my main function:

main() async {
  var pool = new ConnectionPool(
    host: 'localhost', port: 1234,
    user: 'root', password: 'password',
    db: 'angularsite', max: 5);

  var results = await pool.query("select * from discussions");

  results.forEach((row) {
    print('Row: ${row}');
  });
}

As you can see, it's basically the example that sqljocky provides. I just replaced the credentials with mine. I don't get an error message, nothing happens. From using the good old print method I know that the execution of the code doesn't go beyond the "pool.query" line. (The ConnectionPool does indeed instanciate)

Anything I did wrong?

Thanks in advance

What do you get when you add `print(results);` before `results.forEach(...)`? — Günter Zöchbauer, Apr 12 '17 at 08:30
I don't think it's related to your code. Sounds more like the database doesn't respond. Do you get anything different when you change the query to `pool.query("select * from discussions limit 10");` or `pool.query("select 'hello world'");`? — Günter Zöchbauer, Apr 12 '17 at 08:44
Yep, same :D Going to figure it out, I'll let you know if I do. — OhMad, Apr 12 '17 at 09:04
Oh wow, it was my dumb mistake. It wanted only the port of mysql, which is 3306 by default. Huh, in Laravel 1234 worked just fine for the database credentials... ^^ — OhMad, Apr 12 '17 at 09:11
Great to see you solved the issue. Just for SO hygiene, could you please put your answer-in-comment into a proper answer, and then mark this question answered? Also, it _is_ weird that the query didn't throw an error and hasn't timed out. Could you file an issue to sqljocky? — filiph, Apr 28 '17 at 23:56

score 1 · Answer 1 · answered Apr 29 '17 at 06:41

1

The problem I had was that I was refering to the port of my localhost, and not to the port of MySql only. Entering 3306 as the port worked for me.

answered Apr 29 '17 at 06:41

OhMad

6,871
20
56
85

Dart SqlJocky - No response from the database

1 Answers1