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

facing problem in taking SQL Server 2005 database backup--regarding

 
Abhishek Reddy
Ranch Hand
Posts: 259
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Iam getting the following exception
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot perform a backup or restore operation within a transaction.

Query:
String backupQuery="BACKUP DATABASE jiffy TO disk=?";

Iam using hibernate for database transactions:

tx =session.beginTransaction();


SQLQuery selectQuery=session.createSQLQuery(backupQuery);
selectQuery.setString(0, path);
selectQuery.executeUpdate();

tx.commit();
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
DDL is non-transactional. Do as the error message tells you and run it outside a transaction.
 
Sagar Rohankar
Ranch Hand
Posts: 2905
1
Java Spring Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The exception says, it can't perform backup operation in transaction, so had you tried removing the "transaction" specific statement, like beginTransaction and commit and re running ?
 
ujjwal soni
Ranch Hand
Posts: 403
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

The problem is that your code opens a transaction and then

try to execute the backup command. See the error message. You need to make the jdbc API not open a

transaction for you. How you do that, I don't know, it would be a jdbc issue, Perhaps in the

connection string, perhaps by using some other function calls in jdbc.

Cheers!!!
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic