I have embed a query in the JAVA to retrieve the data from the back end and I use Oracle for back end. What I'm trying to do is in my query has been shown below. The issue here is that result set returns the NULL. But fine when I change the query "SELECT 5 FROM DUAL" and it returns 5 for me which right. When I try to run the same at the back end as a query I'm getting proper result.
public String getReturnPart(String partNumberIn) {
//int returnPartNumber = 0;
String query =
"SELECT COUNT(*) AS CHECK1 FROM PART_MASTER PM,UNITS_OF_MEASURE UOM WHERE PM.PART_NUMBER = '" + partNumberIn
+ "' AND PM.UNIT_OF_ISSUE = UOM.UNIT_OF_MEASURE AND UOM.UNIT_TYPE = 0 ";
//String query = "SELECT 5 AS CHECK1 FROM DUAL"; This returns fine as "5"
ResultSet result = null;
Working on chapter 10 of my book which covers exceptions and file I/O. The only part that does not work is line 40 where it is supposed to print getMessage(). It print's null instead of the more verbose error message.
import java.io.*; import java.util.*; import java.text.DecimalFormat; public class SalesReport2 { public static void main(String[] args) { String filename = "SalesData.txt"; int months = 0;
[Code] ....
temp.txt
123.33 asdf 549.85 dsaf 8456.23 21588.22 652.00
My output when using my test file.
ERROR: SalesData.txt does not exist. Enter another filename: temp.txt Nonnumeric data found in file: null The invalid record will be skipped. Nonnumeric data found in file: null The invalid record will be skipped. Number of months: 5 Total Sales: 31,369.63 Average Sales: 6,273.93
I then removed the try catch so that I could get a stacktrace
import java.io.*; import java.util.*; import java.text.DecimalFormat; public class SalesReport2a { public static void main(String[] args)
[Code] ...
This was the output.
ERROR: SalesData.txt does not exist. Enter another filename: temp.txt Exception in thread "main" java.util.InputMismatchException at java.util.Scanner.throwFor(Unknown Source) at java.util.Scanner.next(Unknown Source) at java.util.Scanner.nextDouble(Unknown Source) at SalesReport2a.main(SalesReport2a.java:32)
I also pulled the copy of the code from the CD that came with the book and it's output is the same as my code.
The image in the book shows that the error should be more informative though.
what I get
Nonnumeric data found in file: null
vs
what I should get
Nonnumeric data found in file: For input string: "asdf"
The getGraphics() method in my constructor is returning a nullPointerException and I can't figure out why. This class is extending a JPanel and I thought calling super() would fix it because it makes sense that the JPanel would initialize its graphics object in the constructor, but that didn't fix it. The line that produces the error is in bold. I've narrowed it down to the getGraphics() method is returning null, so the next line that calls the graphics object is actually the one that produces the error.
int leftMargin = 2, rightMargin = 2, topMargin = 2, bottomMargin = 2; int lineSpacing = 1; int currentX = leftMargin, currentY = topMargin; Font defaultFont, customFont; public HTMLFrame(){ super();
[Code] ....
print(String) is a method I made that draws lines of text on the graphics object, similar to System.out.println(String) in the command prompt.
I'm using NetBeans to create this project and I have the gui registering text boxes, but it won't retrieve what the user entered, so the calculate button returns a null exception error.
In Oracle SQL, when you do trim(column_name), if column_name is blank spaces only (say datatype is CHAR(8)), then "trim(column_name) is null" is true.
In JPQL, if you do "TRIM ( BOTH FROM p.column_name ) is null", does it evaluate to true just like in Oracle SQL?
The reason I'm asking, is my colleague wrote some code in JPQL like below:
... TRIM ( BOTH FROM CONCAT(p.column_name, '#@') ) = '#@'
He said he originally wanted to compare the TRIM result to empty String '', but the result is false, so he concat the column to some junk.
So if after the TRIM, the result is the same junk he added, then the column contains only blanks. I think this works but there could a simpler way to do it.
I want to embed an existing JAVA applet in to my swing application which is a standalone application. The applet is used in some other application which is not developed by me or my company. The application is open source application (So I have the source code). The entire existing application is basically one of the parts of my new application.
I am having a problem with a PreparedStatement for a MySQL query, where the query seems to get cut off. I can't really post a self contained example, because it involves an SQL database.The part of the code with the problem...
Java Code:
public void insertEntry( Hashtable<String, String> strings, Hashtable<String, Integer> integers, Date created, Date paid, boolean enabled) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver");
[code]....
The output of the whole program, though all it has done so far is create some default values and attempt to insert them with the above code, where the problem occurs.
Debug: SQLpaid = 1990-03-21
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT enabled=0, username='default_username', created='2000-03-21', paid='1990-' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45)
I seem to be having a issue with my java console app what it should do is query a SQL DB and list the user details (userid, firstname ,lastname) from the user table, and the users stocks (stockname ,stockdiscription) associated to each user from the userstocks table if I'm thinking correctly!
I'm sure it is just a logical error, but I'm not sure of the way to get the out put I'm looking for. I will add the makeDB.java file and DatabaseQuery.java file as well as the current Exception(Run Time Exception) below.
**I have added other users and stocks manually - Not just what the MakeDB.java file inserts **
Output and Exception:
Stock holdings by User User ID User Name Stock - Description ------------------------------------------- admin01 Default Admin Exception in thread "main" java.sql.SQLException: ResultSet is closed at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6647 ) at sun.jdbc.odbc.JdbcOdbcResultSet.next(JdbcOdbcResultSet.java:1248) at DatabaseQuery.main(DatabaseQuery.java:45) Press any key to continue . . .
Java Code:
MakeDB.java: import java.sql.*; import java.io.*; public class MakeDB { public static void main(String[]args) throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
I have code which query value from database, the use case is the user can enter value as 1,01,11 in database but when the user enter value in xml file he can only enter 11,01,12 in database there is two columns lets say column test1=1 and test2=2 combination of this is 12, which is the value the use will enter in xml, but sometime the use can enter test1=04 than column test2=00 how can i approach this
I got table called card with column crdind,crdpos1,cardpos2 as primary key. The user can enter value as
The rule say if you enter one number in crdpos1 eg 2 than you must enter value in crdpos2 it can be any number 1-9 but if you enter 00-09 in crdpos1 than crdpos2 is 00
The challenge I have is to query this value after they been enter. I have xml file which got field crdpos the use enter 15 which is the combination of column crdpos1=1 and crdpos2=5 ... How can I split the value crdpos and got and able to query in database in two separate column ....
I've a small question relating to type promotion I can't find an answer for on the web. Basically in your code if you have :
byte b = 0; b = b + 1;
The compiler will complain about the result being an int which cannot be assigned to a byte. That I understand, as b on the right hand side of the expression is promoted to an int and the result of the addition is an int. However the following does compile :
byte b = 0; b++;
Does the post increment not carry out the post increment as "give me the value of b and then add 1 to b" where I would have expected 'add 1 to b' to do the same integer promotion as the previous example ? The compiler will also allow the following
my aim is to make a runnable jar. I've made a program using swings which uses MS Access database to fetch records. So, I've used an absolute path to refer to the database for connection. Now, I intend to distribute this runnable jar to other people as well. So I guess the best option would be to embed the MS Access database as well in the jar file. But I don't know how to do that. Where should I keep the database in my Project Explorer ? Should I use a relative path etc.
Its required to create a service to embed widgets on any foreign website(server), using servlets where i'll pass encrypted widgetId and in turn i will get html for displaying it on screen. Also a refresh button with the embedded widget is to be provided so as to fetch updated computed data. The point is that user should copy some html/script code and place it on his website.
I am thinking of following approach.An empty span with id, followed by a js script to make ajax call to the server to get widget HTML.
public class Test { public static void main(String[] args) { Car c = new Car(); c.setInf("toyota", "red"); System.out.println("name: "+ c.brand + " colour: " + c.colour);
[code]....
Why do I get the result brand null, colour null? I know what null means but what am I missing here?
i have a j sf application that is using web-services to communicate to another application and pass some parameters to it.The application has three methods one to call the webservice,another to insert some values into a database and the third method to call the two methods when i click a button in a form.The methods a are
update() this is for calling a webservice and passing parameters to it. insertt() to in sert to a database. all() to call the above two.
when i call upadate and insertt in all method am getting an error java lang null pointer exception but when i call just one of the methods it executes successfully.This is my code package softmint.com;
My project consists of a web app where a user can select a area from a picture and f.e. if it is a office layout he can input the worker name and any peace of hardware that the area might have. In this case there are two categories: Hardware and Computer. Hardware - it has 5 dropdown lists consisting of printer, scanner and etc. Computer - like Hardware consists of many dropdown lists which add up to components such as processor, motherboard and etc. For me, considering this is my first ever web app project, is a huge step towards web development, I have used various mixes of Java, javascript and primefaces code.
My current problem: When a user selects an area he gets a dialog box where he is prompted to select his desired input, afterwards the user clicks the 'save' button and get's another dialogbox which has a resume of what he has selected so he could check out his input and save it by clicking the 'save' button in the resume box. My problem is that when the user clicks the save button the button calls a method which takes all the input and creates an Area object (Area object consists of various objects such as: Coordinates, Dimensions, Employee, ComputerList and HardwareList) and sends a query to the database, but all the values I get is null.
XHTML code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:ui="http://java.sun.com/jsf/facelets" xmlns:h="http://java.sun.com/jsf/html" xmlns:f="http://java.sun.com/jsf/core" xmlns:p="http://primefaces.org/ui">
I am trying to parse a XML string into `org.w3c.dom.Document` object.
I have looked at solutions provided [here](xml - How to convert String to DOM Document object in java? - Stack Overflow), [here](How to create a XML object from String in Java? - Stack Overflow) and a few other blogs that give a variation of the same solution. But the `Document` object's #Document variable is always null and nothing gets parsed.
Here is the XML
XMLMappingValidator v = new XMLMappingValidator("<?xml version="1.0" encoding="utf-8"?> " + "<mapping> " + "<container> " + "<source-container>c:stem.csv</source-container>
[Code] ....
When I call **v.getXML().toString()** I get `[#document: null]`
Clearly, the parse is failing. But I don't understand why.
I am trying to parse a XML string into `org.w3c.dom.Document` object.
I have looked at solutions provided [here](xml - How to convert String to DOM Document object in java? - Stack Overflow), [here](How to create a XML object from String in Java? - Stack Overflow) and a few other blogs that give a variation of the same solution. But the `Document` object's #Document variable is always null and nothing gets parsed.
Here is the XML
Java Code:
XMLMappingValidator v = new XMLMappingValidator("<?xml version="1.0" encoding="utf-8"?> " + "<mapping> " + "<container> " + "<source-container>c:stem.csv</source-container>
[Code] .....
When I call Java Code: **v.getXML().toString()** mh_sh_highlight_all('java');
I get Java Code: `[#document: null]` mh_sh_highlight_all('java');
Clearly, the parse is failing. But I don't understand why.
users are trying saving or updating incident request on website they are able to see fault string =Java.lang.stackoverflow : null when saving or updating ticket request on flex with Java hibernate.
