Insert into export_table values("1", "ExportedValue")
#Access denied for user 'ajitesh'@'localhost' (using password: yes) jdbc mac password
: : Access denied for user (using password: YES)Ĭaused by: : Access denied for user (using password N: : Access denied for user (using password: YES) : Access denied for user (using password: YES)Īt .createSQLException(SQLError.java:1073)Īt .checkErrorPacket(MysqlIO.java:3597)Īt .checkErrorPacket(MysqlIO.java:3529)Īt .checkErrorPacket(MysqlIO.java:935)Īt .secureAuth411(MysqlIO.java:4101)Īt .doHandshake(MysqlIO.java:1300)Īt .coreConnect(ConnectionImpl.java:2337)Īt .connectOneTryOnly(ConnectionImpl.java:2370)Īt .createNewIO(ConnectionImpl.java:2154)Īt .(ConnectionImpl.java:792)Īt 4Connection.(JDBC4Connection.java:49)Īt 0(Native Method)Īt (NativeConstructorAccessorIĪt (DelegatingConstructorAĪt .newInstance(Constructor.java:526)Īt .handleNewInstance(Util.java:411)Īt .getInstance(ConnectionImpl.java:381)Īt .connect(NonRegisteringDriver.java:305)Īt (DriverManager.java:571)Īt (DriverManager.java:215)Īt .SqlManager.makeConnection(SqlManager.java:885)Īt .GenericJdbcManager.getConnection(GenericJdbcManager.javĪt .CatalogQueryManager.listDatabases(CatalogQueryManager.jĪt .n(ListDatabasesTool.java:49)Īt .run(Sqoop.java:148)Īt .n(ToolRunner.java:70)Īt .runSqoop(Sqoop.java:184)Īt .runTool(Sqoop.java:226)Īt .runTool(Sqoop.java:235)Īt .main(Sqoop.java:244)ġ6/01/11 18:44:43 ERROR sqoop.Sqoop: Got exception running Sqoop: SLF4J: Actual binding is of type ġ6/01/11 18:44:43 ERROR manager.CatalogQueryManager: Failed to list databases SLF4J: Found binding in !/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Class path contains multiple SLF4J bindings. Please set $ACCUMULO_HOME to the root of your Accumulo installation.ġ6/01/11 18:44:42 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.2.0-2950ġ6/01/11 18:44:42 WARN tool.BaseSqoopTool: Setting your password on the command-line is insġ6/01/11 18:44:43 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. Can anyone advise? Warning: /usr/hdp/2.3.2.0-2950/accumulo does not exist! Accumulo imports will fail. Instead of a list of databases, I get the below output. I have then logged in to ssh () root within a terminal and type: sqoop list-databases -connect jdbc:mysql://127.0.0.1:xxxx -username root -password abcabcabc To get a working example of this - I have created a mySQL database (hostname=127.0.0.1 and port=xxxx) on my Mac. It's just that even though the data source bean is correct, the connection is established with random DB.I am trying to perform the following task: 'Import data from a table in a relational database into HDFS'. Note: I made sure that determineTargetDataSource in AbstractRoutingDataSOurce resolves to the right data source bean always. Exception: Could not open Hibernate Session for transaction nestedĮxception is : Cannot open PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host Now, when I make another request by setting readOnly = false, it throws this error: The anomaly is, when I make a request with readOnly = true ( tReadonlyDataSource(true)), it randomly goes to any of the databases - Master or Replica, even though AbstractRoutingDataSource resolves the right data source.
Now, I am calling the tReadonlyDataSource() based on some input parameter of my API. Then this MasterReplicaRoutingDataSource is injected into the sessionFactory. So, I created two data sources - Primary and Replica and created a MasterReplicaRoutingDataSource that extends AbstractRoutingDataSource. However, if I try to dynamically select a data source using - AbstractRoutingDataSource, I am seeing anomalies. Both database connections are working independently. I have an RDS Database and I have created an Aurora Read Replica on top of that RDS database.
0 kommentar(er)
