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
Tagged:
0
Comments
base on below picture I configured Parabank jdbc.properties file to read data from mysql but i face with below error
also I attach error log file
Did you miss any of the steps here?
JDBC Configuration for ParaBank
There 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.
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
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"
Thank you so lot.