Questions tagged [dbconnection]
230 questions
1
vote
1 answer
In R (and using ROracle), how do I successfully pull in data from my database?
In R (and using ROracle), how do I successfully pull in data from my database? It looks like everything is working, but it's not providing me my table from my database.
I have the following code:
#set path to oracle client…
Scott R
- 133
- 2
- 13
1
vote
1 answer
DataBase Connection String Parameter Pollution fortify issue
I have developed a tool and when I am running the fortify then I am getting 6 critical issues related to Db connection string stating "Concatenating unvalidated input into a database connection may allow an attacker to override the value of a…
Raj Singh
- 41
- 5
1
vote
2 answers
Ubuntu 18.04 RJDBC:JDBC connection to oracle hangs no response
I developed a shiny application using data from an oracle database, my app is developed and running smoothly in my windows environment. To deploy my app within my colleges I wrote it as a package and installed this packages on a ubuntu server.
…
Alina Ludewig
- 89
- 7
1
vote
1 answer
HikariCP shutdown initally
First of all, I am not a Java developer. However, I have a service developed in Java and working as expected until today. Our database server get a disk error so we return VMVare backup.
My services which are in different machines doesn't working(or…
is_oz
- 813
- 1
- 8
- 27
1
vote
1 answer
Create Dynamic Database Connection in Laravel
I tried to change the database connection from laravel model,
This is my code,
namespace App\model;
use Illuminate\Database\Eloquent\Model;
use Config;
use DB;
class Process extends Model
{
config(['database.connections.newsql' => [
…
JIJOMON K.A
- 1,290
- 3
- 12
- 29
1
vote
0 answers
R to Oracle Connection
I am trying to connect R with Oracle using RJDBC. I am using the following code -
library(RJDBC)
jdbcDriver = JDBC(driverClass="oracle.jdbc.OracleDriver",classpath="~/lib/ojdbc14.jar")
jdbcConnection = dbConnect(jdbcDriver,…
user5891930
- 51
- 6
1
vote
1 answer
connect to different database +singleton + node.js
I want to connect to different database(MongoDB) based on the Redis configuration. So i have to read the redis database and have to make database connection(MongoDb). Also have to make sure that its singleton.
What i have tried is…
Subburaj
- 5,114
- 10
- 44
- 87
1
vote
1 answer
Does Sqlite have a table, view, and/or column description in the metadata?
I am calling DbConnection.GetSchema("Tables") and that does not return a column named "table_comment".
Does Sqlite not have descriptions in its metadata?
Or if it has it, how do I query it?
thanks - dave
David Thielen
- 28,723
- 34
- 119
- 193
1
vote
0 answers
Profiling SQL in application c# level
Some context:
I have a project with both MSSQL and Oracle connections using the classes below:
Oracle.ManagedDataAccess.Client.OracleConnection; // from nuget: Oracle.ManagedDataAccess
System.Data.SqlClient.SqlConnection; // from .net framework…
Jonny Piazzi
- 3,684
- 4
- 34
- 81
1
vote
0 answers
Only get `character(0)` from ROracle conection
Does someone know why I am unable to get data tables from my ROracle connection configured as below?
drv <- dbDriver("Oracle")
con <- dbConnect(drv,username = "myusername", password = "mypassword ")
Up to there it seems to be okay, I get the…
JeanBertin
- 633
- 1
- 7
- 23
1
vote
0 answers
Why Sql Server returns same error code of every exception in asp.net?
I am building an asp.net website in which I have to track different exceptions like duplicate user email or data inserted or not or foreign key exceptions but sql server 2016 always return error code -2146232060. I heard about duplicate error code…
Hafiz Hamza
- 311
- 3
- 16
1
vote
1 answer
Read a View created from a procedure in SAP HANA from R
I have schema in SAP HANA by the name "HYZ_ProcurementToSales" and View "V_HYZ_P25_Market_Market_Orders" which is created from a procedure, I am trying to extract the view in the R server version 1.0.153. The code I am using…
Ashmin Kaul
- 860
- 2
- 12
- 37
1
vote
0 answers
Total 0 Hikari Pool, how is possible?
i have threaded system. too many (thousands)
Sometimes we have had a database bottleneck.
For analyse this bottleneck i had opened log on debug mode. And i saw this :
Hikari loaded...
springHikariCP -…
wikiCan
- 449
- 3
- 14
1
vote
0 answers
MySQL ODBC Driver not recognizing date fields with DbFactory
I have a date field stored just fine in MySQL:
But when I try to connect to it using the Microsoft ODBC driver, I get the following error:
ERROR [HY000] [MySQL][ODBC 5.3(a) Driver][mysqld-5.7.19-log]Incorrect date value: '3/22/2013 12:00:00 AM'…
dashnick
- 2,020
- 19
- 34
1
vote
1 answer
SSMA for Oracle "Connect to Oracle" error
i tried to connect to Oracle using Sql server migration assistant for oracle(SSMA for oracle).
and specified parameters like this
provider: Oracle Client Provider
mode: standard mode
and connection info(servername, port ...)
but i got a error…
이미진
- 11
- 1
- 3