Hi

Welcome to Talend Community!

In fact, I'm facing the same issue.
I have a schema called "ABC" in SQL SERVER.
When I try to retrieve schema from ABC, it shows "Pending" and never stop.

However, if the schema is dbo, the retrieving works fine.

Please report it on BugTracker.

Regards,
Pedro

Hi Pedro

I found that on the web :

"In MS SQL
- Create a user
- Create a role
- Add your user to the role created
- Add your user to the db_owner role
- Go to the properties of your schema
- Add the role that you created
- Selection can be made in the matrix of the different bottom right SELECT
You can now access your database schema through talend specifying the component's info (USER, PWD, SCHEMA, etc ...)"

Do you think that can resolve our problem ?

Did you have an answer about your own ticket in the Talend bug tracker ?
Could you give me the link to follow it ?

Thx

Hi

Somebody know if v5.1.0 has the same problem ?

Thx

Hi

Thanks for your feedback.
Hope this bug would be fixed soon.

Regards,
Pedro

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"

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?

Hi

Yes, it's worst....

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

Regards

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.

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

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--------

Hi

This problem is resolved in v5.0.3.

Regards

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