derby运行环境搭建:
derby 10.13
jdk1.8
Centos7.2
搭建方法:
1.derby上传到服务器上目录
/home/xx/db-derby-10.13.1.1-bin/db-derby-10.13.1.1-bin/
2.修改环境变量
vim /etc/profile
export DERBY_HOME=/home/youedata/db-derby-10.13.1.1-bin/db-derby-10.13.1.1-bin
export PATH=$PATH:$DERBY_HOME/bin
3.使其生效
source /etc/profile
4.启动derby
进入$DERBY_HOME/bin目录执行
./NetworkServerControl start -h 192.168.0.142 -p 1527
5.创建数据库
语句略
derby mybatis spring 集成
1.maven依赖
<!-- https://mvnrepository.com/artifact/org.apache.derby/derby -->
<dependency>
<groupId>org.apache.derby</groupId>
<artifactId>derby</artifactId>
<version>10.13.1.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.derby/derbyclient -->
<dependency>
<groupId>org.apache.derby</groupId>
<artifactId>derbyclient</artifactId>
<version>10.13.1.1</version>
</dependency>
2.配置文件
<!-- 链接derby -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" abstract="false" scope="singleton" lazy-init="false">
<property name="driverClass" value="org.apache.derby.jdbc.ClientDriver" />
<property name="jdbcUrl" value="jdbc:derby://192.168.0.142:1527/dedb;user=root;password=root" />
</bean>
3.java代码和mysql mybatis spring代码一样 自行百度一下