Save log information in mysql stored procedures -


i writing stored procedure in mysql , need save log information in text file.

has come across this?

well, after long hours of searching conclude there internal constraints in mysql direct writing text files.

the contour occurs me write log messages , debugging on table in database, , save relevant records in text file.

similarly, grateful may have tried help.


-

Comments

Post a Comment

Popular posts from this blog

java - Could not retrieve pre-bound Hibernate session - Could not obtain transaction-synchronized Session for current thread -

i creating web application spring-mvc, spring-security, spring-core, , hibernate. but non-error hibernate session factory. it throwing hibernateexception, see on log in debug level, , application continues execution no problem. but curious understand reason of exception raised. the log shows following lines. 2016-08-29 13:34:55,310 debug [sg.com.diamond.express.base.dao.impl.hibernatedaoimpl].[doexecute]([328]) [http-nio-8888-exec-4] - not retrieve pre-bound hibernate session org.hibernate.hibernateexception: not obtain transaction-synchronized session current thread @ org.springframework.orm.hibernate4.springsessioncontext.currentsession(springsessioncontext.java:134) @ org.hibernate.internal.sessionfactoryimpl.getcurrentsession(sessionfactoryimpl.java:1014) @ org.springframework.orm.hibernate4.hibernatetemplate.doexecute(hibernatetemplate.java:325) @ org.springframework.orm.hibernate4.hibernatetemplate.executewithnativesession(hibernatetemplate.java:308)...
Read more

java - ConcurrentModificationException upon committing transaction with Hibernate -

in our application have upgraded hibernate 3.5.6-final 4.2.21.final , getting concurrentmodificationexception when database transaction committed: java.util.concurrentmodificationexception: null @ java.util.arraylist$itr.checkforcomodification(arraylist.java:901) @ java.util.arraylist$itr.next(arraylist.java:851) @ org.hibernate.engine.spi.actionqueue.executeactions(actionqueue.java:386) @ org.hibernate.engine.spi.actionqueue.executeactions(actionqueue.java:304) @ org.hibernate.event.internal.abstractflushingeventlistener.performexecutions(abstractflushingeventlistener.java:349) @ org.hibernate.event.internal.defaultflusheventlistener.onflush(defaultflusheventlistener.java:56) @ org.hibernate.internal.sessionimpl.flush(sessionimpl.java:1195) @ org.hibernate.internal.sessionimpl.managedflush(sessionimpl.java:404) @ org.hibernate.engine.transaction.internal.jdbc.jdbctransaction.beforetransactioncommit(jdbctransaction.java:101) @ org.hibernat...
Read more

java - Not entering the success part of http response in angularjs using spring mvc -

please me resolve problem. java @requestmapping(value = "/employeelogincheck/{emailid}/{password}", method = requestmethod.get) public @responsebody string employeelogincheck( @pathvariable("emailid") string emailid, @pathvariable("password") string password) { system.out.println("employeelogincheck"); system.out.println(password); system.out.println(emailid); return emailid; } javascript var app = angular.module('signin', []) { app .controller( 'signincontroller', function($scope, $http, $window) { $scope.emailid = ''; $scope.password = ''; $scope.getvalues = function() { var email = $scope.emailid; var pass = $scope.password; return $http .get( 'employeelogincheck/' + email + '/' + pass) .then( function(response) { alert("hai"); ret...
Read more