Mysql DB virtualize
Hello team,
I want to know what is jdbc url for mysql?
I use below configuration but I face with error
jdbc.driverClassName=com.parasoft.xtest.jdbc.virt.driver.JDBCProxyDriver
jdbc.url=jdbc:parasoft:proxydriver:jdbc:mysql://localhost:3306/mydb
jdbc.username=sa
jdbc.password=123
I think below line is invalid, but I can not find any useful information about mysql db virtualize in your user guid
jdbc:parasoft:proxydriver:jdbc:mysql://localhost:3306/mydb
Comments
-
base on below picture I configured Parabank jdbc.properties file to read data from mysql but i face with below error
Cannot create JDBC driver of class 'com.parasoft.xtest.jdbc.virt.driver.JDBCProxyDriver' for connect URL 'jdbc:mysql://localhost:3306/parabank' java.sql.SQLException: No suitable driver
also I attach error log file
0 -
Did you miss any of the steps here?
JDBC Configuration for ParaBankThere are some steps besides modifying the jdbc.properties file, like coping the ParasoftJDBCDriver.jar. I imagine you also need to copy a MySQL jar since ParaBank doesn't use MySQL but HyperSQL.
0 -
Dear Benken,
my simple question is this if I have a Mysql db and I want to virtuale it first step is copy jar file after that I must change config files and my problem is for below line how I set it? what is valid "jdbc.url" for mysql url? for example my URL is "mysql://localhost:3306/mydb" how I can change it ?
jdbc.url=jdbc:parasoft:proxydriver:jdbc:mysql://localhost:3306/mydb
0 -
jdbc.url=jdbc:parasoft:proxydriver:jdbc:mysql://localhost:3306/mydb
According to docs, format is this:
jdbc:parasoft:proxydriver:[original driver fully qualified class name]:@[original driver connection URL]So, it looks like you are missing "original driver fully qualified class name" part. For the MySQL it is something like "com.mysql.jdbc.Driver"
0 -
Thank you so lot.
0