This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

use a database schema from java using jdbc

 
suman deb
Ranch Hand
Posts: 54
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am trying to execute a sql query from java using jdbc and its throwing me an db exception. here is the code -
----------------------------------------------------------------------------------------------
String query = "use primus \ngo\n";
query = query + "select o.name , text = convert(char(255) not null, text) " +
"from sysobjects o, syscomments s "+
"where o.type = 'P' and s.id = object_id(o.name) order by o.name";
PreparedStatement st = conn.prepareStatement(query);
ResultSet rs = st.executeQuery();
---------------------------------------------------------------------------------------------
and here is the exception -
SQL Exception:Incorrect syntax near 'go'.

But the same code is working when I am running it directly in the database.

Please help

Thanks
Suman
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Suman,
That looks like two statements. Why not write it as one?

from primus.sysobjects o
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic