java - RJDBC Connection to Amazon Redshift in R -


i tried create jdbc connection amazon redshift in r. following instruction under https://aws.amazon.com/blogs/big-data/connecting-r-with-amazon-redshift/, created following:

driver <- jdbc("com.amazon.redshift.jdbc42.driver", "redshiftjdbc42-1.2.1.1001.jar", identifier.quote="`")  url <- "jdbc:redshift://xxxxxx.us-east-1.redshift.amazonaws.com :5439/user=xxx&password=xxx"  conn <- dbconnect(driver, url)

everything works except last row gave me error message of following:

error in .jcall(drv@jdrv, "ljava/sql/connection;", "connect", as.character(url)[1], : java.sql.sqlnontransientconnectionexception: error message not found: connection_refused. can't find bundle base name com.amazon.dsi.core.impl.jdbcmessages, locale en

any thoughts?

i had error got working. things did included :

  1. used .jclassloader()$setdebug(1l) full debug info of jar
    load - showed path checking
  2. downloaded latest jar amazon s3 (manually not r)
  3. moved latest jar path being checked in a)
  4. used real redshift instance being used team credentials

voila worked !


Comments

Post a Comment

Popular posts from this blog

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

javascript - pass values from mssql to views in node -

being new node js , javascript . have been trying find solution problem . this app.js file var express=require ('express'); var bodyparser = require('body-parser'); var path = require ('path'); var sql = require('mssql'); var app = express(); const config = { user: 'sa', password: 'password', server: 'localhost\\sqlexpress', // can use 'localhost\\instance' connect named instance database: 'pcgdb', options: { encrypt: false // use if you're on windows azure } }; const request = new sql.request() //view engine app.set('view engine', 'ejs'); app.set('views', path.join(__dirname, 'views')) app.use(bodyparser.json()); app.use(bodyparser.urlencoded({extended: false})); app.get('/',function(req,res){ res.render('index') }); app.get('/new_project', function(req, res) { function(data,err){ ...
Read more

image - python get coordinates (pixels) of corresponding points from clicks -

this question has answer here: store mouse click event coordinates matplotlib 2 answers detecting mouse event in image matplotlib 2 answers determine button clicked subplot in matplotlib 2 answers i have 2 images want following using python 3.6 1- plot both images side side 2- click on 1 image , output corresponding pixel coordinates 3- click on second image , corresponding pixel coordinates note: question different because has work on 2 images finding axis click event happening. i think best way have function identifies axis clicking on , gets clicked coordinates. couldn't find of resources 2 images, found on 1 image.
Read more