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 sql query is not working in jboss... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sql query is not working in jboss... " Watch "sql query is not working in jboss... " New topic
Author

sql query is not working in jboss...

chaitanya kiran pvn
Greenhorn

Joined: Nov 01, 2007
Posts: 25
hai

i have one problem in jsp with sql tag in but this tag is working in weblogic but it wont work in jsp when i change into datasource=${ds}.
give any help on this.

hear i post my tag



i change the tld version to 1.1
thanks in advance
chaitanya
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10289
    
168

When you say, its not working, do you see any error messages? I don't have much knowledge about how that tag is supposed to work and this question looks more related to JSP than JBoss. I will move this to the JSP forum where you might get a solution.

Moderators: If later, this turns out to be JBoss specific issue, please feel free to move it back to the JBoss forum.


[My Blog] [JavaRanch Journal]
Hongli Li
Ranch Hand

Joined: Oct 29, 2006
Posts: 124
if any of the table has blob or clob field, you need to make sure your query is in side of a transaction.


Do you know why this cup is useful? Because it is empty.
chaitanya kiran pvn
Greenhorn

Joined: Nov 01, 2007
Posts: 25
hai

iam using this as dynamic table creation of my reacent actiity from mssqlserver database but it throws in sql exception. in runtime jsp.

i am not using any blob are clob in my application.

thanks in advance
chaitanya
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql query is not working in jboss...