| Author |
Message
|
| MSAT |
 Posted: Wed Aug 17, 2005 8:41 pm Post subject: JDBC Connector Not starting |
 |
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Hi,
I am new to JDBC adapter(V2.6 and Frame work 2.6) for WMQI (V2.1).
I got a Business Object from DB2(V7.1) using the JDBC Adapter. I configured the connector, according to the instructions given in the "Adapter for JDBC User Guide". When I tried to start the connector from the StartUp menu, after some time it asks to press any kwy in the connector window and comes out.
When I saw the log file generated by the connector it shows
This is an internal error.A request was made that a client-socket-generatorgenerate a server socket.
Failed to initialize socket factory context.The error encounter was:xworlds_events.
I started the connector using below option.
C:\IBM\WebSphereAdapters\connectors\JDBC\start_JDBC.bat JDBC MQSI_SAMPLE_BROKER -cC:\IBM\WebSphereAdapters\repository\TestConnector.cfg
Please tell me how can I solve the problem.
Thanks
MSAT |
|
| Back to top |
|
 |
| hopsala |
| Posted: Thu Aug 18, 2005 12:48 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
Um, first of all why are you using such old versions? WMQI2.1 is really old and is much improved in the later versions, and the current JDBC adapter version is 4.3.1, so what gives?
Second, The first parameter in the connector startup command - you put in MQSI_SAMPLE_BROKER - should be the name of the connector, not the name of the broker. (see parameter ConnectorID in the connector cfg file)
Third, Does the table "xworlds_events" exist? Raise the adapter trace levels to 5 (there are two trace level parameters in the cfg file, connector and agent if I remember correctly) and slowly but carefully look through the log and trace files. (set the log and trace files in the cfg as well).
After you've done that, if you're still lost, post here the parameters in the cfg file and a larger section of the log file. |
|
| Back to top |
|
|
| kishoreraju |
| Posted: Thu Aug 18, 2005 3:33 am Post subject: |
|
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
There is not problem with thte things that u have given here . can u post the exeact portion of the log at where u r getting error.
To find the error part of the message
open the log file-> search for the "error" |
|
| Back to top |
|
|
| MSAT |
| Posted: Mon Aug 22, 2005 10:47 pm Post subject: JDBC Connector |
|
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Thanks for the reply.
Regarding older version It is required here.
The first parameter in the connector start up command is name of the connector, which is "JDBC" as I provided it. The value for the ConnectorID in the connector cfg file is "NONE".
The table xworlds_events was not there previously but after running the script provided in the path
<WebSphereAdapters>\connectors\JDBC\dependencies\
It is created. But I am not able to run another script named "event_pacage_db2.sql" provided in the same directory.It is actually to create a Procedure.My DB2 version is 7.1 with fixpack 3.
There is only one trace level parameter in the connector cfg file that is AgentTraceLevel which I set to 5.
Below I am providing the log file content.
[Version:4.3.0.0][TZ:Asia/Calcutta]
[Time: 2005/08/23 12:27:46.222] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Info] [MsgID: 17000] [Mesg: Initialization started. Name: JDBCConnector. ConfigFileName: C:\IBM\WebSphereAdapters\repository\TestConnector.cfg. Implementation DLL/Class Name: com.crossworlds.connectors.JDBC.JDBCConnectorAgent.class.]
[Time: 2005/08/23 12:27:46.238] [System: Server] [Thread: wbia_main (#816086851)] [Mesg: Privacy is NOT initialized. Reason: The privacy is NOT turned on.]
[Version:4.3.0.0][TZ:Asia/Calcutta]
[Time: 2005/08/23 12:27:47.113] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Trace] [MsgID: 17016] [Mesg: Initializing connector JDBCConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.]
[Time: 2005/08/23 12:27:47.144] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Error] [MsgID: 33018] [Mesg: This is an internal error. A request was made that a client-socket-generatorgenerate a server socket.]
[Time: 2005/08/23 12:27:47.160] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Internal Warning] [MsgID: 33027] [Mesg: No applicable transport-layer security context information was foundfor a requested ssl-protected socket. The request was made on behalfof component {1} of type {2}.]
[Time: 2005/08/23 12:27:47.707] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Error] [MsgID: 33022] [Mesg: Failed to initialize socket factory context. The error encountered was: xworlds_events]
[Time: 2005/08/23 12:27:47.707] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Error] [MsgID: 33022] [Mesg: Failed to initialize socket factory context. The error encountered was: xworlds_archive_events]
[Time: 2005/08/23 12:27:47.707] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Fatal Error] [MsgID: 17058] [Mesg: Application call to method init() returned failure. The application could not be contacted.]
[Time: 2005/08/23 12:27:47.707] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Info] [MsgID: 17066] [Mesg: Application state is disconnected]
[Time: 2005/08/23 12:27:47.707] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 1 for serial connector agent JDBCConnector.]
[Time: 2005/08/23 12:27:47.707] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#816086851)] [Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent JDBCConnector.] |
|
| Back to top |
|
|
| hopsala |
| Posted: Tue Aug 23, 2005 12:13 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
First off - there is another trace parameter called ControllerTraceLevel, if you don't have it in the list (remember it's not alphabetized) it probably means you have created the connector configuration file from the wrong template, which may be the source to all your problems. (Or maybe it didn't exist in the old versions, I don't know...)
If the parm is there, raise it to 5 and run again; remember to look both at the trace and log files (in the connector config).
As for the problem itself, i'll tell you how I sometimes solve problems in adapters, it's the worst way imaginable but since the messages are so entirely uninformative it's the fastest way to go. What I do is Jad the class files and look at the code - I simply search for the message - in this case being 33018 or 33027. FYI the function init() is at JDBCConnectorAgent.class.
I tried looking through the code but you're using an entirely different version than what I have here, and I can see even the messages codes are different, so I can't help you there. Sorry...
What's odd here is the messages about SSL - is there any possibility your database expects some sort of ssl connection?
Last but not least, you should post your cfg file content (only adapter-specific and relevant standard properties) |
|
| Back to top |
|
|
| kishoreraju |
| Posted: Tue Aug 23, 2005 2:44 am Post subject: |
|
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
| Is u r Database url is correct |
|
| Back to top |
|
|
| recallsunny |
| Posted: Tue Aug 23, 2005 6:37 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
Couple of Points for this discussion:
1. Controller TraceLevel is not used by adapters configured for Integration broker, You donot have a Controller at all !!!
2.The SSL err messages are because, your message file is off the target. Point it to "JDBCConnector.txt" in the MessageFileName property.
3. The reason "event_package_db2.sql" was not executed was because DB2 needs a C++ compiler (MS Visual C++ or Visual Age C++) to execute stored procedures. Check on the web on how to configure DB2 to use the compiler for executing SP.
4. Check Your Connector Configuration based on the previous POST on this topic
http://www.mqseries.net/phpBB2/viewtopic.php?t=23838 |
|
| Back to top |
|
|
| hopsala |
| Posted: Tue Aug 23, 2005 9:11 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
recallsunny - I think you're right about the message file, that's probably it.
about the event_package_db2.sql, it's really not necessary at this point (and possibly at all) to start handling that little tidbit; its only for events and which he can, for now, put manually into the events table. One battle at a time... |
|
| Back to top |
|
|
| recallsunny |
| Posted: Tue Aug 23, 2005 11:38 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
MSAT
The "event_package_db2.sql" functionality can be handled manually, by inserting records for an event into the xworlds_events Table as our friend has suggested.
You could also consider including the piece of Code in "insert_event_f" procedure into your Insert Trigger of the base event table. You could do away with the C++ setup for now....  |
|
| Back to top |
|
|
| MSAT |
| Posted: Tue Aug 23, 2005 10:20 pm Post subject: JDBC Connector |
|
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Thanks to all,
Now the connector started But in the log file it is generating some error indicating "Setting TimingStats to default."
I think it can be ignored.If this is not the case then just reply me.
Now I need to use Vision Test Connector to test the BO. I made following changes in my connector cfg file, as told by recallsunny.
1. In the Standard Properties, value of the MessageFileName field set to JDBCConnector.txt
2. Created tables namely xworlds_archive_events and xworlds_events. Before I was not created them, It gave me some error saying both these tables are not present in the database.
3. Some of the parameters are changed according to the values given in one of the previous mail.Link is below
http://www.mqseries.net/phpBB2/viewtopic.php?t=23838
Thanks to all
MSAT |
|
| Back to top |
|
|
| MSAT |
| Posted: Tue Aug 23, 2005 11:17 pm Post subject: |
|
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Hi,
I want to know in which Database I need to create the event and archive tables. I created in "MY_DB"(This is the Database from where I created BO and using for my testing purpose). And the same I mentioned in my JDBC URL field (jdbc:db2:MY_DB).
Now if I set CheckForEventTableInInit to True the connector logs an error indicating "the event and archive tables not found in the database".Along with "Setting TimingStats to default."
But if I set CheckForEventTableInInit to False. No errors in the log file accept "Setting TimingStats to default."
Please let me know some information related to this.
Thanks |
|
| Back to top |
|
|
| hopsala |
| Posted: Wed Aug 24, 2005 2:32 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
| MSAT wrote: |
| Setting TimingStats to default |
Two options: Either you do not have TimingStats in your cfg file at all, therefore it is set to default, or you set it to an illegal value.
This parameter is not that important, you may ignore it for now - look through the manuals and see what it means.
| MSAT wrote: |
| the event and archive tables not found in the database |
You should check earlier in the log if connection to the database was successful (also check RDBMSVendor is DB2). I assume you're using a local db since I do not see an IP address in "jdbc:db2:MY_DB".
If it was successful, possilby you created the tables under some userspace, ask you DBA or simply look at the table name more carefully - sometimes when you create a table called ATBL, by default its name is USR.ATBL where USR is your user name.
Another possibility is that you have to use SchemaName parameter in your cfg file. Try adding a parm called SchemaName type string and set it up like this:
DatabaseURL="jdbc:db2://localhost/MY_DB"
SchemaName="MY_DB"
This worked for me.
Btw, if this is a AS/400 DB2 there are many other parameters to set up, I just did this a few months back - the literature does not state how to work with AS4000 at all, and one has to figure it out himself simply by trying. If this is the case, tell us.
While you're at it, what is it you're trying to do exactly? Poll for events? insert data to the database? |
|
| Back to top |
|
|
| MSAT |
| Posted: Wed Aug 24, 2005 3:25 am Post subject: |
|
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Hi,hopsala
My CONNECTOR SPECIFIC PROPERTIES are as below
ApplicationPassword ********
ArchiveProcessed True
ArchiveTableName xworlds_archive_events
AutoCommit False
CheckForEventTableInInit True
ChildUpdatePhyDelete False
CloseDBConnection False
ConnectorID NONE
DatabaseURL jdbc:db2:MY_DB
DateFormat MM/dd/yyyy HH:mm:ss
DriverConnectionProperties
MaximumDatabaseConnections 5
PingQuery 0
PollQuantity 1
PreserveUIDSeq True
QueryTimeOut False
RDBMS.initsession 0
RDBMSVendor DB2
RetryCountAndInterval 3,20
ReturnDummyBOForSP False
SchemaName mqsiuid
UniqueIDTableName xworlds_uid
UseDefaults False
UseDefaultsForCreatingChildBOs False
UseDefaultsWhenPolling True
UseDefaultsForRetrieve False
DriverSupportForLong True
EventKeyDel ;
EventOrderBy 0
EventQueryType Fixed
EventTableName xworlds_events
JDBCDriverClass COM.ibm.db2.jdbc.app.DB2Driver
ApplicationUserName mqsiuid
Even I tried changing the DB Url as you told but not worked fine.
In the log file I am getting below message
"Event/Archive table xworlds_events does not exist in the database."
"Event/Archive table xworlds_archive_events does not exist in the database."
Please tell me in which database I need to create these tables ( Since there are 4 databases, Broker DB,Message Repository DB, Configuration Manager DB and MY_DB) I created in MY_DB.
My intention is to retrieve some data from DB2 table using this JDBC adapter, and process it in Message Flow.
Thanks |
|
| Back to top |
|
|
| hopsala |
| Posted: Wed Aug 24, 2005 4:36 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
| MSAT wrote: |
| SchemaName mqsiuid |
...? what does "mqsiuid" mean? As I already said in my previuos post, check if the tables were not created as USER.xworlds_event.
| MSAT wrote: |
| Please tell me in which database I need to create these tables ( Since there are 4 databases, Broker DB,Message Repository DB, Configuration Manager DB and MY_DB) I created in MY_DB. |
Look, are you sure you understood what an event table is? If not, you'd better read the literature again. Suffice to say the table should be wherever you want it to be - if the adapter URL is pointed to MY_DB then the table should be in MY_DB.
Keep in mind the adapter is an entirely seperate program from the broker, they communicate between one another, but they are independant. First get the adapter to poll events, then start working on the broker flow.
There's a redbook called "The Express Route to Business Integration" (sg246353), you should read the relevant parts. |
|
| Back to top |
|
|
| recallsunny |
| Posted: Wed Aug 24, 2005 5:55 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
Ok MSAT
While You do what was suggested in the previous reply by Jman, Check with What schema the tables have been created... Your Table "Schema" name appears beside the Table name in the Control Center view.
Make sure that the event & archive tables were created using "mqsiuid". If not, drop 'em and recreate by Loggin into the Command center as mqsiuid user. Execute the DB scripts to make sure that Schema name associated is mqsiuid.
And PS: Documentation is the first step, don;t post without going thru it. |
|
| Back to top |
|
|
|
|
