cancel
Showing results for 
Search instead for 
Did you mean: 

DataSource and JDBC connection

SOLVED
Highlighted
Visitor

DataSource and JDBC connection

Hello,

I have created a Database connection using my mysql.jdbc.driver.  It is imported into right location.  Properties were added and I get successful connection from database configuration screen.  However, when I add DataSource in my test, pick DataSource:JDBC and under connection dropdown, I select my database that I created connection for and hit TestConnection, I get Failed to initialize the connection that uses the [sun.jdbc.odbc.JdbcOdbcDriver] driver.  This is not the driver that is set in my database connection.  Why is it picking this one?

Thanks,

D

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

Re: DataSource and JDBC connection

Thank you for willing to help Richie!

 

@dag1976 I see that you replied straight to the email notification, this way your reply won't reach the forums.

I'll copy it here, please answer inside the Community next time 🙂

 

>>

Hi Rich,
I just figured out what the issue was. I removed user and password from my connection string template for jdbc driver and added them along with other stuff to properties section.
This resolved the issue for me.
I appreciate you reaching out.
-D

<<


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

2 REPLIES 2
Highlighted
Community Hero

Re: DataSource and JDBC connection

Hey @dag1976

I'll try and reproduce. What version of readyapi! are you using?

Also, have you more than 1 db connection configured in your project?

Ta

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
Community Manager

Re: DataSource and JDBC connection

Thank you for willing to help Richie!

 

@dag1976 I see that you replied straight to the email notification, this way your reply won't reach the forums.

I'll copy it here, please answer inside the Community next time 🙂

 

>>

Hi Rich,
I just figured out what the issue was. I removed user and password from my connection string template for jdbc driver and added them along with other stuff to properties section.
This resolved the issue for me.
I appreciate you reaching out.
-D

<<


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors