Hello,
I have an application which uses the jdbc 1.5 driver to acces domino data. The jdbc driver is installed on a local client, the agent runs locally.
Within a 5.x environment that works fine. We are currenty planning to migrate to a 6.5 environment.
I’m testing the application within this environment. When running the agent performing the jdbc access I get the following messages on the java-console:
→ start of console output
Select $DWFCountry , KraMaxEngagementNO, KraSumBWRiskNO, QBDummyNO, QBDummyNO, QBDummyNO, QBDummyNO, QBDummyNO, Nummer from SQL_KRA WHERE $DWFPlafond=‘Osteuropa’ AND $DWFStatus=‘in Abwicklung’ AND $DWFVptIsAvailable<>‘1’ AND FolderStatusOS <> ‘Job completed’
Select $DWFCountry, QBDummyNO, QBDummyNO , QBDummyNO, QBDummyNO, VptPresentCommitmentTotalNO, VptPresentBwRiskTotalNO, VptTrancheDeliveredTX, Nummer FROM SQL_VPT WHERE $DWFPlafond=‘Osteuropa’ AND $DWFStatus=‘in Abwicklung’ AND FolderStatusOS <> ‘Job completed’ AND SQL_VPT.VptTrancheDeliveredTX<>‘2’
Select $DWFCountry , QBDummyNO, QBDummyNO, KcaMaxEngagementNO, KcaSumBwRiskNO, QBDummyNO, QBDummyNO, Nummer FROM SQL_KCA WHERE $DWFPlafond=‘Osteuropa’ AND $DWFStatus=‘in Abwicklung’ AND FolderStatusOS <> ‘Job completed’
Select $DWFCountry , QBDummyNO, QBDummyNO, KcaMaxEngagementNO, KcaSumBwRiskNO, QBDummyNO, QBDummyNO, Nummer FROM SQL_KCA WHERE $DWFPlafond=‘Osteuropa’ AND $DWFStatus=‘in Abwicklung’ AND FolderStatusOS <> ‘Job completed’
java.lang.UnsatisfiedLinkError: Can’t find library JdbcDomino (JdbcDomino.dll) in java.library.path
java.library.path=C:\Program Files\notes;.;C:\WINDOWS\System32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Documents and Settings\All Users\Application Data\Lotus\Notes\Data;C:\Program Files\DC VB Extended Components\S00;C:\Program Files\oracle\dcoracl\bin;C:\Program Files\SQLLIB\HELP;C:\Program Files\SQLLIB\FUNCTION;C:\Program Files\SQLLIB\BIN;C:\JdbcSql\Lib
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1751)
at java.lang.Runtime.loadLibrary0(Runtime.java:780)
at java.lang.System.loadLibrary(System.java:865)
at lotus.jdbc.domino.DominoEnvCLI.<init>(DominoEnvCLI.java)
at lotus.jdbc.domino.DominoDriver.<init>(DominoDriver.java)
at lotus.jdbc.domino.DominoDriver.<clinit>(DominoDriver.java)
at java.lang.Class.forName1(Native Method)
at java.lang.Class.forName(Class.java:142)
at ViewHeader.executeQuery(ViewHeader.java:55)
at ViewHeader.NotesMain(ViewHeader.java:37)
at lotus.domino.AgentBase.runNotes(Unknown Source)
at lotus.domino.NotesThread.run(NotesThread.java:208)
→ end of console output
The JdbcDomino.dll resides in the path C:\JdbcSql\Lib which is specified within my path-varaible and also in the JavaUserClasses entry inside the notes.ini.
every help is very appreciated!
ciao
Heiko