[JBoss JIRA] (JBIDE-11907) import.sql should warn me if I have multiple lines as it seems hibernate does not like that, or is this is hibernate issue?
5:34 p.m.
Jim Tyrrell created JBIDE-11907:
-----------------------------------
Summary: import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Reporter: Jim Tyrrell
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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
5:59 p.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Alexey Kazakov updated JBIDE-11907:
-----------------------------------
Assignee: Dmitry Geraskov
Component/s: hibernate
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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
1:23 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov commented on JBIDE-11907:
-----------------------------------------
Yes, this is hibernate core behaviour.
It expects you have each statement on separate line.
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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
1:25 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov edited comment on JBIDE-11907 at 5/18/12 2:24 AM:
------------------------------------------------------------------
Yes, this is hibernate core behaviour.
It expects you have each statement on separate line.
See org.hibernate.tool.hbm2ddl.SchemaExport#importScript()
The class is in hibernate*.jar
was (Author: dgeraskov):
Yes, this is hibernate core behaviour.
It expects you have each statement on separate line.
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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:04 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Jim Tyrrell commented on JBIDE-11907:
-------------------------------------
That may be true but for a long sql statement this makes it really hard to look at and
view and see what is being brought into the database. For example the MySQL command line
client and piping data into the MySQL command supports multiple line inputs. If this
would be possible to be supported it would improve usability.
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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:16 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov commented on JBIDE-11907:
-----------------------------------------
I agree with you, guys. IMO statements should be separated with ';' but not new
line.
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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:51 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Max Rydahl Andersen updated JBIDE-11907:
----------------------------------------
Fix Version/s: 3.4.x
agree that import.sql could be better but its a hibernate core issue.
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
Fix For: 3.4.x
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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
10:02 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Jim Tyrrell commented on JBIDE-11907:
-------------------------------------
It would be awesome if this can be fixed addressed at some point in the future...in
Hibernate 4...no need to back port to 3.
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
Fix For: 3.4.x
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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:08 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov commented on JBIDE-11907:
-----------------------------------------
Please create the issue/feature request in Hibernate jira
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
Fix For: 3.4.x
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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:09 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Dmitry Geraskov resolved JBIDE-11907.
-------------------------------------
Resolution: Migrated to another ITS
Created the issue in Hibernate core jira: https://hibernate.onjira.com/browse/HHH-7488
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
Fix For: 3.4.0.M1
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
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
5:08 a.m.
[
https://issues.jboss.org/browse/JBIDE-11907?page=com.atlassian.jira.plugi...
]
Jiri Peterka closed JBIDE-11907.
--------------------------------
To be resolved on Hibernate side
import.sql should warn me if I have multiple lines as it seems
hibernate does not like that, or is this is hibernate issue?
---------------------------------------------------------------------------------------------------------------------------
Key: JBIDE-11907
URL: https://issues.jboss.org/browse/JBIDE-11907
Project: Tools (JBoss Tools)
Issue Type: Feature Request
Components: hibernate
Reporter: Jim Tyrrell
Assignee: Dmitry Geraskov
Fix For: 4.0.0.Alpha1
For example this line does not work:
insert into Event (id, name, description, major, picture, version) values (2,
'Rock concert of the decade',
'Get ready to rock...',
true,
'http://dl.dropbox.com/u/65660684/640px-Weir%2C_Bob_(2007)_2.jpg',
It also has bad quotes in it, the tool should give you a better error message on that
also.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4407
days inactive
4524
days old
jbosstools-issues@lists.jboss.org
10 comments
5 participants
participants (5)
-
Alexey Kazakov (JIRA) -
Dmitry Geraskov (JIRA)
-
Jim Tyrrell (JIRA)
-
Jiri Peterka (JIRA)
-
Max Rydahl Andersen (JIRA)