RE: Can't deploy example atm with datasource db2 (NOW I CAN DEPLOY)
That' s OK. Thank you Joe. Matthias -- Weitergeleitet von Matthias Weiler/AVSG on 15.06.2000 09:24 --- "Joe Walnes" [EMAIL PROTECTED]@orionserver.com on 14.06.2000 18:02:11 Gesendet von: [EMAIL PROTECTED] An: Orion-Interest [EMAIL PROTECTED] Kopie: Thema: RE: Can't deploy example "atm" with datasource "db2" In the database-schemes the "type" is the Java-Class and the "name" is the Column-Type in the database. So the entry for name should be name="long varchar", but what is the entry for type ? java.io.Serializable -Joe Walnes
RE: Can't deploy example atm with datasource db2
How can I change the type-mapping from longvarbinary to longvarchar for the LogEntries ? If you look in [orion-dir]/config/database-schemas you will find a bunch of xml files with type-mappings for various databases. Copy one of these files to db2.xml and edit it to reflect the appropriate type mappings. (see http://www2.orionserver.com/docs/database-schema.xml.html ) In config/data-sources.xml, edit the data-source being used by the application so it has the parameter schema="database-schemas/db2xml". -Joe Walnes
RE: Can't deploy example atm with datasource db2
Hi Esa, Hi Joe ! Thank you for the quick reponse, but my question was not so exactly. Sorry. I know database-schemes. The field "value" is generated for the serialized "LogEntryBeans" from orion. In the database-schemes the "type" is the Java-Class and the "name" is the Column-Type in the database. So the entry for name should be name="long varchar", but what is the entry for type ? Matthias Here is my database-scheme: ?xml version="1.0"? !DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd" database-scheme max-table-name-length="25" name="DB2" not-null="not null" null="" primary-key="primary key" type-mapping type="java.lang.String" name="varchar (255)" / type-mapping type="int" name="integer" / type-mapping type="long" name="integer" / type-mapping type="float" name="float" / type-mapping type="double" name="double precision" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char" / type-mapping type="short" name="integer" / type-mapping type="boolean" name="bit" / type-mapping type="java.util.Date" name="date" / type-mapping type="java.math.BigDecimal" name="decimal(10,5)" / disallowed-field name="parent" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / /database-scheme
RE: Can't deploy example atm with datasource db2
In the database-schemes the "type" is the Java-Class and the "name" is the Column-Type in the database. So the entry for name should be name="long varchar", but what is the entry for type ? java.io.Serializable -Joe Walnes