topic Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2 in Talend Studio

[resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Tue, 08 May 2012 23:08:15 GMT

Hello
This is my first post here so sorry if I'm not using best practices.
This is my problem:
I have a SQL Server 2008 R2 hosted on a Windows Server 2003 64 bit.
On this database I created two schemes and dedicated users/connections owners of these schemes in SQL Server authentication.
I attack these schemes since Talend V5.0.2 deployed on a desktop Windows XP 32-bit.
No problem to create connections "MS SQL Server" (jtds).
But when I try to retrieve schemes of my tables, Talend tell me "waiting" indefinitely.
I tried everything in terms of rights on my users (sysadmin, dbowner etc.) but nothing changes.
It happens the same thing if I use the "sa" user.
In fact, what I do, the only schemes I can retrieve my tables schemes are dbo and sys. I can not retrieve the tables schemes from other database schemes.
Odbc connection is worst, I can not recover tables schemes at all.
Does anyone here have a solution and / or the same problem?
Thank you for your answers, and please come back to me if you need additional information.
Rergards

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

Anonymous — Wed, 09 May 2012 04:09:57 GMT

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

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Wed, 09 May 2012 07:10:54 GMT

Done here :
http://jira.talendforge.org/browse/TDI-21056
Thx Pedro

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Thu, 10 May 2012 02:52:31 GMT

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

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

Anonymous — Thu, 10 May 2012 10:35:19 GMT

You can now access your database schema through talend specifying the component's info (USER, PWD, SCHEMA, etc ...)"

Yes. You can configure the MSSQL components manually to access tables from other schema.
I have thought you knowed this and just wanted to report the 'pending' bug.
Regards,
Pedro

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Wed, 23 May 2012 08:37:19 GMT

Hi
Somebody know if v5.1.0 has the same problem ?
Thx

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Sun, 27 May 2012 03:06:59 GMT

Hi
For information the problem is the same with Talend v5.1.0 and Java 7.
Regards

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

Anonymous — Mon, 28 May 2012 02:31:38 GMT

Hi
Thanks for your feedback.
Hope this bug would be fixed soon.
Regards,
Pedro

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Mon, 28 May 2012 05:18:46 GMT

Hi
Normaly it will be fixed in v5.1.1
You can look here :
http://jira.talendforge.org/browse/TDI-20393
Regards

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Sat, 02 Jun 2012 07:02:51 GMT

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"

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

Anonymous — Mon, 04 Jun 2012 02:26:18 GMT

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

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

_AnonymousUser — Tue, 05 Jun 2012 14:42:29 GMT

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?

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

Anonymous — Wed, 06 Jun 2012 16:30:28 GMT

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

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Wed, 06 Jun 2012 22:47:09 GMT

Hi
Yes, it's worst....
You can see here : http://jira.talendforge.org/browse/TDI-21382
Regards

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Fri, 22 Jun 2012 01:41:26 GMT

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

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

_AnonymousUser — Mon, 25 Jun 2012 06:40:20 GMT

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.

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

cwaras — Mon, 02 Jul 2012 07:05:07 GMT

The problem seems solved in v5.0.3.
Thank you.

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

_AnonymousUser — Fri, 10 Aug 2012 11:10:08 GMT

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

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

janhess — Fri, 10 Aug 2012 13:15:57 GMT

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

Re: [resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

Anonymous — Wed, 22 Aug 2012 15:56:54 GMT

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)
disconnected
I am using this components

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