The Wiert Corner – Jeroen Pluimers’ irregular stream of Wiert stuff

on .NET, C#, Delphi, databases, and personal interests

  • Twitter Updates

  • My work

  • My badges

  • My Flickr Stream

    DSC_4321

    DSC_4304

    DSC_4301

    More Photos
  • Pages

  • All categories

Firebird/InterBase – “unsupported on-disk structure for file …; found 32779.13, support .”

Posted by jpluimers on 2009/09/03

If you get this error message:

Sep 3, 2009 5:16:24 PM de.aderon.dl.adapter.DataAdapter getConnection
SEVERE: error DataAdapter getConnection : GDS Exception. 335544379. unsupported on-disk structure for file C:\\develop\\Db\\17_20090314.fdb; found 32779.13, support .
Reason: unsupported on-disk structure for file C:\\develop\\Db\\17_20090314.fdb; found 32779.13, support .

Most answers found by google mention that your ODS (on disk structure) is too new for your Firebird version.
But in this case, the portname was pointing to InterBase 2009 (relatively new) in stead of Firebird (2.1.1) also relatively new.

The solution was to fix the connection string:

  <key name="connection_uri"><value>jdbc:firebirdsql:127.0.0.1/3050:C:\\develop\\Db\\17_20090314.fdb</value></key>
  <key name="connection_uri"><value>jdbc:firebirdsql:127.0.0.1/30521:C:\\develop\\Db\\17_20090314.fdb</value></key>

Firebird 2.1.1 was running on port fbs_211 (decimal 30521), but the jdbc Firebird driver does not understand service names like fbs_211, only hard-coded TCP/IP ports like 30521.
InterBase 2009 was running onport 3050.

–jeroen

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>