aspose file tools*
The moose likes JDBC and the fly likes query problem in jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "query problem in jsp" Watch "query problem in jsp" New topic
Author

query problem in jsp

Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
i am running my following query in my jsp page but its goint into catch part & showin unable to connect to database



please help me
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61756
    
  67

You should not be doing JDBC in a JSP. Move the code to a Java class where it will be easier to debug.

Moved this to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61756
    
  67

Explain how you are establishing the DB connection. And if that's in a JSP too, then it needs to be moved to a Java class.
Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
thanks bear for showing your concern actually everything is right except that my role field is integer & logintype is string thats the problem
Sunny Bhandari
Ranch Hand

Joined: Dec 06, 2010
Posts: 448

Aditi,

you are showing us the query code and the problem as unable to connect to database.

Please share full code of making the connection and invoking that query.

This will help you and us to resolve this in one go.

Anyways, to resolve that problem, I will straight away run the query on DB console with hard coded values.

If the query runs fine then probably my connection has not established.


Java Experience
Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
thank you sunny for your reply but as i mentioned above that my connection is allright but instead in my query role is an integer & logintype is a string thats what the problem is


unable to connect database i sshown because i have printed it on the catch part

if you have any solution for that please share it with me

thank you
Swastik Dey
Rancher

Joined: Jan 08, 2009
Posts: 1479
    
    6

Could you please explain, what exactly are you trying to achieve with this query?


Swastik
amit punekar
Ranch Hand

Joined: May 14, 2004
Posts: 516
Hello,

("select * from ams_menuitems where role is (select logintype from ams_login where loginname= '"+user1.trim()+"');");


Shouldn't the query have "IN" instead of "is" ?

Also subquery will not need the ";" as per my interpreation of the query posted above.

Regards,
Amit
Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
hey swastik actually i have username who is logged in nnow i want on basis of his logintype i should get roles on my jsp page

i cannot change logintype from character to integer as it will effect other forms also

hey amit i have tried is in like = everything but nothing is working
Swastik Dey
Rancher

Joined: Jan 08, 2009
Posts: 1479
    
    6

Aditi

You don't have to change the data type in underlying table, but you can always use some conversion function in the query. What database are you using?

Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
thank you all of you for your reply & also sory for wasing your time i have now changed my logintype datatype

its the only solution which i think is remaining
Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
Swastik i am using Postgre SQL
Swastik Dey
Rancher

Joined: Jan 08, 2009
Posts: 1479
    
    6

I haven't worked on this, but your query might go somewhat like this, if you don't wish to change the data type in table.

select * from ams_menuitems where role in (select to_number(logintype,'999') from ams_login where loginname= '"+user1.trim()+"'")

http://www.postgresql.org/docs/7.4/static/functions-formatting.html
Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
i must say swastik you are a genius

you have solved my 2 major problems thank you thank you so much
Swastik Dey
Rancher

Joined: Jan 08, 2009
Posts: 1479
    
    6

Glad to be of some help.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: query problem in jsp