Hi,

I get indeterministically the same Internal Server Error when creating new transactions that I get from my database. Sometimes the code below creates 1, 2, 5 or so transactions before throwing the error below. I have adapted the sample code.

The error occurs here: TransactionEntry insertedEntry = service.insert(new URL(feedUrl), entry);

I have tried putting a sleep command to delay transaction creation a bit. .

Any ideas?

/** * @param args server, user email, and user password in that order. */ public static void main(String[] args) throws Exception {

BasicConfigurator.configure(); // should use log.properties instead! TODO log.info("Starting StrategyEvaluator...");

// Create ratings db connection: Class.forName("org.sqlite.JDBC"); dbConnection = DriverManager.getConnection("jdbc:sqlite:var/....dbev");

// Google Finance GData service. FinanceService service = new FinanceService("Google- PortfoliosDemo-1.0"); Scanner sc = new Scanner(System.in); System.out.println("Sample Google Finance Portfolios Client"); if (args.length != 1 && args.length != 3) { printUsage(); System.exit(0); } // Set username and password from command-line arguments if they were passed // in. Otherwise prompt the user to login. if (args.length == 3) { userEmail = args[1]; userPassword = args[2]; } else { System.out.print("Enter user ID: "); userEmail = sc.nextLine(); System.out.print("Enter user password: "); userPassword = sc.nextLine(); } if (!loginUser(service, userEmail, userPassword)) { printUsage(); System.exit(0); } server = args[0]; baseUrl = server + basePath + "default";

portfolioIdProperty = "2";

Statement stat = dbConnection.createStatement();

ResultSet allTradesRs = stat.executeQuery("select * from _trades_5starSimpleFew where symbol=='JOBS';"); while (allTradesRs.next()) { tickerProperty = "NASDAQ:" + allTradesRs.getString(StockrConstants.DB_TRADES_SYMBOL); // TODO remove hardcoded exchange String requestUrl = baseUrl + PORTFOLIO_FEED_URL_SUFFIX + "/"; //System.out.println("requestUrl before: " + requestUrl); requestUrl += portfolioIdProperty + POSITION_FEED_URL_SUFFIX + "/" + tickerProperty + TRANSACTION_FEED_URL_SUFFIX; //System.out.println("requestUrl after: " + requestUrl); String type = allTradesRs.getString(StockrConstants.DB_TRADES_ACTION); String date = allTradesRs.getString(StockrConstants.DB_TRADES_DATE); String shares = allTradesRs.getString(StockrConstants.DB_TRADES_AMOUNT); String price = allTradesRs.getString(StockrConstants.DB_TRADES_PRICE); String commission = "0.0"; String currency = ""; // exchange determines the currency String notes = ""; TransactionEntry entry = FinanceUtilities.makeTransactionEntry( type, date, shares, price, commission, currency, notes); insertTransactionEntry(service, requestUrl, entry); Thread.sleep(5000); // causes indeterministic errors, perhaps a sleep might help? }

//_______________________ // Shut down ratings db connection dbConnection.close();

}

the log:

... Sample Google Finance Portfolios Client Inserting Entry at location: http://finance.google.com/finance/feeds/default/portfolios/2/positions/NASDAQ:JOBS/transactions Exception in thread "main" com.google.gdata.util.ServiceException: Internal Server Error An error occurred while processing the request

at com.google.gdata.client.http.HttpGDataRequest.handleErrorResponse(Unknown Source) at com.google.gdata.client.http.GoogleGDataRequest.handleErrorResponse(Unknown Source) at com.google.gdata.client.http.HttpGDataRequest.checkResponse(Unknown Source) at com.google.gdata.client.http.HttpGDataRequest.execute(Unknown Source) at com.google.gdata.client.http.GoogleGDataRequest.execute(Unknown Source) at com.google.gdata.client.Service.insert(Unknown Source) at com.google.gdata.client.GoogleService.insert(Unknown Source) at portfolioevaluation.GFinanceUploader.insertTransactionEntry(GFinanceUploader.java: 1002) at portfolioevaluation.GFinanceUploader.main(GFinanceUploader.java: 1132)