jdbc connector for AS400

[bigdata....@gmail.com]

Hi,

I am trying to connect AS400 database using kafka jdbc connector. But getting below issue

Invalid value java.sql.SQLException: No suitable driver found for  jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to jdbc:as400://***.***.***.***/*****

Invalid value java.sql.SQLException: No suitable driver found for jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to  jdbc:as400://***.***.***.***/*****

You can also find the above list of errors at the endpoint `/{connectorType}/config/validate`

        at org.apache.kafka.connect.util.ConvertingFutureCallback.result(ConvertingFutureCallback.java:80)

        at org.apache.kafka.connect.util.ConvertingFutureCallback.get(ConvertingFutureCallback.java:67)

        at org.apache.kafka.connect.cli.ConnectStandalone.main(ConnectStandalone.java:96)

Caused by: org.apache.kafka.connect.runtime.rest.errors.BadRequestException: Connector configuration is invalid and contains the following 2 error(s):

Invalid value java.sql.SQLException: No suitable driver found for  jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to  jdbc:as400://***.***.***.***/*****

Invalid value java.sql.SQLException: No suitable driver found for  jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to  jdbc:as400://***.***.***.***/*****

You can also find the above list of errors at the endpoint `/{connectorType}/config/validate`

        at org.apache.kafka.connect.runtime.AbstractHerder.maybeAddConfigErrors(AbstractHerder.java:365)

        at org.apache.kafka.connect.runtime.standalone.StandaloneHerder.putConnectorConfig(StandaloneHerder.java:158)

        at org.apache.kafka.connect.cli.ConnectStandalone.main(ConnectStandalone.java:93)

I have added jt400-6.1.jar jar in my classpath. Still am getting this issue. Please help.

Thanks,
Arkaprova

[Ewen Cheslack-Postava]

I haven't ever tried running the connector against AS400, but this seems to suggest you might need to change the format of the URL to use : instead of / between the host & database: https://community.oracle.com/thread/2561243

-Ewen

--
You received this message because you are subscribed to the Google Groups "Confluent Platform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to confluent-platform+unsub...@googlegroups.com.
To post to this group, send email to confluent-platform@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/confluent-platform/53750869-63b2-45a3-bd68-6f2a9548d8f2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Vincent]

Hi Arkaprova, 

Did you get this working ? I am facing the similar error and looking for the advises if get that up and running. 

[Alf Baez]

You must have jt400.jar in your classpath for the AS/400 JDBC driver to work.

Version 7.10 is in Maven or download the latest from https://sourceforge.net/projects/jt400/ or copy it from IFS. The native CC driver is only used when running locally on the AS/400.

You should only have jt400.jar in your classpath. Remove the other ones listed in the question, as they - if I recall correctly - want to use non-Java code you most likely do not have installed

--

You received this message because you are subscribed to the Google Groups "Confluent Platform" group.

To unsubscribe from this group and stop receiving emails from it, send an email to confluent-platf...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/confluent-platform/d42fbcfd-94a5-46c2-9a02-15d48ebccd00o%40googlegroups.com.

[Vincent]

Hi Alf baez, 

I have only jt400.jar in classpath. It still complains about "No Suitable Driver Found".. 

We have Kafka-connect running on Linux RHEL -7 and jt400.jar in ../../kafka-connect-jdbc/ folder. 

We are trying to connect DB2 running on IBM i series running remotely.. 

Correct me if I am doing anything wrong..

Thanks in advance!

On Wednesday, 10 June 2020 14:55:20 UTC-7, Alf Baez wrote:

You must have jt400.jar in your classpath for the AS/400 JDBC driver to work.

Version 7.10 is in Maven or download the latest from https://sourceforge.net/projects/jt400/ or copy it from IFS. The native CC driver is only used when running locally on the AS/400.

You should only have jt400.jar in your classpath. Remove the other ones listed in the question, as they - if I recall correctly - want to use non-Java code you most likely do not have installed

On Tue, Jun 9, 2020 at 9:31 PM Vincent <nirmal....@gmail.com> wrote:

Hi Arkaprova, 

Did you get this working ? I am facing the similar error and looking for the advises if get that up and running. 

On Friday, 12 May 2017 06:08:50 UTC-7, bigdata....@gmail.com wrote:

Hi,

I am trying to connect AS400 database using kafka jdbc connector. But getting below issue

Invalid value java.sql.SQLException: No suitable driver found for  jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to jdbc:as400://***.***.***.***/*****

Invalid value java.sql.SQLException: No suitable driver found for jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to  jdbc:as400://***.***.***.***/*****

You can also find the above list of errors at the endpoint `/{connectorType}/config/validate`

        at org.apache.kafka.connect.util.ConvertingFutureCallback.result(ConvertingFutureCallback.java:80)

        at org.apache.kafka.connect.util.ConvertingFutureCallback.get(ConvertingFutureCallback.java:67)

        at org.apache.kafka.connect.cli.ConnectStandalone.main(ConnectStandalone.java:96)

Caused by: org.apache.kafka.connect.runtime.rest.errors.BadRequestException: Connector configuration is invalid and contains the following 2 error(s):

Invalid value java.sql.SQLException: No suitable driver found for  jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to  jdbc:as400://***.***.***.***/*****

Invalid value java.sql.SQLException: No suitable driver found for  jdbc:as400://***.***.***.***/***** for configuration Couldn't open connection to  jdbc:as400://***.***.***.***/*****

You can also find the above list of errors at the endpoint `/{connectorType}/config/validate`

        at org.apache.kafka.connect.runtime.AbstractHerder.maybeAddConfigErrors(AbstractHerder.java:365)

        at org.apache.kafka.connect.runtime.standalone.StandaloneHerder.putConnectorConfig(StandaloneHerder.java:158)

        at org.apache.kafka.connect.cli.ConnectStandalone.main(ConnectStandalone.java:93)

I have added jt400-6.1.jar jar in my classpath. Still am getting this issue. Please help.

Thanks,
Arkaprova

--
You received this message because you are subscribed to the Google Groups "Confluent Platform" group.

To unsubscribe from this group and stop receiving emails from it, send an email to confluent-platform+unsub...@googlegroups.com.

[Vincent]

We are able to solve this issue. 

Please download the jt400.jar from JTOpen download page and use jt400.jar which is inside ../lib/java8/jt400.jar