Comments (6)
I suspect this is the same issue, so posting here instead of a new issue. If it turns out to be unrelated, we can open a new issue.
I get "TypeError: object is not a function" when calling a stored procedure via a prepared statement. It works if I replace .execute
with .query
.
Stack trace:
var r = new this.statementInfo.parser(packet);
^
TypeError: object is not a function
at Execute.row (/Users/brandon/Desktop/binder-test/node_modules/mysql2/lib/commands/execute.js:181:11)
at Execute.Command.execute (/Users/brandon/Desktop/binder-test/node_modules/mysql2/lib/commands/command.js:26:20)
at Connection.handlePacket (/Users/brandon/Desktop/binder-test/node_modules/mysql2/lib/connection.js:263:28)
at PacketParser.onPacket (/Users/brandon/Desktop/binder-test/node_modules/mysql2/lib/connection.js:68:65)
at PacketParser.execute (/Users/brandon/Desktop/binder-test/node_modules/mysql2/lib/packet_parser.js:37:14)
at Socket.<anonymous> (/Users/brandon/Desktop/binder-test/node_modules/mysql2/lib/connection.js:80:31)
at Socket.emit (events.js:95:17)
at Socket.<anonymous> (_stream_readable.js:748:14)
at Socket.emit (events.js:92:17)
at emitReadable_ (_stream_readable.js:410:10)
Sample code:
var mysql = require('mysql2');
var connection = mysql.createConnection({
host: '10.0.1.44',
user: 'root',
database: 'mytestdb'
});
connection.execute('CALL get_user(?)', [ 1 ], function (err, rows) {
console.log(JSON.stringify(rows, null, 2));
connection.end();
});
from node-mysql2.
@brandonramirez thanks for report. This was low priority for me ( you can switch to text protocol if you really need multiple statements ). I might give it some attention, but it requires some code restructuring
Can you make minimal case (including code to create temporary procedure) so it's easier for me to replicate?
from node-mysql2.
nevermind, I actually have example in issue body (but still feel free to include your if my example gives different result to you)
from node-mysql2.
This is the source for the get_user procedure being called by the previously given client code.
CREATE PROCEDURE `get_user`(IN supplied_user_id INT)
BEGIN
select * from user_account ua where ua.user_id = supplied_user_id;
END
from node-mysql2.
should be (partially) fixed. Your example might still not work as it requires multiple statement support (select + procedure result itself). I'll address this in execute()
refactor as doing directly would add a lot of duplicated code between commands/query.js and commands/execute.js
from node-mysql2.
should be closed by #157
from node-mysql2.
Related Issues (20)
- Add support for auth_gssapi_client MariaDB authentication plugin HOT 4
- Connection Timeout on ubuntu 22.04 (works fine on windows) HOT 2
- Decimals
- Error: Can't add new command when connection is in closed state HOT 1
- awsCaBundle not working as intended for import RDS cert HOT 5
- idleTimeout doenst work in lambda environment?
- `connection.stream` does not close in Bun HOT 6
- Issue with `sha256_password` auth plugin for `MySQL v8.0.35-27` HOT 1
- Connection.end() not compatible with mysql HOT 1
- deleted: Buffer(1) [ 0 ], HOT 7
- Probably -VE Testcase: TypeError: cb is not a function at C:\Development\YADAMU\src\node_modules\mysql2\lib\pool.js:64:18 HOT 1
- Probably -VE Testcase : Error: Cannot read properties of undefined (reading 'on') at PromisePoolConnection.query (C:\Development\YADAMU\src\node_modules\mysql2\promise.js:94:22) HOT 6
- Compatibility issue - Possible corruption of values with min and max values for a double. HOT 2
- Pool does not detect nor recover from failover
- Graceful poolcluster management with AWS Aurora
- [Bug?] node-mysql2 seems to swap `x` and `y` values of a geographic Point (SRID 4326) stored in mysql8 HOT 5
- problem HOT 3
- Can't add new command when connection is in closed state
- Wrong error returned without correcting sending internal Fatal error message
- createPoolCluster does not maintain a connection to the same database throughout execution
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from node-mysql2.