RE: torque-3.1.zip archives

2003-12-17 Thread Edwin Yearwood
Hi Bogdan, I've followed the guidelines you defined but keep getting the following errors causing the class generation build to fail. [torque-sql] log4j:ERROR Could not find value for key log4j.appender.org.apache.torque.engine [torque-sql] log4j:ERROR Could not instantiate appender named "org.ap

RE: Problem with CLOB retreival

2003-12-17 Thread Shin Ohkubo
Hi Bill, Thank you very much for your kind and valuable reply. However, this mailing list seems to unaccept attached files; Would it be possible for you to send the file directly via e-mail to me? My e-mail is [EMAIL PROTECTED] I am looking forward to hearing from you. Thank you very much in adv

Templates

2003-12-17 Thread Pedro Salgado
Hi! I am using Torque to automatically generate the SQL, data, OJB repository and model (with success). I have made severall templates so that I can produce 1:n and n:m definitions to OJB repository and the respective collections to the model (with complicated schemas, it still works but it

Re: Does Torque Pool Connections

2003-12-17 Thread Dave Newton
On Wed, 2003-12-17 at 17:14, Sonu Vijay wrote: > Does Torque pools connections. It can; the example properties files has a wad of pooling options commented out. (RTFEF? Read The yadda-yadda Example Files?! ;) Dave - To unsubsc

Does Torque Pool Connections

2003-12-17 Thread Sonu Vijay
HI, Does Torque pools connections. Sonu __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-ma

RE: DAOs and Peers

2003-12-17 Thread Michael Kucera
Sonu, Yes I am dealing with only one database but as I understand it Torque should have no problem dealing with multiple databases. I don't have any rules for the scope of a DAO. Some of my DAOs deal with multiple tables and some with only one table. I just go with what makes the most sense conce

RE: DAOs and Peers

2003-12-17 Thread Sonu Vijay
Michael, Is your DAO/DAOs primarily dealing with one database as a whole. I was making one DAO for each table in my database. My busniess rules would call the DealersDAO for Dealers table data and CustomersDAO for customer table data. But now Torque generates code for the whole database. So now s

RE: DAOs and Peers

2003-12-17 Thread Michael Kucera
I'm using torque and I'm using DAOs. My value objects are torque objects. Basically I can ask one of my DAOs to give me a torque object or a list of torque objects. The DAO contains the code that builds the criteria etc.. Basically what I'm saying is that torque objects are the value objects. All

RE: Criteria.addAscendingOrderByColumn(field) NullPointerEx

2003-12-17 Thread mr.x
Hello Thanks for your replies. Finally i found the problem: the parameter "[EMAIL PROTECTED]@.adapter=mysql" was missing (misspelled) in the configs. Strange behaviour ;-> Anyway. Thanks for helping Cheers Rolf -Original Message- From: Gerhard Otte [mailto:[EMAIL PROTECTED] Sent: Diens

DAOs and Peers

2003-12-17 Thread Sonu Vijay
Hi Everybody, I have a DAO framework in place and we make DAO's primarily for each table in our DB2400 Database libraries (DB2400 doesn't has the conventional concept of a database, tables are just arranged in libraries). And then the interface to that DAO is exposed to the business rule program

Re: Problem with CLOB retreival

2003-12-17 Thread Bill Leng
Hope this email helps. The root cause is Oracle's jdbc driver does not conform jdbc specc. In fact, most jdbc drivers do not conform jdbc spec when dealing with clob or blob but oracle is nortoriously bas in this regard. Per spec, you should be able to PreparedStatement.setClob or setBlob. How

Re: MSSQL JDBC reverse ?

2003-12-17 Thread Bogdan Vatkov
Thanx Andras, that works for me too :) - Original Message - From: "Andras Balogh" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[EMAIL PROTECTED]> Sent: Wednesday, December 17, 2003 17:03 Subject: Re: MSSQL JDBC reverse ? > Hello Bogdan, > > I think this line: > torque.database.sc

Re: MSSQL JDBC reverse ?

2003-12-17 Thread Andras Balogh
Hello Bogdan, I think this line: torque.database.schema = dbo is missing from your build.properties file. Also i'm not sure exaclty what values should hae, dbo works for me. Best wishes, Andras. Bogdan Vatkov wrote: Hi all, I have tried to reverse xml schema from ms sql server via jdbc target..

MSSQL JDBC reverse ?

2003-12-17 Thread Bogdan Vatkov
Hi all, I have tried to reverse xml schema from ms sql server via jdbc target.. and no tables reversed ..(they actually exist in the db server) the result is this : no error but no table in the result xml H:\PROJECTS\java\OldFKSUOrganizer\torque-gen-3.1>ant jdbc Buildfile: build.xml jdbc:

Re: foreign key in another database

2003-12-17 Thread Charles-Alexandre Sabourdin
To me this beaviour is forbiden in SQL, but you can map (link) one table from a database to another table in a other database. Le Mercredi 17 Décembre 2003 00:36, Charles N. Harvey III a écrit : > Hello. > I have been looking through the mail-archives and I don't seem to > be able to come up wit

RE: Problem with CLOB retreival

2003-12-17 Thread Shin Ohkubo
Hi, See also: http://share.whichever.com/ where you can find all kinds of valuable Village related info including the entire source. by the way, I heard that the oracle jdbc driver limits the size of LOB data to 4000B, which I'm still not sure whether this info is correct. Is this information cor

Re: Problem with CLOB retreival

2003-12-17 Thread Felipe Ramos
Thank you very much Jaya It's very interesting for me. Jaya wrote: Hi, I got the info from this mailing list archive only. Please see the link http://www.mail-archive.com/[EMAIL PROTECTED]/msg07213.html In villagexxx.jar you can find a class named Value.java where we have to include the code g

RE: Problem with CLOB retreival

2003-12-17 Thread Jaya
Hi, I got the info from this mailing list archive only. Please see the link http://www.mail-archive.com/[EMAIL PROTECTED]/msg07213.html In villagexxx.jar you can find a class named Value.java where we have to include the code given below by Shin Ohkubo. Make jar again and use it. You can get th

Re: Problem with CLOB retreival

2003-12-17 Thread Felipe Ramos
I have some questions Changing the code in village? What's village? Where I must retrieve the result as a oracle.sql.CLOB? Could you please, give a list of steps to follow? It would be wonderful !! I really am very interesting in the same topic. Jaya wrote: Hi, Thanks a lot. It is work

Torque 3.1 JDBC Task creates DECIMAL instead of INTEGER for Oracle9i

2003-12-17 Thread "Göschl,Siegfried"
Hi folks, I have the following setup +) Oracle 9i +) Oracle Thin JDBC Driver +) Torque 3.1 The ORACLE database contains the following column (JDBC Metadata taken from Squirrel SQL Client) COLUMN_NAME = SORTSEQUENCE TYPE_NAME = NUMBER COLUMN_SIZE = 5 DECIMAL_DIGITS = 0 The Torque JDBC task cr