| Author |
Message
|
| lamtbs |
 Posted: Fri Jun 13, 2008 8:55 pm Post subject: JDBC Adapter on Informix IDS V10 |
 |
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Hi,
been searching for a sample of JDBC with Informix but can't find it.
Tried anyway to build the event/archive tables refering to Oracle sample script.
Installed the Informix client onto c:\informix\JDBC3\lib\ifxjdbc.jar
modified the startup.bat to point JDBCDRIVERPATH to the above.
Still I got error at startup .... I've seen it processed the .cfg, trying to fetch connection & then fail ...
[Time: 2008/06/14 10:58:15.344] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting Initialization of configuration properties] ]
[Time: 2008/06/14 10:58:15.344] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering fetchConnection] ]
[Time: 2008/06/14 10:58:15.359] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Error] [MsgID: 17109] [Mesg: Exception caught in the method BusObjJavaInterface::init. Reason: java.util.NoSuchElementException]
[Thread: wbia_main (#1291926033)] [Type: Error] [MsgID: 17109] [Mesg: Exception
caught in the method BusObjJavaInterface::init. Reason: java.util.NoSuchElement
Exception]
java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java(Compiled Cod
e))
at com.crossworlds.connectors.JDBC.JDBCConnPool.fetchConnection(JDBCConn
Pool.java:300)
at com.crossworlds.connectors.JDBC.JDBCConnectorAgent.init(JDBCConnector
Agent.java:225)
at AppSide_Connector.BusObjJavaInterface.init(BusObjJavaInterface.java:4
94)
at AppSide_Connector.AppCalls.init(AppCalls.java:140)
at AppSide_Connector.AgentBusinessObjectManager.init(AgentBusinessObject
Manager.java:815)
at AppSide_Connector.AgentBusinessObjectManager.<init>(AgentBusinessObje
ctManager.java:250)
at AppSide_Connector.AppEnd.run(AppEnd.java:1435)
at AppSide_Connector.AppEnd.init(AppEnd.java:362)
at AppSide_Connector.AppEnd.<init>(AppEnd.java:137)
at AppSide_Connector.AppEnd.main(AppEnd.java:1069)
at AppEndWrapper.main(AppEndWrapper.java:2
[Time: 2008/06/14 12:51:08.219] [System: ConnectorAgent] [SS: PRU_JDBCConnector]
[[Time: 2008/06/14 10:58:15.359] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2008/06/14 10:58:15.359] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Fatal Error] [MsgID: 17050] [Mesg: The call to method init() in the application connector failed.]
[Time: 2008/06/14 10:58:15.359] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Trace] [Mesg: :getTypeForDeliveryTransport = JMS]
[Time: 2008/06/14 10:58:15.359] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 1 for serial connector agent PRU_JDBCConnector.]
[Time: 2008/06/14 10:58:15.359] [System: ConnectorAgent] [SS: PRU_JDBCConnector] [Thread: wbia_main (#1291912407)] [Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent PRU_JDBCConnector.]
Terminate batch job (Y/N)?
Press any key to continue . . .
Is it my configuration mistake, or Informix support problem
(PS. Client connection to Informix is tested okay, ODA works fine to get BO from Informix, tried both V2 & V3 client driver)
Please help, thanks!
Teresa |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Sat Jun 14, 2008 11:18 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
you havent configured properly.
communicating with Informix , you have to keep all the jars required for the same.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| lamtbs |
| Posted: Sat Jun 14, 2008 11:32 pm Post subject: |
|
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Sorry, but what does it mean to "keep all the jars required for the same"?
Please help further, thanks!
Teresa |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Sat Jun 14, 2008 11:48 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
it requires informix JDBC drivers, thats what i meant here
have a look of this...you will come to know what and all require:
http://www-1.ibm.com/support/docview.wss?rs=695&uid=swg27006311
then configure your adapter properly well
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| lamtbs |
| Posted: Sun Jun 15, 2008 1:02 am Post subject: |
|
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Dear Gaya,
I've downloaded exactly V3.0 JC2 from the IBM site, read thru the manual to install the driver
1) Driver installed in c:\Informix\JDBC3
2) unzip ifxjdbc.jar in c:\Informix\JDBC3\lib
(now there is the \com & \META-INF folder under c:\Informix\JDBC2\lib)
3) In the Start_JDBC.bat added a statement
set CLASSPATH=c:\Informix\JDBC3\lib\ifxjdbc.jar;c:\Informix\JDBC3\lib;%CLASSPATH%
Try restart the adapter, the error is the same as before.
Am I still missing something?
(By the way, I'm using WBI adapter instead of WebSphere JCA adapter, but I suppose the setup of the client should be the same?)
Thanks again! |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Sun Jun 15, 2008 1:11 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
whats your JDBC Adpater version?
so you are using WBI Adapter not Websphere adapter right
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| lamtbs |
| Posted: Sun Jun 15, 2008 1:15 am Post subject: |
|
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Hi, I'm using WBI Adapter for JDBC V2.6 with fixpak 9
Thanks! |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Sun Jun 15, 2008 2:00 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
did you keep these jars on that directory, if not keep this and point the class path directory to there
For Informix Dynamic Server, enter
ifxjdbc.jar
ifxjdbcx.jar
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| lamtbs |
| Posted: Sun Jun 15, 2008 2:19 am Post subject: |
|
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Hi,
the content of c:\informix\JDBC3\lib
\com (inside it \informix\jdbc .... etc etc)
\META-INF (inside it is only one file MANIFEST.MF)
ifxjdbc.jar
ifxjdbcx.jar
ifxlang.jar
ifxlsupp.jar
ifxsqli.jar
ifxtools.jar
In startJDBC.bat, I have
set CLASSPATH=c:\Informix\JDBC3\lib\ifxjdbc.jar;c:\Informix\JDBC3\lib;%CLASSPATH%
SET JDBCDRIVERPATH=c:\informix\JDBC3\lib\ifxjdbc.jar
I tried the JDBC client separately with java application, the driver & DB URL works.
Even ODA is able to build a Business Object from the table.
Wonder where I got it wrong with the starup?? 
Teresa |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Sun Jun 15, 2008 2:29 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
send me the startJDBC.bat file to me through PM or post it here.
copy and paste all the jars from META-INF to
c:\informix\JDBC3\lib\
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| lamtbs |
| Posted: Sun Jun 15, 2008 2:32 am Post subject: |
|
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
REM @echo off
REM set the name to be the application connector that starts
set CONNAME=%1
set CONNPACKAGENAME=com.crossworlds.connectors.JDBC.JDBCConnectorAgent
REM Set Connector JAR Name
set CONNJAR=CW%CONNAME%.jar
REM set the server name to be the interchange that is being targeted
set SERVER=%2
REM Set JVMArgs variable
set JVMArgs=
REM if WBIA_RUNTIME is set use start_adapter launcher to run adapter.
if "%WBIA_RUNTIME%"=="" goto CROSSWORLDS
REM call CWConnEnv
call "%WBIA_RUNTIME%"\bin\CWConnEnv
REM set the directory where the JText adapter resides.
set CONNDIR="%WBIA_RUNTIME%"\connectors\%1
REM goto the connector specific directory
cd /d %CONNDIR%
REM set the variables that are required for the start_adapter callee
SET JDBCDRIVERPATH=c:\informix\JDBC3\lib\ifxjdbc.jar
set DATADIRECT="%WBIA_RUNTIME%"\lib\xwutil.jar;"%WBIA_RUNTIME%"\lib\xwbase.jar;"%WBIA_RUNTIME%"\lib\xwsqlserver.jar;"%WBIA_RUNTIME%"\lib\spy\lib\spy.jar;"%WBIA_RUNTIME%"\lib\xworacle.jar
set JCLASSES=%JCLASSES%;%JDBCDRIVERPATH%;%DATADIRECT%;%CONNDIR%\%CONNJAR%;
call "%WBIA_RUNTIME%\bin\start_adapter" -n%CONNAME%Connector -s%SERVER% -l%CONNPACKAGENAME% %3 %4 %5
pause
goto END
REM *****************************************************************************************
REM This is the previous version of starting the connector
:CROSSWORLDS
REM @echo off
call "%CROSSWORLDS%"\bin\CWConnEnv
REM set the directory where the specific connector resides
set CONNDIR="%CROSSWORLDS%"\connectors\%1
REM goto the connector specific drive & directory
cd /d %CONNDIR%
REM set the name to be the application connector that is starting
if exist %CONNDIR%\BIA_%CONNAME%.jar set CONNJAR=BIA_%CONNAME%.jar
REM SET JDBCDRIVERPATH=
set DATADIRECT="%CROSSWORLDS%"\lib\xwutil.jar;"%CROSSWORLDS%"\lib\xwbase.jar;"%CROSSWORLDS%"\lib\xwsqlserver.jar;"%CROSSWORLDS%"\lib\spy\lib\spy.jar;"%CROSSWORLDS%"\lib\xworacle.jar
set JCLASSES=%JCLASSES%;%JDBCDRIVERPATH%;%DATADIRECT%
REM config file location defaults to HOME\InterchangeSystem.cfg on the local machine
REM start the Java connector under the Java Application End
REM -Dbea.home=%CROSSWORLDS% has been removed as it is no longer required
%CWJAVA% -mx128m -ms64m -Djava.ext.dirs="%MQ_LIB%";%JRE_EXT_DIRS% -Djava.library.path="%CROSSWORLDS%"\bin;%CONNDIR%;"%MQ_LIB%";%JRE_EXT_DIRS% %ORB_PROPERTY% -Duser.home="%CROSSWORLDS%" -cp %JCLASSES%;%CONNDIR%\%CONNJAR%; AppEndWrapper -l%CONNPACKAGENAME% -n%CONNAME%Connector -s%SERVER% %3 %4 %5
:END
endlocal
pause |
|
| Back to top |
|
|
| lamtbs |
| Posted: Fri Jun 20, 2008 5:17 pm Post subject: |
|
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Thanks so much to Gaya's help.
My silly mistake
put the driver under the wrong connector config parameter, so when it start it doesn't know how to load the driver.
By the way, after rectifying this, I got another error complaining that
[MsgID: 36010] [Mesg: Could not turn auto commit to False for the connection.]
Informix have 3 kinds of "log" mode (No log, Buffered Log, Unbuffered Log). We have to change it from "No Log" to "Buffered Log" to make the adapter work (in the connector config, Auto Commit = False)
Thanks again, Gaya for the many diaglogs we had over that Sunday to make this work |
|
| Back to top |
|
|
|
|
