JDBC connection to iSeries AS400 or i5

[Marc Vos-3]

After 2 years, my inlines to the iSeries database do not accept the -
table parameter anymore in the inlines to our iSeries connection, as  
set up in SiteAdmin. It uses the com.ibm.as400.access JDBC driver. As  
weird as this sounds, it's all too true.

I have been swearing and trying all morning to get the query through  
this JDBC connection running, because we found that as of last weekend  
they all gave errors. Just now I decided to remove the -table  
parameter, and hop, query worked. Grrrrrrrrr!!

Here's the inline that has been in use for two years now:

        inline(-database='FCS',
                -table='USRLOG',
                -sql="select max(timestmp) as LDTS from db.usrlog where aktion like  
'GEDRUCKT%'");

As of last sunday 00:15 hrs exactly, this inline did not work anymore.  
The error in SiteAdmin was 'Token . not valid. Expected <IDENTIFIER>'.  
So I checked the JDBCLog.txt and this is what I found when the above  
query was executed:

        [11/03/09 11:15:41] > Executing ACTION_INFO with params: SQL=SELECT *  
FROM "S655D82E".."USRLOG" WHERE 0=1
        [11/03/09 11:15:41] [SQL0104] Token . ungültig. Gültige Token:  
<IDENTIFIER>.
        java.sql.SQLException: [SQL0104] Token . ungültig. Gültige Token:  
<IDENTIFIER>.
                at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
                at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
                at com.ibm.as400.access.AS400JDBCStatement.commonPrepare
(AS400JDBCStatement.java:1506)
                at com.ibm.as400.access.AS400JDBCStatement.executeQuery
(AS400JDBCStatement.java:1937)
                at com.omnipilot.jdbc.JDBCDataSource.doInfo(JDBCDataSource.java:1591)
                at com.omnipilot.jdbc.JDBCDataSource.DS_FUNC(JDBCDataSource.java:802)
        [11/03/09 11:15:41] Nested exception:
                [1] Message: [SQL0104] Token . ungültig. Gültige Token: <IDENTIFIER>.
                    SQLState: 42601
                    ErrorCode: -104


Note that it is an ACTION_INFO and note the two dots between  
"S655D82E".."USRLOG" and the craziest thing: the query is completely  
different.

If I execute the query from the inline, inside the SQL-Browser in  
SiteAdmin, I got this in JDBCLog.txt:

        [11/03/09 11:34:06] > Executing ACTION_SQL with params: SQL=select max
(timestmp) as LDTS from db.usrlog where aktion like 'GEDRUCKT%'
        [11/03/09 11:34:06] SQL: select max(timestmp) as LDTS from db.usrlog  
where aktion like 'GEDRUCKT%'
        [11/03/09 11:34:22] Action exec time: 15609 msec


Which is as it should be. If I change the inline to this:

        inline(-database='FCS',
                -sql="select max(timestmp) as LDTS from db.usrlog where aktion like  
'GEDRUCKT%'");

It works and I get the same result in JDBCLog.txt as the direct  
executed query.

So now I am changing all code and remove the -table parameter from  
inlines that access the iSeries.


Has anybody who works with iSeries experienced anything like this  
before?

- -
Thanks,
Marc


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/

[Fabrizio Carioni]

Hi, it' some time that I noticed that some new databases have
appeared in my Lasso Administration page under the Lasso Internal
connector.
That's sqllite I believe.
Beside the usual lasso_internal, lasso_admin etc here are the names
of the new ones:

:memory:    (status new)
lasso_site_1-journal   (status not available)
lasso_internal-journal    (status not available)
lasso_site_1-m49rsxgntr1axgceogma-journal     (status not available)

I have other 5/6 like this.
I never noticed them before... should I worry? Should I delete them?

This is on Lasso 8.5.5 on CentOs.

Thx in advance for any help!

Ciao
--
======================================================================
Fabrizio Carioni - Golem100 S.r.l.
Gran Sasso (via), 50 - 20090 - Segrate (Mi) - Italy
Voice [phone]  -  Fax [phone]  - Mobile [phone]
Email fabrizio@... - URL http://www.golem100.com/
======================================================================

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/

[Steve Piercy]

On 11/3/09 at 2:15 PM, fab_liste@... (Fabrizio Carioni) pronounced:

>Hi, it' some time that I noticed that some new databases have
>appeared in my Lasso Administration page under the Lasso
>Internal connector.
>That's sqllite I believe.
>Beside the usual lasso_internal, lasso_admin etc here are the names of the new ones:
>
>:memory:    (status new)
>lasso_site_1-journal   (status not available)
>lasso_internal-journal    (status not available)
>lasso_site_1-m49rsxgntr1axgceogma-journal     (status not available)
>
>I have other 5/6 like this.
>I never noticed them before... should I worry? Should I delete them?

I vaguely recall that on a restart of Lasso Server they will go
away as part of Lasso's maintenance.  It's been asked before on
the list.

--steve

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<web@...>                  <http://www.StevePiercy.com/>


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/

[Pieter Claerhout-2]

The journal files are specific to the SQLite databases. Everytime a
database transaction is active in SQLite, it will create a journal
file with the changes. Once the transaction is committed, the data is
written to the actual database. If you rollback the transaction, the
journal just disappears.

You can read more about it on
http://www.sqlite.org/atomiccommit.html#section_3_5

My guess is that Lasso should not even should these files in the first place.

Cheers,

pieter

2009/11/3 Steve Piercy - Web Site Builder <Web@...>:

> On 11/3/09 at 2:15 PM, fab_liste@... (Fabrizio Carioni) pronounced:
>
>> Hi, it' some time that I noticed that some new databases have appeared in
>> my Lasso Administration page under the Lasso Internal connector.
>> That's sqllite I believe.
>> Beside the usual lasso_internal, lasso_admin etc here are the names of the
>> new ones:
>>
>> :memory:    (status new)
>> lasso_site_1-journal   (status not available)
>> lasso_internal-journal    (status not available)
>> lasso_site_1-m49rsxgntr1axgceogma-journal     (status not available)
>>
>> I have other 5/6 like this.
>> I never noticed them before... should I worry? Should I delete them?
>
> I vaguely recall that on a restart of Lasso Server they will go away as part
> of Lasso's maintenance.  It's been asked before on the list.
>
> --steve
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <web@...>                  <http://www.StevePiercy.com/>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/Lasso/Browse/
> Manage your subscription: http://www.ListSearch.com/Lasso/
>
>
>

--
pieter claerhout . pieter@... . http://www.yellowduck.be/

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/