|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
|
|||
|
|||
|
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. |
|
#2
|
||||
|
||||
|
Are you shure about your code, what you posted
Quote:
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
||||
|
||||
|
Shure, the exact code that gives you an error of course
|
|
#5
|
|||
|
|||
|
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. |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > FBSQLException 335544358 message length error (encountered 0, expected 8) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|