|
I have a small java program running SQL against our ERP running on iSeries DB2 to create CSV to be fed to another system. All was OK until recently something happened and the data doesn't look right. SQL query was giving exact result as expected when run via WinSQL. We found one of the column wasn't getting right data. All the values were 0.0 . Column in question is of type Decimal(17,6).
I started debugging and found different behavior using ODBC connection vs using direct JDBC driver.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // This gives proper data
Class.forName("com.ibm.as400.access.AS400JDBCDriver"); // This converts it to null.
I tried every combination for the JDBC driver. getString, getBigDecimal, getObject. All resulted in null value. I tried 3 different version of driver jar files and they are all the same. Something is not right with the driver.
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
Are the drivers from IBM?
Caveat Emptor.
"Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long
|
|
|
|
|
I think so as jar file jt400.jar came part of the ERP system which runs on AS400 iSeries machine.
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
raise a pmr
Caveat Emptor.
"Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long
|
|
|
|
|
virang_21 wrote: AS400
Ugh, aargh, spit spit  .
Caused me a lot of pain some years ago
|
|
|
|
|
If I could (in C#) derive a new Attribute from both System.ComponentModel.DescriptionAttribute and System.ComponentModel.DefaultValueAttribute . Yeah, that'd be great.
|
|
|
|
|
Work on Saturday, and you might as well plan to work on Sunday.
Yeah... that would be great....
|
|
|
|
|
This Sunday? No, I'll be dealing blackjack at a charity fundraiser event.
modified 20-Oct-17 19:27pm.
|
|
|
|
|
Watch 'Office Space'.. the quote may not be exact, but close enough.
|
|
|
|
|
|
If I could (in C#) derive a new Attribute from both System.ComponentModel.BillionaireAttribute and System.ComponentModel.DefaultMoneyAttribute . Yeah, that'd be great.
|
|
|
|
|
You mean the System.ComponentModel.BillGatesAttribute? 
|
|
|
|
|
It would be long, apparently.
|
|
|
|
|
What would the advantage of using ...
[CustomAttribute(Description = "A number", DefaultValue = 1000)]
public int YourProperty { get; set; }... over ...
[Description("A number"), DefaultValue(1000)]
public int YourProperty { get; set; }..or...
[Description("A number")]
[DefaultValue(1000)]
public int YourProperty { get; set; }...be?
|
|
|
|
|
So tried a couple of data recovery tool recommended by folks here in my last thread.
GetDataback showed a bunch of files and folders as it was canning, but then said "No files found" when it completed
I then tried R-Studio. That found only a few files. Recovering them produces some strange files that I've never seen before.
Finally I just got don running Eassos Recovery. I said it found 1543 files. That looked promising. So I paid the $0 for a license and restored them.. None of the files ever belonged to me. In a folder called "Document Files" it produced 92 PDF files. All of them are various language manuals for "My Book Essential" - the old external hard drive enclosure that went bad.
It also produced 1028 video files. None will play. No idea what they are.
In all, nothing it produced is even close to the data I had on that HD before
So at this point I'm out $40 AND all my data.
I'm open to any other recovery options. I may try bringing the drive to a pro but they'll probably just use the same tools I had.
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Another one UFS Explorer Professional Recovery (version 5, 64 bit)
Caveat Emptor.
"Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long
|
|
|
|
|
Did you try to recover files using deleted files option with GetDataBack?
In order to understand recursion, you must first understand recursion.
|
|
|
|
|
No. .I'll give it a try
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
If you didn't lost partitions (partition table), that's the option I would use. Otherwise if you lost partition table and/or MFT (or MFT copy) there's only a small chance you'll recover things. Some recovery software can recover some well known formats from raw data, but they can't be fragmented. Also this type of software will recover false positives (for example it will find PNG header and it will think that PNG image follows, but it could be just random data). So you usually just recover one sector sized (very small) files that can't be fragmented. I hope you still have your PT/MFT.
In order to understand recursion, you must first understand recursion.
|
|
|
|
|
|
Best of luck man. Losing data like that is rough.
Jeremy Falcon
|
|
|
|
|
Probably not a lot of help, but I had some success recovering jpegs from a corrupt memory stick. It was only 4 GB. IIRC, you don't say how big you hard drive is. I used Linux.
First, I made a copy of the drive using dd and ddrescue, then worked on the copy. If your drive is large, this may not be practical.
I found a program via Google, it was written just to recover jpegs and was in Haskell. We recovered about 100 MB of jpegs. Alas, not the 2 he wanted. A store who advertises recovery of data from bad drives did no better.
Arguing with a woman is like reading the Software License Agreement. In the end, you ignore everything and click "I agree".
Anonymous
|
|
|
|
|
Forget all those windows rescue programs, they are severely hobbled by windows.
Use System Rescue CD or Hiren's Boot CD (which can both be booted from a USB stick)
they are linux - so using direct access they can do a lot more with the disk than windows can (doesn't rely on the windows folder structure being correct to find files, it can find orphaned folders/files/blocks.)
Yes it does mean you need to enter obscure linux commands similar to "mount /dev/sd0a /mnt/dos" and suchlike - there's plenty of instructions out there, it will take time, but the results are well worth it.
I've used these at client sites, and usually the final count of files lost/not recovered can be counted on 1 hand - even when were are some pretty severe bad blocks.
Never found any windows rescue software that even came close to the abilities of these - but it's not their fault, it's because the windows OS/calls just wont let them have the low-level access to access disks where the expected windows structure is broken.
|
|
|
|
|
Are steak puns rarely well done?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Who did you sirloin that from?
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
