Excuse me Thomas.
The listing of the log was of an old one where I tried to cheat OJB putting MySQL
instead of MsAccess to see what would
happen.
Here is the one using MsAccess. Same problem.
15:55:50,418 - DEBUG org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl -
createPersistenceBroker(key) called
15:55:50,418 - DEBUG org.apache.ojb.broker.accesslayer.ConnectionManagerImpl - Request
new connection from
ConnectionFactory: [EMAIL PROTECTED]
15:55:50,418 - DEBUG org.apache.ojb.broker.accesslayer.ConnectionManagerImpl - Try to
change autoCommit state to 'false'
15:55:50,418 - DEBUG org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl -
SQL: SELECT
apellidos,nombre,organizacion,tratamiento,id FROM revisores WHERE id = ?
15:55:50,478 - DEBUG org.apache.ojb.broker.accesslayer.StatementManager -
closeResources was called
15:55:50,478 - DEBUG org.apache.ojb.broker.accesslayer.StatementManager -
closeResources was called
15:55:50,478 - DEBUG org.apache.ojb.broker.accesslayer.JdbcAccessImpl - executeUpdate :
[EMAIL PROTECTED]
15:55:50,478 - DEBUG org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl -
SQL: UPDATE contactoRevisor SET
direccion=?, ciudad=?, codigoPostal=?, pais=?, email=?, telefono=?, fax=?, url=? WHERE
revisor = ?
15:55:50,598 - DEBUG org.apache.ojb.broker.accesslayer.StatementManager -
closeResources was called
15:55:50,598 - DEBUG org.apache.ojb.broker.accesslayer.JdbcAccessImpl - executeUpdate :
[EMAIL PROTECTED]
15:55:50,598 - DEBUG org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl -
SQL: UPDATE revisores SET
tratamiento=?, nombre=?, apellidos=?, organizacion=? WHERE id = ?
15:55:50,598 - DEBUG org.apache.ojb.broker.accesslayer.StatementManager -
closeResources was called
15:55:50,608 - DEBUG org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl -
SQL: SELECT palabraClave FROM
palabrasClaveRevisor WHERE revisor=?
15:55:50,608 - DEBUG org.apache.ojb.broker.accesslayer.JdbcAccessImpl - executeSQL:
SELECT palabraClave FROM
palabrasClaveRevisor WHERE revisor=?
15:55:50,608 - DEBUG org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl -
SQL: DELETE FROM
palabrasClaveRevisor WHERE revisor=? AND palabraClave=?
15:55:50,608 - DEBUG org.apache.ojb.broker.accesslayer.JdbcAccessImpl -
executeUpdateSQL: DELETE FROM
palabrasClaveRevisor WHERE revisor=? AND palabraClave=?
15:55:50,648 - ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl - SQLException
during the execution of the Update
SQL query (for a com.gescon.model.revisor.RevisorImpl): SQL Exception :
[Microsoft][Controlador ODBC Microsoft
Access]Funci�n opcional no implementada
java.sql.SQLException: SQL Exception : [Microsoft][Controlador ODBC Microsoft
Access]Funci�n opcional no implementada
at
sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1415)
at
sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1072)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknown
Source)
at
org.apache.ojb.broker.platforms.PlatformMsAccessImpl.setObjectForStatement(Unknown
Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindValues(Unknown
Source)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.deleteMtoNImplementor(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeCollections(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeToDb(Unknown
Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(Unknown
Source)
at com.gescon.model.revisor.dao.OJBRevisorDAO.modificarRevisor(Unknown Source)
...
-----Mensaje original-----
De: Mahler Thomas [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 27 de febrero de 2003 15:39
Para: 'OJB Users List'
Asunto: RE: HELP: MsAccess ODBC Controller Error: Optional function not
implemented
Hi Jose,
There seems to be some config problem with your repository:
>From the stacktrace I learn that PlatformMySQLImpl produces a problem.
You should setup repository.xml to use the MsAccess platform and not the
MySql platform!
cheers,
Thomas
> -----Original Message-----
> From: Jos� Manuel V�zquez [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 3:25 PM
> To: OJB User Mail
> Subject: HELP: MsAccess ODBC Controller Error: Optional function not
> implemented
>
>
> I'm using OJB 0.9.9 with MsAccess and I got an error from the ODBC
> controller: Optional function not implemented.
>
> Got someone a similar error with Access?
>
> The update statement OJB generates is very simple DELETE FROM
> palabrasClaveRevisor WHERE revisor=? AND palabraClave=? .
> palabrasClaveRevisor is an intermediary table that only has
> the primary keys
> from tables palabrasClave and revisores (M:N relation)
>
> Can anybody help me?
>
> Bellow is an extract of a log in debug mode:
> 12:46:29,524 - DEBUG
> org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl -
> createPersistenceBroker(key) called
> 12:46:29,524 - DEBUG
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl - Request new
> connection from ConnectionFactory:
> [EMAIL PROTECTED]
> 12:46:29,524 - DEBUG
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl - Try
> to change
> autoCommit state to 'false'
> 12:46:29,524 - DEBUG
> org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
> - SQL: SELECT
> apellidos,nombre,organizacion,tratamiento,id FROM revisores
> WHERE id = ?
> 12:46:29,524 - DEBUG
> org.apache.ojb.broker.accesslayer.StatementManager -
> closeResources was called
> 12:46:29,534 - DEBUG
> org.apache.ojb.broker.accesslayer.StatementManager -
> closeResources was called
> 12:46:29,534 - DEBUG
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl -
> executeUpdate : [EMAIL PROTECTED]
> 12:46:29,544 - DEBUG
> org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
> - SQL: UPDATE
> contactoRevisor SET direccion=?, ciudad=?, codigoPostal=?,
> pais=?, email=?,
> telefono=?, fax=?, url=? WHERE revisor = ?
> 12:46:29,554 - DEBUG
> org.apache.ojb.broker.accesslayer.StatementManager -
> closeResources was called
> 12:46:29,554 - DEBUG
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl -
> executeUpdate : [EMAIL PROTECTED]
> 12:46:29,554 - DEBUG
> org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
> - SQL: UPDATE
> revisores SET tratamiento=?, nombre=?, apellidos=?,
> organizacion=? WHERE id
> = ?
> 12:46:29,554 - DEBUG
> org.apache.ojb.broker.accesslayer.StatementManager -
> closeResources was called
> 12:46:29,554 - DEBUG
> org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
> - SQL: SELECT
> palabraClave FROM palabrasClaveRevisor WHERE revisor=?
> 12:46:29,554 - DEBUG
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl -
> executeSQL: SELECT palabraClave FROM palabrasClaveRevisor
> WHERE revisor=?
> 12:46:29,564 - DEBUG
> org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
> - SQL: DELETE
> FROM palabrasClaveRevisor WHERE revisor=? AND palabraClave=?
> 12:46:29,564 - DEBUG
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl -
> executeUpdateSQL: DELETE FROM palabrasClaveRevisor WHERE revisor=? AND
> palabraClave=?
> 12:46:29,574 - ERROR
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl -
> SQLException during the execution of the Update SQL query (for a
> com.gescon.model.revisor.RevisorImpl): SQL Exception :
> [Microsoft][Controlador ODBC Microsoft Access]Funci�n opcional no
> implementada
> java.sql.SQLException: SQL Exception : [Microsoft][Controlador ODBC
> Microsoft Access]Funci�n opcional no implementada
> at
> sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPrep
> aredStatement.
> java:1415)
> at
> sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPrep
> aredStatement.
> java:1072)
> at
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectF
> orStatement(Un
> known Source)
> at
> org.apache.ojb.broker.platforms.PlatformMySQLImpl.setObjectFor
> Statement(Unkn
> own Source)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.bindValues(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdate
> SQL(Unknown
> Source)
> at
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.deleteMto
> NImplementor(U
> nknown Source)
> at
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeColl
> ections(Unknow
> n Source)
> at
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeToDb(Unknown
> Source)
> at
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unk
> nown Source)
> at
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unk
> nown Source)
> at
> org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.sto
> re(Unknown
> Source)
> at
> com.gescon.model.revisor.dao.OJBRevisorDAO.modificarRevisor(Un
> known Source)
>
> ...
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---Publicidad--------------------------------------------------------
�nete a los miles de sin pareja en Meetic... �te vas a enamorar!
http://www.iespana.es/_reloc/email.meetic
---Publicidad--------------------------------------------------------
Juega con Ventura24.es, loter�a inteligente y multiplica tus
posibilidades!! http://www.iespana.es/_reloc/email.ventura
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
