Mysql DB virtualize

rvmsengrvmseng Posts: 89
edited January 7 in 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:

Comments

  • rvmsengrvmseng Posts: 89

    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

  • benken_parasoftbenken_parasoft Posts: 1,009 ✭✭✭
    edited January 7

    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.

  • rvmsengrvmseng Posts: 89

    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

  • benken_parasoftbenken_parasoft Posts: 1,009 ✭✭✭

    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"

  • rvmsengrvmseng Posts: 89

    Thank you so lot.

Sign In or Register to comment.