|
From: Zoltan F. <zol...@ya...> - 2013-01-04 08:55:29
|
Cool, are you also planning to revisit the error handling? Based on the current ocilib example if directpathconvert fails if I call directpathconvert again it should resume conversion, skipping last errored row. This does not seem to be happening.(the current example will go in a infinite loop in case of an error) So in error case I am resetting the direct path and manually restart from the row after the erred row. Same applies to the load operation. Thank you for your work, I call this library from java(jna), and I can load data 20 times faster than JDBC batch inserts, without the need to write the data to a csv and load it with SQL loader or external tables... --z On Jan 3, 2013, at 11:30 PM, vincent rogier <vin...@ya...> wrote: > I will have a look and fix it an version 3.11.2 for end of january. But I will update svn this weekend for the bug regarding null number and this one as well > I had plans to enhance direct path support in version 4.0.0 (object support, fix piece support for lobs, ....) > I may work on this topics soon as well. > > Regards > > Vincent > > Le 3 janv. 2013 21:21, "Zoltan Farkas" <zol...@ya...> a écrit : >> Hi Vincent I also noticed a potential inconsistency: >> >> OCI_DirPathGetErrorRow seems to return a 0 based row number while OCI_DirPathSetEntry requires a 1 based row index. >> >> thank you >> >> --Z >> >> >> >> On Jan 3, 2013, at 4:00 PM, Zoltan Farkas <zol...@ya...> wrote: >> >>> Thank you, will do that. >>> >>> --z >>> >>> On Jan 3, 2013, at 12:39 PM, vincent rogier <vin...@ya...> wrote: >>> >>>> >>>> HI, >>>> >>>> I've checked the code, and even if the value provided to OCI_DirPathSetEntry() is NULL, OCILIB tries to convert the value to NUMBER if the column has a numeric format. >>>> >>>> I'll fix it in next release. >>>> >>>> The only thing you can do for now is to modify the source to not call OCI_NumberFromString() in dirpath.c or not call OCI_DirPathSetEntry() for null numbers. >>>> >>>> Regards, >>>> >>>> Vincent >>>> >>>> >>>> On Tue, Jan 1, 2013 at 11:30 PM, Zoltan Farkas <zol...@ya...> wrote: >>>>> dy let me know what >>>> >>>> >>>> >>>> -- >>>> Vincent Rogier >>> ------------------------------------------------------------------------------ >>> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, >>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current >>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft >>> MVPs and experts. ON SALE this month only -- learn more at: >>> http://p.sf.net/sfu/learnmore_122712_______________________________________________ >>> Orclib-users mailing list >>> Orc...@li... >>> https://lists.sourceforge.net/lists/listinfo/orclib-users |
