Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
AW: [dali-dev] db schemas functionality for MS SQL Server 2000 notworking

Hi!

We had similar issues using Dali with MaxDB. Changing our JDBC driver to the latest version fixed the issue.

Best Regards,
Robin de Silva Jayasinghe

-----Ursprüngliche Nachricht-----
Von: dali-dev-bounces@xxxxxxxxxxx [mailto:dali-dev-bounces@xxxxxxxxxxx] Im Auftrag von Angel Todorov
Gesendet: Dienstag, 5. September 2006 13:47
An: dali-dev@xxxxxxxxxxx
Betreff: [dali-dev] db schemas functionality for MS SQL Server 2000 notworking

Hi All,

I am using version 0.5.0v200606270000-87cMN7N7crMMMR of the Dali Java
Persistence API, I can successfully create (and test) a DB connection
to my MS SQL server , but once i try to browse the schema under the
"Database Explorer" View, i cannot see anything listed under the node
"schemas" (Connections -> MSSQL -> Schemas -> empty ). Moreover, when
i create an EJB 3.0 Entity, and try to generate DDL , once i have
described my entity (which is, successfully built ), i get strange
errors , such as :

An SQL exception was reported during this operation.
  [NWMss][SQLServer JDBC Driver]This driver is locked for use with
embedded applications.

Starting run

ALTER TABLE null.TMP_TEST ADD CONSTRAINT gfdgdf_PK PRIMARY KEY (id)

java.sql.SQLException: [NWMss][SQLServer JDBC Driver]Object has been closed.

Also notice the "Null" in the table name (should be replaced by the
valid SCHEMA name ! )


I would be grateful for any feedback on the above 2 problems (I guess
they are related). Thank you very much in advance.

Best Regards,
Angel Todorov
_______________________________________________
dali-dev mailing list
dali-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dali-dev


Back to the top