mysql 的连接配置

Question

mysqljdbcsql

Answer 1

<transactionManager type="JDBC" commitRequired="false">    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="org.gjt.mm.mysql.Driver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/aaa;"/>
      <property name="JDBC.Username" value="root"/>
      <property name="JDBC.Password" value="root"/>
      <property name="JDBC.DefaultAutoCommit" value="true"></property>
    </dataSource>
  </transactionManager>
  -----------------------------------------
就上面这个改成mysql 的怎么写？ 大虾们 出刀了

Answer 2

这不就是mysql的么jdbc:mysql://localhost:3306/aaa

Answer 3

com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in config/Account.xml.  
--- The error occurred while executing mapped statement.  
--- Check the insertAccount.  
--- Check the statement or the result map.  
--- Cause: java.sql.SQLException: Unknown database 'aaa;'
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:58)
at com.test.SimpleExample.insertAccount(SimpleExample.java:52)
at com.test.SimpleExample.main(SimpleExample.java:77)
Caused by: java.sql.SQLException: Unknown database 'aaa;'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:770)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3641)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1175)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)
at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222)
at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)