Hi Christian, Thanks for your help and tests. Unfortunately I cannot test authentication on another database. Informix is not crucial for us, but it would still be nice support it through the new security system.
Looking at the Informix docs, it seems that the driver needs to be discovered through Class.forName [1] and instantiated with DriverManager.getConnection(url) [2]. [1] http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.jdbc_pg.doc/jdbc51.htm [2] http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.jdbc_pg.doc/jdbc48.htm Cheers, Torsten On Thu, Apr 19, 2012 at 8:31 AM, <[email protected]> wrote: > Hi thegis, I did some tests. > > In my environment I have installed the following drivers. > > oracle > db2 > h2 > postgres > mysql > hsqld > ms sqlserver > jdbc.odbc bridge > > I get all this drivers in the combo box. > > I downloaded the informix driver and interestingly, this is the only one NOT > appearing in the list. > > No idea what is going on. Could you choose another database for your tests ? > > Christian > > Zitat von thegis <[email protected]>: > > >>>> The question is therefore how to add an additional JDBC driver so that >>>> it can be selected with the "New Authentication Provider" page? >> >> >>> The panel used DriverManager.getDrivers to find available jdbc drivers. >>> >>> 1) Where did you download, I found the drivers here >>> http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc >>> >>> 2) try to put the jar file(s) into JAVA_HOME/jre/lib/ext directory of the >>> java installation used by geoserver. >> >> >> Thanks Christian, I've tried with an old driver (3.00) and later with >> the latest version (3.70) from 1), installed it and copied all jar's >> to JAVA_HOME/jre/lib/ext. The ext folder now contains the following >> jars: ifxjdbc.jar ifxjdbcx.jar ifxlang.jar ifxlsupp.jar >> ifxsqlj.jar ifxtools.jar >> >> Unfortunately that didn't seem to work as the IfxDriver is still not >> shown in the driver class dropdown box.. >> >> I've tried with Java 1.7 and 1.6 and also added >> META-INF/services/java.sql.Driver to the jars in case they are needed >> for the discovery through DriverManager.getDrivers. But that didn't >> worked either. Any other ideas? >> > > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
