Configuring SqlServer / MyBatis SqlMapConfig Data Source

I work through this MyBatis tutorial and I got to the problem of setting dataSource in SqlMapConfig.xml. The tutorial uses MySql, like any other tutorial existing on the Internet, it seems, but I use SqlServer 2008.

Please help me convert the code below to connect to a local SqlServer or help me understand how to set up the environment / how SqlMapConfig works with a factory connection.

Links to information / tutorials will also be helpful.

Thank!

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <typeAliases>
        <typeAlias alias="Contact" type="com.name.model.Contact"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
          <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/blog"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
       </environment>
    </environments>

    <mappers>
       <mapper resource="com/name/data/Contact.xml"/>
    </mappers>

</configuration>

UPDATED:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <typeAliases>
        <typeAlias alias="Contact" type="com.name.model.Contact"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
          <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
            <property name="url" value="jdbc:sqlserver://localhost(or name of server):1433;databaseName=yourdbname; catalogName=sameasdbname"/>
            <property name="username" value="root"/>
            <property name="password" value="root"/>
            </dataSource>
       </environment>
    </environments>

    <mappers>
       <mapper resource="com/name/data/Contact.xml"/>
    </mappers>

</configuration>

: JDBC- 4 SQL 2008 , : " : java.lang.UnsupportedClassVersionError(com/microsoft/sqlserver/jdbc/SQLServerDriver) = 6........."

, sqljdbc.jar sqljdbc3/sqljdbc4.jar.

+5
1

SQL Server ( ), :

  • JDBC.
  • ;

, , " " Microsoft JDBC SQL Server, classpath, MyBatis, (com.microsoft.sqlserver.jdbc.SQLServerDriver, ) URL- ( jdbc:sqlserver:// jdbc:mysql://).

, , ( , SQL Server, SQL Server 2012 , Microsoft ).

, ( , ), , SQL.

+4

All Articles