Author |
Message
|
pcelari |
Posted: Wed Apr 02, 2008 12:08 pm Post subject: customized table in broker DB keep getting cleared ? |
|
|
Chevalier
Joined: 31 Mar 2006 Posts: 411 Location: New York
|
I created a ROUTING_TABLE in the broker database for application use. But I noticed everytime I restarted the broker, the routing records I entered in the table are all gone?
Is this the expected behavior? and why?
 _________________ pcelari
-----------------------------------------
- a master of always being a newbie |
|
Back to top |
|
 |
bower5932 |
Posted: Wed Apr 02, 2008 12:49 pm Post subject: |
|
|
 Jedi Knight
Joined: 27 Aug 2001 Posts: 3023 Location: Dallas, TX, USA
|
I didn't think the broker license permitted the use of application data inside the broker database.
Regardless, how did you get the records into the table? If it is done by the broker through a message flow, is it possible that the records are never committed? |
|
Back to top |
|
 |
pcelari |
Posted: Wed Apr 02, 2008 12:54 pm Post subject: |
|
|
Chevalier
Joined: 31 Mar 2006 Posts: 411 Location: New York
|
I maually inser the routing information into the table. a message flow using the same mechanism as the routing example queries the records in the table at run time to route msg to destination queues stored in the table.
I'm testing with using a seperately created database for such utility purpose.
 _________________ pcelari
-----------------------------------------
- a master of always being a newbie |
|
Back to top |
|
 |
jefflowrey |
Posted: Wed Apr 02, 2008 12:57 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
The Broker license does not, afaik, allow any use of the DB2 installation for any user data.
Regardless of whether it's in the same database or not.
If you're using Derby instead of DB2, then this is likely the cause of your problem.
If you're not using Derby OR Db2, then it's not clear what's going on at all - but you're probably licensed for what you're trying to do. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
bower5932 |
Posted: Thu Apr 03, 2008 3:03 am Post subject: |
|
|
 Jedi Knight
Joined: 27 Aug 2001 Posts: 3023 Location: Dallas, TX, USA
|
jefflowrey wrote: |
If you're not using Derby OR Db2, then it's not clear what's going on at all - but you're probably licensed for what you're trying to do. |
Is there supposed to a not in the second part of this sentence? |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Apr 03, 2008 3:32 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
bower5932 wrote: |
jefflowrey wrote: |
If you're not using Derby OR Db2, then it's not clear what's going on at all - but you're probably licensed for what you're trying to do. |
Is there supposed to a not in the second part of this sentence? |
No.
If you're not using DB2, then you're not using the license for DB2 that comes with Broker, and has the restrictions.
You're, presumably, using some OTHER database - Oracle, SQLServer, etc - and are presumably licensed for it for all purposes. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
|