| Author |
Message
|
| martinrydman |
 Posted: Sat Oct 28, 2006 8:14 am Post subject: Using Derby database from WMB messageflows |
 |
|
Centurion
Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
|
Hi,
I've successfully been able to:
1. Create a Derby Db and ODBC Data Connection
2. Create, populate, and query a table in this db using the Data perspective in the toolikit
3. Run a msgflow quering the table
However, it seems that 2 and 3 above are mutually exclusive. When I manage to connect to the db from within the toolkit, the msgflow is unable to connect to the db. If I restart the computer and run the msgflow, it succeeds, but trying to connect to the db from within the toolkit fails.
Since my only reason for using Derby concerns running it locally in order not to have to install something monstrous like DB2, being able to run msgflows and access the db from within the toolkit simultaneously is pretty essential.
Any hints welcome.
TIA!
/Martin |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Sat Oct 28, 2006 10:13 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Gosh.
Maybe Derby only supports one connection at a time.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| martinrydman |
| Posted: Sat Oct 28, 2006 11:22 am Post subject: |
|
|
Centurion
Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
|
Jeff,
Is this a theory, statement of fact, or joke...? 
/Martin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat Oct 28, 2006 11:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| Michael Dag |
| Posted: Sun Oct 29, 2006 1:09 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
interesting tutorial, but where does it state to support only 1 concurrent connection?
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Oct 29, 2006 4:52 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Michael Dag wrote: |
| interesting tutorial, but where does it state to support only 1 concurrent connection? |
It may be the broker's licence. You are supposed to use the databases connected to the Broker/configmgr (and installed with the broker licence) for the broker/configmgr only and not for storing/manipulating other data.... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sun Oct 29, 2006 5:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Quote: |
| However, an application can also access a Derby database using the more familiar client/server mode. This is achieved via a framework that embeds Derby and handles database requests from applications, including applications running in different JVMs on the same machine or on remote machines. |
The default mode for Derby is as an embedded database, that does not accept network connections and does not allow more than one application to connect at a time.
Try using the Derby client to connect to the ConfigMgr's embedded database while the configmgr is running - you can't.
And a little more poking around at the Derby site might have lead to http://db.apache.org/derby/docs/dev/getstart/cgsquck70629.html, which explicitly says
| Quote: |
| An embedded environment is an environment in which only a single application can access a database at one time, and no network access occurs. |
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jfluitsm |
| Posted: Wed Feb 07, 2007 3:04 am Post subject: |
|
|
Disciple
Joined: 24 Feb 2002
Posts: 160
Location: The Netherlands
|
For the broker Derby is not embedded.
After creating the database and ODBC connection you can use the DB2 Command Line Processor.
The only trouble is that in case of an error you only see 1 error message (about a failed binding).
_________________
Jan Fluitsma
IBM Certified Solution Designer WebSphere MQ V6
IBM Certified Solution Developer WebSphere Message Broker V6 |
|
| Back to top |
|
|
|
|
