Why do I get an error using importJDBC from the sjdbc package?
Article ID: KB0080897
Updated On:
| Products | Versions |
|---|---|
| Spotfire S+ | All supported versions |
Description
When using the importJDBC (or exportJDBC) function in the sjdbc package the following error message comes up:
"Message: Problem in .JavaMethod("SJDBCBridge", "sjdbcExportStart", : java.lang.NullPointerException"
"Message: Problem in .JavaMethod("SJDBCBridge", "sjdbcExportStart", : java.lang.NullPointerException"
Issue/Introduction
Why do I get an error using importJDBC from the sjdbc package?
Environment
Product: TIBCO Spotfire S+
Version: All supported versions
OS: All supported operating systems
--------------------
Resolution
The appropriate JDBC driver must be loaded before using the functions in this package. From the Help files for sjdbc:
"Provides an interface to a databases using JDBC drivers. You can get JDBC drivers from the software providers. Place the JAR or ZIP file containing the JDBC drivers in the drivers folder under the package installation directory. All files placed in this directory are added automatically to the Java CLASSPATH when the package is loaded. Alternatively, drivers can be loaded explicitly at runtime using loadJDBCDriver()."
For proprietary reasons we do include any JDBC drivers with the program, only the interface. You must download the JDBC driver that is compatible with your database. Once that driver has been installed and loaded you should be able to use these functions as expected.
"Provides an interface to a databases using JDBC drivers. You can get JDBC drivers from the software providers. Place the JAR or ZIP file containing the JDBC drivers in the drivers folder under the package installation directory. All files placed in this directory are added automatically to the Java CLASSPATH when the package is loaded. Alternatively, drivers can be loaded explicitly at runtime using loadJDBCDriver()."
For proprietary reasons we do include any JDBC drivers with the program, only the interface. You must download the JDBC driver that is compatible with your database. Once that driver has been installed and loaded you should be able to use these functions as expected.
Feedback
Yes
No
Powered by
