• Index
  •  » Usage, Operation
  •  » [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

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)

alevy
2012-09-10 03:41:27

5.0.3 was released after 5.1.1.  5.1.2 should be out in a week and contain the fix.

s33k3r
2012-09-04 18:26:16

The issue still exists in 5.1.1

cwaras
2012-08-30 23:01:33

Hi

This problem is resolved in v5.0.3.

Regards

s33k3r
2012-08-30 22:20:38

I can get the structures, but selecting a schema in MS SQL causes the same problem.. sits on pending indefinately.

RK-talend
2012-08-22 16:56:54

Hi all,
     
      I am new to talend,i am extracting 2 table(oracle) data using teltoracleinput components and load to the destination(Oracle).
      I created job & exicuted i am getting the following error.

       Any can help me............



Exception in component tELTOracleOutput_1
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at kranthi.job1_0_1.job1.tELTOracleMap_1Process(job1.java:347)
    at kranthi.job1_0_1.job1.runJobInTOS(job1.java:610)
    at kranthi.job1_0_1.job1.main(job1.java:478)
[statistics] disconnected

I am using this components


tELTOracleinput--------
                       TELTMAP -------- -- TELRORACLEOUTPUT                 
tELTORACLEINPUT--------

janhess
2012-08-10 14:15:57

I have had a similar problem related to permissions for sql server authentication.

Sakshi
2012-08-10 12:10:08

Hi,
I am using sql server 2008 for my database and when trying to retrieve its schema even with dbo as schema type i am unable to do so .It doesn't fetches the schema for any of the tables and remains in Pending state indefinitely.
I this forum i do see a bug but there it says it should atleast work with dbo schema

Please help

cwaras
2012-07-02 08:05:07

The problem seems solved in v5.0.3.

Thank you.

KO
2012-06-25 07:40:20

I had had the same problem.
This is just a workaround in my case , but I can now retrieve table structures from SQL Server 2008 R2 SP1 using v5.1.0 by un-checking "SYNONYM" on the first screen named "Filter for the Table." in "Retrieve Schema" wizard.

cwaras
2012-06-22 02:41:26

Hi

Normaly release date for v5.0.3 was yesterday (21/06/2012) but i see nothing....

Somebody know where i can find it ?

Thx

cwaras
2012-06-06 23:47:09

Hi

Yes, it's worst....

You can see here : http://jira.talendforge.org/browse/TDI-21382

Regards

skay
2012-06-06 17:30:28

I same problam observed :

With MS SQL Server and schema dbo (default) Talend is OK with connection + schema + table structure.

BUT

With a different schema than dbo and Talend v5.1.0, I got the schema, but not tables (pending state).

Now, on latest version 5.1.1r804309, I even no longer retrive schemas of the DB :

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

Sounds like worse than on v5.1.0 ?!

jw517
2012-06-05 15:42:29

I am experiencing the same ConnectionJDBC3 cast to ConnectionJDBC2 error in 5.1.1 on Win7 64bit.

cwaras - Can you kindly reopen bug TDI-20393?

pedro
2012-06-04 03:26:18

Hi

I notice you have made a new comment on TDI-20393.
You might reopen it if the bug exists.

Regards,
Pedro

cwaras
2012-06-02 08:02:51

Now in 5.1.1 connection is totally impossible...
When you check connection there is a message :

"Access to the data failur{0}
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"

Board footer

Powered by FluxBB