• Post Reply Bookmark Topic Watch Topic
  • New Topic

Function sequence error  RSS feed

 
sakthivel shan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,
while loading this frame i am gettting the following error...
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:1902)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:1810)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java, Compiled C
ode)
at UserInterface.getData_polleddetailspanel(UserInterface.java, Compiled Code)
at UserInterface$PolledDetailsPanel.<init>(UserInterface.java:374)
at UserInterface.<init>(UserInterface.java:35)
at UserEntry$1.actionPerformed(UserEntry.java:107)
at java.awt.Button.processActionEvent(Button.java:308)
at java.awt.Button.processEvent(Button.java:281)
at java.awt.Component.dispatchEventImpl(Component.java, Compiled Code)
at java.awt.Component.dispatchEvent(Component.java, Compiled Code)
at java.awt.EventQueue.dispatchEvent(EventQueue.java, Compiled Code)
at java.awt.EventDispatchThread.pumpOneEventForComponent(EventDispatchThread.ja
va, Compiled Code)
at java.awt.EventDispatchThread.pumpEventsForComponent(EventDispatchThread.java
:95)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:90)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
i tried out all the combinations of function calling sequences...but still it is throwing the error....could any one pl. sort out the problem....
bye & waiting for ur reply,
Sakthivel S.

(edited by Cindy to format code . . . ALLLLLLL of it ).
[ November 12, 2002: Message edited by: Cindy Glass ]
 
Murali Nanchala
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The root cause is the SQL Exception. Possibly on the lines
ResultSet resultset=stmt.executeQuery("Select * from pollingdetails;");
stmt.executeUpdate("Insert into profile values(" + "'"+ basedir +"'" + "," + "'"+ inputbasedir +"'" + "," + "'"+ ccode +"'" + ");");
stmt.executeUpdate("insert into pollingdetails values(" + "'"+ innervector.elementAt(0) +"'" + "," + "'"+innervector.elementAt(1)+"'" + "," + "'"+innervector.elementAt(2)+"'" + "," + "'"+innervector.elementAt(3)+"'" + "," + "'"+innervector.elementAt(4)+"'" + "," + "'"+innervector.elementAt(5)+"'" + ");");
You probably don't need the semi-colon in the SQL. Try without those.
Murali
[ November 13, 2002: Message edited by: Murali Nanchala ]
[ November 13, 2002: Message edited by: Murali Nanchala ]
 
Philip Shanks
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Murali is correct... remove the ';' from your SQL query strings.
PCS
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!