Torque Example Runtime Problem

All, This is the followup to my previous email.. I find out the code that causes the problem. The following code is the problem. When I tried to use either the foreign key directly (that was the original example code) or use the object, it errors out and gave me the error. When I commnet out cre

build.properties

Do you have to modify the file below when setting up my own database (MSSQL). jetspeed-1.4\build\torque\build.properties Also, Is there any other files that need to be modified other than this one and torque.properties? Vincent A. Tebano (Vinnie) Software Engineer Lockheed Martin Aircraft & Log

RE: sql2xml postgresql

> 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

Spot on Ben! I feel like such an idiot. I'm still getting used to all the config settings. Thanks. robert > -Original Message- > From: Benjamin Yu [mailto:[EMAIL PROTECTED] > Sent: Friday, March 05, 2004 11:54 AM > To: 'Apache Torque Users List' > Subject: RE: [Newbie] Trouble executing

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

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

[Newbie] Trouble executing create-db for mysql

Greetings: I'm just starting to use Torque (torque-gen-3.1) and I'm trying to create a new database. I can successfully run the "sql" target defined in build-torque.xml and I see that the correct DDL statements are generated for my target database; mysql. When I run the "create-db" target, the

RE: sql2xml postgresql

Hello Andras, thx for the answer. I found some information here http://db.apache.org/torque/properties-reference.html about this properties : Used by the JDBC -> XML process, and by the SQL Ant Task that will initialize your target database with the generated SQL. This is only used by O

RE: DB Issues

I tried your (modifying it for mine) and this is the error I get when after startup: org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfil e(JetspeedProfilerService.java:544) a

Re: sql2xml postgresql

Hello, I think at jdbc target the problem is the schema: "[torque-jdbc-transform] schema : ${databaseSchema}" You should specify in build.properties: torque.database.schema = but i don't know what this vaules should be for postgres maybe the owner of the tables? (i.e. the username who created

AW: DB Issues

Ok, here is my working sqlserver 2000 setup, contents of Torque.properties: torque.applicationRoot = . torque.defaults.pool.logInterval = 0 torque.defaults.pool.connectionWaitTimeout = 10 torque.defaults.pool.defaultMaxConnections = 80 torque.defaults.pool.maxExpiryTime = 3600 torque.defaults.conn

sql2xml postgresql

Hi, I'd like to generate the XML schema file from the .sql or jdbc connection to a postgresql database. When I try the jdbc torque action, I get an empty database : see at the bottom. When I try the sql2xml torque action, I get nothing and the action does not end. The cpu is at 100%. I get no

RE: DB Issues

Nope, Tried that and it didn't work Vincent A. Tebano (Vinnie) Software Engineer Lockheed Martin Aircraft & Logistics Centers 244 Terminal Road Greenville, SC 29605 864-299-7267 -Original Message- From: Gerhard Otte [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 8:25 AM To: Ap

AW: DB Issues

may be you should try microsoft instead of Microsoft in the connection url Gerhard Otte __ mailto:[EMAIL PROTECTED] emediapark GmbH http://www.emediapark.de Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 Regensburg,Germany -Ursprüngliche Nachricht- Von: Tebano, Vincent A [mailto:

DB Issues

I can't seem to get the system to connect to my Microsoft SQL 2000 DB. Are these statements needs in Torque.Properties when I am setting up my own DB. torque.database.default=default torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc eFactory torque.dsf

Torque Example

Hi All, I am trying to run the bookstore example explained in the tutorial. I am getting an exception during runtime. I am using mysql database. Following is the exception. If anybody knows how to solve this problem, please let me know. Thanks, Jones. PS: When I tried the same SQL in the mysql c