Did you change the Hibernate dialect to MySql? -Scott
On Fri, Mar 21, 2008 at 3:51 PM, Robert Lewis <[EMAIL PROTECTED]> wrote: > Hi, > > Still trying to get services manager hooked up to a db. I switched to > trying mysql. The following is my bean in deployerConfigContext.xml. > > <bean id="dataSource" > class="org.apache.commons.dbcp.BasicDataSource" > p:driverClassName="com.mysql.jdbc.Driver" > > p:url="jdbc:mysql://sample.tamu.edu:3306/sampleDBName?autoReconnect=true" > p:password="sample" > p:username="sample" /> > > > Where my database is named sampleDBName. > > When I deploy, I get the following error. > > 2008-03-21 14:39:02,962 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] > - <Unsuccessful: create table RegisteredServiceImpl (id int8 not null, > allowedAttributes bytea, allowedToProxy bool not null, anonymousAccess > bool not null, description varchar(255), enabled bool not null, name > varchar(255), serviceId varchar(255), ssoEnabled bool not null, theme > varchar(255), primary key (id))> > 2008-03-21 14:39:02,963 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] > - <No database selected> > 2008-03-21 14:39:02,965 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] > - <Unsuccessful: create sequence hibernate_sequence> > 2008-03-21 14:39:02,965 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] > - <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 'sequence hibernate_sequence' at line 1> > Hibernate: select registered0_.id as id0_, > registered0_.allowedAttributes as allowedA2_0_, > registered0_.allowedToProxy as allowedT3_0_, > registered0_.anonymousAccess as anonymou4_0_, registered0_.description > as descript5_0_, registered0_.enabled as enabled0_, registered0_.name as > name0_, registered0_.serviceId as serviceId0_, registered0_.ssoEnabled > as ssoEnabled0_, registered0_.theme as theme0_ from > RegisteredServiceImpl registered0_ > 2008-03-21 14:39:03,936 ERROR [org.hibernate.util.JDBCExceptionReporter] > - <No database selected> > > > I must be putting in the db name incorrectly, but I have tried > variations and have not gotten it to work. Does anyone see how I can > correct this? > > Thanks, > > Robert Lewis > > > > > _______________________________________________ > Yale CAS mailing list > [email protected] > http://tp.its.yale.edu/mailman/listinfo/cas > -- -Scott Battaglia PGP Public Key Id: 0x383733AA LinkedIn: http://www.linkedin.com/in/scottbattaglia
_______________________________________________ Yale CAS mailing list [email protected] http://tp.its.yale.edu/mailman/listinfo/cas
