C#•2y ago

❔ error connection oracle

94 Replies

Kouhai•2y ago

conn is null

RanaOP•2y ago

@Kouhai are you here

Kouhai•2y ago

Yup!

RanaOP•2y ago

RanaOP•2y ago

this is the connection string why it's return null ?

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionString": {
    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;persist security info=True;user id=RHODES_HR;pooling=true;"
  }
}

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionString": {
    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;persist security info=True;user id=RHODES_HR;pooling=true;"
  }
}

Kouhai•2y ago

Changed ConnectionString to ConnectionStrings

Kouhai•2y ago

RanaOP•2y ago

new error

RanaOP•2y ago

The entity type 'USERINFOTEST' requires a primary key to be defined. If you intended to use a keyless entity type, call 'HasNoKey' in 'OnModelCreating'. For more information on keyless entity types, see https://go.microsoft.com/fwlink/?linkid=2141943.

Bing

Under the rainbow

The water pictured crashing down the side of Waime

RanaOP•2y ago

Kouhai•2y ago

Can you show your db models?

RanaOP•2y ago

using System.ComponentModel.DataAnnotations;

namespace Nour.DB
{
    public class USERINFOTEST
    {

        [Key]
        public string USER_ID { get; set; }

        public DateTime TIMESTAMP { get; set; }

        public int STATUS { get; set; }

        public int PUNCH { get; set; }
    }
}

using System.ComponentModel.DataAnnotations;

namespace Nour.DB
{
    public class USERINFOTEST
    {

        [Key]
        public string USER_ID { get; set; }

        public DateTime TIMESTAMP { get; set; }

        public int STATUS { get; set; }

        public int PUNCH { get; set; }
    }
}

when i put [key] the new error is fetch: Connection string is not well-formed

RanaOP•2y ago

RanaOP•2y ago

this is my connectionsring code

  "ConnectionStrings": {
    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;persist security info=True;user id=RHODES_HR;pooling=true;"
  }

  "ConnectionStrings": {
    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;persist security info=True;user id=RHODES_HR;pooling=true;"
  }

How i can fix it ?

Kouhai•2y ago

Weird, looks fine to me

RanaOP•2y ago

give you team viwer to see the code ?

Kouhai•2y ago

Have you tried connecting to the db using any 3d party tools with same connection string? Sry, can't rn 😄

RanaOP•2y ago

Kouhai•2y ago

Try DBeaver, free open source sql client

RanaOP•2y ago

my company works in SQL Oracle Developer

Kouhai•2y ago

Never used it, don't know how it works 😅 Well, you could also try removing couple of sections from the connection string and re-adding them till the error shows up again

RanaOP•2y ago

this is true in Program.cs ?

RanaOP•2y ago

Kouhai•2y ago

Yes, that's correct What happens when you hard code the connection string in Program.cs file, does the same error show up?

RanaOP•2y ago

i dont understand

Kouhai•2y ago

Try to replace string conn = builder..... with

string conn = "data source=192.168.1.34:1521/orcl;password=RHODES_HR;persist security info=True;user id=RHODES_HR;pooling=true;"

Does the error still show up?

RanaOP•2y ago

Kouhai•2y ago

Yeah connection string is read correctly No need to replace conn Weird

RanaOP•2y ago

yes the same error

Kouhai•2y ago

try to remove the last semicolon here

RanaOP•2y ago

this same the same error *

Kouhai•2y ago

can't spot anything wrong at all with the connection string tbh

RanaOP•2y ago

~~ it's so bad :/

Kouhai•2y ago

Can you try running with a debugger again and checking conn...

RanaOP•2y ago

Kouhai•2y ago

Hmmm, try again after removing the trailing semi colon

RanaOP•2y ago

remove ; ? 3 semi colon delete ?

Kouhai•2y ago

Yeah, only the last one The one after Pooling=true;

RanaOP•2y ago

i try it but not work

Kouhai•2y ago

Yeah, I know, just want to make sure the connection string was read without a ; 😅

RanaOP•2y ago

now work :/

RanaOP•2y ago

Kouhai•2y ago

you connect to your db using oracle sql developer you mentioned? Also, try to remove the space before "Password" idk if it'll affect it that much

RanaOP•2y ago

RanaOP•2y ago

i can connect to db

Kouhai•2y ago

Okay, one last thing, can you send the appsettings.json where the connection string is located in? Send it as an attachment And if you have any confidential info. make sure to delete them before sending here

RanaOP•2y ago

appsettings.json

.aimless.little.moth•2y ago

You can try to connect using this connection string, I usually connect to oracle using tnsnames.ora file

"OracleConnectionString":"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= 
 (PROTOCOL=TCP)(HOST=192.168.1.34)(PORT=1521)))(CONNECT_DATA=orcl)));User Id=RHODES_HR;password=RHODES_HR;"

"OracleConnectionString":"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= 
 (PROTOCOL=TCP)(HOST=192.168.1.34)(PORT=1521)))(CONNECT_DATA=orcl)));User Id=RHODES_HR;password=RHODES_HR;"

RanaOP•2y ago

@penera the same error

RanaOP•2y ago

RanaOP•2y ago

RanaOP•2y ago

i will send you the project files

RanaOP•2y ago

Project.rar

RanaOP•2y ago

.aimless.little.moth•2y ago

Check if this formatting is correct:

 "OracleConnectionString": "Data Source=(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.34)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME=orcl)));User Id=RHODES_HR;password=RHODES_HR;"

 "OracleConnectionString": "Data Source=(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.34)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME=orcl)));User Id=RHODES_HR;password=RHODES_HR;"

Don't have an access to any oracle instance right now to try it out

RanaOP•2y ago

i can access to db the same error

.aimless.little.moth•2y ago

ok cannot help you then ;/

Kouhai•2y ago

@Rana Can you show your db context

Kouhai•2y ago

RanaOP•2y ago

using Microsoft.EntityFrameworkCore;

namespace Nour.DB
{
    public class DemoDBContext :DbContext
    {
        public DemoDBContext(DbContextOptions<DemoDBContext> options):base(options) {
        
        
        }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseOracle("OracleConnectionString");
        }

        public DbSet<USERINFOTEST> USERINFOTESTs { get; set; }
        
    }
}

using Microsoft.EntityFrameworkCore;

namespace Nour.DB
{
    public class DemoDBContext :DbContext
    {
        public DemoDBContext(DbContextOptions<DemoDBContext> options):base(options) {
        
        
        }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseOracle("OracleConnectionString");
        }

        public DbSet<USERINFOTEST> USERINFOTESTs { get; set; }
        
    }
}

Kouhai•2y ago

Voila!

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseOracle("OracleConnectionString");
        }

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseOracle("OracleConnectionString");
        }

RanaOP•2y ago

delete it ?

Kouhai•2y ago

Yeah, just delete it, you don't need to override in your case

RanaOP•2y ago

new error

Kouhai•2y ago

Basically you were connecting using "OracleConnectionString" not the actual connection string

RanaOP•2y ago

RanaOP•2y ago

Kouhai•2y ago

Try testing the connection in database developer, does it timeout?

RanaOP•2y ago

it's connect

Kouhai•2y ago

Okay Try to increase the timeout in your connection stirng

RanaOP•2y ago

how ?

Kouhai•2y ago

add Connection Timeout=200 In the connection string

RanaOP•2y ago

    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;Connection Timeout=200;persist security info=True;user id=RHODES_HR;pooling=true"

    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;Connection Timeout=200;persist security info=True;user id=RHODES_HR;pooling=true"

like this ?

Kouhai•2y ago

Yup!

RanaOP•2y ago

the same

Kouhai•2y ago

Can you show the GetData endpoint?

RanaOP•2y ago

Kouhai•2y ago

I'm not entirely sure what can cause timeout with an oracle db, but can you check current connections in sql developer?

RanaOP•2y ago

yes it's connect to db

Kouhai•2y ago

No I mean like Can you check how many connections currently exist?

RanaOP•2y ago

Kouhai•2y ago

45 with the ASP app running?

RanaOP•2y ago

when i run the asp it's 41

Kouhai•2y ago

And when you close it?

RanaOP•2y ago

45 now 41

Kouhai•2y ago

And when you try to access GetData ?

RanaOP•2y ago

Kouhai•2y ago

So when the request is made it's always over 45

RanaOP•2y ago

Connection request timed out the appsettings is correct ?

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;persist security info=True;Connection Timeout=200;User d=RHODES_HR;pooling=true;"
  }
  

}

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "OracleConnectionString": "data source=192.168.1.34:1521/orcl;password=RHODES_HR;persist security info=True;Connection Timeout=200;User d=RHODES_HR;pooling=true;"
  }
  

}

and this is the Program.cs

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Options;
using Oracle.EntityFrameworkCore;
using Oracle.ManagedDataAccess;
using Nour.DB;
using Oracle.ManagedDataAccess.Client;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddControllers();

var conn = builder.Configuration.GetConnectionString("OracleConnectionString");
builder.Services.AddDbContext<DemoDBContext>(options=> options.UseOracle(conn));



// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Options;
using Oracle.EntityFrameworkCore;
using Oracle.ManagedDataAccess;
using Nour.DB;
using Oracle.ManagedDataAccess.Client;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddControllers();

var conn = builder.Configuration.GetConnectionString("OracleConnectionString");
builder.Services.AddDbContext<DemoDBContext>(options=> options.UseOracle(conn));



// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

it's ture?

Kouhai•2y ago

This is wrong

RanaOP•2y ago

the same i try 10000 connection strings

Kouhai•2y ago

can you try to remove pooling?

Accord•2y ago

Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.

Gaming

Programming

❔ error connection oracle