Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem updating DB from Jaguar EJB

3 posts in General Discussion (old) Last posting was on 2000-03-28 19:36:45.0Z
Jamie Crutchley Posted on 2000-03-28 17:50:27.0Z
Newsgroups: sybase.public.easerver
Reply-To: "Jamie Crutchley" <jdcrutch@raystl.com>
From: "Jamie Crutchley" <jdcrutch@raystl.com>
Subject: Problem updating DB from Jaguar EJB
Date: Tue, 28 Mar 2000 11:50:27 -0600
Lines: 42
Organization: Raytheon
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 128.242.150.59
Message-ID: <347_biGyh7Nm$GA.275@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25459
Article PK: 155542

I'm trying to get updates into a database from an EJB. I've been trying to
use
the DynamicTargetCell class to do this, although I'd be open to other
suggestions
as long as they don't involve datawindows.
Here is what I'm doing:

I have an EJB class defined as
public class sysObjectImpl extends java.lang.Object implements
com.sybase.jaguar.beans.enterprise.ServerBean

Within this class, I have a String object called version. I also have the
following defined:
private powersoft.powerj.db.DynamicTargetCell dt_version = new
powersoft.powerj.db.DynamicTargetCell(this, "version", "String");

Inside a method which is called by Dynamo script when the object is first
instantiated, I have the following code:
if( !query_sysRelease.open() )
{
System.err.println("Unable to execute retrieve of sysRelease");
return false;
}
dt_version.setDataColumns( "VERSION" );
dt_version.setDataSource( query_sysRelease );
query_sysRelease.moveFirst(true,true);

It was my understanding that all of this would bind the "version" property
of this object to the "VERSION" column of my query object, then calling the
moveFirst would populate the property, and after that my "get" and "set"
methods for "version" would also change the database column. Trouble is,
that doesn't seem to be happening. The version property remains in its
initialized state and changing it has no effect on the database. Any ideas
what I'm doing wrong? I'd also be open to suggestions on alternate ways
of doing this so long as it does not involve DataWindows. Thanks in
advance.

Jamie Crutchley
jdcrutch@raystl.com


Dave Wolf [Sybase] Posted on 2000-03-28 18:57:20.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: Problem updating DB from Jaguar EJB
Date: Tue, 28 Mar 2000 13:57:20 -0500
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: nomad6-31.sybase.com 157.133.176.31
Message-ID: <347_pd61VgOm$GA.298@forums.sybase.com>
References: <347_biGyh7Nm$GA.275@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25445
Article PK: 155536

Please try the PowerJ newsgroup. You might have better luck.

Dave Wolf
Internet Applications Division

"Jamie Crutchley" <jdcrutch@raystl.com> wrote in message
news:biGyh7Nm$GA.275@forums.sybase.com...
> I'm trying to get updates into a database from an EJB. I've been trying
to
> use
> the DynamicTargetCell class to do this, although I'd be open to other
> suggestions
> as long as they don't involve datawindows.
> Here is what I'm doing:
>
> I have an EJB class defined as
> public class sysObjectImpl extends java.lang.Object implements
> com.sybase.jaguar.beans.enterprise.ServerBean
>
> Within this class, I have a String object called version. I also have the
> following defined:
> private powersoft.powerj.db.DynamicTargetCell dt_version = new
> powersoft.powerj.db.DynamicTargetCell(this, "version", "String");
>
> Inside a method which is called by Dynamo script when the object is first
> instantiated, I have the following code:
> if( !query_sysRelease.open() )
> {
> System.err.println("Unable to execute retrieve of sysRelease");
> return false;
> }
> dt_version.setDataColumns( "VERSION" );
> dt_version.setDataSource( query_sysRelease );
> query_sysRelease.moveFirst(true,true);
>
> It was my understanding that all of this would bind the "version" property
> of this object to the "VERSION" column of my query object, then calling
the
> moveFirst would populate the property, and after that my "get" and "set"
> methods for "version" would also change the database column. Trouble is,
> that doesn't seem to be happening. The version property remains in its
> initialized state and changing it has no effect on the database. Any
ideas
> what I'm doing wrong? I'd also be open to suggestions on alternate ways
> of doing this so long as it does not involve DataWindows. Thanks in
> advance.
>
> Jamie Crutchley
> jdcrutch@raystl.com
>
>
>


Jamie Crutchley Posted on 2000-03-28 19:36:45.0Z
Newsgroups: sybase.public.easerver
Reply-To: "Jamie Crutchley" <jdcrutch@raystl.com>
From: "Jamie Crutchley" <jdcrutch@raystl.com>
Subject: Re: Problem updating DB from Jaguar EJB
Date: Tue, 28 Mar 2000 13:36:45 -0600
Lines: 64
Organization: Raytheon
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 128.242.150.59
Message-ID: <347_dWSZ72Om$GA.298@forums.sybase.com>
References: <347_biGyh7Nm$GA.275@forums.sybase.com> <347_pd61VgOm$GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25441
Article PK: 155530

Thanks, I'll repost it.

"Dave Wolf [Sybase]" <dwolf@sybase.com> wrote in message
news:pd61VgOm$GA.298@forums.sybase.com...
> Please try the PowerJ newsgroup. You might have better luck.
>
> Dave Wolf
> Internet Applications Division
>
> "Jamie Crutchley" <jdcrutch@raystl.com> wrote in message
> news:biGyh7Nm$GA.275@forums.sybase.com...
> > I'm trying to get updates into a database from an EJB. I've been trying
> to
> > use
> > the DynamicTargetCell class to do this, although I'd be open to other
> > suggestions
> > as long as they don't involve datawindows.
> > Here is what I'm doing:
> >
> > I have an EJB class defined as
> > public class sysObjectImpl extends java.lang.Object implements
> > com.sybase.jaguar.beans.enterprise.ServerBean
> >
> > Within this class, I have a String object called version. I also have
the
> > following defined:
> > private powersoft.powerj.db.DynamicTargetCell dt_version = new
> > powersoft.powerj.db.DynamicTargetCell(this, "version", "String");
> >
> > Inside a method which is called by Dynamo script when the object is
first
> > instantiated, I have the following code:
> > if( !query_sysRelease.open() )
> > {
> > System.err.println("Unable to execute retrieve of sysRelease");
> > return false;
> > }
> > dt_version.setDataColumns( "VERSION" );
> > dt_version.setDataSource( query_sysRelease );
> > query_sysRelease.moveFirst(true,true);
> >
> > It was my understanding that all of this would bind the "version"
property
> > of this object to the "VERSION" column of my query object, then calling
> the
> > moveFirst would populate the property, and after that my "get" and "set"
> > methods for "version" would also change the database column. Trouble
is,
> > that doesn't seem to be happening. The version property remains in its
> > initialized state and changing it has no effect on the database. Any
> ideas
> > what I'm doing wrong? I'd also be open to suggestions on alternate ways
> > of doing this so long as it does not involve DataWindows. Thanks in
> > advance.
> >
> > Jamie Crutchley
> > jdcrutch@raystl.com
> >
> >
> >
>
>