Hello,

I am trying to configure a Jdbc mysql driver.
The mysql version is the 4.0.18 (old version).
Does someone know which mysql connector to use ?
- mysql-connector-2.0.4-bin.jar ?

- mysql-connector-java-5.1.6.jar ?
- mysql-connector-java-3.1.14.jar ?
- an other connector ?

or an other one ?

During the creation of this driver, it is recommended to use the
following driver :
MySQL Connector/J (mysql-connector-<version>-bin.jar)

I wonder which <version> I have to use ? Is there a way to find it ?
Is it linked with java ? if yes, which installed java have I to look
about ?

Have I to use a mysql-connector-<version>-bin.jar or a
mysql-connector-java-<version>-bin.jar ?


I give you logs bellow.
Thanks in advance for your help,

Christine




[03/27/08 14:02:44.889]:/root/tracesAnnuaireIntra.log ST:
DirXML Log Event -------------------
Driver: \DEVNDS\dev\system\EnsemblePilote\Test Annuaire
Intranet
Status: Error
Message: <description>Unable to connect. There is a
connectivity-related problem.</description>
<jdbc:exception jdbc:class="com.mysql.jdbc.CommunicationsException "
jdbc:error-code="0" jdbc:sql-state="08S01"
xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>Communications link failure

Last packet sent to the server was -1 ms ago.</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve"
xmlns:jdbc="urn:dirxml:jdbc">&lt;nds dtdversion="3.5"
ndsversion="8.x">
&lt;source>
&lt;product version="3.5.10.20070918 ">DirXML&lt;/product>
&lt;contact>Novell, Inc.&lt;/contact>
&lt;/source>
&lt;input>
&lt;init-params src-dn="\DEVNDS\dev\system\EnsemblePilote\Test
Annuaire Intranet">
&lt;authentication-info>
&lt;server>jdbc:mysql://10.12.4.23:3306/annuaire&lt;/server>
&lt;user>annuaire&lt;/user>
&lt;password>
&lt;!--content suppressed-->
&lt;/password>
&lt;/authentication-info>
&lt;driver-options>
&lt;jdbc-class display-name="Third-party JDBC driver class
name:">org.gjt.mm.mysql.Driver&lt;/jdbc-class>
&lt;ignore1 display-name="Show database scoping
parameters?">show&lt;/ignore1>
&lt;sync-filter display-name="Synchronization
filter:">list&lt;/sync-filter>
&lt;sync-tables display-name="Table/view
names:">personne&lt;/sync-tables>
&lt;time-syntax display-name="Time syntax:">_&lt;/time-syntax>
&lt;state-dir display-name="State directory:">.&lt;/state-dir>
&lt;ignore11 display-name="Show connectivity
parameters?">hide&lt;/ignore11>
&lt;use-single-connection display-name="Use minimal number of
connections?">_&lt;/use-single-connection>
&lt;connection-init display-name="Connection initialization
statements:">&lt;/connection-init>
&lt;connection-properties display-name="Connection
properties:">&lt;/connection-properties>
&lt;ignore3 display-name="Show compatibility
parameters?">hide&lt;/ignore3>
&lt;ignore4 display-name="Use custom descriptor
files?">0&lt;/ignore4>
&lt;jdbc-driver-descriptor display-name="JDBC driver descriptor
filename:">&lt;/jdbc-driver-descriptor>
&lt;database-descriptor display-name="Database descriptor
filename:">&lt;/database-descriptor>
&lt;ignore12 display-name="Show backward compatibility
parameters?">hide&lt;/ignore12>
&lt;enable-refs display-name="Enable table referential attribute
support?">_&lt;/enable-refs>
&lt;enable-meta-identifiers display-name="Enable view
meta-identifier support?">_&lt;/enable-meta-identifiers>
&lt;ignore5 display-name="Show transaction-related
parameters?">hide&lt;/ignore5>
&lt;use-manual-transactions display-name="Use manual
transactions?">0&lt;/use-manual-transactions>
&lt;transaction-isolation-level display-name="Transaction isolation
level:">read committed&lt;/transaction-isolation-level>
&lt;ignore6 display-name="Show statement-related
parameters?">hide&lt;/ignore6>
&lt;reuse-statements display-name="Reuse
statements?">_&lt;/reuse-statements>
&lt;handle-stmt-results display-name="Number of returned result
sets:">_&lt;/handle-stmt-results>
&lt;enable-locking display-name="Enable statement-level
locking?">0&lt;/enable-locking>
&lt;ignore13 display-name="Use custom lock statement generator
class?">0&lt;/ignore13>
&lt;lock-generator-class display-name="Lock statement generator
class:">&lt;/lock-generator-class>
&lt;force-username-case display-name="Force username
case:">_&lt;/force-username-case>
&lt;left-outer-join-operator display-name="Left outer-join
operator:">_&lt;/left-outer-join-operator>
&lt;minimal-metadata display-name="Retrieve minimal
metadata?">_&lt;/minimal-metadata>
&lt;function-return-method display-name="Function return
method:">_&lt;/function-return-method>
&lt;supports-schemas-in-metadata-retrieval display-name="Supports
schemas in metadata
retrieval?">0&lt;/supports-schemas-in-metadata-retrieval>
&lt;column-position-comparator display-name="Sort column names
by:">_&lt;/column-position-comparator>
&lt;/driver-options>
&lt;subscriber-options>
&lt;disable display-name="Disable subscriber?">_&lt;/disable>
&lt;ignore10 display-name="Show primary key
parameters?">hide&lt;/ignore10>
&lt;key-gen-method display-name="Generation/retrieval method
(table-global):">auto&lt;/key-gen-method>
&lt;key-gen-timing display-name="Retrieval timing
(table-global):">after&lt;/key-gen-timing>
&lt;key-gen display-name="Method and timing
(table-local):">&lt;/key-gen>
&lt;disable-locking display-name="Disable statement-level
locking?">0&lt;/disable-locking>
&lt;check-update-count display-name="Check update
counts?">_&lt;/check-update-count>
&lt;/subscriber-options>
&lt;publisher-options>
&lt;disable display-name="Disable publisher?">1&lt;/disable>
&lt;publication-mode display-name="Publication
mode:">2&lt;/publication-mode>
&lt;startup-option display-name="Startup
option:">_&lt;/startup-option>
&lt;handle-future-events display-name="Enable future event
processing?">_&lt;/handle-future-events>
&lt;ignore8 display-name="Use custom timestamp
statement?">0&lt;/ignore8>
&lt;current-timestamp-stmt display-name="Current timestamp
statement:">&lt;/current-timestamp-stmt>
&lt;ignore9 display-name="Show polling-related
parameters?">hide&lt;/ignore9>
&lt;polling-interval display-name="Polling interval (in
seconds):">10&lt;/polling-interval>
&lt;time-of-day display-name="Polling time of
day:">&lt;/time-of-day>
&lt;post-poll-stmt display-name="Post polling
statements:">&lt;/post-poll-stmt>
&lt;batch-size display-name="Batch size:">_&lt;/batch-size>
&lt;pub-heartbeat-interval display-name="Heartbeat interval (in
minutes):">0&lt;/pub-heartbeat-interval>
&lt;/publisher-options>
&lt;/init-params>
&lt;/input>
&lt;/nds></jdbc:document>
[03/27/08 14:02:44.958]:/root/tracesAnnuaireIntra.log ST:
DirXML Log Event -------------------
Driver: \DEVNDS\dev\system\EnsemblePilote\Test Annuaire
Intranet
Status: Warning
Message: Code(-8001) Unable to retrieve application schema.
[03/27/08 14:02:44.960]:/root/tracesAnnuaireIntra.log ST:Reading driver
information from the \DEVNDS\dev\system\EnsemblePilote\Test Annuaire
Intranet object.
[03/27/08 14:02:44.962]:/root/tracesAnnuaireIntra.log ST:Loading Java
shim com.novell.nds.dirxml.driver.jdbc.JDBCDriverShim.
[03/27/08 14:02:44.963]:/root/tracesAnnuaireIntra.log ST:JDBC driver
version info:
version: 3.5.2
built: 20070918_0743
debug: true
activation level: 5
[03/27/08 14:02:44.967]:/root/tracesAnnuaireIntra.log ST:Reading XML
attribute
vnd.nds.stream://DEVNDS/dev/system/EnsemblePilote/Test+Annuaire+Intranet#DirXML-ShimConfigInfo.


--
coves
------------------------------------------------------------------------
coves's Profile: http://forums.novell.com/member.php?userid=4568
View this thread: http://forums.novell.com/showthread.php?t=321713