package.json文件
{ "name": "typeorm-typescript-koa-example", "version": "0.0.1", "description": "Example how to use Koa and TypeORM with TypeScript.", "license": "MIT", "readmeFilename": "README.md", "author": { "name": "Umed Khudoiberdiev", "email": "pleerock.me@gmail.com" }, "repository": { "type": "git", "url": "https://github.com/typeorm/typescript-koa-example.git" }, "bugs": { "url": "https://github.com/typeorm/typescript-koa-example/issues" }, "tags": [ "orm", "typescript", "typescript-orm", "typeorm-sample", "typeorm-example", "typeorm-koa-example" ], "devDependencies": { "typescript": "^2.1.5" }, "dependencies": { "@types/koa": "^2.0.39", "@types/koa-bodyparser": "^3.0.24", "@types/koa-router": "^7.0.23", "@types/node": "^8.0.26", "body-parser": "^1.17.2", "koa": "^2.3.0", "koa-bodyparser": "^4.2.0", "koa-router": "^7.2.1", "mssql": "^4.0.4", "node-mssql": "0.0.1", "reflect-metadata": "^0.1.10", "typeorm": "0.0.11" }, "scripts": { "start": "tsc && node src/index.js" }}
ormconfig.json
[ { "name": "default", "driver": { "type": "mssql", "host": "127.0.0.1", "port": 3000, "username": "sa", "password": "wangliao123", "database": "TF_DW" }, "autoSchemaSync": false, "entities": [ "src/entity/*.js" ], "subscribers": [ "src/subscriber/*.js," ], "migrations": [ "src/migration/*.js" ], "cli": { "entitiesDir": "src/entity", "migrationsDir": "src/migration", "subscribersDir": "src/subscriber" } }]
报错信息
TypeORM connection error: TypeError: _this.mssql.Connection is not a constructor at D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\driver\sqlserver\SqlServerDriver.js:98:30 at Promise (<anonymous>) at SqlServerDriver.connect (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\driver\sqlserver\SqlServerDriver.js:97:16) at Connection.<anonymous> (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:165:58) at step (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:32:23) at Object.next (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:13:53) at D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:7:71 at Promise (<anonymous>) at __awaiter (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:3:12) at Connection.connect (D:\workspace_webstorm\typescript-koa-example-master\node_modules\typeorm\connection\Connection.js:157:16)
解决方案
这个是mssql的版本问题,4.x版本对3.x版本的一些方法不支持了,改用mssql 3.3.0版本就好了