The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
The database driver could not be found. No advanced options available
michaelhecht
Member Posts: 89 
Maven
Hi,
I tried to add an INFORMIX driver which I use for long time successfully (e.g. with DBvisualizer and my own java applications).
I added this under "Manage Database Drivers" by selecting the jar file and so on. Afterwards I went to "Manage Database Connections ..."
and selected the Informix driver as well as added all necessary configurations. The resulting URL is correct:
Clicking on "Advanced ..." results in an error message: "The Informix driver could not be found. No advanced options available".
Since I selected the driver by selecting the jar file, this message sounds slightly strange.
Can anyone give me a hint?
All drivers that were originally installed with RapidMiner seem to work appropriately.
I use RM 64bit under Windows 7 64 (I'm not sure wether the driver is 32bit or 64bit, but it might be 32bit).
I tried to add an INFORMIX driver which I use for long time successfully (e.g. with DBvisualizer and my own java applications).
I added this under "Manage Database Drivers" by selecting the jar file and so on. Afterwards I went to "Manage Database Connections ..."
and selected the Informix driver as well as added all necessary configurations. The resulting URL is correct:
jdbc:informix-sqli://128.35.3.12/stawdb:informixserver=stwdb_oldbut testing the connection fails with the message: "No suitable driver found for ..."
Clicking on "Advanced ..." results in an error message: "The Informix driver could not be found. No advanced options available".
Since I selected the driver by selecting the jar file, this message sounds slightly strange.
Can anyone give me a hint?
All drivers that were originally installed with RapidMiner seem to work appropriately.
I use RM 64bit under Windows 7 64 (I'm not sure wether the driver is 32bit or 64bit, but it might be 32bit).
Tagged:
0
Answers
I modified the .classpath file in the RM root directory by extending the lib-jdbc area with the new database drivers.
Now it works even if I'm not sure whether this is the rhight way to do it or not.
If I click on the "Test" button RM starts to test the connection but never finishes ?!?!
If would really like to try the Oracle driver which is predefined, but how to give RM the jar file since the
configuration in the "Manage Database Drivers" is disabled and there is no Orcle drive installed with RM!
Meanwhile I added three connections: MySQL, Informix, Oracle where all URLs are correct (like DBvisualizer, etc.)
and all passwords and usernames are correct. Nevertheless, clicking on Test results in endless "Testing Database Connection".
Why?
Added:
After about 5 minutes the MySQL-Test results in "Communications link failure. The last packet sent successfully to the server was 0 milliseconds ago ..."
After about 5 minutes the Informix-Test results in "com.informix.asf.IfxASFException: Attempt to connect to database server failed."
After about 5 minutes the Oracle-Test results in "Io exception: Got minus one from a read call"
It seems that there is now connection going out of RM.
http://rapid-i.com/rapidforum/index.php/topic,4417.0.html