File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Query working in sql worksheet but in the program
Joined: Oct 24, 2013
Feb 04, 2014 18:08:04
yesterday I got a very strange error.
my worked fine in sql worksheet but query didn't work in eclipse.
resultset had no element.
In sql worksheet with same query i got 2 elements.
I've cleaned the project and pressed build all.thereafter I restarted eclipse but I got
same very peculiar output.I dunno how to resolve this problem.
pleas help me out.
thanks in advance.
author & internet detective
Joined: May 26, 2003
Feb 04, 2014 20:14:15
The first things to check are:
1) Are you pointing to the same database?
2) Are you using the same user id to connect?
3) Is the data committed?
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Query working in sql worksheet but in the program
JDBC INSERT error
My query works fine at Oracle prompt..fails in JSP page
Strange behaviour when using Oracle TO_CHAR to get day of week
Sorting problem with HibernateSqlQuery with Websphere
When Session Closed Data Will be Lost in Hibernate
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015