Hi,
Are the database settings in your app's TurbineResources.properties
correct? (JDBC URL, username, password, etc.)
Hope this helps,
-jeff
----- Original Message -----
From: "St�phane MOR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 24, 2002 9:41 PM
Subject: Turbine 2.1 - Torque : How to access the data ?
> Hello,
>
> I'm very enthusiasthic about Turbine, and moreover about Torque.
> This is why I started using Turbine (2.1, awaiting decoupled versions !).
> Templates, Layouts, Navigations and Screens work fine, but I can't use any
> Torque
> code !
>
> I read each and every HOW-TO, tutorial on Turbine's site, but couldn' t
find
> any answer to
> "how to integrate Torque in Turbine ?".
> Analysing the TDK's source code didn't help as Flux is integrated as a
tool,
> which is a
> quite different thing (I think so, at least).
>
> In my own app, Flux tool works fine, and I can access Roles, Permissions,
> etc.
> easily but my data can't be accessed, whereas they are both sharing the
same
> database.
>
> To start simple I only have this configuration :
>
> - a schema : shop-schema.xml :
> <database name="shop">
> <table name="customer">
> <column name="id" size="99" type="VARCHAR"/>
> <column name="name" size="99" type="VARCHAR"/>
> </table>
> </database>
> which generated the appropriate CustomerPeer, CustomerBase and Customer.
> I have no problems at all with schemas and Torque Ant Tasks.
>
> - a screen : ${package}.modules.screens.Default
> public class Default extends VelocityScreen
> {
> public void doBuildTemplate(RunData data, Context context) throws
> Exception
> {
> Criteria crit = new Criteria();
> Vector customers = CustomerPeer.doSelect(crit);
> context.put("customers", customers);
> }
> }
> I am not sure at all that this code should be there ...
>
> - a template : ${WEBAPP_ROOT}/templates/app/screens/Default.vm
> The customers :<br/>
> #foreach ( $customer in $customers )
> Name : $customer.Name , ID : $customer.Id <br/>
> #end
> I tried using fake Customer classes instead of the Torque ones with
success
> in this
> template.
>
> When trying to retrieve my data, i get a : " java.SQL.SQLException :
> Connection Object
> is null ! " log in turbine.log , and a redirection to the error template.
>
> What I would like is a very basic and simple plan to integrate Torque in
> Turbine :
> 1) configure Turbine like that (actually as Flux works I guess it is
> correctly configured )
> 2) write your Criteria code in this class (Action ? Screen ?)
> 3) initialize the connection like this
> etc.
>
> This is the last thing that prevents me from switching definitely to
> Turbine, so I hope it
> can be solved !
>
> Thanks a lot (even without Torque I had a great pleasure discovering and
> playing with
> Turbine !).
>
> Stephane
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
