Hi !. I'm using Microsoft sql server and not MySQL. Happy to Know that is not an Ojb problem, so I have just to fix on my code. Martin Post has me make to think if I have to configure something in repository-database.xml. that's my jdbc-connection-descriptor : <jdbc-connection-descriptor jcd-alias="default" default-connection="true"platform ="MsSQLServer" jdbc-level="2.0" driver=" com.microsoft.jdbc.sqlserver.SQLServerDriver" protocol="jdbc" subprotocol=" microsoft:sqlserver" dbalias="//walqasrv01:1433;DatabaseName=trayectorias"username ="steria" password="filemon" eager-release="false" batch-mode="false"useAutoCommit ="0" ignoreAutoCommitExceptions="false">
<connection-pool maxActive="5" maxIdle="2" maxWait="3"minEvictableIdleTimeMillis ="4" numTestsPerEvictionRun="5" testOnBorrow="true" testOnReturn="true"testWhileIdle ="true" timeBetweenEvictionRunsMillis="6" whenExhaustedAction="2"validationQuery ="select 1 from sysobjects" logAbandoned="true" removeAbandoned="true"removeAbandonedTimeout ="8"/> <sequence-manager className=" org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl"> <attribute attribute-name="autoNaming" attribute-value="false"/> </sequence-manager> </jdbc-connection-descriptor> I send you the involved part of repository.xml too. <class-descriptor class="com.steria.tc.vo.DiagnosticoVO" table="MDIAG"> <field-descriptor id="1" name="codigo" column="codigo" jdbc-type="VARCHAR"primarykey ="true" autoincrement="false"/> <field-descriptor id="3" name="descripcion" column="descripcion" jdbc-type=" VARCHAR"/> <field-descriptor id="4" name="texto" column="texto" jdbc-type="VARCHAR"/> <field-descriptor id="3" name="codmclas" column="codmclas" jdbc-type=" VARCHAR"/> <field-descriptor id="4" name="fcrea" column="fcrea" jdbc-type="TIMESTAMP"/> <field-descriptor id="5" name="usucrea" column="usucrea" jdbc-type="VARCHAR "/> <field-descriptor id="6" name="fmodif" column="fmodif" jdbc-type="TIMESTAMP "/> <field-descriptor id="7" name="usumodif" column="usumodif" jdbc-type=" VARCHAR"/> <reference-descriptor name="claseVO" class-ref="com.steria.tc.vo.ClaseVO"auto-retrieve ="false"> <foreignkey field-ref="codmclas"/> </reference-descriptor> <collection-descriptor name="diagInteVOs" element-class-ref=" com.steria.tc.vo.DiagInteVO" orderby="codinte" sort="ASC" auto-retrieve=" false" auto-update="true" auto-delete="object"> <inverse-foreignkey field-ref="coddiag"/> </collection-descriptor> <collection-descriptor name="diagObjeVOs" element-class-ref=" com.steria.tc.vo.DiagObjeVO" orderby="codobje" sort="ASC" auto-retrieve=" false" auto-update="true" auto-delete="object"> <inverse-foreignkey field-ref="coddiag"/> </collection-descriptor> <collection-descriptor name="diagCDefVOs" element-class-ref=" com.steria.tc.vo.DiagCDefVO" orderby="codcdef" sort="ASC" auto-retrieve=" false" auto-update="true" auto-delete="object"> <inverse-foreignkey field-ref="coddiag"/> </collection-descriptor> </class-descriptor> When I execute my method I pass an instance of DiagnosticoVO. it has populated the property diagInteVOs with a vector of insances of DiagInteVO. One of them has a field too large. A row for DiagnosticoVO in insert as well I cheked that it corretly go in the piece of code where it do begin transaction and in the piece of code where it do abort transaction. Could it be a configuration problem? Thanks for help. On 4/20/05, Martin Kal�n <[EMAIL PROTECTED]> wrote: > > Alessandro Colantoni wrote: > > Change are really written to the database. > > I get an error of MsSQLServer. > > Beware that MySQL using MYISAM storage in early versions [*] > does not implement database transactions. > > Either use InnoDB if your licensing requirements permit it or > try to upgrade to a newer MySQL version. > > Regards, > Martin > > [*] I believe this to be <4.x where x=something you would have to confirm > in the MySQL docs... > > P.S. Or better yet: Use PostgreSQL instead. It's also free but is a real > database. ;-) > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
