DBI | A database interface definition for communication | Database library

I have a MySQL table1 in which:

• id is auto incremented

• A, B, C are NON-UNIQUE

  ...

I'm building a WebApp with a SQL DB as Backend. I'm Deploying the both parts on Azure, as Azure Webapp and SQL Server.

The SQL server is sercured with Azure AD (AAD). So only Users in a Group can access the DB.

So I'm trying to setup a workflow where the Webapp login the user and collect his Access token. And then uses the token to Query the SQL server.

I've registreted the App in AAD, where it is authorized to read the user ID and impersonate as the user.

I've the following code which is working local. But I can't get it to work deployed locally in a Docker Image.

I have a JSF web application that worked under Java 6, Glassfish 4.1, SQL Server 2012, Nebeans 8 but I am receiving an error under Java 8, Glassfish 5.1.0, SQL Server 2014, Netbeans 12. It varies some, but it is usually a handshake, socket, or class not found (focused on a servlet).

Hand shake error:

I am looking for a way to work with connected databases using R so I don't have to upload databases to my memory. I have been working using pool or DBI packages to connect to the database and dplyr for data manipulation, but I have found some problems I haven't been able to solve:

Loading the Data:

Trying to have a pie (or preferably, donut) chart that displays totals per category and that allows a drilldown to display specifics per category when clicked. Make sense?

I think I might not have every system setting correct, since also copy/paste standard examples render an empty page. Unless that's somehow outdated or something. My system: Ubuntu 20.04, R 4.0.5, packageVersion("shiny") 1.6.0, shiny-server --version 1.5.16.958 Blank examples: https://plotly-r.com/linking-views-with-shiny.html#drill-down and Creating drill down report in R Shiny (amongst others)

My current attempt (not reactive yet because I can't for the life of me figure it out):

I've been using pp

https://metacpan.org/pod/pp

A while ago!

However when hiring another hosting, when I run the pp command the scripts do not run on the server

CentOS Linux release 7.9.2009 (Core) Perl v 5.32.1

Command using pp, host old

When I knit any of the CV templates in the R package vitae I get a slightly different error for each one. I've made sure that all the files, including my Rmd file, are in the same directory and I haven't changed the template in any way. When I knit the modern CV template, for example, I get this error message:

The example below is a simple one which tries to assert the column y is always positive (y>0). How can I extract the errored data (row 3 with the negative value,into a dataframe maybe, or any convenient object) while allowing the workflow to continue with "cleaned" data?

I try to connect to an oracle DB using Rstudio, but I can't figure out how to do it. I have connected to the database with PowerBi, so I know it is accessible (from my pc/ip) and that the database works fine, however using R I cannot get this done. Prior to asking this question I have been searching the web for days, I'm not new to R or SQL, but I am to Oracle. I have tried various packages (DBI, odbc, RODBC etc.) but still no success. I have talked to the administrators of the DB, they said I should be able to connect using the following information which is provided to me;

Server: xxx.xxx.xx.xx

Port : xxxx

Instance : ORCL

User: myusername

Pwd : mypwd

When I connect to the DB using PowerBI, my server name is: server/instance, in combination with the uid and pwd the connection than works fine.

The closest I (think I) got, was using the 'odbcDriverConnect()' function. First I ran the following command to check which drivers are installed;

sort(unique(odbcListDrivers()[[1]]))

which gave as output

"Oracle in OraClient12Home1" "Oracle in OraClient12Home2" "SQL Server"

Other topics here on stackoverflow, suggested the following site to check which string to use in the function:

https://www.connectionstrings.com/oracle/

I couldn't find a specific one for my listed drivers, but I altered the one for the Oracle in OraClient11g_home1 since it seemed to be the best match, this string is as follows;

Driver={Oracle in OraClient11g_home1};Server=serverSID;Uid=myUsername; Pwd=myPassword;

So I replaced the Oracle in OraClient11g_home1 with my drivers, they all gave another error;