Announcement
Collapse
No announcement yet.
X
-
Change your configuration to:
Code:sql.defaultDatabase:Mysql sql.Mysql.type:mysql sql.Mysql.interface.type:dataSource sql.Mysql.driver:org.mariadb.jdbc.MariaDbDataSource sql.Mysql.driver.serverName:${db.host} sql.Mysql.driver.portNumber:3306 sql.Mysql.driver.databaseName:${db.name} sql.Mysql.driver.user:${db.user} sql.Mysql.driver.password:${db.password}
Leave a comment:
-
MySQL Datasource
I'm trying to hook up a MySQL data source. I have it working and setting up the DB connection. I verified that the connection works using Spring and getting the db connection from JNDI. However, when I try and load a ds.xml, I get this error:
Code:java.sql.SQLException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource
Code:sql.defaultDatabase.jndi.publish.path:isomorphic/jdbc/defaultDatabase # If you want to use Mysql instead, uncomment the following line # and comment all other sql.defaultDatabase definitions sql.defaultDatabase:Mysql sql.defaultDatabase.type:mysql sql.defaultDatabase.interface.type:dataSource sql.defaultDatabase.driver:org.mariadb.jdbc.MariaDbDataSource sql.defaultDatabase.driver.serverName:${db.host} sql.defaultDatabase.driver.portNumber:3306 sql.defaultDatabase.driver.databaseName:${db.name} sql.defaultDatabase.driver.user:${db.user} sql.defaultDatabase.driver.password:${db.password}
Code:<DataSource ID="Customer" serverType="sql" tableName="customer" autoDeriveSchema="true"> </DataSource>
Tags: None
Leave a comment: