Menu
▾
▴
Re: [Makumba-user] SQL Internal Makumba error
|
From: Manuel <ma...@ma...> - 2010-03-08 22:21:54
|
Hi Sebastian, this looks like a bug with the default database that comes with the makumba maven installation (which is a java-based HSQLDB database). In order to develop your project, I would recommend that you use MySQL instead (http://www.mysql.com/downloads/mysql/), which is the DBMS that works best with makumba. After installing MySQL, you'll need to create a new database: - if you're using windows or linux you should be able to run a MySQL client window (by opening a command shell and running 'mysql'), there you can issue 'create database blog;' in order to create a new database called 'blog' - if you're using Mac OS X you can use the MySQL Administrator GUI that comes with the distribution, then go to the Catalogs tab and create a new database there. You'll then need to configure the database connection in Makumba.conf. The connection URL for MySQL looks like: connection.url=jdbc:mysql://localhost/<databaseName>?user=root&password= I will file a bug report for this on bugzilla (http://bugs.makumba.org), as indeed it's a rather annoying issue. hope this helps, manu On Mon, Mar 8, 2010 at 11:13 PM, Sebastian Öhrn <seb...@gm...> wrote: > Hi, > I'm trying to set up a simple blog web application in Makumba. Basically I > just translated the Person example that you start with into Posts instead. > Eventually I want to be able to comment on posts as well but I'm starting > with just simple posts. My Post.mdd looks like this: > title = text > content = text > I changed index.jsp to look like this: > <%@ taglib uri="http://www.makumba.org/presentation" prefix="mak" %> > <html> > <head> > <title>Hello world!</title> > </head> > <body> > <h1>Create a new post</h1> > <mak:newForm type="general.Post" action="index.jsp"> > Title: <mak:input field="title" /><br/> > Content: <mak:input field="content" /> > <mak:submit/> > </mak:newForm> > <h1>List of posts</h1> > <mak:list from="general.Post p"> > <mak:value expr="p.title" /> > </mak:list> > <br /> > <a href="index.jspx">View source</a> > </body> > </html> > However, when I try to add a new post through the form, I get an error page > with the title "SQL Internal Makumba error", and the message: > > While executing page /index.jsp > > The problem is related to SQL: > SQLstate: 22003 > ErrorCode: -95 > Message: Type Conversion not supported > > Refer to your SQL server's documentation for error explanation. > Please check the configuration of your webapp and SQL server. > Please report to the developers. > java.sql.SQLException: Type Conversion not supported > at org.hsqldb.jdbc.Util.sqlException(Unknown Source) > at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) > at org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown Source) > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setString(NewProxyPreparedStatement.java:963) > at > org.makumba.db.makumba.sql.TableManager.set_text_Argument(TableManager.java:1097) > at > org.makumba.db.makumba.sql.TableManager.setArgument(TableManager.java:1081) > at > org.makumba.db.makumba.sql.TableManager.base_setInsertArgument(TableManager.java:1408) > at > org.makumba.db.makumba.sql.TableManager.setInsertArgument(TableManager.java:1397) > at > org.makumba.db.makumba.sql.TableManager.insertRecordImpl(TableManager.java:654) > at org.makumba.db.makumba.Table.insertRecord(Table.java:258) > at > org.makumba.db.makumba.MakumbaCRUDOperationProvider.insert(MakumbaCRUDOperationProvider.java:22) > at org.makumba.db.DataHolder.insert(DataHolder.java:174) > at > org.makumba.db.TransactionImplementation.insert(TransactionImplementation.java:157) > at org.makumba.db.makumba.DBConnection.insert(DBConnection.java:159) > at > org.makumba.db.makumba.DBConnectionWrapper.insert(DBConnectionWrapper.java:83) > > Do you have any idea what is wrong, and what I can do to fix it? > Regards, > Sebastian Öhrn > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Makumba-user mailing list > Mak...@li... > https://lists.sourceforge.net/lists/listinfo/makumba-user > > |