SunQuest
           Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Firebird SQL Development
Reload this Page

FBSQLException 335544358 message length error (encountered 0, expected 8)

Discuss FBSQLException 335544358 message length error (encountered 0, expected 8) in the Firebird SQL Development forum on Dev Shed.
FBSQLException 335544358 message length error (encountered 0, expected 8) Firebird SQL Development forum discussing administration, Firebird SQL syntax, or other Firebird SQL-related topics. Firebird is the evolution of Borland's Interbase product.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!
  #1  
Old April 22nd, 2008, 12:42 PM
Klava Klava is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 3 Klava User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 41 m 32 sec
Reputation Power: 0
Question FBSQLException 335544358 message length error (encountered 0, expected 8)
Hi,
I am trying to execute stored procedure.
When I do it from SQL command line, data gets inserted just fine. I do select *. The data is there, everything looks good.
If I am trying to execute the same stored procedure from within Java code (below are parts of it):
PreparedStatement stm = null;
ResultSet r;
r = stm.executeQuery();
I get this error:
FBSQLException 335544358 message length error (encountered 0, expected 8)
I am able to execute another stored procedure using the same Java code. String "Execute Procedure..." looks exactly the same in Java and in SQL command line. Have you ever seen above error? What could be causing it?
Thank you in advance.
Reply With Quote
  #2  
Old April 22nd, 2008, 12:55 PM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,620 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 3 Days 23 h 47 m 19 sec
Reputation Power: 259
Are you shure about your code, what you posted
Quote:
PreparedStatement stm = null;
ResultSet r;
r = stm.executeQuery();
shouldn't work
Reply With Quote
  #3  
Old April 22nd, 2008, 12:58 PM
Klava Klava is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 3 Klava User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 41 m 32 sec
Reputation Power: 0
code
I posted a small part of it. Let me know if you need much more info. It works fine for other stored procedure.
Do you want more info?
Thanks.
Reply With Quote
  #4  
Old April 22nd, 2008, 01:04 PM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,620 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 3 Days 23 h 47 m 19 sec
Reputation Power: 259
Shure, the exact code that gives you an error of course
Reply With Quote
  #5  
Old April 22nd, 2008, 03:58 PM
Klava Klava is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 3 Klava User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 41 m 32 sec
Reputation Power: 0
Fixed it.
I fixed it. It turned out to be known firebird bug. I used "select * from PROC_NAME..." instead of "execute PROC_NAME..." and it worked.
Thank you for looking into this anyway.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > FBSQLException 335544358 message length error (encountered 0, expected 8)

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway.