| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WMBv6.1 - Simplified Database Routing Sample -- Resolved |
« View previous topic :: View next topic » |
| Author |
Message
|
| wraymore |
 Posted: Wed Jan 09, 2008 1:10 pm Post subject: WMBv6.1 - Simplified Database Routing Sample -- Resolved |
 |
|
Centurion
Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA
|
I am reviewing "What's new in WMBv6.1?"
WMBv6.1.0.1 runtime is installed on Windows XP.
The broker database is Cloudscape Derby.
In trying to execute the Simplified Database Routing Sample to review the new Route and DatabaseRoute Nodes, I am getting an error when trying to access the sample database that was setup during the installation of this sample.
ExceptionList >
(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 739
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmJniNode'
(0x03000000):Name = 'SimplifiedDBRouting#FCMComposite_1_3'
(0x03000000):Label = 'SimplifiedDBRouting.DatabaseRetrieve'
(0x03000000):Catalog = 'BIPv610'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):DatabaseException = (
(0x03000000):File = 'JDBCCommon.java'
(0x03000000):Line = 466
(0x03000000):Function = 'JDBCConnection::createConnection'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv610'
(0x03000000):Severity = 3
(0x03000000):Number = 6233
(0x03000000):Text = 'Problem encountered obtaining JDBC connection'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'Broker 'WBRK61_DEFAULT_BROKER'; Execution Group 'SimplerRouteDBExecutionGroup'; Message Flow 'SimplifiedDBRouting'; Node 'DatabaseRetrieve'; Thread 'Thread[Thread-10,5,main]' '
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'jdbc:derby:C:\Documents and Settings\All Users\Application Data\IBM\MQSI\common\dbinstmgr\SROUTEDB'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = ' message: Failed to start database 'C:\Documents and Settings\All Users\Application Data\IBM\MQSI\common\dbinstmgr\SROUTEDB', see the next exception for details. SQLState value: XJ040 vendor's error code: 40000 stack trace: [org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
com.ibm.broker.jdbcnodes.JDBCConnection.createConnection(JDBCConnection.java:248)
com.ibm.broker.jdbcnodes.JDBCDatabaseManager.getThreadOwnedConnections(JDBCDatabaseManager.java:551)
com.ibm.broker.jdbcnodes.DatabaseRetrieveNode.evaluate(DatabaseRetrieveNode.java:397)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1424)
com.ibm.broker.plugin.MbOutputTerminal._propagate(Native Method)
com.ibm.broker.plugin.MbOutputTerminal.propagate(MbOutputTerminal.java:103)
com.ibm.broker.jdbcnodes.RouteNode.evaluate(RouteNode.java:205)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1424)] Next Exception: message: Failed to start database 'C:\Documents and Settings\All Users\Application Data\IBM\MQSI\common\dbinstmgr\SROUTEDB', see the next exception for details. SQLState value: XSDB6 vendor's error code: 45000 stack trace: [org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
ERROR XSDB6: Another instance of Cloudscape may have already booted the database "database"
This problem occurs because Cloudscape embedded framework only allows one Java virtual machine (JVM) to access the database instance at a time.
I am assuming that I am not allowed to have two Databases in the same dbinstmgr (DEFBKD61 and SROUTEDB)? 
Last edited by wraymore on Mon Jan 28, 2008 10:31 am; edited 1 time in total |
|
| Back to top |
|
 |
| mqmatt |
| Posted: Mon Jan 14, 2008 2:32 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
Hi, please could you raise a PMR? The folks would like to look at this in more detail.
Cheers,
-Matt |
|
| Back to top |
|
|
| wraymore |
| Posted: Fri Jan 18, 2008 9:50 am Post subject: |
|
|
Centurion
Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA
|
PMR Entered: 17094 499 000
I was able to get the sample working by setting up the SIMPLERROUTEDB in DB2 9.1 Server Edition.
For the working instance:
Broker Runtime is MQSI 6.1.0.1
Broker Database is Cloudscape Derby
Application Database is DB2 v9.1.300.257
WMBToolkit is 6.1.0.1 |
|
| Back to top |
|
|
| wraymore |
| Posted: Mon Jan 28, 2008 10:30 am Post subject: WMBv6.1 - Simplified Database Routing Sample -- Resolved |
|
|
Centurion
Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA
|
I was able to follow the instructions to create a fresh derby database
and jdbc provider registry updates. Once I ran these steps, executing
the SimplifiedDBRouting Message Flow executed correctly using the Derby
Database SROUTEDB.
This is just to make sure that you removed all your DB2 database and its
JDBC provider registry entries before attempting to create a derby
database -
Once you take care of these steps - please following instructions to
create a fresh derby database and jdbc provider registry updates -
- Open broker command console
- Make sure to have derbytools.jar and derby.jar to your CLASSPATH
- Change derby database working directory, where you could create
SROUTEDB database
cd %MQSI_WORKPATH%\components\WBRK61_DEFAULT_CONFIGURATION_MANAGER
- have setupSROUTED.sql and simplifieddbrouting.bat scripts copied
over there
- Then run ij using the command:
java -Dcs.database.mode=DB2 org.apache.derby.tools.ij
ij>CONNECT 'jdbc:derby:SROUTEDB;create=true';
ij>run setupSROUTEDB.sql; (pl remove first few lines to create
database)
ij>SELECT * FROM SYS.SYSTABLES; (get the listing of the tables, make
sure to have Department and EMPLOYEE tables)
ij>exit;
- mqsistart WBRK61_DEFAULT_BROKER
- run simplifieddbrouting.bat script/cmd
- check if the default broker registry is correctly updated with the
sample SIMPLERROUTEDDB JDBCProvider entry using the cmd:
mqsireportproperties WBRK61_DEFAULT_BROKER -o SIMPLERROUTEDB -c
JDBCProviders -r
- make sure to have SROUTEDB DB2 database and the corresponding
datasource is deleted.  |
|
| 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
|
|
|
|
