MQSeries.net :: View topic - Deployment Problem with DatabaseRetrieve Node

bhanu_palnati · Posted: Fri Apr 24, 2009 2:48 am Post subject:

Hi All

I have a Problem with DatabaseRetreve Node . In the basic property of the databaseRetreive node there is datasource name feild there when I am providing the data source name then its creating problem while deployment but when I am selecting on of the database name from the drop down menu it is not giving deployment problem but giving a problem while testing.Where shall I provide the datasource name and database name can you kindly guide me.

The Deployment Problem is given below:-
This error was came at the time of Deployement Time.
BIP6253E: Error in node: Broker 'WBRK61_DEFAULT_BROKER'; Execution
Group 'default'; Message Flow 'DataBase_Select_Flow';
Node 'DatabaseRetrieve'; Thread 'Thread[Thread-12,5,main]' . Could not
locate JDBC Provider entry 'DB' in the broker registry, which was given
for the data source name property for this node.

Suppose i set one of the data base name from the drop down menu at that time i successful the Deployement but rise the Exception at testing time.

The error is Given Below:-

ExceptionList
RecoverableException

File:CHARACTER:F:\build\S000_P\src\DataFlowEngine\ImbDataFlowNode
.cpp
Line:INTEGER:739

Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmMQInputNode

Name:CHARACTER:DataBase_Select_Flow#FCMComposite_1_1
Label:CHARACTER:DataBase_Select_Flow.MQInput
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException

File:CHARACTER:F:\build\S000_P\src\DataFlowEngine\PluginInterface
\ImbJniNode.cpp
Line:INTEGER:1022

Function:CHARACTER:ImbJniNode::evaluate
Type:CHARACTER:ComIbmJniNode

Name:CHARACTER:DataBase_Select_Flow#FCMComposite_1_3

Label:CHARACTER:DataBase_Select_Flow.DatabaseRetrieve
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception
and rethrowing
DatabaseException

File:CHARACTER:JDBCCommon.java
Line:INTEGER:466

Function:CHARACTER:JDBCConnection::createConnection
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:

Catalog:CHARACTER:BIPv610

Severity:INTEGER:3

Number:INTEGER:6233

Text:CHARACTER:Problem encountered obtaining JDBC connection
Insert

Type:INTEGER:5

Text:CHARACTER:Broker 'WBRK61_DEFAULT_BROKER'; Execution
Group 'default'; Message Flow 'DataBase_Select_Flow';
Node 'DatabaseRetrieve'; Thread 'Thread[Thread-16,5,main]'
Insert

Type:INTEGER:5

Text:CHARACTER:jdbc:db2://default_Database_Server_Name:50000/defa
ult_Database_Name:user=********;password=********;
Insert

Type:INTEGER:5

Text:CHARACTER: message: Required property "serverName" is
unknown host vendor's error code: -99999 stack trace:
[com.ibm.db2.jcc.b.a.<init>(a.java:194)
com.ibm.db2.jcc.b.b.a(b.java:1624)
com.ibm.db2.jcc.c.p.a(p.java:350)
com.ibm.db2.jcc.c.p.<init>(p.java:404)
com.ibm.db2.jcc.b.b.<init>(b.java:256)
com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)
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)]

anyone can Help on this error