Hi there, I'm currently looking for a 'sharding' and 'federated sql' solution. And ShardingSphere is on my list of candidates and it did seem like a good match. I do have a problem with setting up my sharding rules, particulary the 'dataSources' section: We have a JDBC Driver which works fine (we use it on java backend app/service - already in Production - so no issue with that one). But the DatabaseType is not recognized ... the DatabaseTypeFactory uses the jdbc-url string to detect the type. I would assume that, if the type is not recognized the 'SQL92DataType' would be used as the default (as the documentation states), but that's not the case. I get a UnsupportedStorageTypeException ...Can you tell me how to set up my 'dataSources' properly so that I can test ShardingSphere for my challenge, please?+FYI : further downstream I use JPA & Hibernate (and there's a specific Dialect set up - which works fine in our normal setup).A big thanks in advance [:+1:]
ds0: dataSourceClassName: com.zaxxer.hikari.HikariDataSource driverClassName: com.Connx.jdbc.TCJdbc.TCJdbcDriver jdbcUrl: jdbc:connx:DD=<data dictionary ref>;Gateway=<<http://ldextl2k001a.cloud.extranetdc.be/>myhostname>;Port=7505 username: ... password: ...the 'jdbc:conn' part is used to detect the DatabaseType ...Driver info: https://documentation.softwareag.com/adabas/cxx146/userguide/CONNXCDD32A/JDBC_Driver_Definition.htm Overeenkomstig de bepalingen inzake de vertegenwoordiging van de vzw in haar statuten, kan enkel de gedelegeerde bestuurder, de algemeen directeur of zijn uitdrukkelijke lasthebber verbintenissen aangaan namens Smals. Indien dit bericht niet voor u bestemd is, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Conformément aux dispositions relatives à la représentation de l'asbl dans ses statuts, seul l'administrateur délégué, le directeur général ou son mandataire exprès est habilité à souscrire des engagements au nom de Smals. Si ce message ne vous est pas destiné, nous vous prions de nous le signaler immédiatement et de détruire le message. According to the provisions regarding representation of the non profit association in its bylaws, only the chief executive officer, the general manager or his explicit agent can enter into engagements on behalf of Smals. If you are not the addressee of this message, we kindly ask you to signal this to us immediately and to delete the message.
