8:55 a.m.
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Priority: Critical
Fix For: 3.3.0.M5
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias does
not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:43 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Jiri Peterka updated JBIDE-10467:
---------------------------------
Fix Version/s: 3.3.0.Beta1
(was: 3.3.0.M5)
Priority: Major (was: Critical)
After several tries it generated tables so it works but there are still weird errors while
generating, so moving to beta1
java.sql.SQLException: Table not found: PRODUCTS in statement [alter table
PUBLIC.PRODUCTS]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:383)
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:43 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Jiri Peterka updated JBIDE-10467:
---------------------------------
Attachment: hb-schema.log
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:12 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov commented on JBIDE-10467:
-----------------------------------------
Jiri, do you see the tables were actually create in the schema Public?
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:18 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov commented on JBIDE-10467:
-----------------------------------------
About alias problem:
I tried to find similar problems by Google and seem you didn't specify database name
in your url. This is an HSQLDB specific problem. The url should have database name/alias
like mydb
in the url:
jdbc:hsqldb:hsql://localhost/mydb
or it should be specified when server starts:
java -cp ../lib/hsqldb.jar org.hsqldb.Server -database.0 file:xdb -dbname.0 mydb
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:05 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov commented on JBIDE-10467:
-----------------------------------------
Please check this manually on the same java project using:
Configuration cfg = ...;
SchemaExport export = new SchemaExport(cfg);
export.create(false, true);
export.getExceptions();
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:57 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov edited comment on JBIDE-10467 at 12/14/11 7:56 AM:
-------------------------------------------------------------------
Jiri, do you see the tables were actually created in the schema Public?
was (Author: dgeraskov):
Jiri, do you see the tables were actually create in the schema Public?
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:39 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Jiri Peterka commented on JBIDE-10467:
--------------------------------------
Strange, I started HSQLDB as same as you before but currently I'm not able to
replicate that alias error even with new database. However there are still SQL errors
which I suppose should not be here, see hb-schema.log. I'll try your diagnostic steps
and let you know.
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:35 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov resolved JBIDE-10467.
-------------------------------------
Resolution: Done
After discussion:
the problem is resolved(workaround) by specifying used database name throught url or
server parameter.
This a way of how hsqldb should be used.
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:37 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov resolved JBIDE-10467.
-------------------------------------
Resolution: Rejected
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:10 a.m.
[
https://issues.jboss.org/browse/JBIDE-10467?page=com.atlassian.jira.plugi...
]
Jiri Peterka closed JBIDE-10467.
--------------------------------
Verified in jbosstools-3.3_stable_branch.aggregate-Update-2012-02-24_23-15-15-H93, L64
Run Schema Export from Hibernate Console Configuration error
------------------------------------------------------------
Key: JBIDE-10467
URL: https://issues.jboss.org/browse/JBIDE-10467
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: hibernate
Affects Versions: 3.3.0.M5
Reporter: Jiri Peterka
Assignee: Dmitry Geraskov
Fix For: 3.3.0.Beta1
Attachments: hb-schema.log
Hibernate Configuration Run SchemaExport action gives me:
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias
does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.hibernate.eclipse.libs.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5149
days inactive
5227
days old
jbosstools-issues@lists.jboss.org
10 comments
7 participants
participants (7)
-
Dmitry Geraskov (Commented) (JIRA) -
Dmitry Geraskov (Issue Comment Edited) (JIRA)
-
Dmitry Geraskov (JIRA)
-
Jiri Peterka (Commented) (JIRA)
-
Jiri Peterka (Created) (JIRA)
-
Jiri Peterka (JIRA)
-
Jiri Peterka (Updated) (JIRA)