Jeff Foflygen

Greenhorn
+ Follow
since Mar 12, 2009
Merit badge: grant badges
For More
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 Jeff Foflygen

Hello,

I am having trouble calling a simple splash screen class from my main application class; My main application class called PUI, with all of my code that is working, I created a very simple splash class called PS. I want the PS to show before the main PUI application loads. Here is the simple code for the PS class.


As you can see the Thread is set for 5000, then I want the main PUI to open. How do I call this class from PUI? also, How do I make this class come first in the load of the entire package?
Thank you, all help will be much appreciated!
14 years ago
Hello,

I need some help or direction if any can; I have a spreadsheet-like view that I created, it is working, but the problem is that it is going to the schema level as opposed to the instance level of the database, and I'm not sure how to make it do that. any thoughts, suggestions, etc... would be more than welcomed. Here is my code that I am using:



then the bulk of the connect and display:
Hello,

Is it possible to call a file with pre-determined queries specific to the application and list them in a drop down? My code right now, you select the schema, then in the next drop down list you select the table within that schema;

Could I lock down in code 1 schema only and then from the + selectTable portion call a file(s) instead of selectTables? I hope this makes sense.

Thanks for any help!
Hello all,

My problem is that my class is not returning data at all and I'm stuck. the culprit I think is my in the class. I need help getting past it. I am posting the whole code so everyone knows what I'm looking at. the prepared statement is being filled out based on a value entered from another class. it works, I have verified, this class allows for people to see a Spreadsheet like view of the query instead of specific data. please, any ideas or help would be awesome! thanks!
Hi,

I put the code in place that you suggested, no errors. Tomcat is installed and running. I go to launch and it does nothing, no errors, warnings, no succeeded, etc.... do I need to put in more code? it should just find the default excel and launch, correct?

thanks!
14 years ago
Hi,

I am wondering if anybody could take a look at this code and tell me if they see why my application/vnd.ms-excel is not opening. I am getting no blatant errors in the code, the only thing that is concerning me is in certain bits of the code I get "Note: This element has no attached source and the Javadoc could not be found in the attached Javadoc." for example, the setContentType("application/vnd.ms-excel"); says that note. below is the code. please help, or any suggestions are welcomed!
14 years ago

Hello,

I have an application that is currently working in returning data from an oracle database. The place where I am getting stuck is display the next set of a resultset with the click of a JButton called "Next" The resultset returns 15 line items, based on a variable that I pass to it from the swing application. some have 3 sets of 15 line items. Here is the code I have in place so far, any help or thoughts would be much appreciated.

Thanks!
Jan,

Thanks for all of your help! I got it figured out. it is working nicely now, what the problem was, was that the String for number of columns to return the data to was also the same string that I was trying to pull from. (hope that makes sense)

I put in this code,


POData is the name of the JTextField in another class, the same one I wanted to pull the variable from to place into the sql statement. I just had to define the string, and the method of that string.

Thanks!
when I change it to setString I get this error message:
Exception in thread "Thread-2" java.lang.Error: Unresolved compilation problem:
The method setString(int, String) in the type PreparedStatement is not applicable for the arguments (int, int)

In the code that you didn't like to much I noticed that the beginning of the SQL statement looked like this:


In the code now that looks better the beginning of the SQL looks like this:


could that be the cause of the error? Eclipse and JDeveloper both want me to setLong.

Thanks!
I did as you suggested; here is what it looks like


Then I added the prepared statement code:


when I click the submit button, I get the following error:
java.sql.SQLException: ORA-01008: not all variables bound

Not too sure what that means? If I place the value in with single quotes, it works and returns my data.

???
Thanks!
Jeff
I printed the SQL statement by itself, entered a value in place of the ? and used TOAD to run it, I had to put a single quotes around the value, once I did that it returned the data that I want.

next I went back to the code that worked before returning the same data. it is below. the one thing that I found different was that this code was before I put in java to call the JTextField to enter the value, this code has the value in place already, when I hit my submit button, it runs this class and returns the data.

I am trying to run an application that is talking to an oracle DB. when I run the application, enter the value into the JTextField, then hit the submit button, I get the error: java.sql.SQLException: ORA-00923: FROM keyword not found where expected
I have checked the SQL, it is correct before anybody ask. If I place single quotes around the ? for my prepared statement, I get the error "invalid column index" take the quotes out, I get the ORA-00923 error. I know it works because if I modify the code and run it with a value in place of the ? like a regular SQL statement it returns the values that are to fill out in my 15 JTextFields of my swing application. any ideas or help would be much appreciated! help!
Here is the code for the JDBC connection class: