Hi Ryan,
I got the (dumb) problem: I was using
charSet=iso8859_1
instead of
charSet=ISO8859_1
I red somewhen and somewhere to use the first syntax, and the driver
didn't complain about the incorrect charset definition.
Thank you Ryan and thank you Helen for your help!
Regards
Massimo


--- In Firebird-Java@yahoogroups.com, "Ryan Baldwin"
<ryan.baldwin@n...> wrote:

> 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@y...]
> 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