rafiss
commented
4 years ago @mkharibalaji Thanks for the report. With the code sample you provided, sequelize should be logging the SQL query it is generating. Can you find the query (or queries), and share them here?
When I run your code sample, it works, though so far I have only tried on MacOS.
$ node sequelize-repro.js
sequelize deprecated String based operators are now deprecated. Please use Symbol based operators for better security, read more at http://docs.sequelizejs.com/manual/tutorial/querying.html#operators node_modules/sequelize-cockroachdb/node_modules/sequelize/lib/sequelize.js:245:13
Executing (default): SELECT 1+1 AS result
Connection has been established successfully.
Environment : Windows 2016 Server 1 ) Install Cockroach DB 19.1 2) create a nodejs application with Sequalize ORM 3) Setup the sample database bank with a user maxroach and no ssl or insecure config in the local machine without clustering
var sequelize = new Sequelize('bank', 'maxroach', '', { host: 'localhost', dialect: 'postgres', port: 26257, logging: console.log });
sequelize .authenticate() .then(() => { console.log('Connection has been established successfully.'); }) .catch(err => { console.error('Unable to connect to the database:', err); });
Expected behavior A Connection should have been established
Additional data / screenshots