WaveyDavey
14 years agoOccasional Contributor
Mysql jdbc diffs between OS and Pro
I have just upgraded from Open source 3.6.1 to Pro 4.0.0
In 3.6.1 I needed mysql connectivity, so put mysql-connector-java-5.1.16-bin.jar in C:\Program Files (x86)\eviware\soapUI-3.6.1\bin\ext
I installed 32-bit installed version of Pro 4.0.0 (as it says 64-bit comes with no JRE, and I copied the mysql connector into C:\Program Files (x86)\eviware\soapUI-Pro-4.0.0\bin\ext
Now when running the groovy script to access mysql, the following script:
import groovy.sql.Sql
sql = Sql.newInstance("jdbc:mysql://localhost:3306/groovy", "root","", "com.mysql.jdbc.Driver");
gives the error:
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/groovy
3.6.1 still works.
Any ideas ? (My java knowledge is very close to zero, by the way)
David
In 3.6.1 I needed mysql connectivity, so put mysql-connector-java-5.1.16-bin.jar in C:\Program Files (x86)\eviware\soapUI-3.6.1\bin\ext
I installed 32-bit installed version of Pro 4.0.0 (as it says 64-bit comes with no JRE, and I copied the mysql connector into C:\Program Files (x86)\eviware\soapUI-Pro-4.0.0\bin\ext
Now when running the groovy script to access mysql, the following script:
import groovy.sql.Sql
sql = Sql.newInstance("jdbc:mysql://localhost:3306/groovy", "root","", "com.mysql.jdbc.Driver");
gives the error:
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/groovy
3.6.1 still works.
Any ideas ? (My java knowledge is very close to zero, by the way)
David