Stack Overflow
Stack Overflow

Questions tagged [mysql-x-devapi]

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.

64 questions
0
votes
1 answer

X DevAPI mysqlx::Session() over linux socket fails with “CDK Error: unexpected message”

I’ve (3) freshly installed mysql, (4) freshly installed Connector/C++ 8.0 X DevAPI, (5) did minimal configuration in my.cnf, (1) wrote a minimal C++ program, (2) build it, and after executing it gave the following output: $ sudo bin/sql [sudo]…
Jeroen Lammertink
  • 394
  • 1
  • 9
0
votes
1 answer

Using the MSQL XDEVAPI In Node JS, can I chain multiple calls together?

Example, I'm trying to check to see if a value exists in a table and then if no duplicates exists write the values in the same table, but its not working. Let me know if chaining the calls is possible if not, would I just pass the variable and then…
nmsdev
  • 29
  • 6
0
votes
1 answer

PHP mysql_xdevapi extension: replaceOne() seems not to be idempotent

If I replace a document with itself in a collection, the document seems to be altered. My data becomes unusable because of this problem. What am I doing wrong?
Geoffroy
  • 1
  • 1
0
votes
1 answer

info about MySQL Shell

I'm using the MySQL shell for the first time. I ran the following commands: \connect --mysql root@localhost:3306 \use myschema But, when I try to follow this instruction: myColl = db.createCollection('my_coll') I get the error: …
Alessio Frabotta
  • 117
  • 11
0
votes
1 answer

@mysql/xdevapi ECONNREFUSED doesn't release connection

I'm using the @mysql/xdevapi npm package (version 8.0.22) with a local installation of mysql-8.0.15-winx64. I have set pooling to enabled and attempted to retrieve a session from the client. If I do this before mysql is ready then I get an…
Jen
  • 5
  • 2
0
votes
1 answer

@mysql/xdevapi won't allow array parameters for WHERE field IN (?) query

I'm using the @mysql/xdevapi npm package with a local installation of mysql-8.0.15-winx64. I'm trying to execute a SQL string with parameters. The query is looking for records where the id is IN an array. const sql = "SELECT * FROM table WHERE id IN…
Jen
  • 5
  • 2
0
votes
1 answer

can't install mysql_xdevapi on ami linux2

I need mysql_xdevapi extension. trying through sudo pecl install mysql_xdevapi error: C++ preprocessor "/lib/cpp" fails sanity check - fixed. error: boost not found - fixed. error: protobuf not found - this is the main problem(( ...bla bla…
Tig
  • 38
  • 4
0
votes
0 answers

How to ping with MySQL X Dev API

In old MySQL API you can use mysql_ping() to archive that. But is there any similar function in X Dev API?
Kotori0
  • 135
  • 2
  • 10
0
votes
1 answer

XDevApi How to Send Back the Result of .insert()

.insert() is successful, but the following resulting {result:{}} in Postman. How do I send the whole object in screen back so the client can query properties?
Jeb50
  • 6,272
  • 6
  • 49
  • 87
0
votes
1 answer

MySQL XDevAPI How to return a successful status

Developing my RestAPI using XDEVAPI talking to MySQL. This piece of code works for adding a new record, myRecord.add = (newmyRecord, res) => { mysql.getSession(mydb) // .getSession() is a Promise, returns a session .then ( …
Jeb50
  • 6,272
  • 6
  • 49
  • 87
0
votes
1 answer

MySQL Connector/C++ 8 X Plugin disabled

I am working on a server application in c++ that will connect to a MySQL Server using MySQL Connector/C++ 8.0. The server has X plugin disabled and I cannot change that. https://dev.mysql.com/doc/refman/8.0/en/x-plugin-disabling.html It is possible…
cprogrammer
  • 5,503
  • 3
  • 36
  • 56
0
votes
2 answers

How Use the Oracle Cloud Infrastructure MYSQL DB and XDev API together?

So I've created a MYSQL DB on the OCI and can connect to it via SSH, I have all the ingress rules set up, the users, etc. What do I put in the host: "....": field in the javascript code? (instead of localhost). mysqlx .getSession( { …
nmsdev
  • 29
  • 6
0
votes
1 answer

How can I set the options for a MySQL Connector/Python X DevAPI connection?

How can I set the "--local-infile[={0|1}]" option for a mysqlx connection? My python code looks the following: import mysqlx # Connect to server on localhost session = mysqlx.get_session({ 'host': 'localhost', 'port': 33060, 'user':…
lucasahli
  • 388
  • 1
  • 4
  • 14
0
votes
1 answer

mysql-xdevapi getCollections promise return value

I've been trying to output the array of collections in my database schema. Assuming my session works, I'd get an Promise{} output below which I think is normal. .then(()=>{ return…
JEFF
  • 3
  • 3
0
votes
1 answer

Mysql 8 enable plugin X

few days ago I created mysql cluster on digitalocean (by default it starts on port 25060). When I installed MySQL Connector/Node.js and tried to establish connection with default port and it went on error saying : "Error: The server connection is…
j.sinjaradze
  • 145
  • 2
  • 16
1 2 3
4
5