JNDI In Fusion Registry - Revision history

Vmurrell at 16:31, 30 October 2025

2025-10-30T16:31:19Z

2023-09-11T05:53:45Z

2022-08-08T14:25:02Z

‎Troubleshooting

2022-08-08T14:24:55Z

‎Troubleshooting

2022-02-25T17:40:27Z

‎Example File

2021-11-10T16:56:11Z

‎Elements of the Resource

2021-11-08T09:06:10Z

‎Setting in the Registry User Interface

2021-11-08T09:04:19Z

‎Setting in the Registry User Interface

2021-11-08T09:03:12Z

‎In GUI

2021-11-08T09:01:46Z

‎In GUI

← Older revision		Revision as of 16:31, 30 October 2025
Line 1:		Line 1:
−	~~[[Category:How_To]]~~	+	[[Category:Fusion Registry Configuration]]
−	[[Category:Fusion Registry ~~Install~~]]
	== Overview ==		== Overview ==

← Older revision		Revision as of 05:53, 11 September 2023
Line 1:		Line 1:
		+	[[Category:How_To]]
		+	[[Category:Fusion Registry Install]]
	== Overview ==		== Overview ==

@@ Line 99: / Line 99: @@
 '''Possible Fix 2:'''
 Your "url" is incorrect and this is causing the issue. Look at your context.xml file and ensure that your "url" is specified correctly in your resource.
 '''Error: Import Error Bulk Load Failed'''

← Older revision		Revision as of 14:24, 8 August 2022
Line 99:		Line 99:
	'''Possible Fix 2:'''		'''Possible Fix 2:'''
	Your "url" is incorrect and this is causing the issue. Look at your context.xml file and ensure that your "url" is specified correctly in your resource.		Your "url" is incorrect and this is causing the issue. Look at your context.xml file and ensure that your "url" is specified correctly in your resource.
		+
		+	'''Error: Import Error Bulk Load Failed'''
		+
		+	If this occurs then please check the logs of Fusion Registry.
		+
		+	If you are using MySQL and the log file states the following (note this will not all be output on a single line)
		+	<pre>
		+	BadSqlGrammarException: StatementCallback; bad SQL grammar [LOAD DATA LOCAL INFILE
		+	...
		+	The used command is not allowed with this MySQL version
		+	</pre>
		+
		+	This issue is caused because your database needs to be configured to permit the bulk loading of data via INFILE. This needs to be performed on the server (database) and within your client. To setup your database to permit this, please see resources on the Internet. To permit this in your Tomcat JNDI connection you may find that you need to edit the URL in the context.xml file so '''allowLoadLocalInfile''' is explicitly set to '''true'''. For example:
		+
		+	driverClassName="com.mysql.cj.jdbc.Driver"
		+	url="jdbc:mysql://localhost:3306/fr-soap-ui?useLegacyDatetimeCode=false&serverTimezone=Europe/London&allowLoadLocalInfile=true"
		+	username="root"

@@ Line 47: / Line 47: @@
      auth="Container"
      type="javax.sql.DataSource"
-     maxActive="100"
+     maxTotal="16"
      maxIdle="30"
      driverClassName="com.mysql.cj.jdbc.Driver"
      url="jdbc:mysql://localhost:3306/fr-soap-ui?useLegacyDatetimeCode=false&amp;serverTimezone=Europe/London"
@@ Line 60: / Line 59: @@
      auth="Container"
      type="javax.sql.DataSource"
-     maxActive="100"
+     maxTotal="16"
      maxIdle="30"
      driverClassName="com.mysql.cj.jdbc.Driver"
      url="jdbc:mysql://localhost:3306/fusion_registry_temp2?useLegacyDatetimeCode=false&amp;serverTimezone=Europe/London"

@@ Line 6: / Line 6: @@
 The following items must exist within the resource:
 * name - used to refer to the resource from the UI
-* driver class name - this must be a valid Java packae (see below)
+* driver class name - this must be a valid Java package (see below)
 * url - the connection string used to connect to the database
 * Username and password - to authenticate with the database (optional)

@@ Line 82: / Line 82: @@
 The values should be:
-* JNDI Name - this must be the name as specified in
+* JNDI Name - this must be the name exactly as specified in the resource. E.g. for Apache Tomcat and the examples above of the context.xml file, this could be either jdbc/test1 or test2
 == Troubleshooting ==

@@ Line 79: / Line 79: @@
 In the fields enter the JNDI name and the context
-[[File:JNDI-Setting.png|800px]]
+[[File:JNDI-Setting.png|JNDI Settings]]
 == Troubleshooting ==

@@ Line 71: / Line 71: @@
 </pre>
-==In GUI==
+== Setting in the Registry User Interface ==
 [[File:JNDI-Setting.png|800px]]