Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

janhess
2012-07-11 09:59:12

Ibram,
Start a new thread for this.

Ibran
2012-07-11 08:42:03

hi,

I Ibran now i am trying to run talend job from JAVA, I am successfully running the talend job from JAVA, but
can any one tell me how to pass parameter from java class to the talend this is very important in my project please help me out of it.

pedro
2012-07-03 09:02:59

Hi

I told you yesterday it seemed to be a bug...
But then you said it was OK and you fixed it...

If you still get this exception, please report it on BugTracker.
PS: Do not add the URL of this forum. Just describe the issue on BugTracker.

Regards,
Pedro

Ibran
2012-07-03 08:57:42

Ibran wrote:

Ibran wrote:

pedro wrote:

Hi

The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.

Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.

Regards,
Pedro

Hi,

thank you for your response now i am able to connect to the mssql from talend with General JDBC as a DB Type.
but when i changed the DB Type to Microsoft SQL Server i am getting this error can you help for this also,

Connection failure. You must change the Database Settings.
  java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2

Thank you.

please give me some suggestion for this above error.

Ibran
2012-07-02 10:18:19

pedro wrote:

Hi

The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.

Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.

Regards,
Pedro

Hi,

thank you for your response now i am able to connect to the mssql from talend with General JDBC as a DB Type.
but when i changed the DB Type to Microsoft SQL Server i am getting this error can you help for this also,

Connection failure. You must change the Database Settings.
  java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2

Thank you.

pedro
2012-07-02 09:47:24

Hi

The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.

Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.

Regards,
Pedro

Ibran
2012-07-02 09:40:36

pedro wrote:

Hi

Which version of TOS do you use?

Here is my SQL Server settings.

Regards,
Pedro

i have tried your settings now i am getting this error

Connection failure. You must change the Database Settings.
  java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2

Ibran
2012-07-02 09:30:55

pedro wrote:

Hi

Which version of TOS do you use?

Here is my SQL Server settings.

Regards,
Pedro

this is Microsoft SQL Server Settings, I want general JDBC Settings .
and i am using TOS 5.1.1 version.

pedro
2012-07-02 09:21:54

Hi

Which version of TOS do you use?

Here is my SQL Server settings.

Regards,
Pedro

Ibran
2012-07-02 09:16:44

pedro wrote:

Hi

The error indicates that some settings like host or port is not correct.
Or go to SQL Server Configuration Manager to see whether TCP/IP has started.

Regards,
Pedro

Thanks for your reply,
can you send me what should be the configuration in SQL Server.

pedro
2012-07-02 09:09:38

Hi

The error indicates that some settings like host or port is not correct.
Or go to SQL Server Configuration Manager to see whether TCP/IP has started.

Regards,
Pedro

Ibran
2012-07-02 09:06:04

pedro wrote:

Hi

Please show us the error info. Or upload a screen shot.

Regards,
Pedro

now i am connecting to the MsSql with general JDBC as DB Type
and i am getting this error now

Connection failure. You must change the Database Settings.
  com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host locahost, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

Ibran
2012-07-02 08:41:04

pedro wrote:

Hi

Please show us the error info. Or upload a screen shot.

Regards,
Pedro

hi,

i am getting this error
impossible to initialize the connection

pedro
2012-07-02 08:21:49

Hi

Please show us the error info. Or upload a screen shot.

Regards,
Pedro

Ibran
2012-07-02 08:20:38

pedro wrote:

Hi Ibran

Welcome to Talend Community!
Please create a new topic next time. smile

Did you encounter any issue about MSSQL connection?
We need more info.

Regards,
Pedro

Hi
I am new to this talend please tell me how to connect to the mssql from talend and
i am able to connect to the mysql but with mssql its giving error impossible to initialize the connection.

Board footer

Powered by FluxBB