java - not able to insert values in my postgresql database -

-

in java code:

callablestatement cs=null; int bcode=1; int dcode=3; int noftab=3; string sql2 = "{? = call public.insertdepttables('"+bcode+"','"+dcode+"','"+noftab+"')}"; cs = conn.preparecall(sql2); cs.registeroutparameter(1,types.integer); rset1=cs.getint(1); system.out.println("success="+rest1);

in insertdepttables:(function in db-postgresql)

create or replace function public.insertdepttables (   in  branch_code  integer,   in  dept_code    integer,   in  no_tables    integer ) returns integer $$ declare count integer; begin      if no_tables>0           loop      insert t_dept_tables(branch_code,dept_code,table_no)values(branch_code,dept_code,no_tables);       no_tables=no_tables-1;       count=count+1;      exit when no_tables =0;      end loop ;      end if; return count; end $$

actually need insert no_table (i.e.,3) times row in t_dept_tables in postgresql. wat have done hav written functions in database. need call java code. used callable stmt there:

my output should in db:

bcode dcode table_no 1      3     1 1      3     2 1      3     3

now while executing java code, i'm getting result as,

console:

success=3

but 3 rows arent inserted in db, while executing function in db, values inserted. no wrong in db function. please me sort out.

are sure haven't forgot call statement, like:

cs.executequery(); ... cs.close();

btw, task achieved without functions, (don't use string concatenation, use parameter values):

string stm = "insert t_dept_tables(branch_code,dept_code,table_no) values(branch_code,dept_code,no_tables); values(?, ?, ?)"; cs = con.preparestatement(stm); cs.setint(1, id); cs.setint(3, id); cs.setint(3, id); rs = cs.executeupdate();

Comments

Post a Comment

Popular posts from this blog

c++ - Linked List error when inserting for the last time -

-
so have part of code here this loop 5 times (max = 5) insert word link list. for ( int = 0 ; < max ; i++ ) { string alphabet = g->returnalphabets(); l[i]->addwords(alphabet[i]); } and have insert word part here string line; fstream myfile ("words.txt"); while (!myfile.eof()) { getline(myfile,line); if ( alphabet == line[0] ) { listnode *newnode = new listnode; if ( head == null ) { newnode->item = alphabet; newnode->next = null; head = newnode; } else { newnode->item = line; prev = cur; prev->next = newnode; } cur = newnode; } } myfile.close(); my problem gives me error on last loop. meaning on max = 4, insert node. rest of loop fine. when decrease max 4 meaning loop 4 times, program error-free when program loops 5 times gives error. anyone can poin...
Read more

java - activate/deactivate sonar maven plugin by profile? -

-
i use sonar plugin executes if activated in maven profile. sonar runs on every compile. the problem build fail other team members not have sonar application installed locally. pom.xml checked in team members same copy including sonar configuration, don't want them modify purpose of disabling sonar (they might inadvertently check modified copy in). please advise how configure maven (.m2/settings.xml) and/or pom.xml sonar feature can enabled/disabled local profile. here sonar configuration in each project's pom.xml: <plugin> <groupid>org.codehaus.mojo</groupid> <artifactid>sonar-maven-plugin</artifactid> <version>1.0</version> <executions> <execution> <id>make-sonar</id> <phase>compile</phase> <goals> <goal>sonar</goal> </goals> </execution> </executions> ...
Read more

java - What is the difference between String. and String.this. ? -

-
this question has answer here: meaning of .this , .class in java 2 answers i'll straight point. im still learning bit of syntax , want know difference between code is code a: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.valueof(i))); } } please ignore fact i undeclared, not lost. code b: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.this.charat(i))); } } what don't yet understand difference in typing string.this , string. i under assumption when use dot operator on class accessing it's static methods(and/or variables if they're not hidden). i have studied little bit , have concluded when using string. accessing string static methods.. when using string.this. i'm accessing methods class buttonz extendi...
Read more