pentaho set up to AWS Aurora ( mysql ) bastion

170
March 07, 2019, at 3:00 PM

I am trying to setup pentaho spoon to connect to AWS auora which on a vpn in AWS. I have access to AWS auora ( mysql ) through a bastion server. It is working with mysql workbench and a simple java program. Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/estimates", "root", "xxxxxxx"); Statement stmt = conn.createStatement(); String strSelect = "select first from test_name";

        ResultSet rset = stmt.executeQuery(strSelect);
        int rowCount = 0;
        while (rset.next()) {  
            String first = rset.getString("first");
            System.out.println(first);
            ++rowCount;
        }

with pentaho this error. Error connecting to database [t1] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database

Exception while loading class org.gjt.mm.mysql.Driver

org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database

Exception while loading class org.gjt.mm.mysql.Driver

at org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
at org.pentaho.di.core.database.Database.connect(Database.java:315)
at org.pentaho.di.core.database.Database.connect(Database.java:277)
at org.pentaho.di.core.database.Database.connect(Database.java:267)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)

I have loaded the jdbc driver in the ..\data-integration\lib.

What could I be missing ? or is it a problem with this version of pentaho 4.4.0-stable ? Any clues would be helpful. I am new to java pentaho.. Many thanks in advanced

Answer 1

I used an older jdbc driver aand it worked with this version of pentaho

https://downloads.mysql.com/archives/c-j/

Rent Charter Buses Company
READ ALSO
Different order of argument for LIKE changes result

Different order of argument for LIKE changes result

I have very strange situation in MySQL (MariaDB)I have a query with:

170
PhpStorm - How to connect to MySQL via Docker

PhpStorm - How to connect to MySQL via Docker

I am working with PhpStorm 20183

226
writing values to a text file, reading it and displaying in db

writing values to a text file, reading it and displaying in db

I have to write some values say some numbers to a text file, read those values from the text file and then make a db connection, to display those values read from the file in javahow can i do that?

180
Script for upload multi images: the first image change the extension of the others

Script for upload multi images: the first image change the extension of the others

i've this script for upload multi imagesIf i upload at the same time, the same type of images, for example, all jpg, gif or png it works well, but if i upload a mix of images types (mix of jpg, gif, png), into the DB i have all images with the same extensions

126