powered by Jive Software

Why can't jdbcGroupProvider write about the database?

i add the jdbcGroupProvider node in the openfire.xml

<?xml version="1.0" encoding="UTF-8"?> 9090 9091 user1 en org.jivesoftware.database.DefaultConnectionProvider net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sqlserver://127.0.0.1/InteractiveOffice;appName=jive iaodev iaodev select 1 true true 5 25 1.0 true net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sqlserver://127.0.0.1/InteractiveOffice;user=iaodev ;password=iaodev;appName=jive org.jivesoftware.openfire.auth.JDBCAuthProvider org.jivesoftware.openfire.user.JDBCUserProvider org.jivesoftware.openfire.group.JDBCGroupProvider SELECT EPassword FROM Employee WHERE LoginName = ? plain SELECT EName, EEmail FROM Employee LoginName = ? SELECT COUNT(*) FROM Employee SELECT jid FROM USERS SELECT LoginName Employee WHERE LoginName EName EEmail SELECT COUNT(*) FROM Company SELECT CName FROM Company SELECT c.CName FROM Company c INNER JOIN Employee e ON e.ComanyID = c.CID WHERE e.LoginName = ? SELECT CDescribe FROM Company WHERE CName = ? SELECT e.LoginName FROM Company c INNER JOIN Employee e ON e.ComanyID =c.CID WHERE c.CName = ? SELECT TOP 1 e.LoginName FROM Company c INNER JOIN Employee e ON e.ComanyID = c.CID WHERE c.CName = ?

如果你需要你可以自己扩展实现