V2.2 data sources
V2.2 data sources
I see you can "discover" other databases (i.e. oracle, postrgre, etc.). Does V2.2 allow you to select different datasources as backend? Or are we still limited to the three choices for new App development?
-
aware_support
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
As far as "native" support of databases is concerned there are still only Derby, MySQL, SQL Server/MSDE/SQL Express (native support for Oracle is coming soon in an Enterprise Edition).
With non-native support you can work with any database that has a JDBC driver (nowadays it is pretty much any SQL database).
Here are the limitations of a "non-native" support:
1) Attribute types are always "discovered" - if a database table uses some exotic column type that Aware IM cannot work with, it will be ignored
2) You cannot have references to other objects inside an object created from an existing database table (but you can have references to such objects inside other "normal" Aware IM objects)
3) You cannot have Picture or Document attributes in such objects (but you can have BINARY attributes)
4) You have to indicate primary key(s) for objects created from existing database tables. If you don't, you will only be able to query such objects, but you won't be able to view and/or modify individual records.
For many situations these limitations will not be a problem.
With non-native support you can work with any database that has a JDBC driver (nowadays it is pretty much any SQL database).
Here are the limitations of a "non-native" support:
1) Attribute types are always "discovered" - if a database table uses some exotic column type that Aware IM cannot work with, it will be ignored
2) You cannot have references to other objects inside an object created from an existing database table (but you can have references to such objects inside other "normal" Aware IM objects)
3) You cannot have Picture or Document attributes in such objects (but you can have BINARY attributes)
4) You have to indicate primary key(s) for objects created from existing database tables. If you don't, you will only be able to query such objects, but you won't be able to view and/or modify individual records.
For many situations these limitations will not be a problem.
Aware IM Support Team
-
aware_support
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact: