[Persistence, JBoss/CMP, Hibernate, Database] - SQLBase (GUPTA) - getIndexInfo(...) => SQLException
by olvin
Hello,
We try to access to a SQLBase database from Gupta and there's only one problem remaining...
We have the last JDBC Driver from Gupta (v. 9.0.1)
We try to deploy the example "cmproster" from the ejb directory from j2eetutorial1.4 from Sun :
- With HyperSonic SQL => no problem.
- with SQLBase => I can see the connection created in the Databases Manager but we have the following SQLException generated by the JDBC Driver : "Only approximate statistics are supported.!"
After a short analyse, the exception is generated by the getIndexInfo method from the JDBC Driver. Here's the decompiled method :
public ResultSet getIndexInfo(String s, String s1, String s2, boolean flag, boolean flag1)
throws SQLException
{
String s3 = null;
if(s != null)
getIndexInfoCatalog = null;
else
getIndexInfoCatalog = "%";
if(s1 != null)
getIndexInfoSchema = s1.toUpperCase();
else
getIndexInfoSchema = "%";
if(!flag1)
throw new SQLException("Only approximate statistics are supported.!");
getIndexInfoTable = s2.toUpperCase();
prepareQuery("Select null as TBALE_CAT, Tbcreator as TABLE_SCHEM, Tbname as TABLE_NAME, @Decode(Uniquerule,'D','True','False') as NON_UNIQUE, Ix.Creator as INDEX_QUALIFIER, Ix.Name as INDEX_NAME, @Decode(Ixtype, 'H', 2, 'B', 1, 0) as TYPE, Ky.Colseq as ORDINAL_POSITION, Ky.Colname as COLUMN_NAME, Ky.Ordering as ASC_OR_DESC, Ky.Distinctcount as CARDINALITY, Indexpagecount as PAGES, null as FILTER_CONDITION From Sysadm.Sysindexes Ix, Sysadm.Systables Tb, Sysadm.Syskeys Ky Where (Tbcreator = Tb.Creator) And (Tbname = Tb.Name) And (Ix.Name = Ky.IxName) And TBCreator like ? And (Tbname = ?) And (Uniquerule = ?) ");
ps.setString(1, getIndexInfoSchema);
ps.setString(2, getIndexInfoTable);
if(flag)
s3 = "U";
else
s3 = "D";
ps.setString(3, s3);
rs = ps.executeQuery();
return rs;
}
And the getIndexInfo method is called from "org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.getOldIndexes" :
14:29:06,093 WARN [ServiceController] Problem starting service jboss.j2ee:service=EjbModule,module=team-ejb.jar
org.jboss.deployment.DeploymentException: Error while geting column names; - nested throwable: (java.sql.SQLException: Only approximate statistics are supported.!)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.getOldIndexes(SQLUtil.java:1168)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:215)
All that I have found is that (for another JDBC driver) :
http://mail-archive.objectweb.org/c-jdbc/2005-02/msg00066.html
You can see that the getIndexInfo method is called with false as the last parameter...
So, here's my question :
Someone could give me a way to configure JBoss (or the ejb) correctly to avoid the call of the method with false as the last parameter to avoid the SQLException returned from JDBC Driver ?
Thanks,
Olivier[/url]
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3960355#3960355
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3960355
19 years, 9 months
[JBoss Seam] - ConcurrentModificationException
by bluetrade
Hi,
I am getting a ConcurrentModificationException which I cannot really resolve, maybe someone has some hints...
I have the following:
| @Stateful
| @Name("accBroker")
| @Scope(CONVERSATION)
| @LoggedIn
| public class AccountBrokerBean implements AccountBroker{
|
| @In(create=true)
| private EntityManager em;
|
| @In(value="securityBroker",create=true)
| private SecurityBroker securityBroker;
|
| @In
| User user;
|
| @Begin(join=true)
| public void find() {
| List<Accounts> accounts = em.createQuery("from Account");
| securityBroker.filter(user,accounts);
|
| }
| ...
| @Stateful
| @Name("securityBroker")
| @Scope(CONVERSATION)
| @LoggedIn
| public class SecurityBrokerBean implements SecurityBroker{
|
| @In(create=true)
| private EntityManager em;
|
| public void filter(User u, Collection<Accounts> accounts) {
| for (Account a : accounts) {
| if (accounts.notAccessibleBy(user) {
| accounts.remove(a);
| } else if (accounts.accessibleBy(user) {
| continue;
| } else {
| accounts.remove(a);
| }
| }
|
| }
|
| ...
|
I get the CME somehere in the filter method...
Any clues?
Thanks,
Joey
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3960354#3960354
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3960354
19 years, 9 months