DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connect Forms to MySQL JDBC

30991Sep 19 2005 — edited Nov 7 2005

Hi,

I need help connecting to a MySQL db through oracle reports using a jdbc connection.

I have downloaded the MySQL JDBC driver:mysql-connector-java-3.0.17-ga-bin.jar.
I can succesfully use it to connect if I write a simple java program. So I know the driver works.

I have set it in my classpath & edited the jdbcpds.conf file by adding the following:
<driver name = "mysql-merant"
sourceDatabase = "other"
subProtocol = "mysql"
connectString = "mainProtocol:subProtocol://databaseName"
class = "com.mysql.jdbc.Driver"
connection = "oracle.reports.plugin.datasource.jdbcpds.JDBCConnectionHandling">
</driver>

When I try to connect, I get the following error, ERR 62002 failed to connect to the data source.

What do I have to do to connect? Is there a way to directly give the connect string?

I can connect to an oracle DB using a the Oracle drivers no problem, why does forms not accept the MySQL driver? What can I do to make this work?

Any help would be appreciated.

Michael Baran
mcbaran@cabm.rutgers.edu