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
