| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [TeraJDBC 13.10.00.10] [Error 8017] [SQLState 28000] |
« View previous topic :: View next topic » |
| Author |
Message
|
| akidase |
 Posted: Mon Nov 12, 2012 11:22 am Post subject: [TeraJDBC 13.10.00.10] [Error 8017] [SQLState 28000] |
 |
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
Error faced:
| Quote: |
| [Teradata Database] [TeraJDBC 13.10.00.10] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid. |
| Code: |
| C:\Program Files\IBM\MQSI\7.0>mqsireportproperties MB7BROKER -c JDBCProviders -o Teradata -r |
| Code: |
JDBCProviders
Teradata
connectionUrlFormat='jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=[portNumber],TMODE=ANSI,ACCOUNT=[user]'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='default_Database_Name'
databaseType='Teradata'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='default_none'
jarsURL='<JDBC DRIVER INSTALL DIRECTORY>\lib'
maxConnectionPoolSize='0'
portNumber='1025'
securityIdentity='default_User@default_Server'
serverName='default_Database_Server_Name'
type4DatasourceClassName='com.teradata.jdbc.TeraDataSource'
type4DriverClassName='com.teradata.jdbc.TeraDriver'
BIP8071I: Successful command completion.
|
| Code: |
mqsichangeproperties MB7BROKER -c JDBCProviders -o TERAJDBC -n " \"connectionUrlFormat\", \"connectionUrlFormatAttr1\", \"connectionUrlFormatAttr2\", \"connectionUrlFormatAttr3\", \"connectionUrlFormatAttr4\", \"connectionUrlFormatAttr5\", \"databaseName\", \"databaseType\", \"databaseVersion\", \"description\", \"environmentParms\", \"jarsURL\", \"maxConnectionPoolSize\", \"portNumber\", \"securityIdentity\", \"serverName\", \"type4DatasourceClassName\", \"type4DriverClassName\" " -v " \"jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=[portNumber],TMODE=ANSI,,ACCOUNT=[user]\", \"\", \"\", \"\", \"\", \"\", \"DDWV01\", \"Teradata\", \"12\", \"Teradata Database1\", \"default_none\", \"C:\apps\TeraData\", \"0\", \"1025\", \"jdbcTdSecIden\", \"system.host.com\", \"com.teradata.jdbc.TeraDataSource\", \"com.teradata.jdbc.TeraDriver\" "
|
There is no option to pass "user" value. How do we specify that ? Can someone help , with this Teradata connection setup?
[/code]
Last edited by akidase on Thu Nov 15, 2012 9:16 am; edited 1 time in total |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon Nov 12, 2012 11:25 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| akidase |
| Posted: Wed Nov 14, 2012 7:04 am Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
We have used mqsisetdbparms to set the UserId and Password.
I am not sure on how to specify the 'Account' user.
| Code: |
mqsisetdbparms MB7BROKER -n jdbc::jdbcTdSecIden -u UserId-p Password |
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Nov 14, 2012 10:13 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Quote: |
JDBCProviders
Teradata
connectionUrlFormat='jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=
|
Isn't this the old problem of modifying this when it must not be because this is a format pattern?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| akidase |
| Posted: Thu Nov 15, 2012 9:06 am Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
I have tried to get type4jdbc database connection - with Broker runtime at 7.0.0.3 and failed. It seems to have been fixed in 7.0.0.3 as per the below , however it didn't work.
| Quote: |
| http://www-01.ibm.com/support/docview.wss?uid=swg1IC72526 |
For the [user] in the connection url, I hardcoded the account name, as per Teradata requirement, while changing the configurable service.
-------------------------------------------------------------------------------------
I am able to get normal JDBC - java.sql.Connection - specifying the details as per the Connection URL
| Code: |
| connectionUrlFormat='jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=[portNumber],TMODE=ANSI,ACCOUNT=[user]' |
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Nov 15, 2012 10:07 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
The
| Quote: |
connectionUrlFormat='jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=[portNumber],TMODE=ANSI,ACCOUNT=[user]'
|
Is wrong. Please restore it to its original value. This is a FORMAT PATTERN.
And MUST not be edited.
If you doubt me then simply do a search on this forum for 'connectionUrlFormat'. you will see many other posts like yours and where thet OP has modified this item.
I did suggest this yeaterday 
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| akidase |
| Posted: Fri Nov 16, 2012 1:12 pm Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
| Quote: |
| jdbc:teradata://server.com/DATABASE=Databasename,DBS_PORT=1025 |
fetching me a connection with Normal JDBC , however I am unable to obtain getJDBCType4Connection with the same URL.
results in Error
| Quote: |
| Single Sign-On NOT supported for Mechanism TD2., SQLState value: HY000, vendor's error code: 1032 |
getJDBCType4Connection doesn't work with any of the URL pattern.
If account name is not specified, I get an error
| Quote: |
| ERROR: Teradata connection: The UserId, Password or Account is invalid. |
If account name is hardcoded in the mqsicreateconfigurable service, I get an error
| Quote: |
| Single Sign-On NOT supported for Mechanism TD2., SQLState value: HY000, vendor's error code: 1032 |
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
