java - Is there a easy way to map varchar2(1) ("1" or "0") to JPA boolean type -

-

i understand default map oracle data type number(1) jpa java boolean, not sure if there default cast varchar2(1) (it either '1' or '0') jpa java boolean? same way mapping number(1)?

not sure following idea ok, referred here:

public class people{      @externalvalues({"true=1", "false=0"})     @type(string.class)     private boolean weird;      ... }

i using openjpa 2.2.0 here. thanks

you can use type casting in getter , setter methods , use string property datatype .

@column(length=1 ) private string string;    public boolean getstring() {     return boolean.valueof(string) ; }  public void setstring(boolean string) {     this.string =  (string) ? "1" : "0"; }

Comments

Post a Comment

Popular posts from this blog

javascript - IndexedDB error: Uncaught DataCloneError: Failed to execute 'put' on 'IDBObjectStore': An object could not be cloned -

-
i using google maps api along html 5 geolocation api display position marker on map. once marker displayed have simple on marker double click function saves new marker current position using indexeddb. goes until object stored, recieve message " uncaught datacloneerror: failed execute 'put' on 'idbobjectstore': object not cloned. " in console. code follows: function initialize() { var mapproperties = { // set maps properties center:new google.maps.latlng(55.8580,-4.2590), zoom:8, maptypeid:google.maps.maptypeid.roadmap }; var map=new google.maps.map(document.getelementbyid("map-overview"),mapproperties); //display map in map-overview div function nogeolocation(e) { //a function handle users not have geolocation if (e) { var content = 'error: unfortunately geolocation service failed.'; } else { ...
Read more

java - Unable to make sub reports with Jasper -

-
i using jaspersoft studio create reports. having sub report in jasper main report. problem unable make work, because if add sub report detail band of main report, sub report generated number of times, row row, entire sub report repeated in number of pages. can't put in summery band due same reason. i unable put in column footer band or other footers because displays below error net.sf.jasperreports.engine.jrexception: net.sf.jasperreports.engine.jrruntimeexception: subreport overflowed on band not support overflow. @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.fillreport(reportcontroler.java:467) @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.access$18(reportcontroler.java:442) @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler$4.run(reportcontroler.java:334) @ org.eclipse.core.internal.jobs.worker.run(worker.java:54) caused by: net.sf.jasperreports.engine.jrruntimeexception: subreport overflowe...
Read more

Integrity error when loading fixtures for Selenium testing in Django -

-
i want load fixture selenium testing. using fixtures successful in initial tests, know capable of loading fixtures in test setup , using them in tests. have attempted several approaches. first, generated fixtures specific models testing using dumpdata. example below: python manage.py dumpdata protocols.step --indent=2 > functional_tests/fixtures/step.json when used in test so: class signintest(functionaltest): fixtures = ['admin_user.json', 'protocol.json', 'step.json', 'protocol_element.json'] def test_login_and_view_user_data(self): ... i error: django.db.utils.integrityerror: problem installing fixtures: row in table 'protocols_protocolelement' primary key '37' has invalid foreign key: protocols_protocolelement.element_content_type_id contains value '41' not have corresponding value in django_content_type.id. second attempt involved using test data in tables, excluding contenttyp...
Read more