Questions tagged [sqljocky]

It is a MySQL connector for the Dart programming language.

A MySQL connector for the Dart programming language. It will only work in the command-line VM, not in a browser.

Home: https://github.com/jamesots/sqljocky

14 questions
9
votes
1 answer

Using Dart, how to properly return an HttpResponse using Future's

I am attempting to create a very simple http server that does one thing. Upon receiving an HttpRequest, it runs a query on the local database server, and returns a string based on that query. I am learning Dart, and I am having trouble grasping…
jabgibson
  • 416
  • 4
  • 14
2
votes
1 answer

Convert a Dart Row Object to a Map. (sqlJocky)

I'd like to get the row data given to me by sqlJocky in my Dart Server application and convert it (with column names) to a Map. Ie. row['email'] == "somename". The row data is a "_BinaryDataPacket" which is an extension of Row type. Right now the…
1
vote
3 answers

EXCEPTION: Unsupported operation: RawSocket constructor (Dart with sqljocky5: ^2.2.1)

I am trying to connect dart with a MySQL database. I installed the MySQL workbench and created a simple DB, have modified the pubspec.yaml and added any other dependencies I needed for MySQL. But I keep pulling up an exception in the…
Chris S.
  • 11
  • 1
  • 3
1
vote
1 answer

Dart - SqlJocky - Cannot resolve class 'SHA1'

I am trying to connect MySQL Server on Amazon RDS, using the following code: var pool = new ConnectionPool( host: "xxxx.rds.amazonaws.com", port: 3306, user: "root", password: "123456", db: "crm", max: 5); try…
1
vote
1 answer

I want to show data from mysql database on browser using dart

I'm working on school project, which requires to show some simple data from mysql database in browser. I've read, that SQLJocky doesn't work in browser so I decided to make it like server-client app and run db on server side (got inspiration here:…
alolapo
  • 21
  • 4
1
vote
0 answers

How to connect to Cloud SQL using dart app engine and sqljocky

I would like to use the application identifier access control method for allowing my app engine service connect to a Cloud SQL database. The app engine service is written using dart with sqljocky. In the Developers Console, Storage, Cloud SQL, db…
Brad
  • 486
  • 2
  • 8
1
vote
2 answers

Socket errors when trying to close pools and queries

I am getting this exception when I close the pool very soon after closing a query: Uncaught Error: Bad state: Cannot write to socket, it is closed Stack Trace: #0 BufferedSocket.writeBufferPart…
SanMadJack
  • 388
  • 1
  • 4
  • 14
0
votes
2 answers

Server responding with empty result when "LIKE" query is used with sqljocky5 package

Hello I am new to flutter and I am tryin to fetch data from MYSQL database based on keyword entered by the user. But the result is empty even though the data is present. I am using msqljocky5 package for MYSQL connection. Future
0
votes
1 answer

How to fix dart 2 mysql not working and sqlkocky package?

I want to connect mysql database using dart sqljocky package but it's not compatible. dart analysis show error. Resolving dependencies... The current Dart SDK version is 2.0.0. Because dartAuth depends on sqljocky >=0.1.3 which requires SDK version…
Polas Habib
  • 9
  • 2
  • 8
0
votes
1 answer

Cannot serve with SQLJocky (Undefined class 'SHA1' & Other errors)

if I try to serve my dart application get these error: Serving `web` on http://localhost:80 [INFO] ------------------------------------------------------------------------ [INFO] Starting Build [INFO] Updating asset graph completed, took 15ms…
Mattia
  • 5,909
  • 3
  • 26
  • 41
0
votes
1 answer

Exception when connecting to Database through Dart

I was trying to connect to MySQL database in Flutter application using sqljocky5 using the below code using dart language void getInfo () async { var pool = new ConnectionPool( host: 'localhost', port: 3305, user:…
dinith jayabodhi
  • 531
  • 2
  • 8
  • 19
0
votes
1 answer

Dart SqlJocky - No response from the database

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, …
OhMad
  • 6,871
  • 20
  • 56
  • 85
0
votes
1 answer

sqljocky query - method not found

Trying to query mysql database with sqljocky. This query works fine in phpmyadmin and return 5 rows with fine data. In Dart i got exception: Class '_ResultsImpl' has no instance method 'forEach'. I made breakpoint in query callback. Result object…
kolombet
  • 87
  • 1
  • 1
  • 7
0
votes
1 answer

Dart exception: class String has no instance method '>'

Im writting a simple class to manage database queries using sqljocky. The code is the following import 'package:sqljocky/sqljocky.dart'; import 'Config.dart'; abstract class QueryResultCallBack { void handleQuery(dynamic queryResult); } class…
Nadir
  • 1,799
  • 12
  • 20