Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 62605 invoked from network); 3 Sep 2003 02:36:22 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 3 Sep 2003 02:36:22 -0000 Received: (qmail 13287 invoked by uid 500); 3 Sep 2003 02:35:48 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 13230 invoked by uid 500); 3 Sep 2003 02:35:46 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 13171 invoked from network); 3 Sep 2003 02:35:45 -0000 Received: from unknown (HELO pepper.flavor.de) (213.239.194.131) by daedalus.apache.org with SMTP; 3 Sep 2003 02:35:45 -0000 Received: from localhost (localhost [127.0.0.1]) by pepper.flavor.de (Postfix) with ESMTP id 637A212552 for ; Wed, 3 Sep 2003 04:37:14 +0200 (CEST) Received: from HANSA.flavor.de (h24-87-11-190.vc.shawcable.net [24.87.11.190]) by pepper.flavor.de (Postfix) with ESMTP id 2819511D67 for ; Wed, 3 Sep 2003 04:37:10 +0200 (CEST) Message-Id: <5.2.0.9.2.20030902193313.01652cd8@flavor.de> X-Sender: shaiges@flavor.de (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Tue, 02 Sep 2003 19:33:15 -0700 To: torque-user@db.apache.org From: Sven Haiges Subject: Torque & MySQL-Treiber... Mime-Version: 1.0 Content-Type: multipart/mixed; x-avg-checked=avg-ok-407D6100; boundary="=======2F1536B9=======" X-Virus-Scanned: by AMaViS 0.3.12pre8 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N --=======2F1536B9======= Content-Type: multipart/alternative; x-avg-checked=avg-ok-407D6100; boundary="=====================_20938097==.ALT" --=====================_20938097==.ALT Content-Type: text/plain; x-avg-checked=avg-ok-407D6100; charset=iso-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Servus beisammen, die 3.1 Version von Torque habe ich gl=FCcklicherweise nun gleich beim= ersten=20 Anlauf zum laufen bekommen :-) Ich initialisiere torque momentan so: try { Torque.init("./Torque.properties"); } catch (TorqueException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } --> gibt es daran etwas auszusetzen? Ich bin nur durch Zufall auf die=20 "Idee" gekommen, nach der Klasse Torque zu sehen um das ganze System zu=20 initialisieren... gibt es ne bessere Methode? Danach folgt folgender Test: ProductDescription pd1 =3D new ProductDescription(); pd1.setTitleDe("test_de"); pd1.setTitleEn("test_en"); try { pd1.save(); System.out.println("Saved the stuff..."); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } --> Leider gibt es dann ein paar Fehlermeldungen, die wohl mit dem neuen=20 MySQL-Treiber zusammenh=E4ngen, den ich verwende: Im unteren Teil sind ein paar Fehler, die wohl auf mangelnden Support=20 Seitens mysql hinweisen. Geht dies normalerweise mit dem alten Treiber, ist= =20 es also empfehlenswert den alten Treiber zu verwenden? Danke, Sven [DEBUG] TorqueInstance - -init(./Torque.properties) [DEBUG] TorqueInstance - -Config Object is=20 org.apache.commons.configuration.PropertiesConfiguration@1d8957f [DEBUG] TorqueInstance -=20 -init(org.apache.commons.configuration.PropertiesConfiguration@1d8957f) [DEBUG] TorqueInstance -=20 -setConfiguration(org.apache.commons.configuration.PropertiesConfiguration@1= d8957f) [DEBUG] TorqueInstance - -initialize() [DEBUG] TorqueInstance -=20 -setConfiguration(org.apache.commons.configuration.BaseConfiguration@3ee284) [DEBUG] TorqueInstance -=20 -initAdapters(org.apache.commons.configuration.BaseConfiguration@3ee284) [DEBUG] TorqueInstance - -Adding mysql -> sueviaweb as Adapter [DEBUG] TorqueInstance -=20 -initDataSourceFactories(org.apache.commons.configuration.BaseConfiguration@= 3ee284) [DEBUG] TorqueInstance - -handle: sueviaweb DataSourceFactory:=20 org.apache.torque.dsfactory.SharedPoolDataSourceFactory [DEBUG] AbstractDataSourceFactory - -Starting initCPDS [DEBUG] TorqueInstance - -getConfiguration() =3D=20 org.apache.commons.configuration.BaseConfiguration@3ee284 [DEBUG] AbstractDataSourceFactory -=20 -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@1df07= 3d,=20 org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@1546e25) [DEBUG] ConvertUtils - -Convert string 'com.mysql.jdbc.Driver' to class=20 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 driver, com.mysql.jdbc.Driver) [DEBUG] ConvertUtils - -Convert string=20 'jdbc:mysql://localhost:3306/sueviaweb' to class 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 url, jdbc:mysql://localhost:3306/sueviaweb) [DEBUG] ConvertUtils - -Convert string 'root' to class 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 user, root) [DEBUG] ConvertUtils - -Convert string 'hitz23' to class 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 password, hitz23) [DEBUG] AbstractDataSourceFactory -=20 -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@120a4= 7e,=20 org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@1546e25) [DEBUG] ConvertUtils - -Convert string 'com.mysql.jdbc.Driver' to class=20 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 driver, com.mysql.jdbc.Driver) [DEBUG] ConvertUtils - -Convert string=20 'jdbc:mysql://localhost:3306/sueviaweb' to class 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 url, jdbc:mysql://localhost:3306/sueviaweb) [DEBUG] ConvertUtils - -Convert string 'root' to class 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 user, root) [DEBUG] ConvertUtils - -Convert string 'hitz23' to class 'java.lang.String' [DEBUG] AbstractDataSourceFactory -=20 -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25,=20 password, hitz23) [DEBUG] SharedPoolDataSourceFactory - -Starting initJdbc2Pool [DEBUG] TorqueInstance - -getConfiguration() =3D=20 org.apache.commons.configuration.BaseConfiguration@3ee284 [DEBUG] AbstractDataSourceFactory -=20 -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@17bd6= a1,=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource@147ee05) [ERROR] AbstractDataSourceFactory - -Property: logInterval value: 0 is not= =20 supported by DataSource:=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource [ERROR] AbstractDataSourceFactory - -Property: connectionWaitTimeout value:= =20 10 is not supported by DataSource:=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource [ERROR] AbstractDataSourceFactory - -Property: defaultMaxConnections value:= =20 80 is not supported by DataSource:=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource [ERROR] AbstractDataSourceFactory - -Property: maxExpiryTime value: 3600 is= =20 not supported by DataSource:=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource [DEBUG] AbstractDataSourceFactory -=20 -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@17e6a= 96,=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource@147ee05) [ERROR] AbstractDataSourceFactory - -Property: defaultMaxActive value: 10=20 is not supported by DataSource:=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource [DEBUG] ConvertUtils - -Convert string 'true' to class 'boolean' [ERROR] AbstractDataSourceFactory - -Property: testOnBorrow value: true is= =20 not supported by DataSource:=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource [DEBUG] ConvertUtils - -Convert string 'SELECT 1' to class= 'java.lang.String' [ERROR] AbstractDataSourceFactory - -Property: validationQuery value:=20 SELECT 1 is not supported by DataSource:=20 org.apache.commons.dbcp.datasources.SharedPoolDataSource [DEBUG] TorqueInstance - -Adding a dummy entry for default, mapped onto=20 sueviaweb [DEBUG] TorqueInstance - -getConfiguration() =3D=20 org.apache.commons.configuration.BaseConfiguration@3ee284 [DEBUG] IDBroker - -IDBroker thread was started. [DEBUG] IDBroker - -Forced id retrieval - no available list [DEBUG] IDBroker - -updateQuantity: UPDATE ID_TABLE SET QUANTITY =3D 10= WHERE=20 TABLE_NAME =3D 'product_description' [DEBUG] IDBroker - -updateNextId: UPDATE ID_TABLE SET NEXT_ID =3D 1010 WHERE= =20 TABLE_NAME =3D 'product_description' --- Sven Haiges sh@flavor.de http://www.svenhaiges.de =20 --=====================_20938097==.ALT Content-Type: text/html; x-avg-checked=avg-ok-407D6100; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Servus beisammen,

die 3.1 Version von Torque habe ich gl=FCcklicherweise nun gleich beim ersten Anlauf zum laufen bekommen :-)

Ich initialisiere torque momentan so:

try
{
Torque.init("./Torque.properties");
}
catch (TorqueException e1)
{
// TODO Auto-generated catch block
e1.printStackTrace();
}

--> gibt es daran etwas auszusetzen? Ich bin nur durch Zufall auf die "Idee" gekommen, nach der Klasse Torque zu sehen um das ganze System zu initialisieren... gibt es ne bessere Methode?

Danach folgt folgender Test:

ProductDescription pd1 =3D new ProductDescription();
pd1.setTitleDe("test_de");
pd1.setTitleEn("test_en");
try
{
pd1.save();
System.out.println("Saved the stuff...");
}
catch (Exception e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}

--> Leider gibt es dann ein paar Fehlermeldungen, die wohl mit dem neuen MySQL-Treiber zusammenh=E4ngen, den ich verwende:

Im unteren Teil sind ein paar Fehler, die  wohl auf mangelnden Support Seitens mysql hinweisen. Geht dies normalerweise mit dem alten Treiber, ist es also empfehlenswert den alten Treiber zu verwenden?

Danke,
Sven

[DEBUG] TorqueInstance - -init(./Torque.properties)
[DEBUG] TorqueInstance - -Config Object is org.apache.commons.configuration.PropertiesConfiguration@1d8957f
[DEBUG] TorqueInstance - -init(org.apache.commons.configuration.PropertiesConfiguration@1d8957f)
[DEBUG] TorqueInstance - -setConfiguration(org.apache.commons.configuration.PropertiesConfiguration@1= d8957f)
[DEBUG] TorqueInstance - -initialize()
[DEBUG] TorqueInstance - -setConfiguration(org.apache.commons.configuration.BaseConfiguration@3ee284)=
[DEBUG] TorqueInstance - -initAdapters(org.apache.commons.configuration.BaseConfiguration@3ee284)
[DEBUG] TorqueInstance - -Adding mysql -> sueviaweb as Adapter
[DEBUG] TorqueInstance - -initDataSourceFactories(org.apache.commons.configuration.BaseConfiguration@= 3ee284)
[DEBUG] TorqueInstance - -handle: sueviaweb DataSourceFactory: org.apache.torque.dsfactory.SharedPoolDataSourceFactory
[DEBUG] AbstractDataSourceFactory - -Starting initCPDS
[DEBUG] TorqueInstance - -getConfiguration() =3D org.apache.commons.configuration.BaseConfiguration@3ee284
[DEBUG] AbstractDataSourceFactory - -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@1df07= 3d, org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@1546e25)
[DEBUG] ConvertUtils - -Convert string 'com.mysql.jdbc.Driver' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, driver, com.mysql.jdbc.Driver)
[DEBUG] ConvertUtils - -Convert string 'jdbc:mysql://localhost:3306/sueviaweb' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, url, jdbc:mysql://localhost:3306/sueviaweb)
[DEBUG] ConvertUtils - -Convert string 'root' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, user, root)
[DEBUG] ConvertUtils - -Convert string 'hitz23' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, password, hitz23)
[DEBUG] AbstractDataSourceFactory - -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@120a4= 7e, org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@1546e25)
[DEBUG] ConvertUtils - -Convert string 'com.mysql.jdbc.Driver' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, driver, com.mysql.jdbc.Driver)
[DEBUG] ConvertUtils - -Convert string 'jdbc:mysql://localhost:3306/sueviaweb' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, url, jdbc:mysql://localhost:3306/sueviaweb)
[DEBUG] ConvertUtils - -Convert string 'root' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, user, root)
[DEBUG] ConvertUtils - -Convert string 'hitz23' to class 'java.lang.String'
[DEBUG] AbstractDataSourceFactory - -setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@154= 6e25, password, hitz23)
[DEBUG] SharedPoolDataSourceFactory - -Starting initJdbc2Pool
[DEBUG] TorqueInstance - -getConfiguration() =3D org.apache.commons.configuration.BaseConfiguration@3ee284
[DEBUG] AbstractDataSourceFactory - -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@17bd6= a1, org.apache.commons.dbcp.datasources.SharedPoolDataSource@147ee05)
[ERROR] AbstractDataSourceFactory - -Property: logInterval value: 0 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
[ERROR] AbstractDataSourceFactory - -Property: connectionWaitTimeout value: 10 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
[ERROR] AbstractDataSourceFactory - -Property: defaultMaxConnections value: 80 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
[ERROR] AbstractDataSourceFactory - -Property: maxExpiryTime value: 3600 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
[DEBUG] AbstractDataSourceFactory - -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@17e6a= 96, org.apache.commons.dbcp.datasources.SharedPoolDataSource@147ee05)
[ERROR] AbstractDataSourceFactory - -Property: defaultMaxActive value: 10 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
[DEBUG] ConvertUtils - -Convert string 'true' to class 'boolean'
[ERROR] AbstractDataSourceFactory - -Property: testOnBorrow value: true is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
[DEBUG] ConvertUtils - -Convert string 'SELECT 1' to class 'java.lang.String'
[ERROR] AbstractDataSourceFactory - -Property: validationQuery value: SELECT 1 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
[DEBUG] TorqueInstance - -Adding a dummy entry for default, mapped onto sueviaweb
[DEBUG] TorqueInstance - -getConfiguration() =3D org.apache.commons.configuration.BaseConfiguration@3ee284
[DEBUG] IDBroker - -IDBroker thread was started.
[DEBUG] IDBroker - -Forced id retrieval - no available list
[DEBUG] IDBroker - -updateQuantity: UPDATE ID_TABLE SET QUANTITY =3D 10 WHERE TABLE_NAME =3D 'product_description'
[DEBUG] IDBroker - -updateNextId: UPDATE ID_TABLE SET NEXT_ID =3D 1010 WHERE TABLE_NAME =3D 'product_description'

---
Sven Haiges
sh@flavor.de
http://www.svenhaig= es.de --=====================_20938097==.ALT-- --=======2F1536B9======= Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --=======2F1536B9=======--