No suitable driver found

[toddwarrington]

I keep getting this error "Error running static method java.sql.SQLException: No suitable driver found for jdbc:as400:..." when I deploy my flow using this jdbc node. Can you please give me some insight as to where I need to put the .jar file for my driver?

[kazuhitoyokoi]

Thank you for using our JDBC node. You need to put the jar file on the current directory and execute the Node-RED command from the current directory.

[toddwarrington]

K, I manually started node-red from the directory that contains the jar file and the error is still the same. Here’s the complete log file information: 16 Mar 11:08:27 - [error] [jdbc:database] Error: Error running static method java.sql.SQLException: No suitable driver found for jdbc:as400://10.10.0.7/ at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at Object.getConnectionSync (/home/installer/.node-red/node_modules/jdbc/lib/drivermanager.js:76:38) at addConnectionSync (/home/installer/.node-red/node_modules/jdbc/lib/pool.js:50:17) at JDBC.Pool.reserve (/home/installer/.node-red/node_modules/jdbc/lib/pool.js:192:14) at Function node setup:ddab20e1673dc436 [database]:29:4 at Function node setup:ddab20e1673dc436 [database]:40:23 at Script.runInContext (vm.js:144:12) at ***@***.******@***.***/nodes/core/function/10-function.js:392:41> Suggestions? From: Kazuhito Yokoi ***@***.***> Sent: Wednesday, March 16, 2022 6:47 AM To: Hitachi/node-red-contrib-jdbc ***@***.***> Cc: Todd Warrington ***@***.***>; Author ***@***.***> Subject: Re: [Hitachi/node-red-contrib-jdbc] No suitable driver found (Issue #5) Thank you for using our JDBC node. You need to put the jar file on the current directory and execute the Node-RED command from the current directory. — Reply to this email directly, view it on GitHub [github.com], or unsubscribe [github.com] ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. ZjQcmQRYFpfptBannerEnd Thank you for using our JDBC node. You need to put the jar file on the current directory and execute the Node-RED command from the current directory. — Reply to this email directly, view it on GitHub [github.com]<https://urldefense.com/v3/__https:/github.com/Hitachi/node-red-contrib-jdbc/issues/5*issuecomment-1069039459__;Iw!!HMLeYTom!R_5R9a86Us5sL0cOfbJPs_f_5tPAMD5_qLkhpJZ9xYFAKs9yobMQcnqZ_WTskC9rawFd$>, or unsubscribe [github.com]<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AOYTMRNIZTMMU5DNAN3JNODVAHC3PANCNFSM5Q2OQ6TA__;!!HMLeYTom!R_5R9a86Us5sL0cOfbJPs_f_5tPAMD5_qLkhpJZ9xYFAKs9yobMQcnqZ_WTskI_BBsH4$>. Triage notifications on the go with GitHub Mobile for iOS [apps.apple.com]<https://urldefense.com/v3/__https:/apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675__;!!HMLeYTom!R_5R9a86Us5sL0cOfbJPs_f_5tPAMD5_qLkhpJZ9xYFAKs9yobMQcnqZ_WTskPjEN9aY$> or Android [play.google.com]<https://urldefense.com/v3/__https:/play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign*3Dnotification-email*26utm_medium*3Demail*26utm_source*3Dgithub__;JSUlJSU!!HMLeYTom!R_5R9a86Us5sL0cOfbJPs_f_5tPAMD5_qLkhpJZ9xYFAKs9yobMQcnqZ_WTskPPT9dSI$>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>