RE: SQLException and TorqueException when getting a Connection.

2004-06-01 Thread Benjamin Yu
It sounds like you have a configuration issue somewhere in ms sql server or the jdbc url that you've created. That is.. a jdbc URL of the the format: jdbc:microsoft:sqlserver://localhost\\instancename:1433;DatabaseName=mydb vs jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb If you wan

RE: Which DB Pooling method is best?

2004-04-30 Thread Benjamin Yu
The advantage that you identified for option 2 is the main reason why I choose that route. In essence, yes, commons-dbcp is still being used but I feel that keeping a separation between the deployment configuration and the application assembler is enough of a reason to have that extra layer. Plus I

RE: Using Torque with Tomcat.

2004-04-30 Thread Benjamin Yu
che.naming.java.javaURLContextFactory #torque.dsfactory.bookstore.datasource.jndiEnvironment.java.naming.factory.u rl. pkgs = org.apache.naming #torque.dsfactory.bookstore.datasource.defaultMaxConnections=10 ~Sarav -- There are 10 kinds of people in the world, those who know binary and those who

RE: Using Torque with Tomcat.

2004-04-19 Thread Benjamin Yu
Here're a couple of emails in the user group to get a sort of direction. > Where should I initialize Torque so that all the sessions of the Webapp use the > same DBConnectionPool? Try instantiating the pool to be referenced as a JNDI datasource. http://nagoya.apache.org/eyebrowse/[EMAIL PROTECT

RE: Time Zone with Torque and PostgreSQL

2004-04-06 Thread Benjamin Yu
I'm not sure if option 2 will work for you...because new Date() and new Date(new GregorianCalendar().getTimeInMillis()) will create a new object of the same time. Java API states that Date "is intended to reflect coordinated universal time (UTC)". To which the Default constructor "initializes it s

RE: where are the classes?

2004-03-25 Thread Benjamin Yu
They're in the torque runtime jar. That's a separate download from torque-gen. -Original Message- From: Derek B. Greer [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 2:52 PM To: [EMAIL PROTECTED] Subject: where are the classes? Using the bookstore example configured for sybase

RE: Multiple packages

2004-03-19 Thread Benjamin Yu
1. Create multiple *-schema.xml files. One for each table or set of tables. 2. Set the database name's value to be the same across all the files. 3. If you have foreign key constraints, make use of the external-schema tag. Tables will only be generated once. Bewarned that a table's id-table sql ge

RE: Multiple databases without JNDI ?

2004-03-17 Thread Benjamin Yu
Yes, it is possible. Just enter multiple dsfactory entries into the *runtime* Torque.properties file. Something like: torque.database.default=db1 torque.database.db1.adapter=postgresql torque.dsfactory.db1.factory=org.apache.torque.dsfactory.SharedPoolDataSourc eFactory torque.dsfactory.db1.pool

RE: Torque on Tomcat: Exception: DataSourceFactory not configure d

2004-03-15 Thread Benjamin Yu
Drake, Here's my setup. The torque properties is to pull from a JNDI datasource... These datasources are created by the servlet container. # Torque.properties # Torque config to pull the connections from a JNDI DataSource. # - The underlying JNDI DataSource may be pooled or unpooled. #The de

RE: Torque on Tomcat: Exception: DataSourceFactory not configure d

2004-03-15 Thread Benjamin Yu
How does struts initialize Torque? Is there such a method? For me, I use an init servlet to load the Torque properties that is loaded on startup. I can't remember where in the docs that I read this suggestion. Eg: public final void init() { String prefix = getServletContext().getRealPath

RE: Torque versions and Maven plugin

2004-03-10 Thread Benjamin Yu
TED] http://www.NequalsOne.com -Original Message- From: Benjamin Yu [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 4:39 PM To: 'Apache Torque Users List' Subject: RE: Torque versions and Maven plugin I ended up listing almost all of torque's runtime dependencies. My b

RE: Torque versions and Maven plugin

2004-03-10 Thread Benjamin Yu
Nathan McMinn Application Developer NequalsOne - HealthCare marketing tools mailto:[EMAIL PROTECTED] http://www.NequalsOne.com -Original Message- From: Benjamin Yu [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 11:15 AM To: 'Ap

RE: Torque versions and Maven plugin

2004-03-10 Thread Benjamin Yu
I'm going to guess that it sounds like your project.xml is missing the dependancy entry. More specifically, the specific error looks like it points to one of the logging packages. Either log4j or commons-logging... Here's a like of dependencies for torque: For torque's generator: http://db.apache.

RE: sql2xml postgresql

2004-03-05 Thread Benjamin Yu
> So it apparently does not have any impact on postgresql DB. I can't remember when the feature was introduced, but postgresql supports schemas (essentially namespaces for your db objects). http://www.postgresql.org/docs/7.4/static/sql-createschema.html Here's an example of what I'm talking abou

RE: [Newbie] Trouble executing create-db for mysql

2004-03-05 Thread Benjamin Yu
Are you sure your torque.database property is set to "mysql" not "mssql"? The MS SQL create-db sql isn't implemented yet (3.1 release). -Ben -Original Message- From: Robert Taylor [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 7:37 AM To: [EMAIL PROTECTED] Subject: [Newbie] Troubl

Maven Plugin 3.2 for torque ignores default properties

2004-02-23 Thread Benjamin Yu
Hi, I noticed this message from november regarding the default properties: http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED] g&msgNo=2743 I searched around the maven bug tracking and the mailing lists regarding this issue since the post but didn't see any followup. Has there been any updates o