aspose file tools*
The moose likes JDBC and the fly likes want to create backup frm java desktop application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "want to create backup frm java desktop application" Watch "want to create backup frm java desktop application" New topic
Author

want to create backup frm java desktop application

Mark Kafe
Ranch Hand

Joined: Jun 23, 2008
Posts: 60

Hey,

i want to backup of Db sql 2000 from java desktop application i use this code for this..........




but one error occure ...........i not understand how i call this storeprocedure because i m new in this line............e no idea how can i correct it..

i know the error for calling in store procedure i not give proper parameters............but i hav

error log here


com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near '{'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at CarShowRoomSystem.Admin.jButton1ActionPerformed(Admin.java:339)
at CarShowRoomSystem.Admin.access$100(Admin.java:21)
at CarShowRoomSystem.Admin$2.actionPerformed(Admin.java:80)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6134)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5899)
at java.awt.Container.processEvent(Container.java:2023)
at java.awt.Component.dispatchEventImpl(Component.java:4501)
at java.awt.Container.dispatchEventImpl(Container.java:2081)
at java.awt.Component.dispatchEvent(Component.java:4331)

 
wood burning stoves
 
subject: want to create backup frm java desktop application
 
Similar Threads
Using Sun's Migration Tool...
Compilation problem Java function in Oracle
how to handle data gotten from CLOBs?
Exception related to JDIC.
java.rmi.UnmarshalException: error unmarshalling return USING NetBeans