| Author |
Message
|
| MQWays |
 Posted: Thu Apr 03, 2008 10:40 pm Post subject: ESQL Database access failure on Database Node |
 |
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
I am trying out the Bookstore scenario using ESQL example given in redbooks WebSphere Mesage Broker Basics pg 79. The ESQL is returning error on the insert command in database node i.e.
INSERT INTO Database.CUSTACCTB .......
Error: Unresovlable Database Table Reference
Would you know the reason for this error. Is a mapping node required to insert rows into the database by way of 'Database Node'. |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Thu Apr 03, 2008 10:44 pm Post subject: Re: ESQL Database access failure on Database Node |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| MQWays wrote: |
INSERT INTO Database.CUSTACCTB .......
Error: Unresovlable Database Table Reference
|
 
Broker wont create table, so create the table and try out once
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| MQWays |
| Posted: Thu Apr 03, 2008 11:01 pm Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
| Well, the database and table has already been created. Table is visible on 'mqsi list tables'. That's part of the sql script provided in the redbook and run via db2 -vf <script>. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Apr 03, 2008 11:20 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
|
| Back to top |
|
|
| MQWays |
| Posted: Fri Apr 04, 2008 1:11 am Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
I will check that.
By the way, don't really like excessive and absurd use of emoticons in the reply.
Thanks. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Fri Apr 04, 2008 1:17 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| MQWays wrote: |
By the way, don't really like excessive and absurd use of emoticons in the reply.
|
Really Sorry, if its hurt you,
Take it in a sportive way, 
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
|
|
