Anonymous_User Absent Member.
Absent Member.
1420 views

Can't load JDBC driver


Hi, everyone!
I'm trying to gather data from external JDBC source with a 3rd party
JDBC driver.
I have followed the steps according to the manual and have put the
driver to
/OperationsCenter_install_path/html/client/extensions
/OperationsCenter_install_path/classes/ext
/OperationsCenter_install_path/classes
folders.
If the driver is not signed, NOC client wouldn't load and the java
console would complain that the JDBC driver is not signed (this means
that it does see the driver). I have signed the driver with custom local
certificate and installed old Java 6 release to avoid security
signature-related issues.
After this, there are no warnings in Java console of the NOC Client
Console when starting it up.
Once I open up definition editor, where I have already configured JDBC
connection details, Java console log shows this:


Code:
--------------------
014-11-11 16:10:23,516 ERROR DB.Connector.com.wily.introscope.jdbc.IntroscopeDriver|jdbc:introscope:net//Admin@10.0.1.2:5001|select now(): Cannot load database: java.lang.ClassNotFoundException: com.wily.introscope.jdbc.IntroscopeDriver
--------------------


Looks like, JDBC driver hasn't even been loaded. Why? Is there anything
I missed with JDBC driver config?


--
m_chistyakov
------------------------------------------------------------------------
m_chistyakov's Profile: https://forums.netiq.com/member.php?userid=8240
View this thread: https://forums.netiq.com/showthread.php?t=52170

Labels (1)
0 Likes
5 Replies
Anonymous_User Absent Member.
Absent Member.

Re: Can't load JDBC driver


It's not a simple answer unfortunately and you may need to work with
support. I can tell you that I have run into at least one jdbc driver
that the jar file had to be expanded (ie: unzipped) to work. There are
also other types of JDBC drivers that are more than one jar. Lastly,
there are Type 1 through Type 4 drivers and some require other files
(IE: actual OEM database drivers installed). I have never done the
self sign, I usually have support sign them for me.

Here is a test you can do. When you run the editor it needs the jar
file in the client deploy directory, when you run your definition as an
adapter then the jar(s) need to be under the classes directory (usually
'ext' directory). What you can do is, drop the jars in the ext
directory and restart NOC. Then run the NOC\bin\mossql batch file.
From there you will manually enter the URI, connection string, etc. If
you can't get it working there, then data integrator is unlikely to
work. Think of mossql batch file as an interactive sql connection like
isql.exe. If the connection works, you can type in adhoc select
statements.

Hope this helps.


--
tisenberg
------------------------------------------------------------------------
tisenberg's Profile: https://forums.netiq.com/member.php?userid=1851
View this thread: https://forums.netiq.com/showthread.php?t=52170

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can't load JDBC driver


tisenberg, thanks for the tip. Unfortunately, mossql batch file also
reports that class is not found. Unzipping tha jar didn't change
anything. Maybe there is some incompatability with JDBC driver, who
knows...


--
m_chistyakov
------------------------------------------------------------------------
m_chistyakov's Profile: https://forums.netiq.com/member.php?userid=8240
View this thread: https://forums.netiq.com/showthread.php?t=52170

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can't load JDBC driver


i did a quick look and the documentation says that all the files
required for the introscope JDBC driver are packaged in the jar file so
it doesn't appear at a high level you are missing anything. One thing
I did notice on unix is the jar must be marked executable (i.e.: chmod
+x) but not sure that is the issue. Also, it appears that the JDBC
driver is the way for their product to access databases and I'm not sure
of the overall architecture, but if behind the scenes introscope (Wily?)
is using Oracle, DB2, Sybase, Postgres, SQL, etc... use our supplied
JDBC drivers to access that database directly.

Lastly, you could double check that what you have is what you think it
is... where did you get the JDBC driver? If you open the jar file with
something like win zip, do you do the following directory/file?
com.wily.introscope.jdbc.IntroscopeDriver If not, that is the main
problem.


--
tisenberg
------------------------------------------------------------------------
tisenberg's Profile: https://forums.netiq.com/member.php?userid=1851
View this thread: https://forums.netiq.com/showthread.php?t=52170

0 Likes
Highlighted
Anonymous_User Absent Member.
Absent Member.

Re: Can't load JDBC driver


Here's the link to Introscope's JDBC jar:
https://www.dropbox.com/s/s3z4fqrx9c8o3op/IntroscopeJDBC.jar?dl=0
I have also tried to load the driver in other JDBC application and it
loaded and connected with CA Wily with no issues. The structure inside
is correct and has the folders mentioned. The jar ships with CA APM
(Wily).
Yes, Wily does work with Postgres, but it's too complicated, too much
data inside. I thought that JDBC driver will make things much easier.
Also Wily's documentation doesn't say anything about direct database
access, I guess they also had a reason for this.


--
m_chistyakov
------------------------------------------------------------------------
m_chistyakov's Profile: https://forums.netiq.com/member.php?userid=8240
View this thread: https://forums.netiq.com/showthread.php?t=52170

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Can't load JDBC driver


At this point you should probably reach out to support. Data
integrator editor requires the jar file to be signed in order for it to
download to the client. Mossql on the other hand, I don't think is
required to be signed. Maybe support can help you figure this out.


--
tisenberg
------------------------------------------------------------------------
tisenberg's Profile: https://forums.netiq.com/member.php?userid=1851
View this thread: https://forums.netiq.com/showthread.php?t=52170

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.