jdbc - How is a Log4j2 JDBCAppender used to insert into a date column? -


i trying use log4j2's jdbcappender insert value oracle date column. know how use iseventtimestamp, need insert date threadcontext.

i'm guessing i'm not formatting date correctly, can't find documentation on how correctly format.

how i'm formatting date:

threadcontext.put("date_value", new date().tostring());

this log4j2 jdbcappender column element i'm using:

<column name="date_column" pattern="%x{date_value}" />

this error i'm getting:

2013-07-25 08:17:18,145 error failed insert record log event in manager [jdbcmanager{ description=xxxxxxxxx, buffersize=5, connectionsource=drivermanager{ url=jdbc:oracle:thin:@//xxxxxxxxx, username=xxxxxxxxx, passwordhash=xxxxxxxxx }, tablename=xxxxxxxxx, columns=[ { name=date_column, layout=%x{date_value}, literal=null, timestamp=false } ] }]. java.sql.sqldataexception: ora-01858: non-numeric character found numeric expected @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:445) @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:396) @ oracle.jdbc.driver.t4c8oall.processerror(t4c8oall.java:879) @ oracle.jdbc.driver.t4cttifun.receive(t4cttifun.java:450)

any suggestions?


Comments

Post a Comment

Popular posts from this blog

How to logout from a login page in asp.net -

whenever click on logout button redirect me login page when im clicking on button redirect me last visited page. not using membership or windows authentication. session.abandon(); response.cache.setcacheability(httpcacheability.private); response.cache.setcacheability(httpcacheability.nocache); response.redirect("loginform.aspx"); if using session destroy session value on logout button click , can put check in app webpages if(session["sessionvaribale"].equals(null)) { response.redirect("logoutpage url"); }
Read more

Stack level too deep error after upgrade to rails 3.2 and ruby 1.9.3 -

i'm upgrading rails 3.0.9 app 3.2.13 , ruby 1.8.7 1.9.3. time try access controller action, following error started "/myapp/login" 127.0.0.1 @ 2013-07-25 07:10:06 -0600 systemstackerror (stack level deep): actionpack (3.2.13) lib/action_dispatch/middleware/reloader.rb:70 rendered /actionpack-3.2.13/lib/action_dispatch/middleware/templates/rescues/_trace.erb (1.5ms) rendered /actionpack-3.2.13/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (5.2ms) rendered /actionpack-3.2.13/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (22.6ms) the way i've been able page load without error clear out database sessions (rake db:sessions:clear) , restart rails server. allows 1 single request succeed , subsequent requests fail. i've tried comparing core config files working 3.2 app , have tried upgrade of gems. here's current gemfile: source 'http://rubygems.org' gem 'rails...
Read more