0 Replies Latest reply on May 25, 2005 6:48 AM by andrzejros

    jboss 4 and postgres sql schema

    andrzejros

      Hi!

      Is there any way to define database schema (i mean schema created using create schema test) with cmp engine? looked around but can't find suitable parameter for this. I have datadabase in postgres, and want to locate my tables in one DS but in different schemas - other than public. When added test. prefix to table name indexes are generated with it too, ie. create index test.test_idx on test.test (field); database cannot accept such name (dot cannot be a part of index name) is there any way to specify it globaly or even per bean or - manualy name db index when using create-table/alter-table options ?