All Forums Connectivity
14 Jan 2011
jdbc 3749 error

I am kind of stumped here maybe some one can help shed some light. I connect to the db with this connection string

URL += "://" + host + "/" + database+" /CHARSET=UTF8,COMPAT_DBS=true,DBS_PORT=" +port;

url is the jdbc:teradata

we have it as a variable because we are an etl tool and connect to diffrent dbms. I am currrently trying to add support for teradata. II can get a successful connection using that string but if i try to send a sql statement or use

else if (dbms.equals(TERADATA))
{
tableTypes = new String[] { "TABLE" };
RSet = dbmd.getTables(null, getSchema(), null, tableTypes);
}

to get a table list I get

[Teradata Database] [TeraJDBC 13.10.00.08] [Error 3749] [SQLState HY000] Options Parcel information is invalid. any suggestions""

tomnolan 594 posts Joined 01/08
17 Jan 2011

Which version of the Teradata Database are you using?

17 Jan 2011

5.0 is the demo version i had but i contacted teradata and have access to new versions I haven't installed them yet will post when i have.

tomnolan 594 posts Joined 01/08
18 Jan 2011

Teradata Database V2R5.0 is very old. You should use a newer demo version of the Teradata Database.

There is a known problem with V2R5.0 returning Error 3749 "Options Parcel information is invalid."

The problem exists in 05.00.00.20 through 05.00.00.22, and was fixed in 05.00.00.23.

The problem exists in 05.00.01.00 through 05.00.01.09, and was fixed in 05.00.01.10.

The problem exists in 05.00.02.00, and was fixed in 05.00.02.01.

The problem was fixed in 05.00.03.00.

You must sign in to leave a comment.