java - PDFbox arabic textnot show retrieve from database mysql -

-

i want display pdf report in arabic generated through mysql database. here code:

protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception {     // todo auto-generated method stub      string relativewebpath = "/font/a_nefel_adeti.ttf";     string absolutediskpath = getservletcontext().getrealpath(relativewebpath);     file file = new file(absolutediskpath);      system.out.print(file);  bytearrayoutputstream output=new bytearrayoutputstream();  pddocument document=new pddocument();  pdfont font = pdtruetypefont.load(document, new file(absolutediskpath),new winansiencoding()); pdpage test=new pdpage(); document.addpage(test);  pdpagecontentstream content=new pdpagecontentstream(document, test);  final string example = "نديم";  system.out.print(example);  try{      con=dbutility.getconnection();      stmt=con.preparestatement("select * login");      rs=stmt.executequery();      while(rs.next()){           username=rs.getstring("username");          password=rs.getstring("password");          content.begintext();          content.newlineatoffset(50, 680);          content.setfont(font, 12);          content.showtext(rs.getstring("username"));         // system.out.print(rs.getstring("password"));          content.endtext();        }   }catch(sqlexception ex){      ex.printstacktrace();  }   content.close();  document.close();    response.setcontenttype("application/pdf;base64,base_64_encoded_pdf");  response.addheader("content-disposition", "inline; filename=\"testreport.pdf\""); response.getoutputstream().write(output.tobytearray());   }

it shows arabic text on console pdf gives error:

type exception report

message u+0646 not available in font's encoding: winansiencoding

description server encountered internal error prevented >fulfilling request.

exception

java.lang.illegalargumentexception: u+0646 not available in font's encoding: winansiencoding org.apache.pdfbox.pdmodel.font.pdtruetypefont.encode(pdtruetypefont.java:368) org.apache.pdfbox.pdmodel.font.pdfont.encode(pdfont.java:286) org.apache.pdfbox.pdmodel.pdpagecontentstream.showtext(pdpagecontentstream.java:411) uae.org.testreport.doget(testreport.java:93) javax.servlet.http.httpservlet.service(httpservlet.java:620) javax.servlet.http.httpservlet.service(httpservlet.java:727) org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:52)

if not done, please update 2.0. javadoc has note:

note: simple fonts support 256 characters. unicode support, use pdtype0font.load(pddocument, file) instead.

so this:

pdfont font = pdtype0font.load(document, new file(absolutediskpath);

this doesn't work 1.8 or earlier.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more