Wayne,
First do a simple query like "SELECT 1" just to double check the DBMS.
Then try grabbing just one row "SELECT packagename FROM Packages WHERE
packagename = '{known name}'"
If that works, then we may be looking for a bug dealing with non-value. Try
"SELECT packagename FROM Packages WHERE packagename IS NOT NULL"
What version of TS are you running? There was a JDBC fix in 7.1.1 and I have
another fix (which may be your problem) coming in 7.1.5.
Robert
-----Original Message-----
From: Wayne Irvine [mailto:[email protected]]
Sent: Tuesday, July 09, 2019 11:34 PM
To: [email protected]
Subject: Re: TeraScript-Talk: First time doing Direct_DBMS
> On 10 Jul 2019, at 4:26 pm, ubslab <[email protected]> wrote:
>
> Wayne,
> So none the following forms will work in the action?
>
> SELECT packagename FROM Packages
>
Error
An error occurred while processing your request:
File: SQLfindpkgs.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -101
General error during data source operation.
[Application File] [2] START /sandbox/SQLfindpkgs.taf TeraScript
Server 7
[user$ Vars] [2] variableTimeout=30; foundset=[Array:553x36];
elcount=20; endpoint=20;
[Direct DBMS Action] [2] Direct_DBMS : over60_db
[Datasource] [288] No existing connection to the data source found,
creating a new connection. DSN: jdbc.over60_db; User: witango;
[Query] [2580] SELECT packagename FROM Packages
[Error] [4965] -101 General error during data source operation.
[user$ Vars] [4965] variableTimeout=30; foundset=[Array:553x36];
elcount=20; endpoint=20;
[request$ Vars] [4965] variableTimeout=30;
>
> SELECT P1.packagename FROM Packages P1
>
Error
An error occurred while processing your request:
File: SQLfindpkgs.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -101
General error during data source operation.
[Application File] [2] START /sandbox/SQLfindpkgs.taf TeraScript
Server 7
[user$ Vars] [2] variableTimeout=30; foundset=[Array:553x36];
elcount=20; endpoint=20;
[Direct DBMS Action] [2] Direct_DBMS : over60_db
[Datasource] [289] No existing connection to the data source found,
creating a new connection. DSN: jdbc.over60_db; User: witango;
[Query] [2635] SELECT P1.packagename FROM Packages P1
[Error] [5055] -101 General error during data source operation.
[user$ Vars] [5055] variableTimeout=30; foundset=[Array:553x36];
elcount=20; endpoint=20;
[request$ Vars] [5055] variableTimeout=30;
> SELECT P1.packagename FROM Packages AS P1
>
Error
An error occurred while processing your request:
File: SQLfindpkgs.taf
Position: Direct_DBMS
Class: Internal
Main Error Number: -101
General error during data source operation.
[Application File] [1] START /sandbox/SQLfindpkgs.taf TeraScript
Server 7
[user$ Vars] [1] variableTimeout=30; foundset=[Array:553x36];
elcount=20; endpoint=20;
[Direct DBMS Action] [1] Direct_DBMS : over60_db
[Datasource] [304] No existing connection to the data source found,
creating a new connection. DSN: jdbc.over60_db; User: witango;
[Query] [2608] SELECT P1.packagename FROM Packages AS P1
[Error] [5006] -101 General error during data source operation.
[user$ Vars] [5007] variableTimeout=30; foundset=[Array:553x36];
elcount=20; endpoint=20;
[request$ Vars] [5007] variableTimeout=30;
Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: [email protected]
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe terascript-talk" in the body.
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe terascript-talk" in the body.
