0

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)
Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
BroscR
  • 167
  • 2
  • 11

0 Answers0