# Help with a dialect error **URL:** \ **Category:** Classic Servoy\ **Created:** [May 17, 2007, 5:17am UTC](https://forum.servoy.com/t/help-with-a-dialect-error/7518 "2007-05-17T05:17:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![raymanj](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@raymanj](https://forum.servoy.com/u/raymanj)\ **Post date:** [May 17, 2007, 5:17am UTC](https://forum.servoy.com/t/help-with-a-dialect-error/7518/1 "2007-05-17T05:17:43Z")
I have been playing around with the new Servoy 3.5 and have run into a few errors. 1. While trying to add columns to existing tables I get the following when the “Apply” button is clicked in data provider. ```auto Error creating table, java.lang.UnsupportedOperationException: No add column syntax supported by Dialect com.servoy.j2db.persistence.RepositoryException: java.lang.UnsupportedOperationException: No add column syntax supported by Dialect java.lang.UnsupportedOperationException: No add column syntax supported by Dialect ``` 1. When I try to import one of the servoy example files “servoy\_sample\_crm” into the repository I get: ```auto com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: ERROR: type "double" does not exist ``` I installed the JDBC driver “edb-jdbc14.jar” into Servoy’s driver file that came with EnterpriseDB. Any ideas what I am doing wrong. Windows XP Servoy 3.5 b5 EnterpriseDB 8.1 Java 6 ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [May 17, 2007, 7:53am UTC](https://forum.servoy.com/t/help-with-a-dialect-error/7518/2 "2007-05-17T07:53:14Z")
Have you been succesful with Servoy 3 in this setup? It sounds like a driver issue… ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [May 17, 2007, 8:37am UTC](https://forum.servoy.com/t/help-with-a-dialect-error/7518/3 "2007-05-17T08:37:49Z")
As you probably know EnterpriseDB is in fact PostgreSQL. Also Servoy comes with a PostgreSQL driver. I am not sure but it might clash with it. See what happends when you remove the PostgreSQL driver from your setup. Hope this helps. ---
**Author:** ![raymanj](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@raymanj](https://forum.servoy.com/u/raymanj)\ **Post date:** [May 18, 2007, 4:36am UTC](https://forum.servoy.com/t/help-with-a-dialect-error/7518/4 "2007-05-18T04:36:31Z")
Well I removed the postgreSQL driver that came with Servoy (using only Enterprise’s driver in the folder) and tried importing the sample CRM. The following error occurred during import of the solution. ```auto com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: ERROR: type "double" does not exist ``` I tried adding a new column to an existing solution and table. I got the same error as in the original post. So this time, I removed the EnterpriseDB driver and used the driver that came with Servoy for PostgreSQL. I was able to successfully import the CRM example and add new columns to existing tables. I had to change all url’s and driver paths to match postgreSQL not EnterpriseDB’s. PostgreSQL’s url: jdbc:postgresql://localhost:5432/servoy\_repository driver path: org.postgresql.Driver not EnterpriseDB’s: url: jdbc:edb://localhost:5432/servoy\_repository driver path: com.edb.Driver Now my next question is will I be missing any options of EnterpriseDB if I don’t use their driver? Thanks for the help. ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [May 18, 2007, 7:49am UTC](https://forum.servoy.com/t/help-with-a-dialect-error/7518/5 "2007-05-18T07:49:28Z")
> raymanj: > Now my next question is will I be missing any options of EnterpriseDB if I don’t use their driver? I suggest you direct that question to EnterpriseDB and also file a bugreport with them. Hope this helps. ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [May 18, 2007, 1:27pm UTC](https://forum.servoy.com/t/help-with-a-dialect-error/7518/6 "2007-05-18T13:27:20Z")
raymanj, Servoy uses the database name returned by the driver to determine the dialect which specifies the database-specific sql to use. When the db name is not recognized, we fall-back to a generic dialect that may not be correct for the specific database, especially the DDL difference are big (DML is usually quite standard) By using a postgres jdbc url, we recognize the db as postgresql dialect. I have added EnterpriseDB to the list of known dialects and Servoy will use the postgres-specifics when you use the edb driver. This change is included in next beta-release of version 3.5, when it is available you should be able to use the EnterpriseDB driver again. Rob