Re: [Rife-users] Problem adding database support to rife
Hi Geert, this is my site structure (pub.xml) http://rifers.org/paste/show/4031 This is universalAuthElement.xml http://rifers.org/paste/show/4032 This is loginBoxElement.xml http://rifers.org/paste/show/4033 And this is the complete stack trace. http://rifers.org/paste/show/4034 Thanks a lot for your time. 2007/3/23, Geert Bevin [EMAIL PROTECTED]: Can you post the entire stacktrace of the exception you get and the site structure in which universalAuthElement.xml is declared also? On 22 Mar 2007, at 14:17, Mork Ork wrote: Ok, i checked this but same error config-base.xml config param name=datasourcemysql/param param name=database_namerife/param param name=database_userrife/param param name=database_passwordrife/param /config participants.xml rep participant param=rep/config-base.xmlParticipantConfig/ participant participant param=rep/ datasources.xmlParticipantDatasources/participant property name=datasourcedatasourcemysql/datasource/ property participant blocking=true param=datasourcecom.cm.financeloupe.participants.ParticipantDatabas eAuthentication/participant participant param=sites/main.xmlParticipantSite/participant /rep datasources.xml datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource universalAuthElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=rife/authenticated/database.xml property name=authvar_typecookie/property submission name=credentials param name=login/ param name=password/ /submission property name=datasourcedatasourcemysql/datasource/ property childtrigger name=authid/ /element LoginBoxElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=auth/universalAuthElement.xml property name=template_nameauth.login/property property name=rolevisitor/property /element 2007/3/22, Henk [EMAIL PROTECTED]:Check the following : rep/datasources.xml : should contain datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource rep/config-base.xml : should contain param name=DATASOURCEmysql/param param name=database_nameyourdatabase/param param name=database_useryouruser/param param name=database_passwordyourpassword/param Mysql should be running, the database should exist together with a working user. cheers Henk On 22 Mar 2007, at 21:51, Mork0075 wrote: Ok, thanks a lot, this was my mistake. But the other problem remains: The property 'datasource' of element 'auth/loginBoxElement.xml' was expected to have the type ' com.uwyn.rife.database.Datasource', however it's actual type 'java.lang.String' couldn't be cast to it. Henk schrieb: Actually, rife jumpstart does support MySQL, but does not include the driver. Moreover, it depends on your mysql version which jdbc driver you should use. Check out http://www.mysql.com/products/ connector/j/ for more information. good luck Henk On 22 Mar 2007, at 21:23, Mork0075 wrote: I use the rife jumpstart project, i thaught theres mysql support out of the box? Henk schrieb: Hi, you probably checked this, but are you sure the MySQL jdbc driver is in the classpath ? cheers Henk On 22 Mar 2007, at 21:11, Mork0075 wrote: Hi, i try to add some basic database functionality to my rife app, but got some errors. First of all, adding this line to my auth.xml (which extends rife/autheticated/database.xml) element property name=datasourcedatasourcemysql/datasource/ property causes the following error: The property 'datasource' of element 'auth/loginBoxElement.xml' was expected to have the type 'com.uwyn.rife.database.Datasource', however it's actual type 'java.lang.String' couldn't be cast to it. The second thing i did, i've added the sample blocking element to create the database tables: (this is my pacitipants.xml ) rep participant param=rep/config-base.xmlParticipantConfig/participant participant param=rep/datasources.xmlParticipantDatasources/participant property name=datasourcedatasourcemysql/datasource/property participant blocking=true param=datasourcecom.cm.financeloupe.participants.ParticipantDat abaseAuthentication/participant participant param=sites/main.xmlParticipantSite/ participant /rep This causes this error: com.uwyn.rife.database.exceptions.DriverInstantiationErrorExceptio n:
Re: [Rife-users] Problem adding database support to rife
I did some debugging, perhaps this is helpful: The error occurs in PurgingDatabaseAuthenticatedDeployer.java where a Datasource object tries to be created (line 59). This line is executed twice. First time the correct datasource object is created (with my mysql settings). The second time in ElementInfo.getPropertyTyped an exception is thrown in line 1195 (if (!type.isAssignableFrom(result.getClass(. In the first run the value of result is Datsource (the mysql one), in the second run, the value of result is . I think this is the failure. The datasource seems to be identified correctly once and then (i dont know why) a second datasource tries to be created from an empty input . 2007/3/23, Mork Ork [EMAIL PROTECTED]: Hi Geert, this is my site structure (pub.xml) http://rifers.org/paste/show/4031 This is universalAuthElement.xml http://rifers.org/paste/show/4032 This is loginBoxElement.xml http://rifers.org/paste/show/4033 And this is the complete stack trace. http://rifers.org/paste/show/4034 Thanks a lot for your time. 2007/3/23, Geert Bevin [EMAIL PROTECTED]: Can you post the entire stacktrace of the exception you get and the site structure in which universalAuthElement.xml is declared also? On 22 Mar 2007, at 14:17, Mork Ork wrote: Ok, i checked this but same error config-base.xml config param name=datasourcemysql/param param name=database_namerife/param param name=database_userrife/param param name=database_passwordrife/param /config participants.xml rep participant param=rep/config-base.xml ParticipantConfig/ participant participant param=rep/ datasources.xmlParticipantDatasources/participant property name=datasourcedatasourcemysql/datasource/ property participant blocking=true param=datasourcecom.cm.financeloupe.participants.ParticipantDatabas eAuthentication/participant participant param=sites/main.xmlParticipantSite/participant /rep datasources.xml datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource universalAuthElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=rife/authenticated/database.xml property name=authvar_typecookie/property submission name=credentials param name=login/ param name=password/ /submission property name=datasourcedatasourcemysql/datasource/ property childtrigger name=authid/ /element LoginBoxElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=auth/universalAuthElement.xml property name=template_name auth.login/property property name=rolevisitor/property /element 2007/3/22, Henk [EMAIL PROTECTED]:Check the following : rep/datasources.xml : should contain datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource rep/config-base.xml : should contain param name=DATASOURCEmysql/param param name=database_nameyourdatabase/param param name=database_useryouruser/param param name=database_passwordyourpassword/param Mysql should be running, the database should exist together with a working user. cheers Henk On 22 Mar 2007, at 21:51, Mork0075 wrote: Ok, thanks a lot, this was my mistake. But the other problem remains: The property 'datasource' of element 'auth/loginBoxElement.xml' was expected to have the type ' com.uwyn.rife.database.Datasource', however it's actual type ' java.lang.String' couldn't be cast to it. Henk schrieb: Actually, rife jumpstart does support MySQL, but does not include the driver. Moreover, it depends on your mysql version which jdbc driver you should use. Check out http://www.mysql.com/products/ connector/j/ for more information. good luck Henk On 22 Mar 2007, at 21:23, Mork0075 wrote: I use the rife jumpstart project, i thaught theres mysql support out of the box? Henk schrieb: Hi, you probably checked this, but are you sure the MySQL jdbc driver is in the classpath ? cheers Henk On 22 Mar 2007, at 21:11, Mork0075 wrote: Hi, i try to add some basic database functionality to my rife app, but got some errors. First of all, adding this line to my auth.xml (which extends rife/autheticated/database.xml) element property name=datasourcedatasourcemysql/datasource/ property causes the following error: The
Re: [Rife-users] Problem adding database support to rife
Which version of RIFE are you using? On 23 Mar 2007, at 03:00, Mork Ork wrote: I did some debugging, perhaps this is helpful: The error occurs in PurgingDatabaseAuthenticatedDeployer.java where a Datasource object tries to be created (line 59). This line is executed twice. First time the correct datasource object is created (with my mysql settings). The second time in ElementInfo.getPropertyTyped an exception is thrown in line 1195 (if (!type.isAssignableFrom(result.getClass(. In the first run the value of result is Datsource (the mysql one), in the second run, the value of result is . I think this is the failure. The datasource seems to be identified correctly once and then (i dont know why) a second datasource tries to be created from an empty input . 2007/3/23, Mork Ork [EMAIL PROTECTED]: Hi Geert, this is my site structure (pub.xml) http://rifers.org/paste/show/4031 This is universalAuthElement.xml http://rifers.org/paste/show/4032 This is loginBoxElement.xml http://rifers.org/paste/show/4033 And this is the complete stack trace. http://rifers.org/paste/show/4034 Thanks a lot for your time. 2007/3/23, Geert Bevin [EMAIL PROTECTED]: Can you post the entire stacktrace of the exception you get and the site structure in which universalAuthElement.xml is declared also? On 22 Mar 2007, at 14:17, Mork Ork wrote: Ok, i checked this but same error config-base.xml config param name=datasourcemysql/param param name=database_namerife/param param name=database_userrife/param param name=database_passwordrife/param /config participants.xml rep participant param=rep/config-base.xml ParticipantConfig/ participant participant param=rep/ datasources.xmlParticipantDatasources/participant property name=datasourcedatasourcemysql/datasource/ property participant blocking=true param=datasourcecom.cm.financeloupe.participants.ParticipantDatabas eAuthentication/participant participant param=sites/main.xmlParticipantSite/ participant /rep datasources.xml datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource universalAuthElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=rife/authenticated/database.xml property name=authvar_typecookie/property submission name=credentials param name=login/ param name=password/ /submission property name=datasourcedatasourcemysql/datasource/ property childtrigger name=authid/ /element LoginBoxElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=auth/universalAuthElement.xml property name=template_name auth.login/property property name=rolevisitor/property /element 2007/3/22, Henk [EMAIL PROTECTED]:Check the following : rep/datasources.xml : should contain datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource rep/config-base.xml : should contain param name=DATASOURCEmysql/param param name=database_nameyourdatabase/param param name=database_useryouruser/param param name=database_passwordyourpassword/param Mysql should be running, the database should exist together with a working user. cheers Henk On 22 Mar 2007, at 21:51, Mork0075 wrote: Ok, thanks a lot, this was my mistake. But the other problem remains: The property 'datasource' of element 'auth/loginBoxElement.xml' was expected to have the type ' com.uwyn.rife.database.Datasource', however it's actual type ' java.lang.String' couldn't be cast to it. Henk schrieb: Actually, rife jumpstart does support MySQL, but does not include the driver. Moreover, it depends on your mysql version which jdbc driver you should use. Check out http://www.mysql.com/products/ connector/j/ for more information. good luck Henk On 22 Mar 2007, at 21:23, Mork0075 wrote: I use the rife jumpstart project, i thaught theres mysql support out of the box? Henk schrieb: Hi, you probably checked this, but are you sure the MySQL jdbc driver is in the classpath ? cheers Henk On 22 Mar 2007, at 21:11, Mork0075 wrote: Hi, i try to add some basic database functionality to my rife app, but got some errors. First of all, adding this line to my auth.xml (which extends rife/autheticated/database.xml) element property name=datasourcedatasourcemysql/datasource/ property causes the following error: The property 'datasource' of element 'auth/
Re: [Rife-users] Problem adding database support to rife
I can't find anything form the snippets you pasted, indeed. Would you mind zipping up your project and sending it to me privately (not to the list). I can step through it myself then and pinpoint why this happens. Take care, Geert On 23 Mar 2007, at 07:33, Geert Bevin wrote: Which version of RIFE are you using? On 23 Mar 2007, at 03:00, Mork Ork wrote: I did some debugging, perhaps this is helpful: The error occurs in PurgingDatabaseAuthenticatedDeployer.java where a Datasource object tries to be created (line 59). This line is executed twice. First time the correct datasource object is created (with my mysql settings). The second time in ElementInfo.getPropertyTyped an exception is thrown in line 1195 (if (!type.isAssignableFrom(result.getClass(. In the first run the value of result is Datsource (the mysql one), in the second run, the value of result is . I think this is the failure. The datasource seems to be identified correctly once and then (i dont know why) a second datasource tries to be created from an empty input . 2007/3/23, Mork Ork [EMAIL PROTECTED]: Hi Geert, this is my site structure (pub.xml) http://rifers.org/paste/show/4031 This is universalAuthElement.xml http://rifers.org/paste/show/4032 This is loginBoxElement.xml http://rifers.org/paste/show/4033 And this is the complete stack trace. http://rifers.org/paste/show/4034 Thanks a lot for your time. 2007/3/23, Geert Bevin [EMAIL PROTECTED]: Can you post the entire stacktrace of the exception you get and the site structure in which universalAuthElement.xml is declared also? On 22 Mar 2007, at 14:17, Mork Ork wrote: Ok, i checked this but same error config-base.xml config param name=datasourcemysql/param param name=database_namerife/param param name=database_userrife/param param name=database_passwordrife/param /config participants.xml rep participant param=rep/config-base.xml ParticipantConfig/ participant participant param=rep/ datasources.xmlParticipantDatasources/participant property name=datasourcedatasourcemysql/datasource/ property participant blocking=true param=datasourcecom.cm.financeloupe.participants.ParticipantDataba s eAuthentication/participant participant param=sites/main.xmlParticipantSite/ participant /rep datasources.xml datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource universalAuthElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=rife/authenticated/database.xml property name=authvar_typecookie/property submission name=credentials param name=login/ param name=password/ /submission property name=datasourcedatasourcemysql/datasource/ property childtrigger name=authid/ /element LoginBoxElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=auth/universalAuthElement.xml property name=template_name auth.login/property property name=rolevisitor/property /element 2007/3/22, Henk [EMAIL PROTECTED]:Check the following : rep/datasources.xml : should contain datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource rep/config-base.xml : should contain param name=DATASOURCEmysql/param param name=database_nameyourdatabase/param param name=database_useryouruser/param param name=database_passwordyourpassword/param Mysql should be running, the database should exist together with a working user. cheers Henk On 22 Mar 2007, at 21:51, Mork0075 wrote: Ok, thanks a lot, this was my mistake. But the other problem remains: The property 'datasource' of element 'auth/ loginBoxElement.xml' was expected to have the type ' com.uwyn.rife.database.Datasource', however it's actual type ' java.lang.String' couldn't be cast to it. Henk schrieb: Actually, rife jumpstart does support MySQL, but does not include the driver. Moreover, it depends on your mysql version which jdbc driver you should use. Check out http://www.mysql.com/products/ connector/j/ for more information. good luck Henk On 22 Mar 2007, at 21:23, Mork0075 wrote: I use the rife jumpstart project, i thaught theres mysql support out of the box? Henk schrieb: Hi, you probably checked this, but are you sure the MySQL jdbc driver is in the classpath ? cheers Henk On 22 Mar 2007, at 21:11, Mork0075 wrote: Hi, i try to add some basic database functionality
Re: [Rife-users] Problem adding database support to rife
Hang on, can you quickly try something for me, don't use the MySQL jar that is in your project (mysql-connector-java-5.0.5-bin.jar). MySQL's JDBC drivers have a tendency to be frequently unstable and incompatible, can you try with this one that's in here http:// rifers.org/download/95/rife-sumo-1.5.1-jdk15.zip ? That's what is used to test RIFE. On 23 Mar 2007, at 03:00, Mork Ork wrote: I did some debugging, perhaps this is helpful: The error occurs in PurgingDatabaseAuthenticatedDeployer.java where a Datasource object tries to be created (line 59). This line is executed twice. First time the correct datasource object is created (with my mysql settings). The second time in ElementInfo.getPropertyTyped an exception is thrown in line 1195 (if (!type.isAssignableFrom(result.getClass(. In the first run the value of result is Datsource (the mysql one), in the second run, the value of result is . I think this is the failure. The datasource seems to be identified correctly once and then (i dont know why) a second datasource tries to be created from an empty input . 2007/3/23, Mork Ork [EMAIL PROTECTED]: Hi Geert, this is my site structure (pub.xml) http://rifers.org/paste/show/4031 This is universalAuthElement.xml http://rifers.org/paste/show/4032 This is loginBoxElement.xml http://rifers.org/paste/show/4033 And this is the complete stack trace. http://rifers.org/paste/show/4034 Thanks a lot for your time. 2007/3/23, Geert Bevin [EMAIL PROTECTED]: Can you post the entire stacktrace of the exception you get and the site structure in which universalAuthElement.xml is declared also? On 22 Mar 2007, at 14:17, Mork Ork wrote: Ok, i checked this but same error config-base.xml config param name=datasourcemysql/param param name=database_namerife/param param name=database_userrife/param param name=database_passwordrife/param /config participants.xml rep participant param=rep/config-base.xml ParticipantConfig/ participant participant param=rep/ datasources.xmlParticipantDatasources/participant property name=datasourcedatasourcemysql/datasource/ property participant blocking=true param=datasourcecom.cm.financeloupe.participants.ParticipantDatabas eAuthentication/participant participant param=sites/main.xmlParticipantSite/ participant /rep datasources.xml datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource universalAuthElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=rife/authenticated/database.xml property name=authvar_typecookie/property submission name=credentials param name=login/ param name=password/ /submission property name=datasourcedatasourcemysql/datasource/ property childtrigger name=authid/ /element LoginBoxElement.xml !DOCTYPE element SYSTEM /dtd/element.dtd element extends=auth/universalAuthElement.xml property name=template_name auth.login/property property name=rolevisitor/property /element 2007/3/22, Henk [EMAIL PROTECTED]:Check the following : rep/datasources.xml : should contain datasource name=mysql drivercom.mysql.jdbc.Driver/driver urljdbc:mysql://localhost:3306/config param=database_name/?autoReconnect=true/url userconfig param=database_user//user passwordconfig param=database_password//password poolsize5/poolsize /datasource rep/config-base.xml : should contain param name=DATASOURCEmysql/param param name=database_nameyourdatabase/param param name=database_useryouruser/param param name=database_passwordyourpassword/param Mysql should be running, the database should exist together with a working user. cheers Henk On 22 Mar 2007, at 21:51, Mork0075 wrote: Ok, thanks a lot, this was my mistake. But the other problem remains: The property 'datasource' of element 'auth/loginBoxElement.xml' was expected to have the type ' com.uwyn.rife.database.Datasource', however it's actual type ' java.lang.String' couldn't be cast to it. Henk schrieb: Actually, rife jumpstart does support MySQL, but does not include the driver. Moreover, it depends on your mysql version which jdbc driver you should use. Check out http://www.mysql.com/products/ connector/j/ for more information. good luck Henk On 22 Mar 2007, at 21:23, Mork0075 wrote: I use the rife jumpstart project, i thaught theres mysql support out of the box? Henk schrieb: Hi, you probably checked this, but are you sure the MySQL jdbc driver is in the classpath ? cheers Henk On 22 Mar 2007, at 21:11, Mork0075 wrote: Hi, i try to add some