Subject | Re: [Firebird-Java] How to set charset,SQL Dialect with FBManager!!! |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-12-15T06:10:51Z |
> I'm using Jaybird 2.0 and Firebird 1.5.2.I use service FBManager to createIt seems that Firebird ignores the DPB that is passed in the
> a new database by method createdatabase(String,String,String), but I find
> no way to set charset,SQL dialect for the new database.
isc_create_database call. You can change the SQL dialect by connecting to
the database with the isc_dpb_set_db_sql_dialect=1 connection property, it
will change the default dialect. In order to change the default character
set, you have to update the RDB$DATABASE table.
> I mean that how to set up a databaseparameterbuffer and pass it toWe have tried this many times, but since it does not work, there is no
> FBManager .
public method to set the DPB.
> And one more thing,when I execute a DDL statement like CREATEAlso does not work. This statement is used in isql and it uses
> DATABASE...in Java using a connection of another database file,it always
> return error.Isthere any way to execute that sql statement?
isc_dsql_execute_immediate, but again, so far I did not manage to make it
work in Jaybird. Neither in existing connection, nor in fresh one.
Roman