File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes sqlUtil.setSQL exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sqlUtil.setSQL exception" Watch "sqlUtil.setSQL exception" New topic
Author

sqlUtil.setSQL exception

Shun Aqieza
Greenhorn

Joined: Feb 20, 2012
Posts: 5

Hi,

I have a problem with Java to set SQL.




However it Hit exception like below.






Can nay one help me?

My environment is j2sdk1.4.2_05.
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

what is sqlUtil it doesn't appear to be standard java, what we actually need to see is the code for SQLUtil.setSql as that is where the error is.

and can you debug out the contents (currently line 7) to before the setSql so we can see what string you are trying to set.

Shun Aqieza
Greenhorn

Joined: Feb 20, 2012
Posts: 5

Hi,


Full Query should be like this,

SELECT PARAMNAME, CODE, DESCRIPTION, ALTDESCRIPTION FROM PARAM ORDER BY PARAMNAME, CODE


and expected output should be,




Can it be due to jdk didn't support?
because when i'm run at j2sdk1.4.2_09 it will run fine.

However it hit exception in j2sdk1.4.2_05
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

Shun Aqieza wrote:Hi,


Full Query should be like this,

SELECT PARAMNAME, CODE, DESCRIPTION, ALTDESCRIPTION FROM PARAM ORDER BY PARAMNAME, CODE


and expected output should be,




Can it be due to jdk didn't support?
because when i'm run at j2sdk1.4.2_09 it will run fine.

However it hit exception in j2sdk1.4.2_05


i don't want to know what it SHOULD be like, i want to know what it is ACTUALLY.

And you haven't answered a single one of my questions.
Shun Aqieza
Greenhorn

Joined: Feb 20, 2012
Posts: 5

Hi,

I didnt understand your question cause my query only select statement without any special parameter to be fit in..


SELECT PARAMNAME, CODE, DESCRIPTION, ALTDESCRIPTION FROM PARAM ORDER BY PARAMNAME, CODE

Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

the questions about sql util, what is it, is it part of standard sql, is it a home grown utility, is it an open source library?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sqlUtil.setSQL exception