topic Re: HOW I Can import JSON Fille and load it in table sql server in Talend Studio

HOW I Can import JSON Fille and load it in table sql server

Anonymous — Sat, 16 Nov 2024 05:48:14 GMT

I need some help in resolving below issue ; i'm new to talend .My requirement is to reqd input Json and convert it into table sql server , i want to load key column as a separate column so that i can search easily based on key.

I had a requirement where i need to take data from json file and load it in table (sql server).I join the photo of my job
can anyone please help me

I am using "Talend open studio for data integration version 7.1.1.2018102681147

Thank you very much for your time and help

Re: HOW I Can import JSON Fille and load it in table sql server

bhagyarekha — Fri, 17 May 2019 13:27:08 GMT

can you elaborate your issue where you are getting struck?

it would be better if you provide us with examples

Regards

rekha

Re: HOW I Can import JSON Fille and load it in table sql server

Anonymous — Fri, 17 May 2019 13:27:49 GMT

You seem to be going in the right direction. What is not working? What is the tMap at the beginning for? It splits the flows, why does it do this?

Re: HOW I Can import JSON Fille and load it in table sql server

Anonymous — Fri, 17 May 2019 13:55:21 GMT

my issue is : Database connection is failed.
java.lang.RuntimeException: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:204)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1139)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(DbTableController.java:769)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$6.run(DbTableController.java:558)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
... 6 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
... 11 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:173)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
... 14 more

Regards

Re: HOW I Can import JSON Fille and load it in table sql server

Anonymous — Fri, 17 May 2019 13:56:55 GMT

i join tmap schema

tmap.PNG

Re: HOW I Can import JSON Fille and load it in table sql server

Anonymous — Fri, 17 May 2019 14:09:15 GMT

also when I execute it goes up this error
unable to find or load the main class vulnmanager.test3_0_1.test3 vulnmanager is name my project et test3 is name my job

thanks you

finaleror.PNG

Re: HOW I Can import JSON Fille and load it in table sql server

Anonymous — Fri, 17 May 2019 15:22:55 GMT

Looks like database connection issue

I suggest :

1. you first make sure you are able to extract the information from the json file correctly. you can output using tlogrow

2. then you move to the next step: that is trying to insert the data in the database

Re: HOW I Can import JSON Fille and load it in table sql server

Anonymous — Fri, 17 May 2019 16:29:30 GMT

I agree with @dgm01 but would add that it is a good idea to test out your DB connection with a t{DB}Input component.

Re: HOW I Can import JSON Fille and load it in table sql server

Anonymous — Mon, 20 May 2019 13:22:36 GMT

thanks for attention; but i can't to extract the information from the json file correctly

How I would like the output to look like:

CVE	Scope	debainbug	description	status	fixed_version	urgency

I attach my jsonfille

regards

inputfille.docx