mybatis / redis-cache Goto Github PK

thread unsafe? if it is a problem, I will fix it

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: redis.clients.jedis.exceptions.JedisDataException: NOAUTH Authentication required.
### Cause: redis.clients.jedis.exceptions.JedisDataException: NOAUTH Authentication required.
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:119)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
    at com.smarttrip.service.impl.StartDateService.selectByConditionMap(StartDateService.java:80)
    at com.smarttrip.service.impl.StartDateServiceTest.test(StartDateServiceTest.java:33)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:606)

has anybody account this problem?when i use redis-cli to connect redis, the password i write in redis.properties is white.

host=xxxx.xxxx.xxxx.xxxx
port=6379
connectionTimeout=5000
soTimeout=5000
password=111111
database=0
clientName=develop

Because I returned a DTO in the mapper file, some of the relevant insert, update in another file, so I need to manually refresh, or there are other ways?

I used AliCloudDB for Redis as my redis, and then occured an error, notice me that the command "client" was not supported.The i checked the source code, and found that, in the class RedisCache, when new a JedisPool, it set the clientName.But AliCloudDB for Redis does not support command "client" yet.

The solution is set the clientName to be empty in you redis config file.

see [here] (e7d4f07)

This was partially highlighted by moving property file into right location to caues issue to occur on travis. The new params in that commit are now commented out. I'm looking at a solution I wrote a long while back but have basically no experience here so any community help would be appreciated.

The parseConfiguration method of the RedisConfigurationBuilder class, InputStream is dead, which means that can not be used in the maven project multi-environment configuration, such as the development environment, production environment, because this class is final type, so can modify from the classpath.

How to Adaptation environment? like this

dev read redis-dev.properties
test read redis-test.properties
prod read redis-prod.properties

Or, I'm use spring boot, use the profiles, how to read environment in org.springframework.boot.autoconfigure.data.redis.RedisProperties ?

And, If use the new jedis version(2.9.0)

pool = new JedisPool(...)

was error...

@hazendaz

if redis server down,i want direct query from db and not throw exception, how can i config?

Is this framework support SQL's join?

Hello

I found that in redis.properties the property names must be host,port,password, otherwise mybatis will config the redis with the default value .

For example, below is my redis.properties

redis.host=192.168.1.10
redis.port=6379
redis.password=
redis.maxIdle=100
redis.maxActive=300
redis.maxWait=1000
redis.testOnBorrow=true
redis.timeout=100000

MyBatis cannot find host,port,password (and ingore the properties maxIdle,maxActive...),but set the host with default value localhost and I had got connection refused error.
I must define

host=192.168.1.10
port=6379
password=

In my project, there was also a property password in jdbc.properties, so...I must change the jdbc property name and modify dbcp config in spring config file carefully.

This problem confused me quite a time, it seems the redis server was not setup corrected at first...finally I found the truth above !

I wrote this issue for hoping others to avoid the same problem!

how to write spring configration，Conflict with spring-data-redis?
thank you

When i use redis-cache in my project ,it throws exception,as you see,"Could not get a resource from the pool".
this is more infomation

Cause: redis.clients.jedis.exceptions.JedisConnectionException: Could not get a resource from the pool] with root cause

java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(DualStackPlainSocketImpl.java)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at redis.clients.jedis.Connection.connect(Connection.java:144)
at redis.clients.jedis.BinaryClient.connect(BinaryClient.java:71)
at redis.clients.jedis.BinaryJedis.connect(BinaryJedis.java:1783)
at redis.clients.jedis.JedisFactory.makeObject(JedisFactory.java:65)
at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:819)
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:429)
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:360)
at redis.clients.util.Pool.getResource(Pool.java:40)
at redis.clients.jedis.JedisPool.getResource(JedisPool.java:84)

Last release in Maven central repository was 28-Dec-2015.
How can I contribute to make it move forward?

trying to use redis via maven,

 <dependency>
    <groupId>org.mybatis.caches</groupId>
    <artifactId>mybatis-redis</artifactId>
    <version>1.0.0-SNAPSHOT</version>
  </dependency>

got this error,

Could not find artifact org.mybatis.caches:mybatis-redis:jar:1.0.0-SNAPSHOT -> [Help 1]

im using this example,

http://mybatis.github.io/redis-cache/index.html

do you have any idea what maven repositories should i use?
thank you.

I use alibaba datasource druid ,when I deal database update,cache not update

没有针对redis集群的二级缓存实现么

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

This repository currently has no open or pending branches.

Detected dependencies

• Check this box to trigger a request for Renovate to run again on this repository

Hi there,

are there any updates on redis-cache? Anything needed to help out?

Last version is from 2015 and there have been many updates in Jedis and MyBatis.

Thank you for your time!

Can I support setting a default expiration time for Key when caching?

Several data were obtained from the database, but only one of them was obtained from redis. I am not familiar with the redis, I do not know the problem is the configuration in the redis or redis-cache. Have you ever encountered such a problem?

I use flushInterval like this:

<mapper namespace="cn.com.xxxxx.dao.mapper.TestMapper"> <cache type="org.mybatis.caches.redis.RedisCache" flushInterval="2000"/> ...

after more than 2 seconds,I use this query again,but I just see information like this(in console):

org.apache.ibatis.cache.decorators.LoggingCache:62 - Cache Hit Ratio [cn.com.chengyisheng.dao.mapper.TestMapper]: 0.875

It means this query use cache result again.

why? How to use flushInterval

In class KryoSerializer, I see the comments about SerializeUtil with Kryo, which is faster and more space consuming., but when I read this article https://www.shenyanchao.cn/blog/2019/02/13/redis-serializer/, it looks like KryoSerializer is faster and less space consuming.

article reference: https://www.shenyanchao.cn/blog/2019/02/13/redis-serializer/

What does this use caching policy？

The src of the version 1.0.0-beta2 from maven are different from those from github.

especially, the constructor of RedisCache, as follow:

pool = new JedisPool(redisConfig, redisConfig.getHost(), redisConfig.getPort(),
redisConfig.getConnectionTimeout(), redisConfig.getSoTimeout(), redisConfig.getPassword(),
redisConfig.getDatabase(), redisConfig.getClientName());

which is not avaliable constructor of JedisPool of version 2.9.0...

or, is there anything i misunderstood?