Hello,
I (still) have the problem in Servoy Developer 3.1b3 that I get an error when I specify a schema name (here: development) in the Server DB properties:
org.postgresql.util.PSQLException: ERROR: syntax error at or near ““development””
I know there was a fix a few month ago but it did not help unfortunately.
I use Postgres 8.2 on a Mac. But it makes no difference when I try this on Windows with the same database.
I know you can solve the problem within Postgres by setting the search_path variable, but it would be nice, if I could specify the schema name within Servoy.
Thanks in advance.
Christoph
It looks like schema is still not working .
java.sql.SQLException: Incorrect syntax near the keyword ‘schema’.
Error occurs when entering a schema name in the preferences
I wanted to see if schema’s are useful for a certain situation that I have, but unfortunately I can’t test it. (schemaname was ‘online’, so not ‘schema’)
Martin,
Which database and driver are you using?
Servoy calls standard jdbc methods to retrieve the list of tables and views.
I think this is an error in the driver and/or database implementation.
Maybe you can try a small jdbc program that calls DatabaseMetaData.getTables().
Rob
Hi Rob,
I’m using the following settings:
URL=jdbc:jtds:sqlserver:///
Driver=net.sourceforge.jtds.jdbc.Driver
I’m not familiar with JAVA and JDBC so I’m not able to write such a program.
The error occurs when changing the preferences in Servoy.
As far as I can see the problem is not that Servoy doesn’t recognize the tables (I can’t determine yet, if Servoy handels this correct).
When I put in my database a table into a schema, and I tried to use this table within Servoy (so without setting the ‘schema’ value), then Servoy doesn’t recognize the table, but that doesn’t seem wrong to me.
Kind regards,
Martin