| Author |
Message
|
| lehare |
 Posted: Thu Mar 02, 2006 3:50 am Post subject: steps required [JDBC successfull configuaration] |
 |
|
Apprentice
Joined: 25 Jul 2005
Posts: 48
|
what steps are required for a successfull jdbc configuaration?
i want to set-up a configuaration were i will insert rows / or delete from a websphere message broker side.
set up steps as i understood them from the jdbc_pdf
1. create - > directory under ...\connectors\MicroLand
2. edit -> start_JDBC.bat on the [JDBCDRIVERPATH]
3. create -> business Object e.g. CUSTOMER.xsd [which corresponds to a table in my database MICROLAND] under ...\repository\MicroLand
4. create -> MicroLandConnector.cfg file [with the CUSTOMER.xsd in the supported business objects]
5. create -> windows shortcut to point to the correct target
6. create -> event table / archive table / triggers [for update, insert, delete]
in the above database
are the above step enough to make the connect start and behave normally? - under the ..\repository\MicroLand - is it enough only to include the CUSTOMER.xsd business object? ...
any enlightment will be appreciated
regards, Lehare |
|
| Back to top |
|
 |
| vk |
| Posted: Thu Mar 02, 2006 5:28 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Lehare,
What are you using the connector for?
Inserting \ Deleting records from the table when the connector gets a message from the message broker? (Request Processing)
Or send a message to the broker when a record is inserted or deleted from the table? (Event Notification)
For the first case, you need not have Event table, Archive table or triggers? If it is the latter case, did you try starting the connector? Are you facing any issues?
Regards,
VK. |
|
| Back to top |
|
|
| lehare |
| Posted: Fri Mar 03, 2006 5:43 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2005
Posts: 48
|
I'm actually implimenting both scenerious (Event Processing & Notification)
but when i'm starting the adapter i get the following erro:
________________________
[Type: Trace] [MsgID: 17016] [Mesg: Initializing connector RapperConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.]
[Type: Error] [MsgID: 33018] [Mesg: This is an internal error. A request was made that a client-socket-generatorgenerate a server socket.]
[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}.]
[Type: Error] [MsgID: 33022] [Mesg: Failed to initialize socket factory context. The error encountered was: WBIA_EVENTS]
[Type: Error] [MsgID: 33022] [Mesg: Failed to initialize socket factory context. The error encountered was: WBIA_ARCHIVE]
[Type: Fatal Error] [MsgID: 17058] [Mesg: Application call to method init() returned failure. The application could not be contacted.]
[Type: Info] [MsgID: 17066] [Mesg: Application state is disconnected]
[Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 2 for serial connector agent RapperConnector.]
[Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent RapperConnector.] |
|
| Back to top |
|
|
| vk |
| Posted: Fri Mar 03, 2006 6:57 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
This means that the connector was not able to eatablish connection to the database. There should have been some problem in the specification of the JDBCDriverClass and DatabaseUrl in the configuration file or startup script.
Did you try connecting to the database using JDBCODA? I always use the ODA first to see if I am able to connect to the database with the driver jar file.
Which is your database? Also can you send the settings of DatabaseUrl and JDBCDriverClass in the connector specific properties tab?
Regards,
VK. |
|
| Back to top |
|
|
| lehare |
| Posted: Mon Mar 06, 2006 4:52 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2005
Posts: 48
|
I can successfully connect to the database using ODA ...
here are the connector specific properties
:[Type: Trace] [MsgID: 17016] [Mesg: Initializing connector LuckConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.] ]
:[Type: Trace] [MsgID: 90018] [Mesg: Message key 90018 :: C:\\IBM\\WebSphereAdapters\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.] ]
:applicationName=LuckConnector]
:ApplicationUserName=LuckAdapter]
:ApplicationPassword= ***** ]
:databaseURL=jdbc:ibm-crossworlds:sqlserver://localhost;DatabaseName=FochiniDB]
:archiveProcessed=True]
:archiveTableName=xworlds_archive_events]
:eventKeyDel=;]
:eventTableName=xworlds_events]
:uniqueIDTableName=xworlds_uid]
:pollQuantity=1]
:retryCountAndInterval=3,20]
:retryCount=3]
:retryInterval=20]
:skipRetrieve=null]
:timingStats=0]
:MaximumDatabaseConnections=5]
:ConnectorID=NONE]
:RDBMSVendor=MSSQLServer]
:ReplaceAllStr=false]
:ReturnDummyBOForSP=False]
:PreparedStatementCacheSize=null]
:StrDelimiter=null]
:ReplaceStrList=null]
:ChildUpdatePhyDelete=False]
:PingQuery=]
:JDBCDriverClass=com.ibm.crossworlds.jdbc.sqlserver.SQLServerDriver]
:EventOrderBy=]
:DateFormat=MM/dd/yyyy HH:mm:ss]
:AutoCommit=False]
:SchemaName=webuser]
:EventQueryType=Fixed]
:PreserveUIDSeq=True]
:CloseDBConnection=False]
:SPBeforePollCall=null]
:CheckForEventTableInInit=True]
:DriverConnectionProperties=]
:DriverSupportForLong=True]
:UseDefaultsForCreatingChildBOs=False]
:[Type: Trace] [MsgID: 90019] [Mesg: Message key 90019 :: C:\\IBM\\WebSphereAdapters\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.] ]
:UseDefaultsWhenPolling=True]
:QueryTimeOut=False]
:SelectiveCommitForPoll=null]
:[Type: Trace] [MsgID: 90019] [Mesg: Message key 90019 :: C:\\IBM\\WebSphereAdapters\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.] ]
:[Type: Trace] [MsgID: 90018] [Mesg: Message key 90018 :: C:\\IBM\\WebSphereAdapters\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.] ]
:checkStatus]
:getTypeForDeliveryTransport = JMS]
_______________________________________________________________
i changed the table names to default table names - now i'm getting the error
[Version:4.3.0.0][TZ:Africa/Harare]
[Time: 2006/03/06 14:05:41.594] [System: ConnectorAgent] [SS: LuckConnector] [Thread: wbia_main (#1126256124)] [Type: Info] [MsgID: 17000] [Mesg: Initialization started. Name: LuckConnector. ConfigFileName: C:\IBM\WebSphereAdapters\connectors\LuckConnector.cfg. Implementation DLL/Class Name: com.crossworlds.connectors.JDBC.JDBCConnectorAgent.class.]
[Time: 2006/03/06 14:05:41.609] [System: Server] [Thread: wbia_main (#1126256124)] [Mesg: Privacy is NOT initialized. Reason: The privacy is NOT turned on.]
[Version:4.3.0.0][TZ:Africa/Harare]
[Type: Trace] [MsgID: 17016] [Mesg: Initializing connector LuckConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.]
[Type: Error] [MsgID: 33018] [Mesg: This is an internal error. A request was made that a client-socket-generatorgenerate a server socket.]
[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}.]
[Type: Error] [MsgID: 36007] [Mesg: Message key 36007 :: C:\\IBM\\WebSphereAdapters\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.]
[Type: Error] [MsgID: 90006] [Mesg: Message key 90006 :: C:\\IBM\\WebSphereAdapters\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.]
[Type: Fatal Error] [MsgID: 17050] [Mesg: The call to method init() in the application connector failed.]
[Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 1 for serial connector agent LuckConnector.]
[Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent LuckConnector.]
__________________________________________ |
|
| Back to top |
|
|
| lehare |
| Posted: Mon Mar 06, 2006 5:34 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2005
Posts: 48
|
I was able to connect to the SQLSever database and the application is now polling successfully -
but now working on [the last stage i assume] - i want the adapter to send (Event Notification) to the broker(WMB) when a record is inserted in the FochiniTable [custom created table] ... |
|
| Back to top |
|
|
| djeripo |
| Posted: Mon Mar 06, 2006 12:13 pm Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
| Quote: |
| [Type: Error] [MsgID: 90006] [Mesg: Message key 90006 :: C:\\IBM\\WebSphereAdapters\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.] |
As long as you did not change the MessageFileName in your connector .cfg file to JDBCConnector.txt,You might not be knowing what actual error you are getting. |
|
| Back to top |
|
|
| vk |
| Posted: Mon Mar 06, 2006 4:28 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
I used the JDBC driver provided for microsoft for connecting to the SQL Server. It is available in the Microsoft website. I am able to run the connector for both Event Notification as well as Request Processing.
Try with these specifications -
DatabaseURL = jdbc:microsoft:sqlserver://localhost:1433;databaseName=FochiniDB
JDBCDriverClass = com.microsoft.jdbc.sqlserver.SQLServerDriver
You need to copy all the 3 jar files to your library - mssqlserver.jar, msbase.jar and msutil.jar
Also, as djeripo pointed out, change the MessageFileName in the Standard Properties to JDBCConnector.txt
Regards,
VK. |
|
| Back to top |
|
|
|
|
