Configure primary and replica database in one string connection. #1098
              
                Unanswered
              
          
                  
                    
                      nmartin-RatedPower
                    
                  
                
                  asked this question in
                Q&A
              
            Replies: 0 comments
  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment
  
        
    
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
So far in our Springboot application we configured the database connection string as follows
spring.datasource.url= jdbc-jdbc:aws-wrapper:mysql:replication://${host},${replica}/${database. name}?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&autoReconnect=true&readOnlyPropagatesToServer=false&rewriteBatchedStatements=true. We have changed to our connector and we would like to do exactly the same thing but when we do it we get the following error:The internal connection has changed since 'com.mysql.cj.jdbc.ClientPreparedStatement: {query} To ensure you are using the updated connection, please re-create Statement and ResultSet objects after failover and/or calling setReadOnly.Any way to set up the replica on the same connection string as the primary database? Thanks!
Beta Was this translation helpful? Give feedback.
All reactions