| Author |
Message
|
| sanketpatel |
 Posted: Tue Oct 31, 2006 11:33 pm Post subject: Database Insert Node |
 |
|
Apprentice
Joined: 31 Oct 2006
Posts: 40
|
Hi,
While inserting a record in a database i am getting this error...
( BROKER.default ) Database error: SQL State ''08004''; Native Error Code '12154'; Error Text ''[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name ''.
The error has the following diagnostic information: SQL State ''08004'' SQL Native Error Code '12154' SQL Error Text ''[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name ''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
pls help...
TNS is working fine...
Using 'sys' user to create RDB def file... |
|
| Back to top |
|
 |
| jbanoop |
| Posted: Tue Oct 31, 2006 11:35 pm Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
| did u create the dsn and add it on the broker using mqsisetdbparms ? |
|
| Back to top |
|
|
| sanketpatel |
| Posted: Tue Oct 31, 2006 11:51 pm Post subject: |
|
|
Apprentice
Joined: 31 Oct 2006
Posts: 40
|
thanks jbannop...
i have created the DSN but how to add it on broker ?
i will try this command .....mqsisetdbparms... |
|
| Back to top |
|
|
| jbanoop |
| Posted: Wed Nov 01, 2006 12:13 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
u should seriously think of reading up atleast the basics of creating message flows on MB before u venture into developing..
If u want to keep trying without reading the docs, better go and search the documentation when u are stuck instead of posting basic questions.. u will look very silly... |
|
| Back to top |
|
|
| sanketpatel |
| Posted: Wed Nov 01, 2006 12:24 am Post subject: |
|
|
Apprentice
Joined: 31 Oct 2006
Posts: 40
|
Anoop Joseph
just one thing i would like to write is
'thing with wich look simpl for you does not mean its simple for all'
this is my 3rd day on message broker and what i know on 3rd day is much better than any beginer knows on 3rd day...
any ways thanks for the help.....
I got the pdf to read on....... |
|
| Back to top |
|
|
| jbanoop |
| Posted: Wed Nov 01, 2006 12:48 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
exactly my point.. you should know better than to just go developing on the 3rd day even before you know the basics of wht is supposed to be a pretty complex EAI product..
I am pretty sure the search on this site would give you enough answers for the first 2 months of ur message broker experince, to go on without askig NEW questions..
keep posting such kind of questions and u would be hearing from a lot more ppl 
anyways best of luck |
|
| Back to top |
|
|
| sanketpatel |
| Posted: Wed Nov 01, 2006 12:51 am Post subject: |
|
|
Apprentice
Joined: 31 Oct 2006
Posts: 40
|
hey its working fine with db2 without setting dbparams...
then why it is not working for oracle? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 01, 2006 2:47 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
We don't know why it's not working with Oracle. You haven't remotely told us any information that we could use to make even a guess.
On the other hand, we do know what mqsisetdbparms is used for, and you don't seem to.
The Broker Information Center has tons of helpful stuff, particularly specific reference information on this command and many many pages of specific information on connecting to and using databases from Broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mgk |
| Posted: Wed Nov 01, 2006 3:31 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
You are using the wrong ODBC driver. You must use the DataDirect Oracle ODBC driver that comes with Message Broker.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| sanketpatel |
| Posted: Wed Nov 01, 2006 3:52 am Post subject: |
|
|
Apprentice
Joined: 31 Oct 2006
Posts: 40
|
this is the error
( BROKER.default ) Database error: SQL State ''08004''; Native Error Code '12154'; Error Text ''[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name ''.
The error has the following diagnostic information: SQL State ''08004'' SQL Native Error Code '12154' SQL Error Text ''[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name ''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
I am using oracle 8i.
Do i have update oracle drivers? |
|
| Back to top |
|
|
| mgk |
| Posted: Wed Nov 01, 2006 3:55 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
| Quote: |
| Do i have update oracle drivers? |
No, you have to use the right driver as I said above.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 01, 2006 4:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What version of WMB are you using?
Is Oracle 8 a supported database for that version? I'm pretty sure it's not supported for v6.
You will also probably need to check the "Enable SQLDescribeParams" option on the data source. Of course that's only available for the correct driver.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sanketpatel |
| Posted: Wed Nov 01, 2006 4:57 am Post subject: |
|
|
Apprentice
Joined: 31 Oct 2006
Posts: 40
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 01, 2006 5:18 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Well, Oracle 8 works for v6, but it's not supported.
Regardless, it's not your actual problem. Your actual problem is that you're using the wrong ODBC drivers.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sanketpatel |
| Posted: Wed Nov 01, 2006 5:30 am Post subject: |
|
|
Apprentice
Joined: 31 Oct 2006
Posts: 40
|
but when ever i am doing test on connection it shows its successful.
I am using mqseries datadirect tech 5.0 32bit oracle driver for DSN
and in wmb for jdbc driver i am using 'oracle thin jdbc driver'... which also shows the successful test connection.
Where i am doing wrong?
pls help.... |
|
| Back to top |
|
|
|
|
