alexandrethiel/paradoxdriver

Automatically exported from code.google.com/p/paradoxdriver

paradoxdriver's Issues

Datatype Decimal Not recognized

Steps to reporduce

Execute a simple select on the table PNT.DB (see attachment fro structure 
definition)  

    DataSource dataSource = (DataSource) applicationContext
                .getBean("dataSourceParadox");
    JdbcTemplate temp = new JdbcTemplate( dataSource);
    List<String> result =  temp.query("select * from PNT.DB",new RowMapper<String>(){
        @Override
    public String mapRow(ResultSet rs, int rowNum)
                throws SQLException {
            return rs.getString(14);
    }
     });
     System.out.println(result);


I get   uncategorized SQLException for SQL [select * from PNT.DB]; SQL state 
[1007]; error code [0]; Type 23 not found.: select * from PNT.DB;

The problem is with column 14: 'PntImportoEuro' type Decimal


Type to be recognized as Decimal.


What version of the product are you using? On what operating system?

paradoxdriver 1.1
paradox file V 7.0 (structure see attachment)
windows 7 32-bit


I tried to resolve the bug by myself using the source code imported from svn 
1.1 tag.
I modify  method

  com.googlecode.paradox.data.TableData.loadData(ParadoxConnection, ParadoxTable, Collection<ParadoxField>)

line 143 like this

    case 23:
    case 5:
    case 6:{
              .....

    }

To convert the Decimal value into double but it didn't work I got strange 
negatives numbers and also null values.

Davide

Original issue reported on code.google.com by [email protected] on 13 Aug 2014 at 3:47

Attachments:

• datatable.png

Allow specify charset as url parameter

Reading some old tables needs to specify charset parameter:

jdbc:paradox:/dir/to/files?charSet=cp1250

Patch is attached.

Original issue reported on code.google.com by [email protected] on 14 Feb 2015 at 9:57

The driver don't support WHERE clausule

Any WHERE clausule don't works

Original issue reported on code.google.com by leonhad on 10 Jul 2014 at 12:19

possible file not found

Classe ParadoxConnection.java - method contructor - line 89.

Original issue reported on code.google.com by [email protected] on 10 Jul 2014 at 7:44

Submit the Driver to Maven Central

Branch name: paradoxdriver-1.1

Deploy some usefull version.

Original issue reported on code.google.com by leonhad on 17 Jul 2014 at 7:36

Web site don't have any information or documentation

The web site or wiki don't have any documentation about use or copyright.

Original issue reported on code.google.com by leonhad on 10 Jul 2014 at 7:43

does it support chinsese? can you help me?

Exception in thread "main" java.nio.BufferUnderflowException
    at java.nio.Buffer.nextGetIndex(Buffer.java:498)
    at java.nio.HeapByteBuffer.getInt(HeapByteBuffer.java:355)
    at com.googlecode.paradox.data.TableData.loadData(TableData.java:141)
    at com.googlecode.paradox.ParadoxStatement.executeQuery(ParadoxStatement.java:111)
    at test.DbTest11.main(DbTest11.java:28)

Original issue reported on code.google.com by [email protected] on 28 Jun 2015 at 2:53

SQLParser don't track column and line numbers

What steps will reproduce the problem?
1. Put any error in SQL.

What is the expected output? What do you see instead?
Error with column and line numbers

Original issue reported on code.google.com by leonhad on 21 Jul 2014 at 5:08

Boolean field value is always TRUE

Boolean field value is always TRUE. Simple patch is bellow.


Index: src/main/java/com/googlecode/paradox/data/TableData.java
===================================================================
--- src/main/java/com/googlecode/paradox/data/TableData.java    (revision 54)
+++ src/main/java/com/googlecode/paradox/data/TableData.java    (working copy)
@@ -159,7 +159,7 @@
                                } else if (v == -127) {
                                    fieldValue = new FieldValue(Boolean.TRUE, Types.BOOLEAN);
                                } else if (v == -128) {
-                                   fieldValue = new FieldValue(Boolean.TRUE, Types.BOOLEAN);
+                                   fieldValue = new FieldValue(Boolean.FALSE, Types.BOOLEAN);
                                } else {
                                    throw new SQLException("Invalid value " + v + ".");
                                }

Original issue reported on code.google.com by [email protected] on 19 Feb 2015 at 8:38