I am getting an error when trying to open Sybase Database connection with TypeOrm. Requirements for connection are absolutely correct (url,port,db,username,pass). I can connect using Sybase JConnect with DB viewer. But I couldn't do that with typeorm. TypeOrm seems to support SAP but I couldn't understand the problem. Hana is a cloud db service but I am trying to connect to a local sybase.
This is my app.module.
import { MiddlewareConsumer, Module, NestModule } from '@nestjs/common';
import { ConfigModule } from '@nestjs/config';
import { TypeOrmModule } from '@nestjs/typeorm';
import { AbcModule } from './abc/abc.module';
import { ApiMiddleware } from './middleware/api.middleware';
@Module({
imports: [
ConfigModule.forRoot(),
TypeOrmModule.forRoot({
logging: true,
type: 'sap',
host: process.env.ASE_URL,
port: Number(process.env.ASE_PORT),
username: process.env.ASE_USER,
password: process.env.ASE_PASS,
database: process.env.ASE_DB,
entities: []
}),
AbcModule,
],
})
export class AppModule implements NestModule {
configure(consumer: MiddlewareConsumer) {
consumer.apply(ApiMiddleware).forRoutes('/api');
}
}
This is connection error.
query failed: SELECT CURRENT_SCHEMA AS "schema_name" FROM "SYS"."DUMMY"
error: Error: Request timeout. Request info: (id: 8, creation time: 1668070673834)
at Request._fireTimeout (D:\Codes\WebProjects\abc-nest-api\node_modules\hdb-pool\lib\Request.js:114:17)
at Timeout.<anonymous> (D:\Codes\WebProjects\abc-nest-api\node_modules\hdb-pool\lib\Request.js:92:43)
at listOnTimeout (node:internal/timers:559:17)
at processTimers (node:internal/timers:502:7)