jimmybow commented on issue #5970: URL: https://github.com/apache/hop/issues/5970#issuecomment-3503917110
I upload the sample hop project in [https://drive.google.com/file/d/10qyyMhrVI8C19zPyoQcyvUwUg4egAIum/view?usp=drive_link](url) the sample project exec 1000 sql and when it exect 300~400 SQL, the error happen and then hop jvm connot connection to db forever > Error connecting to database [oracle] :org.apache.hop.core.exception.HopDatabaseException: > Error occurred while trying to connect to the database > > Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) > Listener refused the connection with the following error: > ORA-12519, TNS:no appropriate service handler found > > > > org.apache.hop.core.exception.HopDatabaseException: > Error occurred while trying to connect to the database > > Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) > Listener refused the connection with the following error: > ORA-12519, TNS:no appropriate service handler found > > > > at org.apache.hop.core.database.Database.normalConnect(Database.java:383) > at org.apache.hop.core.database.Database.connect(Database.java:314) > at org.apache.hop.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:49) > at org.apache.hop.core.database.DatabaseFactory.getConnectionTestResults(DatabaseFactory.java:74) > at org.apache.hop.core.database.DatabaseMeta.testConnectionSuccess(DatabaseMeta.java:2113) > at org.apache.hop.ui.core.database.DatabaseMetaEditor.testConnection(DatabaseMetaEditor.java:903) > at org.apache.hop.ui.core.database.DatabaseMetaEditor.test(DatabaseMetaEditor.java:766) > at org.apache.hop.ui.core.database.DatabaseMetaEditor.lambda$createButtonsForButtonBar$6(DatabaseMetaEditor.java:958) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91) > at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4321) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1208) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4119) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3707) > at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:486) > at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:364) > Caused by: org.apache.hop.core.exception.HopDatabaseException: > Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) > Listener refused the connection with the following error: > ORA-12519, TNS:no appropriate service handler found > > > at org.apache.hop.core.database.Database.connectUsingClass(Database.java:478) > at org.apache.hop.core.database.Database.normalConnect(Database.java:368) > ... 14 more > Caused by: java.sql.SQLException: Listener refused the connection with the following error: > ORA-12519, TNS:no appropriate service handler found > > at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854) > at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) > at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) > at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) > at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) > at org.apache.hop.core.database.DelegatingDriver.connect(DelegatingDriver.java:45) > at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:683) > at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:191) > at org.apache.hop.core.database.Database.connectUsingClass(Database.java:475) > ... 15 more > Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: > ORA-12519, TNS:no appropriate service handler found > > at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284) > at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340) > at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596) > at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588) > ... 23 more > > Hostname: 172.17.24.72 > Port: 1521 > Database name: ORCL > Url: jdbc:oracle:thin:@172.17.24.72:1521:ORCL -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
