No subject

Tue Feb 3 02:35:55 PST 2004

"application" context, I don't seem to be able to retrieve data from the
expresso tables.

The error tells me that when using the DBObject, the context is changed from
"default" to "application", and even when using setDataContext("default"),
I'm getting the following error:

What went wrong:

- The Controller object called
"com.jcorporate.expresso.services.controller.DBMaint" reported a problem. 
- The problem reported was "Nested exception message:Nested exception
message:Unable to execute statement: SELECT    EmailValCode, Passwd,
AccountStatus, LoginName, UserName, RegComplete, UpdateDate, CreateDate,
RegDomId, EMail, ExpUid FROM USERSTABLE ORDER BY LoginName
(com.jcorporate.expresso.services.dbobj.DefaultUserInfo, db/context
'application'):ERROR: Relation "userstable" does not exist " 
- No error number was specified. 

You are logged in as 'Admin' in database/context 'default'

I hope you can sched some light on this

Edward Devos

The information transmitted by this e-mail message is intended solely for
the use of the person to whom or entity to which it is addressed. The
message may contain information that is privileged and confidential.
Disclosure, dissemination, distribution, review, retransmission to, other
use of or taking any action in reliance upon this information by anyone
other than the intended recipient is prohibited. If you are not the intended
recipient, please do not disseminate, distribute or copy this communication,
by e-mail or otherwise. Instead, please notify us immediately by return
e-mail (including the original message with your reply) and then delete and
discard all copies of the message.

Although we have taken precautions to minimize the risk of transmitting
viruses we nevertheless advise you to carry out your own virus checks on any
attachment to this message. We accept no liability for any loss or damage
caused by viruses.

------_=_NextPart_001_01C275EB.814DA930
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>Using OtherDBObject in Expresso 5.0</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hi All, </FONT>
</P>

I'm testing the otherDBObject method to have two =
seperate databases, one for expresso tables, and one for the =
applications own tables. but Im running into the following problem =
now:

<P><FONT SIZE=3D2>I'm logged in as Administrator in the default =
context!</FONT>
<BR><FONT SIZE=3D2>From a DBObject that is described in the schema as =
belonging to the &quot;application&quot; context, I don't seem to be =
able to retrieve data from the expresso tables.</FONT></P>

<P><FONT SIZE=3D2>The error tells me that when using the DBObject, the =
context is changed from &quot;default&quot; to &quot;application&quot;, =
and even when using setDataContext(&quot;default&quot;), I'm getting =
the following error:</FONT></P>

<P><FONT SIZE=3D2>What went wrong:</FONT>
</P>

- The Controller object called =
&quot;com.jcorporate.expresso.services.controller.DBMaint&quot; =
reported a problem. 
 - The problem reported was &quot;Nested exception =
message:Nested exception message:Unable to execute statement: =
SELECT&nbsp;&nbsp;&nbsp; EmailValCode, Passwd, AccountStatus, =
LoginName, UserName, RegComplete, UpdateDate, CreateDate, RegDomId, =
EMail, ExpUid FROM USERSTABLE ORDER BY LoginName =
(com.jcorporate.expresso.services.dbobj.DefaultUserInfo, db/context =
'application'):ERROR: Relation &quot;userstable&quot; does not exist =
&quot;

- No error number was specified.

<P><FONT SIZE=3D2>You are logged in as 'Admin' in database/context =
'default'</FONT>
</P>

<P><FONT SIZE=3D2>I hope you can sched some light on this</FONT>
</P>

<P><FONT SIZE=3D2>Edward Devos</FONT>
</P>

The information transmitted by this e-mail message =
is intended solely for the use of the person to whom or entity to which =
it is addressed. The message may contain information that is privileged =
and confidential.&nbsp; Disclosure, dissemination, distribution, =
review, retransmission to, other use of or taking any action in =
reliance upon this information by anyone other than the intended =
recipient is prohibited. If you are not the intended recipient, please =
do not disseminate, distribute or copy this communication, by e-mail or =
otherwise. Instead, please notify us immediately by return e-mail =
(including the original message with your reply) and then delete and =
discard all copies of the message.

Although we have taken precautions to minimize the =
risk of transmitting viruses we nevertheless advise you to carry out =
your own virus checks on any attachment to this message. We accept no =
liability for any loss or damage caused by viruses.

</BODY>
</HTML>
------_=_NextPart_001_01C275EB.814DA930--