The MySQL X DevAPI is an application-level interface used by clients and connectors built on top of the X Protocol. It specifies a common set of CRUD-style and SQL functions/methods to work with both document store collections and relational tables, a common expression language to establish query properties such as criteria, projections, aliases, and additional database management features for handling things like transactions, indexes, etc.
Questions tagged [mysql-x-devapi]
64 questions
0
votes
1 answer
NodeJS mysql/xdevapi 'Access denied' using SSL and X Protocol
I am trying to connect to my mysql server using the X Protocol and SSL.
To connect to a database I use the MySQL x devapi for NodeJs(mysql/xdevapi). Both, the MySQL server as well as my nodejs application are running on the same machine. However…
Luca
- 45
- 4
0
votes
1 answer
PHP MySQL X DevAPI Collection::existsInDatabase() method does not recognise Collections with additional columns
According to the PHP docs the existsInDatabase() method is intended to determine if an instance of Collection exists in the database (as a SchemaObject aka a Table). But it only considers a Collection to exist if it's table's schema fits exactly…
Martin Joiner
- 3,529
- 2
- 23
- 49
-1
votes
1 answer
How to set DateTime using mysql xdevapi in C#
I am trying to insert a row with a DATETIME field using MySqlX.XDevAPI.
Whatever I try, I just get this cryptic message:
Expected token type IDENT at token pos 0
I have tried string format:
dt.ToString("yyyy-MM-dd HH:mm:ss")
I have tried UTC…
Chebz
- 1,375
- 3
- 14
- 27
-2
votes
1 answer
How do I solve this error: "SQL error: too many arguments"
I have an API through Firebase Functions. When sending an request to the API with the body {"name":"1234"} with postman. I get the error 401 "SQL : Error: Too many arguments"
This is my function:
index.js
const functions =…
Remlej9
- 3
- 3