The driver is not available in your classpath, which is controlled by Phoenix. You can put it into the SAR file in the same location as the mysql driver.
>From searching the archives (http://www.mail-archive.com/[email protected]) it appears that the JDBC-ODBC bridge driver is not necessarily going to work. People have had problems with it, and I didn't spot anyone having success (not that I spent too much time looking). People have had success with Oracle and a real JDBC driver, with MySQL, and with Hypersonic SQL. I'm assuming that someone has had some success with each of: <dbMatcher db="mssql" databaseProductName="microsoft sql server"/> <dbMatcher db="oracle" databaseProductName="oracle.*"/> <dbMatcher db="mysql" databaseProductName="my.*"/> <dbMatcher db="postgresql" databaseProductName="postgres.*"/> <dbMatcher db="sapdb" databaseProductName="sap.*"/> <dbMatcher db="hypersonic" databaseProductName="HypersonicSQL"/> but I can't tell you which drivers worked. You can search the mail archives to see what people have said, or you can tell people which database you are using, and see which (if any) drivers people have had success using. --- Noel -----Original Message----- From: Manigandan Shreetharan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 13:06 To: James Users List Subject: Noel --- How to use JDBC in James hi noel, I wnated to use JdbcOdbcDriver class as my driver and I have specified it in the drver tag in the config.xml file and when I try to configure my JdbcDatasource object it gives it is not a valid driver. Help in this how can i use this driver. regards mani -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
