db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Youngho Cho" <youn...@nannet.co.kr>
Subject Re: MySql InnoDB question
Date Thu, 30 Jun 2005 00:19:53 GMT
Hello,

Thanks. I will check it out.


Youngho


----- Original Message ----- 
From: "Dan Cooper" <dcooper@fvt.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Sent: Thursday, June 30, 2005 7:38 AM
Subject: Re: MySql InnoDB question


> Did you ever get past this problem?
> 
> You should log into Mysql and run the command:
> 
> show table status;
> 
> on the easydesk database.  This will show you what table types have been 
> created in your database.  I had this same problem with Torque when I 
> first started and it turned out that Torque was not creating InnoDB 
> tables.  In my previous email to this list there are instructions on how 
> to change the table type when using Torque to generate your schema.
> 
> Regards & Happy Torqueing
> 
> Dan Cooper
> 
> Youngho Cho wrote:
> 
> >Hello,
> >
> >Here is my test result.
> >I added log line into initialize() method.
> >
> >It looks like the torque initialize process has a problem for checking Tranasction
Support or Not.
> >During initialize process, the IDBroker call the TorqueInstance for checking the
Connection support transaction.
> >Because the TorqueInstance doesn't initialize yet,  it always set false even the
connection support transaction.
> >
> >2005-06-23 23:31:14,609 [main] DEBUG org.apache.torque.TorqueInstance - init(org.apache.commons.configuration.CompositeConfiguration@1c6a99d)
> >2005-06-23 23:31:14,609 [main] DEBUG org.apache.torque.TorqueInstance - setConfiguration(org.apache.commons.configuration.CompositeConfiguration@1c6a99d)
> >2005-06-23 23:31:14,609 [main] DEBUG org.apache.torque.TorqueInstance - initialize()
> >2005-06-23 23:31:14,625 [main] DEBUG org.apache.torque.TorqueInstance - setConfiguration(org.apache.commons.configuration.SubsetConfiguration@1a9876e)
> >2005-06-23 23:31:14,625 [main] DEBUG org.apache.torque.TorqueInstance - initAdapters(org.apache.commons.configuration.SubsetConfiguration@1a9876e)
> >2005-06-23 23:31:14,718 [main] DEBUG org.apache.torque.TorqueInstance - Adding mysql
-> easydesk as Adapter
> >2005-06-23 23:31:14,718 [main] DEBUG org.apache.torque.TorqueInstance - initDataSourceFactories(org.apache.commons.configuration.SubsetConfiguration@1a9876e)
> >2005-06-23 23:31:14,718 [main] DEBUG org.apache.torque.TorqueInstance - handle: easydesk
DataSourceFactory: org.apache.torque.dsfactory.SharedPoolDataSourceFactory
> >2005-06-23 23:31:14,828 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration()
= org.apache.commons.configuration.SubsetConfiguration@1a9876e
> >2005-06-23 23:31:14,828 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- Starting initCPDS
> >2005-06-23 23:31:14,843 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration()
= org.apache.commons.configuration.SubsetConfiguration@1a9876e
> >2005-06-23 23:31:14,843 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@135da43, org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5)
> >2005-06-23 23:31:14,843 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@11a0d35, org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5)
> >2005-06-23 23:31:14,890 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, driver,
org.gjt.mm.mysql.Driver)
> >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, url, jdbc:mysql://localhost:3306/easydesk?zeroDateTimeBehavior=round&useNewIO=true)
> >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, user, root)
> >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, password,
 (value not logged))
> >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.SharedPoolDataSourceFactory
- Starting initJdbc2Pool
> >2005-06-23 23:31:14,937 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration()
= org.apache.commons.configuration.SubsetConfiguration@1a9876e
> >2005-06-23 23:31:14,937 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@1015a9e, org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c)
> >2005-06-23 23:31:14,937 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@e8606c, org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c)
> >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, maxActive,
60)
> >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, maxWait,
30000)
> >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, testOnBorrow,
true)
> >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, timeBetweenEvictionRunsMillis,
-1)
> >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory
- setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, validationQuery,
SELECT 1)
> >2005-06-23 23:31:15,000 [main] DEBUG org.apache.torque.TorqueInstance - Adding a
dummy entry for default, mapped onto easydesk
> >2005-06-23 23:31:15,062 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration()
= org.apache.commons.configuration.SubsetConfiguration@1a9876e
> >2005-06-23 23:31:15,078 [main] ERROR org.apache.torque.oid.IDBroker - org.apache.torque.TorqueException:
Torque is not initialized.
> >2005-06-23 23:31:15,078 [main] WARN  org.apache.torque.oid.IDBroker - IDBroker is
being used with db 'easydesk', which does not support transactions. IDBroker attempts to use
transactions to limit the possibility of duplicate key generation.  Without transactions,
duplicate key generation is possible if multiple JVMs are used or other means are used to
write to the database.
> >2005-06-23 23:31:15,109 [Torque - ID Broker thread] DEBUG org.apache.torque.oid.IDBroker
- IDBroker thread was started.
> >2005-06-23 23:31:17,703 [main] INFO  org.apache.torque.TorqueInstance - Added Manager
for Class: com.nannet.jettiger.om.JettigerUser -> com.nannet.jettiger.om.JettigerUserManager
> >2005-06-23 23:31:17,781 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration()
= org.apache.commons.configuration.SubsetConfiguration@1a9876e
> >2005-06-23 23:31:17,781 [main] DEBUG org.apache.torque.TorqueInstance - initialize
finished
> >
> >
> >I could solved this problem by moving initialize finish flag set true 
> >when after dataSourceFactory initialize not completely finished the TorqueInstance.
> >
> >[youngho@dev db-torque]$ cvs diff src/java/org/apache/torque/TorqueInstance.java
> >Index: src/java/org/apache/torque/TorqueInstance.java
> >===================================================================
> >RCS file: /home/cvspublic/db-torque/src/java/org/apache/torque/TorqueInstance.java,v
> >retrieving revision 1.11
> >diff -r1.11 TorqueInstance.java
> >149a150,151
> >  
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
Mime
View raw message