java - Connecting to Oracle with JDBC causes queries to return zero rows. -


so have been playing around querying databases using standard 

statement s = connection.createstatement(); resultset rs = s.executquery(querystring); resultsetmetadata rsmd = rs.getmetadata();  while(rs.next)){    string code = "";    string value = "";     for(int = 1; <= rsmd.getcolumncount(); i++){       object obj = rs.getobject(i);       if(i == 1){           code = obj.tostring():       }       else{           label = obj.tostring();       }    }    //store code , labels in map }  ...go on close statement , move on.

i trying select 2 columns table in each instance.

for part works well. when working mysql & microsoft sql databases result set full of data in table. when try oracle database empty result set.

i have tested query string in sql developer application , works fine, returns data. result set doesnt contain anything. resultset metadata says has 2 columns though. there need when interacting oracle database different other two? thanks.

if query works when run against oracle database, , know code works since you've run against mysql, other things try are:

1.) make sure jdbc connection url correct. sure connecting database intend to? (i.e. - 1 return rows expect?)

2.) take account credentials. make sure using same credentials through jdbc when connecting oracle directly.

3.) make sure both connections being made same machine , same environment. oracle drivers rely on environment variables find file (i believe called tnsnames.ora, or that) contains alias & connection info. getting different versions of file point different oracle instances.

4.) try manually specifying schema name in query. instead of select * my_table use select * my_schema.my_table. oracle clients configure sessions have default schemas set in preferences.

5.) if attempting select data you've inserted oracle client, make sure you've committed transaction in oracle client data visible other sessions.

one last debugging tool use try connecting via squirrel db client. squirrel 100% pure java sql client connects db using jdbc. test make sure jdbc driver, connection url, etc. valid.


Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true"> ...
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode ...
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release...
Read more