Cannot create JDBC driver of class '' for connect URL 'null'

10857
22
04-20-2011 06:29 AM
sebastiengeorge
New Contributor
Hello,

I installed GeoPortal  but still having the problem when I connect me:

Cannot create JDBC driver of class '' for connect URL 'null'

How can I to do !?
0 Kudos
22 Replies
sebastiengeorge
New Contributor
Thanks you, but now I have not the choice. I owe  to use odbc connection.

<!-- Context configuration file for the Geoportal Web App -->
<Context docBase="geoportal" path="/geoportal" debug="0" reloadable="true" crossContext="true">
    <Resource name="jdbc/gpt" auth="Container" type="javax.sql.DataSource"
              driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
              url="jdbc:odbc:geoportal"
              user="admincarto54"
              password="xxxxxxxxxx"
              maxActive="20"
              maxIdle="10"
              maxWait="-1" />
     
</Context>


I created odbc system connection. His name is geoportal

Now, I have this error :

Cannot create PoolableConnectionFactory ([Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié)
0 Kudos
CliveReece
Esri Contributor
You are swimming in uncharted waters trying to use ODBC.  I would strongly recommend you stick to a JDBC driver and JDBC url connection.  Another tool to try (with the goal of getting the JDBC driver/url combination correct for your system) is DbVisualizer.  It would allow you to choose a driver and quickly test different connection strings.  Still, I think the primary focus needs to be determining which TCP port your SQLServer database machine is configured to accept outside connections.
0 Kudos
sebastiengeorge
New Contributor
The problem is that I can not have access firewall, nor cnfiguration sql server.
The persons of this service are in vacancy. I can only to use ODBC
0 Kudos
sebastiengeorge
New Contributor
I tryed Dbvizualizer and with this software, I can connect me with tcp port 1354.
But with geoportal, this error appear :


Cannot create PoolableConnectionFactory (�?chec de l'ouverture de session de l'utilisateur ''. L'utilisateur n'est pas associé à une connexion SQL Server approuvée.)

I use exactly the same user, password, database, driver ... I don't understand why it work with dbvizualizer but not SQL Server ...




I would strongly recommend you stick to a JDBC driver and JDBC url connection. Another tool to try (with the goal of getting the JDBC driver/url combination correct for your system) is DbVisualizer. It would allow you to choose a driver and quickly test different connection strings. Still, I think the primary focus needs to be determining which TCP port your SQLServer database machine is configured to accept outside connections.
0 Kudos
CliveReece
Esri Contributor
I tryed Dbvizualizer and with this software, I can connect me with tcp port 1354.
But with geoportal, this error appear :

Cannot create PoolableConnectionFactory (�?chec de l'ouverture de session de l'utilisateur ''. L'utilisateur n'est pas associé à une connexion SQL Server approuvée.)

I use exactly the same user, password, database, driver ... I don't understand why it work with dbvizualizer but not SQL Server ...


You are using dBVisualizer from the Tomcat machine?
With dBVisualizer you are pointing to the same database driver that is in Tomcat/lib?
Then I would next look through Tomcat/lib and Tomcat/webapps/geoportal/WEB-INF/lib and make sure you don't have a 2nd database driver that might be conflicting.
0 Kudos
CliveReece
Esri Contributor
One more thing:  I just translated the French error message to English:  "The user logon failed ". The user is not associated with a trusted SQL Server connection."

This would indicate that the username logon is not allowed/configured to remotely log in to your SQL Server.
0 Kudos
sebastiengeorge
New Contributor
I use dbVisualizer from the tomcat machine and I point to the same database driver that is in Tomcat/lib. I don't now if I have a 2nd database driver that might be conflicting.



With dBVisualizer you are pointing to the same database driver that is in Tomcat/lib?
Then I would next look through Tomcat/lib and Tomcat/webapps/geoportal/WEB-INF/lib and make sure you don't have a 2nd database driver that might be conflicting.
0 Kudos
sebastiengeorge
New Contributor
I use dbVisualizer from the tomcat machine and I point to the same database driver that is in Tomcat/lib. I don't now if I have a 2nd database driver that might be conflicting.





This would indicate that the username logon is not allowed/configured to remotely log in to your SQL Server.


With dbVisualizer, I use the same user and password. And It's OK.
0 Kudos
sebastiengeorge
New Contributor
I noticed that SQL server receives no request when I connect me with the geoportal
0 Kudos
CliveReece
Esri Contributor
Let's go back and check that your geoportal webapp context and the JNDI deployment descriptor file are the same.
Your geoportal webapp context is geocarto54.  Correct?
Can you make sure that the JNDI deployment descriptor placed in config/Catalina/localhost is using the same name, namely geocarto54.xml?
0 Kudos