You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-05-11 18:07:04

bluehrmann
Member
2 posts

bluehrmann said:

Can Talend write to an Azure SQL Server Database

I'm running 6.1... I'm able to create and successfully confirm as connection with an Azure SQL Server, but I'm not able to write to it. Is Azure SQL Server not supported yet. I cannot find much information on this site with the word "Azure" in it.

Offline

#3 2016-05-12 18:34:41

bluehrmann
Member
2 posts

bluehrmann said:

Re: Can Talend write to an Azure SQL Server Database

@talendtester I'm not writing to a Microsoft Azure Storage container but an Azure SQL Server database. I haven't found any documentation that shows how to do that. My approach has been as follows
1) In the"Tree" I clicked on Metadata and then right clicked on Db Connections and clicked on create connections.
2) In entered in all the appropriate information and then Clicked "Check" THIS WAS Successful. 
3) So assuming the connection is good, I put a tMSSqlOutput in my workflow and tried to run it. Nothing is ever written to the database and I get the following errors. I'm fairly weak with Java so I'm not sure what the following means.
I/O Error: Connection reset by peer: socket write error
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
    at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
    at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
    at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
    at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:966)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.close(JtdsPreparedStatement.java:707)
    at beginnersguide.uscensusshipments_0_1.USCensusShipments.tFileInputExcel_2Process(USCensusShipments.java:3573)
    at beginnersguide.uscensusshipments_0_1.USCensusShipments.tFileFetch_2Process(USCensusShipments.java:523)
    at beginnersguide.uscensusshipments_0_1.USCensusShipments.runJobInTOS(USCensusShipments.java:3923)
    at beginnersguide.uscensusshipments_0_1.USCensusShipments.main(USCensusShipments.java:3780)

Offline

#4 2016-05-20 20:31:35

kotyara
Member
9 posts

kotyara said:

Re: Can Talend write to an Azure SQL Server Database

Same for me.
On Windows 10 and TOS DI 6.1.1

Connection to Azure SQL works in design-time but failing during runtime:

I/O Error: Connection reset by peer: socket write error
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
	at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
	at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
	at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1030)
	at adwh.gen_0_1.gen.tRowGenerator_1Process(gen.java:837)
	at adwh.gen_0_1.gen.runJobInTOS(gen.java:1221)
	at adwh.gen_0_1.gen.main(gen.java:1078)

Last edited by kotyara (2016-05-20 20:32:42)

Offline

#5 2017-04-06 10:10:00

vmugue
Member
1 post

vmugue said:

Re: Can Talend write to an Azure SQL Server Database

Hey guys, 
I stucked with exactly same problem.
Has anybody solved it?

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy