I just installed the software and am using JBoss and Mysql.
When I start the software I see a login screen. I enter "admin" and the password and press OK. The next screen displays an error message that says "No options from url ../modelview/getmodel.jsp"
I looked in the getmodel.jsp code to see what it's trying to do, but I can't figure out how to resolve the error.
Does anyone have advice on how to fix this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When I run "select * from m_model" there are two rows that are returned.
MDL_ID=-1
MDL_NAME=Meta
MDL_ID=7
MDL_NAME=Open Model
I checked the pooman.props file and it seemed correct. I was able to login to the MySQL database using the connection string, username, and passowrd that is in the poolman.props file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Don't give up. What kind of browser do you use. We have done testing on Mozilla and IE5.5 or higher.
\\localhost:8080\openmodeling\modelview\getmodel.jsp is returning an xml stream.
This xml stream is sent back to the client. The include file xml2htmlform.js is transforming it to a form field.
Is the XML stream filled right what is in it?
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Don't give up. What kind of browser do you use. We have done testing on Mozilla and IE5.5 or higher.
\\localhost:8080\openmodeling\modelview\getmodel.jsp is returning an xml stream.
This xml stream is sent back to the client. The include file \include\xml2htmlform.js is transforming it to a form field.
Is the XML stream filled right what is in it?
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried it using Internet Explorer 6.0, Mozilla 1.4, and Opera.
When I execute the URL that you listed, here is what I get. It's a MySQL error message.
- <error>
- <![CDATA[ Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS (SELECT '' FROM M_MODEL_USERGROUP MUG WHERE MUG.MDL_ID =" at: openm.showallautmodels (MySQL) SELECT MDL.MDL_ID, MDL.MMD_ID, MDL.DEF_MODEL, MDL.MDL_NAME, MDL.MDL_DATABASE, MDL.MDL_DESC, MDL.MLN_ID FROM M_MODEL MDL WHERE NOT EXISTS (SELECT '' FROM M_MODEL_USERGROUP MUG WHERE MUG.MDL_ID = MDL.MDL_ID AND MUG.MUG_ID = ? AND MUG.PERM_SELECT = 1) AND MDL.MDL_ID > 0 ORDER BY MDL.MDL_NAME
]]>
</error>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Now we getting somewhere. The error is clear, you must use a my-sql version that supports sub-queries in version 4.1 it will be standard. In the alpha release we have used it. It worked out well already. All other dbms have this property long time ago.
I just installed the software and am using JBoss and Mysql.
When I start the software I see a login screen. I enter "admin" and the password and press OK. The next screen displays an error message that says "No options from url ../modelview/getmodel.jsp"
I looked in the getmodel.jsp code to see what it's trying to do, but I can't figure out how to resolve the error.
Does anyone have advice on how to fix this?
Hi,
Thanx for feedback.
What version of Mysql are you using? Is your database configured well.
SELECT * FROM M_MODEL is showingl all models. If this is not the case mysql.
Another problem could be (less likely) your poolman.props file in web-inf.
John
I am running version 4.0.15-max on Suse Linux 9.
When I run "select * from m_model" there are two rows that are returned.
MDL_ID=-1
MDL_NAME=Meta
MDL_ID=7
MDL_NAME=Open Model
I checked the pooman.props file and it seemed correct. I was able to login to the MySQL database using the connection string, username, and passowrd that is in the poolman.props file.
Hi,
Don't give up. What kind of browser do you use. We have done testing on Mozilla and IE5.5 or higher.
\\localhost:8080\openmodeling\modelview\getmodel.jsp is returning an xml stream.
This xml stream is sent back to the client. The include file xml2htmlform.js is transforming it to a form field.
Is the XML stream filled right what is in it?
John
Hi,
Don't give up. What kind of browser do you use. We have done testing on Mozilla and IE5.5 or higher.
\\localhost:8080\openmodeling\modelview\getmodel.jsp is returning an xml stream.
This xml stream is sent back to the client. The include file \include\xml2htmlform.js is transforming it to a form field.
Is the XML stream filled right what is in it?
John
I tried it using Internet Explorer 6.0, Mozilla 1.4, and Opera.
When I execute the URL that you listed, here is what I get. It's a MySQL error message.
- <error>
- <![CDATA[ Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS (SELECT '' FROM M_MODEL_USERGROUP MUG WHERE MUG.MDL_ID =" at: openm.showallautmodels (MySQL) SELECT MDL.MDL_ID, MDL.MMD_ID, MDL.DEF_MODEL, MDL.MDL_NAME, MDL.MDL_DATABASE, MDL.MDL_DESC, MDL.MLN_ID FROM M_MODEL MDL WHERE NOT EXISTS (SELECT '' FROM M_MODEL_USERGROUP MUG WHERE MUG.MDL_ID = MDL.MDL_ID AND MUG.MUG_ID = ? AND MUG.PERM_SELECT = 1) AND MDL.MDL_ID > 0 ORDER BY MDL.MDL_NAME
]]>
</error>
Hi Bruce,
Now we getting somewhere. The error is clear, you must use a my-sql version that supports sub-queries in version 4.1 it will be standard. In the alpha release we have used it. It worked out well already. All other dbms have this property long time ago.
Mysql with subqueries you will find it at:
http://www.mysql.com/downloads/mysql-4.1.html
Out of the release notes:
C.2 Changes in release 4.1.x (Alpha)
Version 4.1 of the MySQL server includes many enhancements and new features. Binaries for this version are available for download at http://www.mysql.com/downloads/mysql-4.1.html.
Subqueries and derived tables (unnamed views). See section 13.1.8 Subquery Syntax.
By the way it was there in our installation guide but not clear enough (i dont mind to help you!)
You can run two instances of mysql on the same machine.
For what use do you want to use the software?
John
I upgraded to 4.1 and that fixed the problem.
Thanks!
Bruce
Hi,
Thanx let me know you other experiences as well.
By the way Opera is not working because we didn't find a way to parse XML with javascript. We missed statements like parsexml ( '<e/>'),
One of the design goals server processes XML sends XML back to the client.
Hope you can contribute somehow in future.
John