This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Five Lines of Code and have Christian Clausen on-line!
See this thread for details.
Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!

Bill Fences

Greenhorn
+ Follow
since Oct 23, 2004
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Bill Fences

I did it does not reach it.
just the MSN value, i did have another println under the executeBatch and in never hits, mind you I am writing the values to a textfile adding them to the ArrayList, closing the Printer and then processsing the array to use the same connection, if that has any impact at all.

I use a for loop and did a allMSN.size() to limit the loop and it worked fine.

Bill c/o Rastas
[ November 05, 2004: Message edited by: Bill Fences ]
By the print statements I watching it in the console and it stops on the last iteration and the line

System.out.println("Execute batch");

is never reached it just hangs in the loop, if a can determine the last record I can force it to break.
mobile_phone_number is a VARCHAR2, I use exactly the same code to perform exactly the same function with an ArrayList, same field, in another object that works perfectly fine.
Thanks Bear, what would you suggest?

BF
15 years ago
I'm having a bad hair day or something, if some one can give me some clue,

I have servlet that is initiated at start up

I query the database and get a record set let say 500 rows 30 columns ID, Name, Number etc...

1. how do I get the column name let say getColumnName("ID"), getColumnName("Name"), etc.. I iterating through the record set..

ID321,Cletus,23..
ID123,CousinDaisy,23..
ID144,BossHog,23..
ID113,Flash,23..
etc...

2. I want to eventually write these to a file pipe delimeted to ftp to another app.
a. - Would it be OK to write directly print.out(getColumnName("ID"), getColumnName("Name"), etc.. )?
b. - Or should I look at storing the records in a vector and then writing the data?

3. Later on I get a response from the app I sent the file to to tell me if the records were successful or fail and then I update the status of the record in the database.

If some one can give me an idea what the best apprach to this is I will love you forever.

Bill
15 years ago
Can some one help me I'm having trouble with WL JNDI look up returning
a warning when i deploy

"Did not find resource-ref in web.xml matching MySQLactivate."

I have create the datasource in WL console as follows..

Name: MySQLactivate
JNDI Name repaidactivate

And I get a naming exception as follows when I run the code....

javax.naming.NameNotFoundException: While trying to lookup 'jdbc.prepaidactivate' didn't find subcontext 'jdbc' Resolved ; remaining name 'jdbc/prepaidactivate'










If some one can see where I am going wrong would be a big help
Can some one help me I'm having trouble with WL JNDI look up returning
a warning when i deploy

"Did not find resource-ref in web.xml matching MySQLactivate."

I have create the datasource in WL console as follows..

Name: MySQLactivate
JNDI Name repaidactivate

And I get a naming exception as follows when I run the code....

javax.naming.NameNotFoundException: While trying to lookup 'jdbc.prepaidactivate' didn't find subcontext 'jdbc' Resolved ; remaining name 'jdbc/prepaidactivate'










If some one can see where I am going wrong would be a big help
15 years ago