is there a known problem in the Developer's GUI with using catalogs having a hyphen in the name?
I am using jdbforms version 2.5_20050226 with JDK 1.4.2_04 on MS SQL Server 8.00.818
After entering all the information I get a warning 'Not tables of typ ('TABLE' 'VIEW') found with catalog='blabla-test', schemapattern='null', tablename pattern='null'
If I am doing the same thing on database 'blabla' it works fine. I already checked all access-rights. Also, the jdbForms-Application runs with both, live and test database.
Any ideas?
Thanks,
Frank
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This happens, when I click on the "Generate XML!" button if the radio button "in catalog with name" is active and the selected catalog name contains a hyphen, as in blabla-Test. After having copied the database as blablaTest, it works fine.
If I click on the radio button "in all catalogs", then the generated XML contains a list of the tables of the user's default database, but without the field information.
Hello,
is there a known problem in the Developer's GUI with using catalogs having a hyphen in the name?
I am using jdbforms version 2.5_20050226 with JDK 1.4.2_04 on MS SQL Server 8.00.818
After entering all the information I get a warning 'Not tables of typ ('TABLE' 'VIEW') found with catalog='blabla-test', schemapattern='null', tablename pattern='null'
If I am doing the same thing on database 'blabla' it works fine. I already checked all access-rights. Also, the jdbForms-Application runs with both, live and test database.
Any ideas?
Thanks,
Frank
This is possible. Could you try where this happens in devgui?
I am not working with this tool - so please help us!
Regards,
Henner
This happens, when I click on the "Generate XML!" button if the radio button "in catalog with name" is active and the selected catalog name contains a hyphen, as in blabla-Test. After having copied the database as blablaTest, it works fine.
If I click on the radio button "in all catalogs", then the generated XML contains a list of the tables of the user's default database, but without the field information.
e.g.:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<dbforms-config>
<date-format>dd.MM.yyyy</date-format>
<table name="ArbeitsfreieTage">
<!-- add "granted-privileges" element for security constraints -->
</table>
...
</dbforms-config>
Regards,
Frank
We need your help! Please could you debug the devgui application and repair this fault?
Thanks
Henner
It turns out that the ResultSet returned in line 424 of XMLConfigGenerator.java
ResultSet tablesRS = dbmd.getTables(catalog, schemaPattern,
tableNamePattern, types);
contains no records.
catalog is 'personal-test' while schemaPattern and tableNamePattern are null. types contains 'TABLE' and 'VIEW', as expected.
Looks like this is a bug in SQL Server: http://www.sqltalk.org/ftopic885.html
OK, then it's not a dbforms problem.
Thanks for your help but we can not do anything here.
Maybe you could use another driver?
Henner
That's what I just did.
With the jTDS driver (http://jtds.sourceforge.net/) it works.
Thanks Henner,
Frank