Hi Massimo,

Its the following line from the stack trace that makes me belive that that
is the problem:

Implementation of text subtype 21 not located.

>If I run the code with firebird 1.5 (service)
>and jaybird 1.5 type 4 client I get same (or quite the same) error.

Does the error message in this case include the line above ? If so are you
absolutly sure this isnt
somehow getting mixed up with the embedded server ?(Again you could check
with tool described bellow
that your process has not loaded fbmebed.dll).

>I think fbintl.dll should have been loaded, since the statements
> - SELECT RDB$CHARACTER_SET_NAME, RDB$CHARACTER_SET_ID FROM
> RDB$CHARACTER_SETS ORDER BY RDB$CHARACTER_SET_NAME
> - SELECT RDB$COLLATION_NAME, RDB$CHARACTER_SET_ID FROM RDB$COLLATIONS
> ORDER BY RDB$COLLATION_NAME
> show ISO8859_1, 21 in their result.

I dont know if this proves that fbintl.dll is loaded ...

Perhaps you could try using PE explorer( http://www.heaventools.com/ ) just
too double check that fbintl.dll is being
loaded after fbembed.dll.

If none of this helps - and you see fbintl.dll is definatly being loaded
after fbembed.dll then let us know - but I've never seen
"Implementation of text subtype 21 not located" in an error message for any
other reason.


Thanks
Ryan

-----Original Message-----
From: mapofe [mailto:mapofe@...]
Sent: 23 February 2004 13:06
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Charset problem


Sorry for the re-post, I forgot to say that if I run the same code
using the same database file, but using firebird 1.0.3 and jaybird
1.0.1 I get no error. If I run the code with firebird 1.5 (service)
and jaybird 1.5 type 4 client I get same (or quite the same) error.
Regards
Massimo

--- In Firebird-Java@yahoogroups.com, "mapofe" <mapofe@y...> wrote:
> Ryan, thank you for your answer.
> I think fbintl.dll should have been loaded, since the statements
> - SELECT RDB$CHARACTER_SET_NAME, RDB$CHARACTER_SET_ID FROM
> RDB$CHARACTER_SETS ORDER BY RDB$CHARACTER_SET_NAME
> - SELECT RDB$COLLATION_NAME, RDB$CHARACTER_SET_ID FROM RDB$COLLATIONS
> ORDER BY RDB$COLLATION_NAME
> show ISO8859_1, 21 in their result.
>
> I have set up the embedded engine as explained in the readme file,
> i.e. in the application root dir:
> - fbembed.dll
> - ib_util.dll
> - firebird.msg
> - firebird.conf (RootDirectory set)
> - intl/fnintl.dll
> - udf/fbudf.dll
> - jaybird.dll
>
> Regards
> Massimo
>
> --- In Firebird-Java@yahoogroups.com, "Ryan Baldwin"
> <ryan.baldwin@n...> wrote:
> > Hi,
> >
> > >I can't import data since I continuosly get the following error
> > >message and I have no more ideas :)
> >
> > This is most likley as a result of firebird not being able to load
> > fbintl.dll. Sadly when firebird
> > cannot find this dll it doesent complain - but often fails too work as
> > expected - in this case though it seems
> > to have handled the problem in the way that is expected.
> >
> > The solution is too ensure that fbintl.dll(and for that matter the
> entire
> > fbembed directory structure) is in the 'correct' place. If using
> > fbembedd.dll with jaybird then please check in the forum for posts
> > containing the work 'type2' and you should find discussion as too
> where this
> > directory structure needs too be for jaybird.
> >
> > Thanks
> > Ryan
> >
> > -----Original Message-----
> > From: mapofe [mailto:mapofe@y...]
> > Sent: 23 February 2004 11:31
> > To: Firebird-Java@yahoogroups.com
> > Subject: [Firebird-Java] Charset problem
> >
> >
> > I'm trying to import some data from an access database (sun's
> > jdbc-odbc driver) to a firebird embedded (1.5 final) database.
> > The embedded database has ISO8859_1 as default charset, I'm using
> > ?charSet=iso8859_1 in the connection string.
> > I can't import data since I continuosly get the following error
> > message and I have no more ideas :)
> > Any hints would be appreciated, thank you!
> > Massimo
> >
> > ERROR [DBCExceptionReporter] - could not insert:
[InstrumentType#347121]
> > org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321.
> > arithmetic exception, numeric overflow, or string truncation
> > Implementation of text subtype 21 not located.
> > at
> >
>
org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPrepa
> > redStatement.java:445)
> > at
> >
>
org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPrepare
> > dStatement.java:147)
> > ...
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links




Yahoo! Groups Links