Recent changes to bugs

Max function on integer field is not working

2004-09-07T01:32:34Z

When max function is used for integer field the result
is based on string. e.g. SELECT MAX(EAML_id) FROM
EA_master_list; returns always 9 even table has EAML_id
as 10.

Max function on integer field is not working

2004-09-06T15:02:29Z

When max function is used for integer field the result
is based on string. e.g. SELECT MAX(EAML_id) FROM
EA_master_list; returns always 9 even table has EAML_id
as 10.

Cannot recompile : missing dependencies

2004-04-18T14:45:18Z

Hello,

I try to recompile Ashpool from the sources provided in
CVS and some classes are missing, notably the package
com.rohanclan.crypto.* (required in the imports of
com.rohanclan.ashpool.core.TableManagerCrypto).

Also the class com.rohanclan.ashpool.cmds.Import is
missing from CVS, but is referenced from
com.rohanclan.ashpool.core.CommandManager.

So could you consider putting the missing dependencies
/ sources files on CVS ? Thanks per advance.

SQL operator AND case sensitive

2004-01-26T16:22:23Z

When I use a query with logical operator 'AND' in
uppercase, the DB return an error. If I use the same
query with lowercase, the DB return correct response.

I use OS "Windows 2000 Pro".
I use I use java version 1.4.1_01

See the following example.

=======================================
Example :

Ashpool~# SELECT * FROM users WHERE login='toto'
AND pwd='toto';
Error at xsl:apply-templates on line 1 of :
XPath syntax error in ?*/*[login='toto' AND pwd?:
expected "]", found "QName AND"
Error with command:
'SELECT * FROM users WHERE login='toto' AND
pwd='toto''
com.rohanclan.ashpool.core.AshpoolException: Failed to
compile stylesheet. 1 err
or detected.
Ashpool~# SELECT * FROM users WHERE login='toto'
and pwd='toto';
==========================================
======================================

toto|toto|

======================================

DatabaseMetaData.getColumns returns rs with unexpected order

2004-01-21T22:20:20Z

I am trying to use Ashpool in an application
development framework. It tries to do some
introspection on tables by doing:
DatabaseMetaData.getColumns(null, "%", tableName, "%")
and then checking the returned recordset for:
- The column name in columnIndex 4
- The column size in columnIndex 7
- If it allows nulls in columnIndex 11

Ashpool does not return a compatible recordset. I don't
know if this is a jdbc requirement, but other databases
return a recordset with columns ordered by the javadoc
description of getColumns.

thanks,
mike

tables with 'SET' in name cannot be queried

2004-01-21T21:27:28Z

If I create a table with 'SET' in the name, it cannot
be queried. Here's a session:
Ashpool~# CREATE TABLE TESTSET ( TEST1 string(30),
TEST2 string(30));
0 Rows Returned.
Total Time: 0 second(s) - 3ms
Ashpool~# SELECT COUNT(*) FROM TESTSET;
Error with command:
'SELECT COUNT(*) FROM TESTSET'
com.rohanclan.ashpool.core.AshpoolException:
datastore/TESTset.xml (No such file or directory)
Ashpool~# CREATE TABLE TESTSET2 ( TEST1 string(30),
TEST2 string(30));
0 Rows Returned.
Total Time: 0 second(s) - 50ms
Ashpool~# SELECT COUNT(*) FROM TESTSET2;
Error with command:
'SELECT COUNT(*) FROM TESTSET2'
com.rohanclan.ashpool.core.AshpoolException:
datastore/TESTset2.xml (No such file or directory)

[ashpool]$ ls datastore/TESTSET*
datastore/TESTSET2.xml datastore/TESTSET.xml
datastore/TESTSET2.xsd datastore/TESTSET.xsd

This is on Linux. I assume you don't experience the
problem on a system with a case-insensitive filesystem.

mike

working with squirrel-sql

2003-10-27T15:29:55Z

1. I loaded the ASHpool JDBC driver to SQuirreL SQL
(http://squirrel-sql.sourceforge.net/.)

2. I created this table:

create table test ( r_one varchar(20) );

3. When I issue the following command:
select * from test;

I get the following error:
Error:
javax.xml.transform.TransformerFactoryConfigurationError
: Provider net.sf.saxon.TransformerFactoryImpl not found

Do I need to add additional jars to my classpath to get
this to work ?

Database URL

2003-07-19T10:11:03Z

In Users Guide page says:

- Using the JDBC Driver

Driver: com.rohanclan.ashpool.jdbc.Driver
URL: jdbc:ashpool://file:// [path]

Example 3.

URI on windows could look like
jdbc:ashpool://file://C:\thisdir\thatdir\myxmldir
and on Unix the URI could look like
jdbc:ashpool://file:///thisdir/thatdir/myxmldir

But in Example4. JDBC Test Program says:

command: java -cp Ashpoo.jar;./ JdbcTest
jdbc:ashpool:file//C:\myxml
^
Two slashes are missing? Is this wrong?

Regards.

Select columns from factbook

2003-04-12T04:50:31Z

Running the following syntax:

select columns from factbook

it returns blank information in the query result. see below.

Ashpool~# select columns
Ashpool~# from factbook;
** Select Took: 3431ms
** XML->ResultSet Took: 10ms
================================================================================
columns|
--------------------------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
================================================================================
265 Row(s) Returned.
Total Time: 3744ms

Select TOP

2003-04-12T04:47:36Z

Rob,
Maybe the top syntax is not supported yet in which case i appologize in advance for putting this in.

Performed the following query on the factbook.xml document.

SELECT TOP 1 * FROM factbook

I would have expected this to return 1 row. Instead it returned 265 rows.

If you select the following:

SELECT TOP 1 country from factbook

you get the following error.

Ashpool~# select top 1 country from factbook;
Error at xsl:element on line 1 of file:/Users/markj/java/Ashpool/:
Element name is not a valid QName
Error at xsl:element on line 1 of file:/Users/markj/java/Ashpool/:
Invalid element name: 1
Error with command:
'select top 1 country from factbook'
java.sql.SQLException: javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 2 errors detected.

Mark