oracle11g - Array Binding with Oracle(11g) Db and c# -


i'm currentlty working on application need insert few thousands lines @ same time in oracle (11g) base(using odp.net). ("bulk insert style")

that's why trying use array binding technique oracle data base using odp.net.

here code : no error while running it, nothing happens either runs ever.

if has idea of problem come please tell me.

thanks help.

 private static void adddatatabletodatabase(datatable tablelog)     {         string[] type = new string[tablelog.rows.count];         datetime[] timestamp = new datetime[tablelog.rows.count];         string[] source = new string[tablelog.rows.count];         string[] appname = new string[tablelog.rows.count];         string[] action = new string[tablelog.rows.count];         string[] filetype = new string[tablelog.rows.count];         string[] usr = new string[tablelog.rows.count];         int?[] executiontime = new int?[tablelog.rows.count];         string[] addmetadata = new string[tablelog.rows.count];         string[] explanation = new string[tablelog.rows.count];           (int = 0; < tablelog.rows.count; i++)         {             type[i] = tablelog.rows[i][0].tostring();             timestamp[i] = (datetime)tablelog.rows[i][1];             source[i] = tablelog.rows[i][2].tostring();             appname[i] = tablelog.rows[i][3].tostring();             action[i] = tablelog.rows[i][4].tostring();             filetype[i] = tablelog.rows[i][5].tostring();             usr[i] = tablelog.rows[i][6].tostring();             int executiontimevalue;              if (int.tryparse(tablelog.rows[i][7].tostring(), out executiontimevalue))                  executiontime[i] = executiontimevalue;              addmetadata[i] = tablelog.rows[i][8].tostring();             explanation[i] = tablelog.rows[i][9].tostring();         }         string oracleconnectionstring = configurationmanager.connectionstrings["dmsconnection"].connectionstring;         (oracleconnectionstring);         oracle.dataaccess.client.oracleconnection conn = new oracle.dataaccess.client.oracleconnection(oracleconnectionstring);         conn.open();                     oracle.dataaccess.client.oraclecommand cmd = conn.createcommand();         cmd.commandtext = "insert log (type,timestamp,source,appname,action,filetype,usr,executiontime,addmetadata,explanation) values (:type, :timestamp, :source, :appname, :action, :filetype, :usr, :executiontime, :addmetadata, :explanation)";          oracle.dataaccess.client.oracleparameter type = new oracle.dataaccess.client.oracleparameter("type", oracle.dataaccess.client.oracledbtype.nvarchar2, 150, "type");         oracle.dataaccess.client.oracleparameter timestamp = new oracle.dataaccess.client.oracleparameter("timestamp", oracle.dataaccess.client.oracledbtype.date);         oracle.dataaccess.client.oracleparameter source = new oracle.dataaccess.client.oracleparameter("source", oracle.dataaccess.client.oracledbtype.nvarchar2, 150);         oracle.dataaccess.client.oracleparameter appname = new oracle.dataaccess.client.oracleparameter("appname", oracle.dataaccess.client.oracledbtype.nvarchar2, 150);         oracle.dataaccess.client.oracleparameter action = new oracle.dataaccess.client.oracleparameter("action", oracle.dataaccess.client.oracledbtype.nvarchar2, 150);         oracle.dataaccess.client.oracleparameter filetype = new oracle.dataaccess.client.oracleparameter("filetype", oracle.dataaccess.client.oracledbtype.nvarchar2, 150);         oracle.dataaccess.client.oracleparameter usr = new oracle.dataaccess.client.oracleparameter("usr", oracle.dataaccess.client.oracledbtype.nvarchar2, 150);         oracle.dataaccess.client.oracleparameter executiontime = new oracle.dataaccess.client.oracleparameter("executiontime", oracle.dataaccess.client.oracledbtype.int32);         oracle.dataaccess.client.oracleparameter addmetadata = new oracle.dataaccess.client.oracleparameter("addmetadata", oracle.dataaccess.client.oracledbtype.clob);         oracle.dataaccess.client.oracleparameter explanation = new oracle.dataaccess.client.oracleparameter("explanation", oracle.dataaccess.client.oracledbtype.clob);          type.direction = parameterdirection.input;         timestamp.direction = parameterdirection.input;         source.direction = parameterdirection.input;         appname.direction = parameterdirection.input;         action.direction = parameterdirection.input;         filetype.direction = parameterdirection.input;         usr.direction = parameterdirection.input;         executiontime.direction = parameterdirection.input;         addmetadata.direction = parameterdirection.input;         explanation.direction = parameterdirection.input;          cmd.parameters.add(type);         cmd.parameters.add(timestamp);         cmd.parameters.add(source);         cmd.parameters.add(appname);         cmd.parameters.add(action);         cmd.parameters.add(filetype);         cmd.parameters.add(usr);         cmd.parameters.add(executiontime);         cmd.parameters.add(addmetadata);         cmd.parameters.add(explanation);          cmd.parameters["type"].value = type;         cmd.parameters["timestamp"].value = timestamp;         cmd.parameters["source"].value = source;         cmd.parameters["appname"].value = appname;         cmd.parameters["action"].value = action;         cmd.parameters["filetype"].value = filetype;         cmd.parameters["usr"].value = usr;         cmd.parameters["executiontime"].value = executiontime;         cmd.parameters["addmetadata"].value = addmetadata;         cmd.parameters["explanation"].value = explanation;          cmd.executenonquery();         cmd.dispose();         conn.close();    }

i found solution problem.

the code above works fine, problem use clob oracle data type. internal conversion string clob takes lot of time.

i ended truncating strings long , works fine , fast. (just few seconds insert 4000 records).


Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj...
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer ...
Read more

c# - Asp.net web api : redirect unauthorized requst to forbidden page -

im trying redirect unauthorized request forbidden page instead i'm getting forbidden page in response body , how can fix ? here's startup class : app.createperowincontext(storecontext.create); app.createperowincontext<applicationusermanager>(applicationusermanager.create); app.createperowincontext<applicationsigninmanager>(applicationsigninmanager.create); app.usecookieauthentication(new cookieauthenticationoptions { authenticationtype = defaultauthenticationtypes.applicationcookie, expiretimespan = timespan.fromdays(30), }); app.useexternalsignincookie(defaultauthenticationtypes.externalcookie); app.usetwofactorsignincookie(defaultauthenticationtypes.twofactorcookie, timespan.fromminutes(5)); app.usetwofactorrememberbrowsercookie(defaultauthenticationtypes.twofactorrememberbrowsercookie); the method im trying reach : [httpget] [authorize(roles = "admin")] public string getcurrentusername() { return userman...
Read more